/PRA/PP_CHK_DTL

Payment Processing - Check Detail | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
RUN_ID FK Proc 2.0 - Run ID
CHECK_NO Check number
OWN_NO FK PRA owner
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
OWN_INT_TYPE_SEQ Owner Interest Type / Sequence
SALE_DT Sales Date / Month
PD_CD FK Full three char. product code (Major and Detail Products)
DISB_DECIMAL Payment Processing - Disbursement decimal
SAKNR FK G/L Account Number
RECORD_TYPE Payment Processing - Record Type Show values
Column Name Description
GROSS_VAL Gross value
OWNER_GROSS_VAL Owner Gross Value
NET_VAL Owner Net Value
💲 Currency Key (T001.WAERS):
GROSS_TOT_MKT Gross marketing costs
GROSS_TOT_TAXES Gross Tax
OWNER_TOT_MKT Total owner marketing cost
OWNER_TOT_TAXES Owner tax
OWNER_TOT_OTHER Total Owner Other Deducts
GRS_LESS_TAX_MKT Gross value less deductions
PRICE Price
Column Name Description
📏 Base Unit of Measure (VOL_UOM):
GROSS_VOL Total Gross Volume
NET_VOL Owner Net Volume
📏 Base Unit of Measure (ENERGY_UOM):
GROSS_ENERGY Gross Energy
OWNER_ENERGY Owner Energy
📏 Base Unit of Measure (HEAT_VAL_UOM):
HEAT_VAL Heating value
Column Name Description
SALE_DT Sales Date / Month
CHECK_DT Check Date
Column Name Description
RECORD_TYPE Payment Processing - Record Type Show values
AES_CD Actual, Entitlement, Settlement Codes Show values
Column Name Description Domain name
ACCT_PERIOD Accounting Period /PRA/ACCOUNTING_PERIOD
NRI_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
COMMENT_NO Numeric Character Field, Length 10 NUMC10
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
RESP_USER User Name in User Master Record XUBNAME
RESP_AREA Responsibility Area CHAR20
JVA_NAME JIB Venture JV_NAME
ETYPE Equity type JV_ETYPE
EGRUP Equity group JV_EGROUP
BAL_GUID PP Balance Guid SYSUUID_C32
Master Data Relations Join Conditions
Company Code
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • /PRA/PP_CHK_DTL.MANDT == T005E.MANDT
  • /PRA/PP_CHK_DTL.COUNC == T005E.COUNC
  • /PRA/PP_CHK_DTL.LAND1 == T005E.LAND1
  • /PRA/PP_CHK_DTL.REGIO == T005E.REGIO
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Payment Processing - Detail Level Reject Code
Base Unit of Measure
  • /PRA/PP_CHK_DTL.MANDT == T006.MANDT
  • /PRA/PP_CHK_DTL.ENERGY_UOM == T006.MSEHI
Base Unit of Measure
  • /PRA/PP_CHK_DTL.MANDT == T006.MANDT
  • /PRA/PP_CHK_DTL.HEAT_VAL_UOM == T006.MSEHI
Customer/Partner
  • /PRA/PP_CHK_DTL.MANDT == KNA1.MANDT
  • /PRA/PP_CHK_DTL.JIB_PARTN == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • /PRA/PP_CHK_DTL.LAND1 == T005.LAND1
  • /PRA/PP_CHK_DTL.MANDT == T005.MANDT
Client /PRA/PP_CHK_DTL.MANDT == T000.MANDT
PRA owner
  • /PRA/PP_CHK_DTL.MANDT == LFA1.MANDT
  • /PRA/PP_CHK_DTL.OWN_NO == LFA1.LIFNR
Full three char. product code (Major and Detail Products) /PRA/PP_CHK_DTL.PD_CD == OIUX3_PDCD.PDCD
Prior Period Adjustment Reason Code
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • /PRA/PP_CHK_DTL.MANDT == T005S.MANDT
  • /PRA/PP_CHK_DTL.LAND1 == T005S.LAND1
  • /PRA/PP_CHK_DTL.REGIO == T005S.BLAND
Payment Processing - High Level Reject Code
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • /PRA/PP_CHK_DTL.[column in domain "KTOPL"] == SKA1.KTOPL
  • /PRA/PP_CHK_DTL.MANDT == SKA1.MANDT
  • /PRA/PP_CHK_DTL.SAKNR == SKA1.SAKNR
Suspense Reason Code
Unit venture
  • Unit venture
  • Company Code
Joint venture
  • Company Code
  • Joint venture
  • Client
  • /PRA/PP_CHK_DTL.BUKRS == T8JV.BUKRS
  • /PRA/PP_CHK_DTL.VNAME == T8JV.VNAME
  • /PRA/PP_CHK_DTL.MANDT == T8JV.MANDT
Base Unit of Measure
  • /PRA/PP_CHK_DTL.MANDT == T006.MANDT
  • /PRA/PP_CHK_DTL.VOL_UOM == T006.MSEHI
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number