OIU_PR_DNVD SAP (Delivery Network Variable Data) Table details

Dictionary Type: Table
Description: Delivery Network Variable Data




ABAP Code to SELECT data from OIU_PR_DNVD
Related tables to OIU_PR_DNVD
Access table OIU_PR_DNVD




Table field list including key, data, relationships and ABAP select examples

OIU_PR_DNVD is a standard SAP Table which is used to store Delivery Network Variable Data data and is available within R/3 SAP systems depending on the version and release level.

The OIU_PR_DNVD table consists of various fields, each holding specific information or linking keys about Delivery Network Variable Data data available in SAP. These include DN_NO (Delivery network number), EFF_FROM_DT (Effective from date), EFF_TO_DT (Effective To Date), AL_BASIS_CD (Allocation Basis Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIU_PR_DNVD table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
DN_NODelivery network number OIU_DN_NOCHAR20OIU_PR_DNALPHAOIU_DN_NOOIU_DNH_OIU_PR_DN
EFF_FROM_DTEffective from date OIU_EFF_FROM_DTDATS8DATUMOIU_EFD
EFF_TO_DTEffective To Date OIU_EFF_TO_DTDATS8DATUMOIU_ETD
AL_BASIS_CDAllocation Basis Code OIU_AL_BASIS_CDCHAR1OIU_AL_BASIS_CD
AL_FLAllocation indicator OIU_AL_FLCHAR1OIU_X_FLAG
THEO_BASIS_CDSaturated/Dry Code OIU_SAT_DRY_CDCHAR1OIU_SAT_DRY_CD
THEO_INFL_AMTheoretical inflation factor OIU_INFL_AMNUMC1OIU_INFL_AM
CHA_COMPAT_CDChemical analysis compatibility code. OIU_CHA_COMPAT_CDCHAR4OIU_PR_CHACOIU_CHA_COMPAT_CD
PI_METH_CDPlant inlet calculation method code OIU_PI_METH_CDCHAR1OIU_PI_METH_CODE
INACTIVE_FLInactive indicator OIU_INACTIVE_FLCHAR1OIU_INACTIVE_FL
CHEM_MEAS_GRP_IDChemical Measurement Group OIU_CHEM_MEAS_GRP_IDCHAR10OIU_PR_DN_MGIDOIU_MEAS_GRP_IDOIU_MEAS_GRP
MEAS_GRP_IDMeasurement Group ID OIU_MEAS_GRP_IDCHAR10OIU_PR_DN_MGIDOIU_MEAS_GRP_IDOIU_MEAS_GRP
CA_PRCS_FREQ_CDProcessing Frequency Code OIU_CA_PRCS_FREQ_CDCHAR1OIU_CA_PRCS_FREQ_CD
CA_AUTO_SEL_FLContractual Allocation Auto Select indicator OIU_CA_AUTO_SEL_FLCHAR1OIU_X_FLAG
CA_ALLOC_METH_CDAllocation Method Code OIU_CA_ALLOC_METH_CDCHAR1OIU_CA_ALLOC_METH_CD
CA_ALLOC_TOL_PCCA Allocation Tolerance Percentage OIU_CA_ALLOC_TOL_PCDEC9(6) OIU_PERCENT96
CA_ALLOC_BAS_CDGas Allocation Basis Code OIU_CA_ALLOC_BAS_CDCHAR1OIU_CA_ALLOC_BAS_CD
CA_ASSUME_MKR_FLAssume Market Groups OIU_CA_ASSUME_MKR_FLCHAR1OIU_X_FLAG
CA_ASSUME_ACR_FLAssume ACRs OIU_CA_ASSUME_ACR_FLCHAR1OIU_X_FLAG
CA_ASSUME_DOI_FLAssume DOIs in Simple Plants OIU_CA_ASSUME_DOI_FLCHAR1OIU_X_FLAG
CA_SPF_SBE_FLSPF Sales-Based Entitlements indicator OIU_CA_SPF_SBE_FLCHAR1OIU_X_FLAG
CA_SPF_CPNT_FLComponent Level OIU_CA_SPF_CPNT_FLCHAR1OIU_X_FLAG
CA_FPF_WGB_CDFPF Wet Gas Balancing Code OIU_CA_FPF_WGB_CDCHAR1OIU_CA_FPF_WGB_CD
CA_FPF_SP_RLF_FLFPF Special Return Lease Fuel Processing Flag OIU_CA_FPF_SP_RLF_FLCHAR1OIU_X_FLAG
VL_PRCS_FREQ_CDRun Valuation OIU_VL_PRCS_FREQ_CDCHAR1OIU_X_FLAG
VL_AUTO_SEL_FLValuation Auto Select Flag OIU_VL_AUTO_SEL_FLCHAR1OIU_X_FLAG
VL_VAL_ON_VAL_FLValue on Value indicator OIU_VL_VAL_ON_VAL_FLCHAR1OIU_X_FLAG
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table OIU_PR_DNVD using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIU_PR_DNVD to SELECT all data from the table
DATA: WA_OIU_PR_DNVD TYPE OIU_PR_DNVD.

SELECT SINGLE *
FROM OIU_PR_DNVD
INTO CORRESPONDING FIELDS OF WA_OIU_PR_DNVD
WHERE...

How to access SAP table OIU_PR_DNVD

Within an ECC or HANA version of SAP you can also view further information about OIU_PR_DNVD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!