SAP Table OIU_PR_DN
Delivery Network
OIU_PR_DN (Delivery Network) 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 OIU_PR_DN to other SAP tables.
OIU_PR_DN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| DN_NO | Delivery network number | OIU_DN_NO | CHAR | 20 | 0 | |||||||||
| DN_DE | Delivery network description | OIU_DN_DE_CONV | CHAR | 35 | 0 | |||||||||
| SHTXT | Description | OIU_SHTXT | CHAR | 35 | 0 | |||||||||
| CNTRY_CD | Country | OIU_COUNTRY | T005 | CHAR | 3 | 0 | ||||||||
| PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | OIU_PRI_GEO_LOC | OIU_CM_LXPGL | CHAR | 2 | 0 | ||||||||
| SEC_GEO_LOC | Secondary geographic location | OIU_SEC_GEO_LOC | OIU_CM_LXSGL | CHAR | 3 | 0 | ||||||||
| TOL_PC | Allocation Tolerance percentage | OIU_TOL_PC | NUMC | 3 | 0 | |||||||||
| GPLT_DN_NO | Chaining Network number | OIU_GPLT_DN_NO | OIU_PR_DN | CHAR | 20 | 0 | ||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| VNAME | Joint Venture | JV_NAME | OIU_DO_JV | CHAR | 6 | 0 | ||||||||
| TYPE_CD | Delivery network type code | OIU_DN_TYP_CD | CHAR | 1 | 0 |
Possible values
|
||||||||
| DN_GRP | Delivery Network Number Range Group | OIU_DN_GRP | OIU_PR_DN_GRP | CHAR | 4 | 0 | ||||||||
| DN_SET | Delivery Network Hierarchy Group | OIU_DN_SET | CHAR | 15 | 0 | |||||||||
| OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | 0 | |||||||||
OIU_PR_DN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIU_PR_DN | BUKRS | OIU_PR_DN | MANDT | T001 | Company Codes | MANDT |
| OIU_PR_DN | BUKRS | OIU_PR_DN | BUKRS | T001 | Company Codes | BUKRS |
| OIU_PR_DN | CNTRY_CD | OIU_PR_DN | MANDT | T005 | Countries | MANDT |
| OIU_PR_DN | CNTRY_CD | OIU_PR_DN | CNTRY_CD | T005 | Countries | LAND1 |
| OIU_PR_DN | DN_GRP | OIU_PR_DN | MANDT | OIU_PR_DN_GRP | PRA: DN Group Codes | MANDT |
| OIU_PR_DN | DN_GRP | OIU_PR_DN | DN_GRP | OIU_PR_DN_GRP | PRA: DN Group Codes | DN_GRP |
| OIU_PR_DN | GPLT_DN_NO | OIU_PR_DN | GPLT_DN_NO | OIU_PR_DN | Delivery Network | DN_NO |
| OIU_PR_DN | GPLT_DN_NO | OIU_PR_DN | MANDT | OIU_PR_DN | Delivery Network | MANDT |
| OIU_PR_DN | PRI_GEO_LOC | OIU_PR_DN | MANDT | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | MANDT |
| OIU_PR_DN | PRI_GEO_LOC | OIU_PR_DN | CNTRY_CD | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | LAND1 |
| OIU_PR_DN | PRI_GEO_LOC | OIU_PR_DN | PRI_GEO_LOC | OIU_CM_LXPGL | Country and Primary Geo. Location Xref | PRI_GEO_LOC |
| OIU_PR_DN | SEC_GEO_LOC | OIU_PR_DN | SEC_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | SEC_GEO_LOC |
| OIU_PR_DN | SEC_GEO_LOC | OIU_PR_DN | MANDT | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | MANDT |
| OIU_PR_DN | SEC_GEO_LOC | OIU_PR_DN | CNTRY_CD | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | LAND1 |
| OIU_PR_DN | SEC_GEO_LOC | OIU_PR_DN | PRI_GEO_LOC | OIU_CM_LXSGL | Cross Reference Between Country and Secondary Geo. Locatio | PRI_GEO_LOC |
| OIU_PR_DN | VNAME | OIU_PR_DN | MANDT | OIU_DO_JV | PRA venture extension | MANDT |
| OIU_PR_DN | VNAME | OIU_PR_DN | BUKRS | OIU_DO_JV | PRA venture extension | BUKRS |
| OIU_PR_DN | VNAME | OIU_PR_DN | VNAME | OIU_DO_JV | PRA venture extension | VNAME |
