A_PRAAcctgDocDetail

DDL: A_PRAACCTGDOCDETAIL Type: view_entity CONSUMPTION Package: OIU_ODATA_REV_RAD
111 Fields 1 Data Sources 1 OData Services

Revenue Accounting Items details

A_PRAAcctgDocDetail is a Consumption CDS View that provides data about "Revenue Accounting Items details" in SAP S/4HANA. It reads from 1 data source (R_PRAAcctgDocDetailTP) and exposes 111 fields with key fields CompanyCode, PRAAccountingPeriod, AccountingDocument, PRAAccountingDocumentLine. It is exposed through 1 OData service (API_PRAREVENUEACCTDOCUMENT). Part of development package OIU_ODATA_REV_RAD.

Data Sources (1)

SourceAliasJoin Type
R_PRAAcctgDocDetailTP R_PRAAcctgDocDetailTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Revenue Accounting Items details view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name RevenueAccountingItems_Type view
OData.entitySet.name RevenueAccountingItems view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

OData Services (1)

ServiceBindingVersionContractRelease
API_PRAREVENUEACCTDOCUMENT API_PRAREVENUEACCTDOCUMENT V4 C2 C1

Fields (111)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAAccountingPeriod PRAAccountingPeriod
KEY AccountingDocument AccountingDocument Journal Entry
KEY PRAAccountingDocumentLine PRAAccountingDocumentLine
MajorProduct MajorProduct Major Product
MinorProduct MinorProduct
ItemIsRejected ItemIsRejected
GLAccount GLAccount General Ledger
PRAAccountType PRAAccountType
AcctDeterminationCategory AcctDeterminationCategory
JointVenture JointVenture Joint venture
DivisionOfInterest DivisionOfInterest Venture/DOI
UnitJointVenture UnitJointVenture
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
ProcessingCompanyCode ProcessingCompanyCode
Purchaser Purchaser Master Record
PressureBaseQty PressureBaseQty
ItemIsSummarizedByProduct ItemIsSummarizedByProduct
ItemIsWriteOff ItemIsWriteOff
ItemIsCleared ItemIsCleared
OriginatingMeasurementPt OriginatingMeasurementPt
AffiliatedCompanyCode AffiliatedCompanyCode
TaxClassification TaxClassification Tax class.
PriorPeriodAdjustmentReason PriorPeriodAdjustmentReason
County County Wyoming County
Region Region Venue Region
RelatedPRAContract RelatedPRAContract
ProductBalancingAgreement ProductBalancingAgreement
GasPlantJointVenture GasPlantJointVenture
GasPlantDivisionOfInterest GasPlantDivisionOfInterest
PRAContractType PRAContractType
Transporter Transporter Partner
PartnerCompany PartnerCompany Trading Partner
Remitter Remitter Remitter
AcctsRblMeasurementPt AcctsRblMeasurementPt
AccountsReceivableJointVenture AccountsReceivableJointVenture
AcctsRblDivisionOfInterest AcctsRblDivisionOfInterest
AlternateProperty AlternateProperty
AlternateProduct AlternateProduct
PRAChequeNumber PRAChequeNumber
PaymentDate PaymentDate Payment Date
CashReceiptDate CashReceiptDate
SeveranceTaxType SeveranceTaxType
MarketingType MarketingType
ExpenseJointVenture ExpenseJointVenture
ExpenseDivisionOfInterest ExpenseDivisionOfInterest
VolumeUnit VolumeUnit Volume Unit
EnergyUnit EnergyUnit
HeatingValUnit HeatingValUnit
CompanyCodeCurrency CompanyCodeCurrency Local Currency
HeatingValue HeatingValue
APIGravityRatio APIGravityRatio
DisbursementDecimalRatio DisbursementDecimalRatio
NetRevenueInterestRatio NetRevenueInterestRatio
GrossVolInVolUnit GrossVolInVolUnit
OwnerNetVolInVolUnit OwnerNetVolInVolUnit
GrossEnergyInEnergyUnit GrossEnergyInEnergyUnit
OwnerEnergyInEnergyUnit OwnerEnergyInEnergyUnit
GrossVolReducnInVolUnit GrossVolReducnInVolUnit
OwnrVolReducnInVolUnit OwnrVolReducnInVolUnit
GrossEngyReductionInEngyUnit GrossEngyReductionInEngyUnit
OwnerEnergyReducnInEnergyUnit OwnerEnergyReducnInEnergyUnit
GrossAmount GrossAmount Gross value
OwnerGrossAmount OwnerGrossAmount
NetTaxAmount NetTaxAmount
NetTaxReimbmtAmt NetTaxReimbmtAmt
NetInternalMarketingAmt NetInternalMarketingAmt
NetExternalMarketingAmt NetExternalMarketingAmt
NetReimbmtMarketingAmt NetReimbmtMarketingAmt
OtherDeductionAmount OtherDeductionAmount
OwnerNetAmount OwnerNetAmount
PRAOwner PRAOwner
OwnerInterestType OwnerInterestType
OwnerInterestSequence OwnerInterestSequence
SuspenseReason SuspenseReason
PRAEntitlementCode PRAEntitlementCode
OwnerPaymentStatus OwnerPaymentStatus
OwnerIsJntIntrstBilgEnabled OwnerIsJntIntrstBilgEnabled
JntIntrstBilgPartner JntIntrstBilgPartner
PRALegalForm PRALegalForm
TaxBasis TaxBasis
ItemIsReallocated ItemIsReallocated
JntIntrstBilgVenture JntIntrstBilgVenture
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
RefPRAAccountingPeriod RefPRAAccountingPeriod
RefAccountingDocument RefAccountingDocument Document Number
PRARefAccountingDocumentLine PRARefAccountingDocumentLine
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
RefAccountingDocumentItemExtd RefAccountingDocumentItemExtd
PRAUnitVntrTractPartcipnPct PRAUnitVntrTractPartcipnPct

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 A_PRAAcctgDocDetail.
-- 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 A_PRAAcctgDocDetail 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 R_PRAAcctgDocDetailTP
;

Learn More