/PRA/VL_VDOI_MKT

Mkt group allocation decimals for units | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT Client
DOC_NO Val. document number
DOC_YEAR Document year
BUKRS Company Code
VNAME Joint venture
DOI_NO Division of interest (DOI)
MK_REP_NO Marketing Representative No
MK_REP_ISQ_NO Marketing Representative Interest Sequence No
MATNR Material Number
WL_NO Well ID number
WC_NO FK Well Completion Number
MP_NO Measurement point number
TR_NO Tract Number
OWN_NO FK PRA owner
OWN_INT_TYPE_CD FK Participant Interest Type
OWN_ISQ_NO Owner Interest Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
MAJPD_CD Major product code Show values
PAY_CD Pay Code Show values
ENTY_CD Entity Code Show values
INT_CAT_CD Interest Category Show values
Column Name Description Domain name
TAX_FREE_CD Tax Free Code OIU_TAX_FREE_CD
GRI_PC Gross Revenue Interest Decimal OIU_PERCENT98
ADJ_GRI_PC Adjusted GRI Percentage OIU_PERCENT98
CT_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
ADJ_CT_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
TR_PC Tract Participation Factor Decimal OIU_PERCENT98
NRI_PC Net Revenue Interest Percent OIU_PERCENT98
GR_CT_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
ADGR_CT_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
MKT_GRI_PC Net Revenue Interest Percent OIU_PERCENT98
MKT_ADJ_GRI_PC Net Revenue Interest Percent OIU_PERCENT98
DO_NO Division of Interest Number OIU_SYS_NO
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Participant Interest Type /PRA/VL_VDOI_MKT.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • /PRA/VL_VDOI_MKT.MANDT == LFA1.MANDT
  • /PRA/VL_VDOI_MKT.OWN_NO == LFA1.LIFNR
Well Completion Number
  • Well ID number
  • Well Completion Number