/PRA/P2_ACCT_DOC

Accounting document (All account types) | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
RUN_ID Proc 2.0 - Run ID
BUKRS FK Company Code
ACCT_PERIOD FK Accounting Period
DOC_NO FK Revenue Accounting Document Number
LINE_NO Accounting Document Line Number
Column Name Description
OWNER_GROSS_VAL Owner Gross Value
NET_VAL Owner Net Value
GROSS_VAL Gross value
LINE_TAX_AM Line Item Net Tax Amount
LINE_RMB_AM Line Item Net Tax Reimbursement Amount
LINE_INT_MKT_VAL Line Net Marketing Cost - Internal
LINE_EXT_MKT_VAL Line Net Marketing Cost - External
LINE_DED_RMB_AM Line Net Marketing Cost Reimbursement
LINE_OTH_DED_AM Line Other deducts amount
Column Name Description
📏 Base Unit of Measure (OIU_CM_PRES.PRES_UOM):
PS_BASE_QY Pressure Base
OWN_ENERGY Owner Energy
OWN_PVR Owner PVR
OWN_PTR Owner PTR
GROSS_ENERGY Gross Energy
GROSS_PVR Gross PVR
GROSS_PTR Gross PTR
HEAT_VAL Heating value
NET_VOL Owner Net Volume
GROSS_VOL Total Gross Volume
Column Name Description
SALE_DT Sales Date / Month
CHECK_DT Check Date
CASH_RCPT_DT Cash Receipt Date
Column Name Description
ACCT_TYPE_CD Account Type Show values
ACCT_CAT_CD Account category code Show values
PD_CD_SUM_IND PRA Product Code Summarize Indicator Show values
REJ_FL Accounting Document rejection flag Show values
WRITEOFF Accounting Document Writeoff flag Show values
CLRNG_FL Accounting Document Clearing Show values
RVRS_FL Accounting Reverse Flag Show values
PAY_CD Pay Code Show values
JIB_OFFS_FL Joint Interest Billing Offset Flag Show values
ENTY_CD Entity Code Show values
REALLOC_FL Reallocated flag - results reallocated thru chain-of-title Show values
BOOK_REV_IND Booking/Reversal Indicator Show values
Column Name Description Domain name
ACCT_NO G/L Account Number SAKNR
VNAME Joint venture JV_NAME
DOI_NO Division of interest (DOI) OIU_DOI_NO
UNIT_VNAME Unit Venture JV_NAME
PD_CD Full three char. product code (Major and Detail Products) OIU_FULL_PD_CD
LINE_DESC PRA Account Documnet Line Item's Description
TAX_CLS Tax Class OIU_TAX_CLS
COUNC County Code COUNC
REGIO Region (State, Province, County) REGIO
GPLT_VNAME Gas Plant Venture JV_NAME
GPLT_DOI_NO Gasplant DOI No OIU_DOI_NO
CT_TYPE_CD Contract Type OIU_CT_TYPE_CD
AR_VNAME AR Venture JV_NAME
AR_DOI_NO AR DOI OIU_DOI_NO
PU_VNAME Remitter Property
PU_PDCD Remitter Product OIU_FULL_PD_CD
CHECK_NO Check Number CHCKN
TAX_TYPE_CD Severance Tax Type OIU_SEVT_TAX_TY
MKT_TYPE_CD Marketing type code OIU_MK_TYPE_CD
EXP_VNAME Expense Property number JV_NAME
EXP_DOI_NO Expense DOI Number OIU_DOI_NO
GRAVITY Oil/gas density at standard/base conditions OIU_OIB_DICHT
OWN_ISQ_NO Owner Interest Sequence Number OIU_OWN_ISQ_NO
AES_CD Actual / Entitled / Settlement Code CHAR1
JIB_PARTN JIB Partner KUNNR
DISB_DECIMAL Disbursement Decimal OIU_PERCENT98
NRI_DECIMAL Net Revenue Interest Percent OIU_PERCENT98
TAX_FREE_CD Tax Free Code OIU_TAX_FREE_CD
JVA_NAME JIB Venture JV_NAME
ETYPE Equity type JV_ETYPE
EGRUP Equity group JV_EGROUP
TRACE_ACCT_PRD Accounting Trace period /PRA/ACCOUNTING_PERIOD
TRACE_DOC_NO Revenue Accounting Trace Document Number /PRA/ACCOUNTING_DOC_NO
TRACE_LINE_NO Accounting document trace line number NUMC08
TRACE_VL_DOC_NO Val. document number OIU_MP_NO
TRACE_VL_DOC_YR Document year GJAHR
TRACE_VL_LINE_NO Document Line Number OIU_DOC_LINENR
TRACE_VL_LN_NUM Accounting document trace line number NUMC08
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CHANGE_USER Name of Person Who Changed Object USNAM
CHANGE_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Accounting Period
  • Company Code
  • Client
  • Accounting Period
AR MP
Company Code
  • /PRA/P2_ACCT_DOC.MANDT == T001.MANDT
  • /PRA/P2_ACCT_DOC.BUKRS == T001.BUKRS
Delivery network number
Energy Base Unit Of Measure
  • /PRA/P2_ACCT_DOC.MANDT == T006.MANDT
  • /PRA/P2_ACCT_DOC.ENERGY_UOM == T006.MSEHI
Heating Unit Of Measure
  • /PRA/P2_ACCT_DOC.MANDT == T006.MANDT
  • /PRA/P2_ACCT_DOC.HEAT_VAL_UOM == T006.MSEHI
Affiliated Company
Country/Region Key
  • Country/Region Key
  • Client
  • /PRA/P2_ACCT_DOC.LAND1 == T005.LAND1
  • /PRA/P2_ACCT_DOC.MANDT == T005.MANDT
Client /PRA/P2_ACCT_DOC.MANDT == T000.MANDT
Material Number
Measurement point number
Originating Measurement Point Number
Participant Interest Type /PRA/P2_ACCT_DOC.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • PRA owner
  • Client
PBA Number
  • PBA Number
  • Client
Adjustment Reason Code
Primary geographical location (PRI geo. loc.)
  • Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
Processing Company Code
Purchaser Number
  • /PRA/P2_ACCT_DOC.MANDT == KNA1.MANDT
  • /PRA/P2_ACCT_DOC.PUR_NO == KNA1.KUNNR
Related contract number
Remitter (Customer)
  • /PRA/P2_ACCT_DOC.MANDT == KNA1.MANDT
  • /PRA/P2_ACCT_DOC.REMT_NO == KNA1.KUNNR
Suspense Reason Code
Trading Partner
  • /PRA/P2_ACCT_DOC.MANDT == T880.MANDT
  • /PRA/P2_ACCT_DOC.TRD_PARTNR == T880.RCOMP
Transporter number
  • /PRA/P2_ACCT_DOC.MANDT == KNA1.MANDT
  • /PRA/P2_ACCT_DOC.TRNSP_NO == KNA1.KUNNR
Contract Number
Volume Type Code /PRA/P2_ACCT_DOC.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • /PRA/P2_ACCT_DOC.MANDT == T006.MANDT
  • /PRA/P2_ACCT_DOC.VOL_UOM == T006.MSEHI
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number