R_PRAAcctgDocDetailTP

DDL: R_PRAACCTGDOCDETAILTP Type: view_entity TRANSACTIONAL Package: OIU_RAP_REV_RAD
180 Fields 1 Data Sources 3 Associations

Revenue Accounting Items details - TP

R_PRAAcctgDocDetailTP is a Transactional CDS View that provides data about "Revenue Accounting Items details - TP" in SAP S/4HANA. It reads from 1 data source (I_PRAAcctgDocLine) and exposes 180 fields with key fields CompanyCode, PRAAccountingPeriod, AccountingDocument, PRAAccountingDocumentLine. It has 3 associations to related views. Part of development package OIU_RAP_REV_RAD.

Data Sources (1)

SourceAliasJoin Type
I_PRAAcctgDocLine I_PRAAcctgDocLine from

Associations (3)

CardinalityTargetAliasCondition
[0..*] R_PRAAcctgDocDeductDetailTP _PRAAcctgDocDeductDetail
[0..*] R_PRAAcctgDocMktgDetailTP _PRAAcctgDocMktgDetail
[0..*] R_PRAAcctgDocTaxDetailTP _PRAAcctgDocTaxDetail

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Revenue Accounting Items details - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name RevenueAccountingItems_Type view
OData.entitySet.name RevenueAccountingItems view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name PRARevenueAccountingDocItems view

