/PRA/FP_PAY_SUM

ONRR-2014 - Payable Summary | #transactional | Component: Production and Revenue Accounting

🔑 Keys (13)
💰 Amounts (3)
∑ Quantities (6)
📅 Dates (1)
☰ Categorical (1)
Other (6)
🔗 Relations (17)

Column Name	Description
MANDT FK	Client
SALE_DT	Sales Date / Month
BUKRS FK	Company Code
VNAME FK	Joint venture
DOI_NO FK	Division of interest (DOI)
WL_NO FK	Well ID number
WC_NO FK	Well Completion Number
VBELN FK	Contract Number
VL_TYPE_CD FK	Volume Type Code
PD_CD FK	Full three char. product code (Major and Detail Products)
OWN_NO FK	PRA owner
SAKNR FK	G/L Account Number
KOSTL FK	Cost Center

Column Name	Description
💲 Currency Key (WAERS):
NET_VAL	Owner Net Value
OWNER_GROSS_VAL	Owner Gross Value
GROSS_VAL	Gross value

Column Name	Description
📏 Base Unit of Measure (VOL_UOM):
NET_VOL	Owner Net Volume
GROSS_VOL	Total Gross Volume
RAW_NET_VOL	ONRR-2014 - Raw Net Vol
RAW_GROSS_VOL	ONRR-2014 - Raw Gross Vol
📏 Base Unit of Measure (ENERGY_UOM):
OWNER_ENERGY	Owner Energy
GROSS_ENERGY	Gross Energy

Column Name	Description
SALE_DT	Sales Date / Month

Column Name	Description
DISPOSITION_CD	ONRR-2014 - Disposition Code	Show values

Column Name	Description	Domain name
DN_NO	Delivery network number	OIU_DN_NO
REASON_CD	ONRR-2014 - Reason Code
OIU_CRUSER	Name of Person Responsible for Creating the Object	USNAM
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	TZNTSTMPS
ALT_CT_NO	ONRR MPP: Pricing Contract Number	VBELN
BAL_GUID	PP Balance Guid	SYSUUID_C32

Master Data Relations	Join Conditions
Company Code	`/PRA/FP_PAY_SUM.MANDT == OIU_CM_COMPC.MANDT` `/PRA/FP_PAY_SUM.BUKRS == OIU_CM_COMPC.BUKRS`
Division of interest (DOI) Joint venture Division of interest (DOI) Company Code	`/PRA/FP_PAY_SUM.MANDT == OIU_DO_DI.MANDT` `/PRA/FP_PAY_SUM.VNAME == OIU_DO_DI.VNAME` `/PRA/FP_PAY_SUM.DOI_NO == OIU_DO_DI.DOI_NO` `/PRA/FP_PAY_SUM.BUKRS == OIU_DO_DI.BUKRS`
Base Unit of Measure	`/PRA/FP_PAY_SUM.MANDT == T006.MANDT` `/PRA/FP_PAY_SUM.ENERGY_UOM == T006.MSEHI`
Cost Center ? Cost Center ?	`/PRA/FP_PAY_SUM.MANDT == CSKS.MANDT` `/PRA/FP_PAY_SUM.[column in domain "DATBI"] == CSKS.DATBI` `/PRA/FP_PAY_SUM.KOSTL == CSKS.KOSTL` `/PRA/FP_PAY_SUM.[column in domain "KOKRS"] == CSKS.KOKRS`
Client	`/PRA/FP_PAY_SUM.MANDT == T000.MANDT`
PRA owner	`/PRA/FP_PAY_SUM.MANDT == LFA1.MANDT` `/PRA/FP_PAY_SUM.OWN_NO == LFA1.LIFNR`
Full three char. product code (Major and Detail Products)	`/PRA/FP_PAY_SUM.PD_CD == OIUX3_PDCD.PDCD`
Prior Period Adjustment Reason Code	`/PRA/FP_PAY_SUM.MANDT == OIU_CM_PPARSN.MANDT` `/PRA/FP_PAY_SUM.PPA_RSN_CD == OIU_CM_PPARSN.PPA_RSN_CD`
G/L Account Number Company Code Client G/L Account Number	`/PRA/FP_PAY_SUM.BUKRS == SKB1.BUKRS` `/PRA/FP_PAY_SUM.MANDT == SKB1.MANDT` `/PRA/FP_PAY_SUM.SAKNR == SKB1.SAKNR`
Contract Number	`/PRA/FP_PAY_SUM.MANDT == OIUCM_CONTRACT.MANDT` `/PRA/FP_PAY_SUM.VBELN == OIUCM_CONTRACT.VBELN`
Volume Type Code	`/PRA/FP_PAY_SUM.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD`
Joint venture Joint venture Company Code	`/PRA/FP_PAY_SUM.MANDT == OIU_DO_JV.MANDT` `/PRA/FP_PAY_SUM.VNAME == OIU_DO_JV.VNAME` `/PRA/FP_PAY_SUM.BUKRS == OIU_DO_JV.BUKRS`
Base Unit of Measure	`/PRA/FP_PAY_SUM.MANDT == T006.MANDT` `/PRA/FP_PAY_SUM.VOL_UOM == T006.MSEHI`
Currency Key	`/PRA/FP_PAY_SUM.MANDT == TCURC.MANDT` `/PRA/FP_PAY_SUM.WAERS == TCURC.WAERS`
Well Completion Number Well ID number Well Completion Number	`/PRA/FP_PAY_SUM.MANDT == OIU_PR_WC.MANDT` `/PRA/FP_PAY_SUM.WL_NO == OIU_PR_WC.WL_NO` `/PRA/FP_PAY_SUM.WC_NO == OIU_PR_WC.WC_NO`
Well ID number	`/PRA/FP_PAY_SUM.MANDT == OIU_PR_WELL.MANDT` `/PRA/FP_PAY_SUM.WL_NO == OIU_PR_WELL.WL_NO`