OIU_PR_DN
Delivery Network
OIU_PR_DN is an SAP database table in S/4HANA. Delivery Network. It contains 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DeliveryNetwork | view | from | BASIC | Master Data for Delivery Network |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | dn_no | oiu_dn_no | Delivery network ID | |||
| dn_de | oiu_dn_de_conv | DN Name | ||||
| shtxt | oiu_shtxt | Description | ||||
| cntry_cd | oiu_country | Country/Reg. | ||||
| pri_geo_loc | oiu_pri_geo_loc | Primary geo.loc | ||||
| sec_geo_loc | oiu_sec_geo_loc | Secndry geo.loc | ||||
| tol_pc | oiu_tol_pc | All. Tolerance | ||||
| gplt_dn_no | oiu_gplt_dn_no | Chain. Network | ||||
| bukrs | bukrs | Company Code | ||||
| vname | jv_name | Joint venture | ||||
| type_cd | oiu_dn_typ_cd | DN type | ||||
| dn_grp | oiu_dn_grp | DN Number Group | ||||
| dn_set | oiu_dn_set | DN Hier. Node |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Delivery Network
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_DN (
MANDT, -- Client [mandt]
DN_NO, -- Delivery network ID [oiu_dn_no]
DN_DE, -- DN Name [oiu_dn_de_conv]
SHTXT, -- Description [oiu_shtxt]
CNTRY_CD, -- Country/Reg. [oiu_country]
PRI_GEO_LOC, -- Primary geo.loc [oiu_pri_geo_loc]
SEC_GEO_LOC, -- Secndry geo.loc [oiu_sec_geo_loc]
TOL_PC, -- All. Tolerance [oiu_tol_pc]
GPLT_DN_NO, -- Chain. Network [oiu_gplt_dn_no]
BUKRS, -- Company Code [bukrs]
VNAME, -- Joint venture [jv_name]
TYPE_CD, -- DN type [oiu_dn_typ_cd]
DN_GRP, -- DN Number Group [oiu_dn_grp]
DN_SET, -- DN Hier. Node [oiu_dn_set]
PRIMARY KEY (MANDT, DN_NO)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA