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 | Possible values |
|---|---|---|---|---|---|---|
|
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 |