Fields (180)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAAccountingPeriod PRAAccountingPeriod
KEY AccountingDocument AccountingDocument Journal Entry
KEY PRAAccountingDocumentLine PRAAccountingDocumentLine Parameter line
MajorProduct MajorProduct Major Product
MinorProduct MinorProduct
ItemIsRejected ItemIsRejected Reject Flag
GLAccount GLAccount General Ledger
PRAAccountType PRAAccountType Account Type
AcctDeterminationCategory AcctDeterminationCategory Acc. category
JointVenture JointVenture Joint venture
DivisionOfInterest DivisionOfInterest Venture/DOI
UnitJointVenture UnitJointVenture Unit Venture
PRAProduct PRAProduct Full Product
Material Material Vehicle Model
DocumentItemText DocumentItemText Text
Well Well Well
WellCompletion WellCompletion Well Completion
MeasurementPoint MeasurementPoint Measurement Pt
PRAContract PRAContract Contract
VolumeType VolumeType Volume Type
SalesDate SalesDate Sales Date
DeliveryNetwork DeliveryNetwork Delivery network ID
CostCenter CostCenter Cost Center
Country Country Venue: Ctry/Reg
PrimaryGeogrlLocation PrimaryGeogrlLocation Primary geo.loc
ProcessingCompanyCode ProcessingCompanyCode Processing Company
Purchaser Purchaser Master Record
PressureBaseQty PressureBaseQty Pressure Base
ItemIsSummarizedByProduct ItemIsSummarizedByProduct Sumzd by Product
ItemIsWriteOff ItemIsWriteOff Writeoff Flag
ItemIsCleared ItemIsCleared Clearing
OriginatingMeasurementPt OriginatingMeasurementPt Originating MP
AffiliatedCompanyCode AffiliatedCompanyCode Intercompany cd
TaxClassification TaxClassification Tax class.
PriorPeriodAdjustmentReason PriorPeriodAdjustmentReason PPA Reason
County County Wyoming County
Region Region Venue Region
RelatedPRAContract RelatedPRAContract Related Contract
ProductBalancingAgreement ProductBalancingAgreement PBA No
GasPlantJointVenture GasPlantJointVenture Gplt Venture
GasPlantDivisionOfInterest GasPlantDivisionOfInterest Gplt DOI
PRAContractType PRAContractType Contract Type
Transporter Transporter Partner
PartnerCompany PartnerCompany Trading Partner
Remitter Remitter Remitter
AcctsRblMeasurementPt AcctsRblMeasurementPt AR MP
AccountsReceivableJointVenture AccountsReceivableJointVenture AR Venture
AcctsRblDivisionOfInterest AcctsRblDivisionOfInterest AR DOI
AlternateProperty AlternateProperty Remitter Property
AlternateProduct AlternateProduct Remitter Product
PRAChequeNumber PRAChequeNumber Check Number
PaymentDate PaymentDate Payment Date
CashReceiptDate CashReceiptDate Cash Receipt Date
SeveranceTaxType SeveranceTaxType Severance Tax
MarketingType MarketingType Mrktg Type Code
ExpenseJointVenture ExpenseJointVenture Exp Venture
ExpenseDivisionOfInterest ExpenseDivisionOfInterest Exp DOI Number
VolumeUnit VolumeUnit Volume Unit
EnergyUnit EnergyUnit Energy Unit
HeatingValUnit HeatingValUnit Heating UoM
CompanyCodeCurrency CompanyCodeCurrency Local Currency
HeatingValue HeatingValue Heat.val.factor
APIGravityRatio APIGravityRatio Gravity
DisbursementDecimalRatio DisbursementDecimalRatio Disb Decimal
NetRevenueInterestRatio NetRevenueInterestRatio NRI
GrossVolInVolUnit GrossVolInVolUnit Gross Volume
OwnerNetVolInVolUnit OwnerNetVolInVolUnit Owner Volume
GrossEnergyInEnergyUnit GrossEnergyInEnergyUnit Gross Energy
OwnerEnergyInEnergyUnit OwnerEnergyInEnergyUnit Owner Energy
GrossVolReducnInVolUnit GrossVolReducnInVolUnit Gross PVR
OwnrVolReducnInVolUnit OwnrVolReducnInVolUnit Owner PVR
GrossEngyReductionInEngyUnit GrossEngyReductionInEngyUnit Gross PTR
OwnerEnergyReducnInEnergyUnit OwnerEnergyReducnInEnergyUnit Owner PTR
GrossAmount GrossAmount Gross value
OwnerGrossAmount OwnerGrossAmount Owner Gross Val.
NetTaxAmount NetTaxAmount Line Net Tax Amount
NetTaxReimbmtAmt NetTaxReimbmtAmt Net Tax Reimbmt
NetInternalMarketingAmt NetInternalMarketingAmt Net Int Mktg Cost
NetExternalMarketingAmt NetExternalMarketingAmt Net Ext Mktg Cost
NetReimbmtMarketingAmt NetReimbmtMarketingAmt Net Mktg Reimbmt
OtherDeductionAmount OtherDeductionAmount Line Other Ded
OwnerNetAmount OwnerNetAmount Own Net Val
PRAOwner PRAOwner Owner Number
OwnerInterestType OwnerInterestType Opart int type
OwnerInterestSequence OwnerInterestSequence Own. ISQ
SuspenseReason SuspenseReason Suspense Reason
PRAEntitlementCode PRAEntitlementCode AES Code
OwnerPaymentStatus OwnerPaymentStatus Pay Code
OwnerIsJntIntrstBilgEnabled OwnerIsJntIntrstBilgEnabled JIB Offset
JntIntrstBilgPartner JntIntrstBilgPartner JIB Partner
PRALegalForm PRALegalForm Entity Type
TaxBasis TaxBasis Tax Free
ItemIsReallocated ItemIsReallocated Reallocated Fl
JntIntrstBilgVenture JntIntrstBilgVenture JIB Venture
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
RefPRAAccountingPeriod RefPRAAccountingPeriod
RefAccountingDocument RefAccountingDocument Document Number
PRARefAccountingDocumentLine PRARefAccountingDocumentLine Trace Number
RefValnDocYear RefValnDocYear
RefValnDoc RefValnDoc
RefValnDocItem RefValnDocItem
BookingReversalType BookingReversalType CR HEADER TYPE CODE
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
ChangedDateTime ChangedDateTime Time Stamp
ItemIsReversal ItemIsReversal Reverse Flag
RefAccountingDocumentItemExtd RefAccountingDocumentItemExtd Trace Number
PRAUnitVntrTractPartcipnPct PRAUnitVntrTractPartcipnPct Tr Part Factor
_PRAOwner _PRAOwner
_GLAccountType _GLAccountType
_AcctDeterminationCategory _AcctDeterminationCategory
_OwnerInterestType _OwnerInterestType
_Material _Material
_VolumeType _VolumeType
_CompanyCode _CompanyCode
_CostCenter _CostCenter
_ItemIsRejected _ItemIsRejected
_PartnerCompany _PartnerCompany
_ProcessingCompanyCode _ProcessingCompanyCode
_AffiliatedCompanyCode _AffiliatedCompanyCode
_JntIntrstBilgVenture _JntIntrstBilgVenture
_PRAJointVenture _PRAJointVenture
_JointVentureEquityType _JointVentureEquityType
_GasPlantJointVenture _GasPlantJointVenture
_ExpenseJointVenture _ExpenseJointVenture
_AccountsRblJointVenture _AccountsRblJointVenture
_DivisionOfInterest _DivisionOfInterest
_GasPlantDivisionOfInterest _GasPlantDivisionOfInterest
_AcctsRblDivisionOfInterest _AcctsRblDivisionOfInterest
_ExpenseDivisionOfInterest _ExpenseDivisionOfInterest
_UnitJointVenture _UnitJointVenture
_Well _Well
_WellCompletion _WellCompletion
_MeasurementPoint _MeasurementPoint
_OriginatingMeasurementPt _OriginatingMeasurementPt
_AcctsRblMeasurementPt _AcctsRblMeasurementPt
_PRAContract _PRAContract
_PRAContractType _PRAContractType
_RelatedPRAContract _RelatedPRAContract
_Product _Product
_MajorProduct _MajorProduct
_MinorProduct _MinorProduct
_PRAAccount _PRAAccount
_Purchaser _Purchaser
_Remitter _Remitter
_JntIntrstBilgPartner _JntIntrstBilgPartner
_Transporter _Transporter
_CompanyCodeCurrency _CompanyCodeCurrency
_VolumeUnit _VolumeUnit
_EnergyUnit _EnergyUnit
_DeliveryNetwork _DeliveryNetwork
_CalculationBasis _CalculationBasis
_PriorPeriodAdjustmentReason _PriorPeriodAdjustmentReason
_SuspenseReason _SuspenseReason
_Country _Country
_PrimaryGeogrlLocation _PrimaryGeogrlLocation
_Region _Region
_County _County
_SeveranceTaxType _SeveranceTaxType
_MarketingType _MarketingType
_TaxClassification _TaxClassification
_ProductBalancingAgreement _ProductBalancingAgreement
_OwnerPaymentStatus _OwnerPaymentStatus
_PRALegalForm _PRALegalForm
_TaxBasis _TaxBasis
_BookingReversalType _BookingReversalType
_ItemIsSummarizedByProduct _ItemIsSummarizedByProduct
_ItemIsCleared _ItemIsCleared
_ItemIsWriteOff _ItemIsWriteOff
_OwnerIsJntIntrstBilgEnabled _OwnerIsJntIntrstBilgEnabled
_ItemIsReallocated _ItemIsReallocated
_RefValnDocYear _RefValnDocYear
_RefValnDocHdr _RefValnDocHdr
_PRAAcctgDocDeductDetail _PRAAcctgDocDeductDetail
_PRAAcctgDocMktgDetail _PRAAcctgDocMktgDetail
_PRAAcctgDocTaxDetail _PRAAcctgDocTaxDetail
_PRAAccountingDocumentHeader _PRAAccountingDocumentHeader

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_PRAAcctgDocDetailTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_PRAAcctgDocDetailTP AS
SELECT
  CompanyCode,
  PRAAccountingPeriod,
  AccountingDocument,
  PRAAccountingDocumentLine,
  MajorProduct,
  MinorProduct,
  ItemIsRejected,
  GLAccount,
  PRAAccountType,
  AcctDeterminationCategory,
  JointVenture,
  DivisionOfInterest,
  UnitJointVenture,
  PRAProduct,
  Material,
  DocumentItemText,
  Well,
  WellCompletion,
  MeasurementPoint,
  PRAContract,
  VolumeType,
  SalesDate,
  DeliveryNetwork,
  CostCenter,
  Country,
  PrimaryGeogrlLocation,
  ProcessingCompanyCode,
  Purchaser,
  PressureBaseQty,
  ItemIsSummarizedByProduct,
  ItemIsWriteOff,
  ItemIsCleared,
  OriginatingMeasurementPt,
  AffiliatedCompanyCode,
  TaxClassification,
  PriorPeriodAdjustmentReason,
  County,
  Region,
  RelatedPRAContract,
  ProductBalancingAgreement,
  GasPlantJointVenture,
  GasPlantDivisionOfInterest,
  PRAContractType,
  Transporter,
  PartnerCompany,
  Remitter,
  AcctsRblMeasurementPt,
  AccountsReceivableJointVenture,
  AcctsRblDivisionOfInterest,
  AlternateProperty,
  AlternateProduct,
  PRAChequeNumber,
  PaymentDate,
  CashReceiptDate,
  SeveranceTaxType,
  MarketingType,
  ExpenseJointVenture,
  ExpenseDivisionOfInterest,
  VolumeUnit,
  EnergyUnit,
  HeatingValUnit,
  CompanyCodeCurrency,
  HeatingValue,
  APIGravityRatio,
  DisbursementDecimalRatio,
  NetRevenueInterestRatio,
  GrossVolInVolUnit,
  OwnerNetVolInVolUnit,
  GrossEnergyInEnergyUnit,
  OwnerEnergyInEnergyUnit,
  GrossVolReducnInVolUnit,
  OwnrVolReducnInVolUnit,
  GrossEngyReductionInEngyUnit,
  OwnerEnergyReducnInEnergyUnit,
  GrossAmount,
  OwnerGrossAmount,
  NetTaxAmount,
  NetTaxReimbmtAmt,
  NetInternalMarketingAmt,
  NetExternalMarketingAmt,
  NetReimbmtMarketingAmt,
  OtherDeductionAmount,
  OwnerNetAmount,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  SuspenseReason,
  PRAEntitlementCode,
  OwnerPaymentStatus,
  OwnerIsJntIntrstBilgEnabled,
  JntIntrstBilgPartner,
  PRALegalForm,
  TaxBasis,
  ItemIsReallocated,
  JntIntrstBilgVenture,
  JointVentureEquityType,
  JointVentureEquityGroup,
  RefPRAAccountingPeriod,
  RefAccountingDocument,
  PRARefAccountingDocumentLine,
  RefValnDocYear,
  RefValnDoc,
  RefValnDocItem,
  BookingReversalType,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  ChangedDateTime,
  ItemIsReversal,
  RefAccountingDocumentItemExtd,
  PRAUnitVntrTractPartcipnPct
FROM I_PRAAcctgDocLine
LEFT OUTER JOIN R_PRAAcctgDocDeductDetailTP AS _PRAAcctgDocDeductDetail ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PRAAcctgDocMktgDetailTP AS _PRAAcctgDocMktgDetail ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PRAAcctgDocTaxDetailTP AS _PRAAcctgDocTaxDetail ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More