SAP Table OICDC
Differential Reference Code
OICDC (Differential Reference Code) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OICDC to other SAP tables.
OICDC table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| OIDRC | Differential Reference Code (DRC) | OIC_DRC | CHAR | 5 | 0 | |||
| OIC_DRCTRY | DRC country | OIC_DRCTRY | T005 | CHAR | 3 | 0 | ||
| OIC_DRCREG | DRC region | OIC_DRCREG | T005S | CHAR | 3 | 0 | ||
| OIMETIND | Metropolitan indicator | OIC_METIND | OICMI | CHAR | 4 | 0 | ||
| OIWAP | Wide-area pricing zone | OIC_WAP | OICWA | CHAR | 3 | 0 | ||
| OISLF | State license fee zone | OIC_SLF | OICSL | CHAR | 3 | 0 | ||
| OIPSDRC | Pricing DRC (grouping customers by DRC for pricing) | OIC_PSDRC | OICDC | CHAR | 5 | 0 | ||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||
| ERTIM | Time of creation | OI0_ERTIM | TIMS | 6 | 0 | |||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||
| AETIM | Time of day the record was changed | OI0_AETIM | TIMS | 6 | 0 | |||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||
OICDC foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OICDC | MANDT | OICDC | MANDT | T000 | Clients | MANDT |
| OICDC | OIC_DRCREG | OICDC | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| OICDC | OIC_DRCREG | OICDC | OIC_DRCTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| OICDC | OIC_DRCREG | OICDC | OIC_DRCREG | T005S | Taxes: Region (Province) Key | BLAND |
| OICDC | OIC_DRCTRY | OICDC | MANDT | T005 | Countries | MANDT |
| OICDC | OIC_DRCTRY | OICDC | OIC_DRCTRY | T005 | Countries | LAND1 |
| OICDC | OIMETIND | OICDC | MANDT | OICMI | Metropolitan Indicator | MANDT |
| OICDC | OIMETIND | OICDC | OIMETIND | OICMI | Metropolitan Indicator | OIMETIND |
| OICDC | OIPSDRC | OICDC | MANDT | OICDC | Differential Reference Code | MANDT |
| OICDC | OIPSDRC | OICDC | OIPSDRC | OICDC | Differential Reference Code | OIDRC |
| OICDC | OISLF | OICDC | MANDT | OICSL | State License Fee Zone | MANDT |
| OICDC | OISLF | OICDC | OISLF | OICSL | State License Fee Zone | OISLF |
| OICDC | OIWAP | OICDC | MANDT | OICWA | Wide Area Pricing Zone | MANDT |
| OICDC | OIWAP | OICDC | OIWAP | OICWA | Wide Area Pricing Zone | OIWAP |
