30 likes | 221 Views
SAP/R3 Development workbench Data Dictionary. R/3 table types: Transparent tables Each table definition in DDIC has an underlying physical table of same name. Used to hold application data eg Vendor master data Pooled and cluster tables
E N D
SAP/R3 Development workbenchData Dictionary • R/3 table types: • Transparent tables • Each table definition in DDIC has an underlying physical table of same name. • Used to hold application data eg Vendor master data • Pooled and cluster tables • Can have many table definitions in DDIC but only one underlying physical database of a different name, different fields. • Used to hold system data such as configuration data, historical and statistical data.
SAP/R3 Development workbenchData Dictionary Field (Lifnr) Data Element (Lifnr) Semantic Descriptions Domain (Lifnr) Technical Descriptions
SAP/R3 Development workbenchData Dictionary • Approaches for creating tables • Bottom-up • Create domains first, then data elements then the table. • Easier to understand for the novice • Quickly becomes cumbersome • Top-down • Create table first, then forward navigate to create data elements and domains. • Much easier to use