C_PRATstActlSecdryDets

CA - Actual Secdry Product Details tab | view: CPRATSTASPD | TRAN | Extraction: Not supported | Component: Production and Revenue Accounting

Tables used: OIU_SB_ACTWC, OIU_SB_RNAWC, OIUTV_SB_ACTWC_B, OIUTV_SB_RNAWC_B, OIUTV_SB_ENTWC_B, OIUTV_SB_RNEWC_B, OIU_SB_ENTWC, OIU_SB_RNEWC, OIU_PR_DN, OIU_PR_DNSTD, OIU_PR_DNSTH, OIU_CM_MAT_PRCD, OIUTV_CA_SCEN, OIUTV_CA_TOL

🔑 Keys (10)
💰 Amounts
∑ Quantities (10)
📅 Dates (1)
☰ Categorical (1)
Other (10)
🔗 Relations (10)

Column Name	Description
DeliveryNetwork FK	Delivery network number
Well FK	Well ID number
WellCompletion FK	Well Completion Number
Material FK	Material Number
PRAContract FK	Contract Number
SalesDate	Sales date
PRAOwner FK	PRA owner
OwnerInterestType FK	Participant Interest Type
OriginatingMeasurementPt FK	Original measurement point number
Transporter	Transporter number

Column Name	Description

Column Name	Description
📏 Actual Volume Units (VolumeUnit):
BaselineActualVolume	Actual Volume
ActualVolume	Actual Volume
BaselineEntitledVolume	Entitled Contract Volume
EntitledVolume	Entitled Contract Volume
📏 Heating Value Unit (HeatingValUnit):
BaselineActualHeatingValue	Heating value
ActualHeatingValue	Heating value
📏 Actual Energy Unit (EnergyUnit):
BaselineActualEnergy	Actual Energy
ActualEnergy	Actual Energy
BaselineEntitledEnergy	Entitled Contract Energy
EntitledEnergy	Entitled Contract Energy

Column Name	Description
SalesDate	Sales date

Column Name	Description
MajorProduct	Major product code	Show values

Column Name	Description	Domain name
DeliveryNetworkName	Delivery network description	OIU_TEXT35
ActlSecdryStatusCritlty	null
ActlSecdryStatusText	null
PRATstLineStatusCritlty	null
PRATstLineStatusText	null
ActualVolumeStsCritlty	null
ActualHeatingValueStsCritlty	null
ActualEnergyStsCritlty	null
EntitledVolumeStsCritlty	null
EntitledEnergyStsCritlty	null

Master Data Relations	Join Conditions
Delivery network number Delivery network number Client	`C_PRATSTACTLSECDRYDETS.DELIVERYNETWORK == OIU_PR_DN.DN_NO` `C_PRATSTACTLSECDRYDETS.MANDT == OIU_PR_DN.MANDT`
Actual Energy Unit Client Actual Energy Unit	`C_PRATSTACTLSECDRYDETS.MANDT == T006.MANDT` `C_PRATSTACTLSECDRYDETS.ENERGYUNIT == T006.MSEHI`
Heating Value Unit Heating Value Unit Client	`C_PRATSTACTLSECDRYDETS.HEATINGVALUNIT == T006.MSEHI` `C_PRATSTACTLSECDRYDETS.MANDT == T006.MANDT`
Material Number Client Material Number	`C_PRATSTACTLSECDRYDETS.MANDT == OIU_CM_MAT_PRCD.MANDT` `C_PRATSTACTLSECDRYDETS.MATERIAL == OIU_CM_MAT_PRCD.MATNR`
Original measurement point number Client Original measurement point number	`C_PRATSTACTLSECDRYDETS.MANDT == OIU_PR_MP.MANDT` `C_PRATSTACTLSECDRYDETS.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO`
Participant Interest Type	`C_PRATSTACTLSECDRYDETS.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD`
PRA owner PRA owner Client	`C_PRATSTACTLSECDRYDETS.PRAOWNER == LFA1.LIFNR` `C_PRATSTACTLSECDRYDETS.MANDT == LFA1.MANDT`
Actual Volume Units Client Actual Volume Units	`C_PRATSTACTLSECDRYDETS.MANDT == T006.MANDT` `C_PRATSTACTLSECDRYDETS.VOLUMEUNIT == T006.MSEHI`
Well ID number Client Well ID number	`C_PRATSTACTLSECDRYDETS.MANDT == OIU_PR_WELL.MANDT` `C_PRATSTACTLSECDRYDETS.WELL == OIU_PR_WELL.WL_NO`
Well Completion Number Client Well Completion Number Well ID number	`C_PRATSTACTLSECDRYDETS.MANDT == OIU_PR_WC.MANDT` `C_PRATSTACTLSECDRYDETS.WELLCOMPLETION == OIU_PR_WC.WC_NO` `C_PRATSTACTLSECDRYDETS.WELL == OIU_PR_WC.WL_NO`