SAP table OIU_PR_DN (Delivery Network)

SAP table OIU_PR_DN has 2 primary key fields being MANDT,DN_NO.

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 MANDT
DN_NO Delivery network number CHAR 20 0 OIU_DN_NO
DN_DE Delivery network description CHAR 35 0 OIU_DN_DE_CONV
SHTXT Description CHAR 35 0 OIU_SHTXT
CNTRY_CD Country/Region CHAR 3 0 T005 OIU_COUNTRY
PRI_GEO_LOC Primary geographical location (PRI geo. loc.) CHAR 2 0 OIU_CM_LXPGL OIU_PRI_GEO_LOC
SEC_GEO_LOC Secondary geographic location CHAR 3 0 OIU_CM_LXSGL OIU_SEC_GEO_LOC
TOL_PC Allocation Tolerance percentage NUMC 3 0 OIU_TOL_PC
GPLT_DN_NO Chaining Network number CHAR 20 0 OIU_PR_DN OIU_GPLT_DN_NO
BUKRS Company Code CHAR 4 0 T001 BUKRS
VNAME Joint venture CHAR 6 0 OIU_DO_JV JV_NAME
TYPE_CD Delivery network type code CHAR 1 0 OIU_DN_TYP_CD
F Fuel System
N Network
P Gas Plant
DN_GRP Delivery Network Number Range Group CHAR 4 0 OIU_PR_DN_GRP OIU_DN_GRP
DN_SET Delivery Network Hierarchy Group CHAR 15 0 OIU_DN_SET
OIU_CRUSER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS

OIU_PR_DN foreign key relationships

Table Field Check Table Check Field
0 OIU_PR_DN BUKRS T001 Company Codes BUKRS
1 OIU_PR_DN CNTRY_CD T005 Countries MANDT
1 OIU_PR_DN CNTRY_CD T005 Countries LAND1
0 OIU_PR_DN DN_GRP OIU_PR_DN_GRP PRA: DN Group Codes MANDT
1 OIU_PR_DN GPLT_DN_NO OIU_PR_DN Delivery Network MANDT
1 OIU_PR_DN GPLT_DN_NO OIU_PR_DN Delivery Network DN_NO
0 OIU_PR_DN PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref MANDT
0 OIU_PR_DN PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref LAND1
0 OIU_PR_DN PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref PRI_GEO_LOC
1 OIU_PR_DN SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio MANDT
1 OIU_PR_DN SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio LAND1
1 OIU_PR_DN SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio PRI_GEO_LOC
0 OIU_PR_DN VNAME OIU_DO_JV PRA venture extension MANDT
0 OIU_PR_DN VNAME OIU_DO_JV PRA venture extension BUKRS
0 OIU_PR_DN VNAME OIU_DO_JV PRA venture extension VNAME