OIU_PR_DNAPD

Transparent Table Application Table
14 Fields 2 CDS Views

Network Allocation Profile Detail

OIU_PR_DNAPD is an SAP database table in S/4HANA. Network Allocation Profile Detail. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PRADelivNtwkAllocPrflDet view_entity from BASIC Network Allocation Profile Detail
UPOV_PR_DNAPD_PRA view from Network Allocation Profile Detail_PRA

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY dnaph_no oiu_dnaph_no DN alloc.prof.
KEY matnr matnr Material
KEY vt_cd oiu_vl_type_cd Volume Type
pd_seq_no oiu_pd_seq_no Sequence
dep_matnr oiu_dep_matnr Dep Material
dep_vt_cd oiu_dep_vt_cd Dependent VT
sum_dly_fl oiu_sum_dly_fl Sum Dly
auto_flo_fl oiu_auto_flo_fl Auto flow
calc_vt_cd oiu_calc_vt_cd Calculated VT
alloc_fl oiu_alloc_fl Allocate Mat/VT
cmp_alloc_fl oiu_cmp_alloc_fl Component Alloc
sum_tkt_fl oiu_sum_tkt_fl Run Tickets
dep_dimid oiupr_dep_dimid Dep.dimension

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.

-- Network Allocation Profile Detail
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIU_PR_DNAPD (
    MANDT,         -- Client [mandt]
    DNAPH_NO,      -- DN alloc.prof. [oiu_dnaph_no]
    MATNR,         -- Material [matnr]
    VT_CD,         -- Volume Type [oiu_vl_type_cd]
    PD_SEQ_NO,     -- Sequence [oiu_pd_seq_no]
    DEP_MATNR,     -- Dep Material [oiu_dep_matnr]
    DEP_VT_CD,     -- Dependent VT [oiu_dep_vt_cd]
    SUM_DLY_FL,    -- Sum Dly [oiu_sum_dly_fl]
    AUTO_FLO_FL,   -- Auto flow [oiu_auto_flo_fl]
    CALC_VT_CD,    -- Calculated VT [oiu_calc_vt_cd]
    ALLOC_FL,      -- Allocate Mat/VT [oiu_alloc_fl]
    CMP_ALLOC_FL,  -- Component Alloc [oiu_cmp_alloc_fl]
    SUM_TKT_FL,    -- Run Tickets [oiu_sum_tkt_fl]
    DEP_DIMID,     -- Dep.dimension [oiupr_dep_dimid]
    PRIMARY KEY (MANDT, DNAPH_NO, MATNR, VT_CD)
);

Learn More