SAP table OICDC (Differential Reference Code)

SAP table OICDC has 2 primary key fields being MANDT,OIDRC.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
OIDRC Differential Reference Code (DRC) CHAR 5 0 OIC_DRC
OIC_DRCTRY DRC country/Region CHAR 3 0 T005 OIC_DRCTRY
OIC_DRCREG DRC region CHAR 3 0 T005S OIC_DRCREG
OIMETIND Metropolitan indicator CHAR 4 0 OICMI OIC_METIND
OIWAP Wide-area pricing zone CHAR 3 0 OICWA OIC_WAP
OISLF State license fee zone CHAR 3 0 OICSL OIC_SLF
OIPSDRC Pricing DRC (grouping customers by DRC for pricing) CHAR 5 0 OICDC OIC_PSDRC
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERTIM Time of creation TIMS 6 0 OI0_ERTIM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AETIM Time of day the record was changed TIMS 6 0 OI0_AETIM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM

OICDC foreign key relationships

Table Field Check Table Check Field
0 OICDC MANDT T000 Clients MANDT
1 OICDC OIC_DRCREG T005S Taxes: Region (Province) Key LAND1
0 OICDC OIC_DRCTRY T005 Countries MANDT
0 OICDC OIC_DRCTRY T005 Countries LAND1
1 OICDC OIMETIND OICMI Metropolitan Indicator MANDT
1 OICDC OIMETIND OICMI Metropolitan Indicator OIMETIND
0 OICDC OIPSDRC OICDC Differential Reference Code OIDRC
1 OICDC OISLF OICSL State License Fee Zone MANDT
0 OICDC OIWAP OICWA Wide Area Pricing Zone MANDT