/PRA/PP_SUS_SUM

Payment Processing - Suspense Summary | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
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
WAERS FK Currency Key
Column Name Description
GROSS_VAL Gross value
OWNER_GROSS_VAL Owner Gross Value
NET_VAL Owner Net Value
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
Column Name Description
SALE_DT Sales Date / Month
Column Name Description
RECORD_TYPE Payment Processing - Record Type Show values
AES_CD Actual, Entitlement, Settlement Codes Show values
FUTURE_PAY_FL Payment Processing - Future Pay Flag Show values
Column Name Description Domain name
ACCT_PERIOD Accounting Period /PRA/ACCOUNTING_PERIOD
NRI_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
RUN_ID Proc 2.0 - Run ID
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
JIB_FLAG Job Interest Billing Indicator OIUH_DO_JIB_OFFS_FL
BAL_GUID Legal Suspense Balance Guid SYSUUID_C32
Master Data Relations Join Conditions
Company Code
County Code
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • /PRA/PP_SUS_SUM.MANDT == T005E.MANDT
  • /PRA/PP_SUS_SUM.COUNC == T005E.COUNC
  • /PRA/PP_SUS_SUM.LAND1 == T005E.LAND1
  • /PRA/PP_SUS_SUM.REGIO == T005E.REGIO
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • ?
  • /PRA/PP_SUS_SUM.MANDT == OIU_DO_DI.MANDT
  • /PRA/PP_SUS_SUM.VNAME == OIU_DO_DI.VNAME
  • /PRA/PP_SUS_SUM.DOI_NO == OIU_DO_DI.DOI_NO
  • /PRA/PP_SUS_SUM.[column in domain "BUKRS"] == OIU_DO_DI.BUKRS
Base Unit of Measure
  • /PRA/PP_SUS_SUM.MANDT == T006.MANDT
  • /PRA/PP_SUS_SUM.ENERGY_UOM == T006.MSEHI
Country/Region Key
  • Country/Region Key
  • Client
  • /PRA/PP_SUS_SUM.LAND1 == T005.LAND1
  • /PRA/PP_SUS_SUM.MANDT == T005.MANDT
Client /PRA/PP_SUS_SUM.MANDT == T000.MANDT
PRA owner
  • /PRA/PP_SUS_SUM.MANDT == LFA1.MANDT
  • /PRA/PP_SUS_SUM.OWN_NO == LFA1.LIFNR
Full three char. product code (Major and Detail Products) /PRA/PP_SUS_SUM.PD_CD == OIUX3_PDCD.PDCD
Prior Period Adjustment Reason Code
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • /PRA/PP_SUS_SUM.MANDT == T005S.MANDT
  • /PRA/PP_SUS_SUM.LAND1 == T005S.LAND1
  • /PRA/PP_SUS_SUM.REGIO == T005S.BLAND
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • /PRA/PP_SUS_SUM.[column in domain "KTOPL"] == SKA1.KTOPL
  • /PRA/PP_SUS_SUM.MANDT == SKA1.MANDT
  • /PRA/PP_SUS_SUM.SAKNR == SKA1.SAKNR
Suspense Reason Code
Unit venture
  • Unit venture
  • Company Code
Joint venture
  • Joint venture
  • ?
  • /PRA/PP_SUS_SUM.MANDT == OIU_DO_JV.MANDT
  • /PRA/PP_SUS_SUM.VNAME == OIU_DO_JV.VNAME
  • /PRA/PP_SUS_SUM.[column in domain "BUKRS"] == OIU_DO_JV.BUKRS
Base Unit of Measure
  • /PRA/PP_SUS_SUM.MANDT == T006.MANDT
  • /PRA/PP_SUS_SUM.VOL_UOM == T006.MSEHI
Currency Key
  • /PRA/PP_SUS_SUM.MANDT == TCURC.MANDT
  • /PRA/PP_SUS_SUM.WAERS == TCURC.WAERS
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number