/PRA/VL_DA_LOGKY

Dual Accounting audit log Key | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT Client
DOC_NO Val. document number
DOC_YEAR Document year
DN_NO FK Delivery network number
SALE_DT Sales Date / Month
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
BUKRS FK Company Code
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
OWN_NO FK PRA owner
OWN_INT_TYPE_CD Participant Interest Type
OWN_ISQ_NO Owner Interest Sequence Number
Column Name Description
💲 Currency Key (T001.WAERS):
RESIDUE_VAL_AM Residue Value amount
NGL_VAL_AM NGL Value amount
RES_PLUS_NGL Residue plus NGLS Value amount
WLR_VAL_AM Wet Gas Value amount
WLR_GR_VAL Actual Gross Value Amount
WLR_THEO_COST Actual Gross Value Amount
WLR_NET_VAL Actual Gross Value Amount
Column Name Description
📏 Unit of Measurement (T006.MSEHI):
WLR_VOL Actual Gross Volume Amount
WLR_ENERGY Actual Energy
Column Name Description
SALE_DT Sales Date / Month
Column Name Description
MMS_POP_COMP_FL MMS Percent of Proceeds Flag Show values
Column Name Description Domain name
GUID 16-byte UID in 32 chars (hexadecimal) SYSUUID_C32
CALC_GROUP_NO Calculation Group
PAY_BASIS Pay Basis /PRA/VL_PAY_BASIS
CHANGE_USER Last Changed By USNAM
CHANGE_TIMESTAMP Last Changed Timestamp /PRA/TZNTSTMPS
Master Data Relations Join Conditions
Company Code
  • /PRA/VL_DA_LOGKY.MANDT == T001.MANDT
  • /PRA/VL_DA_LOGKY.BUKRS == T001.BUKRS
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Measurement point number
PRA owner
  • /PRA/VL_DA_LOGKY.MANDT == LFA1.MANDT
  • /PRA/VL_DA_LOGKY.OWN_NO == LFA1.LIFNR
Joint venture
  • Company Code
  • Joint venture
  • Client
  • /PRA/VL_DA_LOGKY.BUKRS == T8JV.BUKRS
  • /PRA/VL_DA_LOGKY.VNAME == T8JV.VNAME
  • /PRA/VL_DA_LOGKY.MANDT == T8JV.MANDT
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number