P_RAContractPostedAmtBill

DDL: P_RACONTRACTPOSTEDAMTBILL Type: view_entity COMPOSITE
13 Fields 1 Data Sources

P_RAContractPostedAmtBill is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RAContractPostedAmtSemiBill) and exposes 13 fields with key field RevenueAccountingContract.

Data Sources (1)

SourceAliasJoin Type
P_RAContractPostedAmtSemiBill bill from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract P_RAContractPostedAmtSemiBill RevenueAccountingContract Revenue Contract
CompanyCode CompanyCode Receiver Company Code
PostedRevnInSlsDocCrcy P_RAContractPostedAmtSemiBill PostedRevnInSlsDocCrcy
PostedInvoiceInSlsDocCrcy P_RAContractPostedAmtSemiBill PostedInvoiceInSlsDocCrcy
RAContrLiabilitiesAmount P_RAContractPostedAmtSemiBill RAContrLiabilitiesAmount
RAContractAssetsAmount P_RAContractPostedAmtSemiBill RAContractAssetsAmount
RAPostedUnbilldRblsAmount P_RAContractPostedAmtSemiBill RAPostedUnbilldRblsAmount
RADeferredRevenueInSlsDocCrcy P_RAContractPostedAmtSemiBill RADeferredRevenueInSlsDocCrcy
RAReceivablesAmtInSlsDocCrcy P_RAContractPostedAmtSemiBill RAReceivablesAmtInSlsDocCrcy
RAContrBalanceDerivationRule P_RAContractPostedAmtSemiBill RAContrBalanceDerivationRule
RARblAdjustmentAmtInSlsDocCrcy P_RAContractPostedAmtSemiBill RARblAdjustmentAmtInSlsDocCrcy
RABilledRblsAmtInSlsDocCrcy P_RAContractPostedAmtSemiBill RABilledRblsAmtInSlsDocCrcy
SalesDocumentCurrency P_RAContractPostedAmtSemiBill SalesDocumentCurrency Currency

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 P_RAContractPostedAmtBill.
-- 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 P_RAContractPostedAmtBill AS
SELECT
  bill.RevenueAccountingContract AS RevenueAccountingContract,
  CompanyCode,
  bill.PostedRevnInSlsDocCrcy AS PostedRevnInSlsDocCrcy,
  bill.PostedInvoiceInSlsDocCrcy AS PostedInvoiceInSlsDocCrcy,
  bill.RAContrLiabilitiesAmount AS RAContrLiabilitiesAmount,
  bill.RAContractAssetsAmount AS RAContractAssetsAmount,
  bill.RAPostedUnbilldRblsAmount AS RAPostedUnbilldRblsAmount,
  bill.RADeferredRevenueInSlsDocCrcy AS RADeferredRevenueInSlsDocCrcy,
  bill.RAReceivablesAmtInSlsDocCrcy AS RAReceivablesAmtInSlsDocCrcy,
  bill.RAContrBalanceDerivationRule AS RAContrBalanceDerivationRule,
  bill.RARblAdjustmentAmtInSlsDocCrcy AS RARblAdjustmentAmtInSlsDocCrcy,
  bill.RABilledRblsAmtInSlsDocCrcy AS RABilledRblsAmtInSlsDocCrcy,
  bill.SalesDocumentCurrency AS SalesDocumentCurrency
FROM P_RAContractPostedAmtSemiBill AS bill
;

Learn More