P_RAContractPostedAmtSemiBill

DDL: P_RACONTRACTPOSTEDAMTSEMIBILL Type: view_entity COMPOSITE
14 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_RAContractPostedAmtRbl sbill from

Annotations (3)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract P_RAContractPostedAmtRbl RevenueAccountingContract Revenue Contract
CompanyCode CompanyCode Receiver Company Code
PostedRevnInSlsDocCrcy P_RAContractPostedAmtRbl PostedRevnInSlsDocCrcy
PostedInvoiceInSlsDocCrcy P_RAContractPostedAmtRbl PostedInvoiceInSlsDocCrcy
RAContrLiabilitiesAmount P_RAContractPostedAmtRbl RAContrLiabilitiesAmount
RAContractAssetsAmount P_RAContractPostedAmtRbl RAContractAssetsAmount
RAPostedUnbilldRblsAmount P_RAContractPostedAmtRbl RAPostedUnbilldRblsAmount
RADeferredRevenueInSlsDocCrcy P_RAContractPostedAmtRbl RADeferredRevenueInSlsDocCrcy
RAReceivablesAmtInSlsDocCrcy P_RAContractPostedAmtRbl RAReceivablesAmtInSlsDocCrcy
RAContrBalanceDerivationRule P_RAContractPostedAmtRbl RAContrBalanceDerivationRule
TransactionPriceInSalesDocCrcy P_RAContractPostedAmtRbl TransactionPriceInSalesDocCrcy Contractual Price
RARblAdjustmentAmtInSlsDocCrcy P_RAContractPostedAmtRbl RARblAdjustmentAmtInSlsDocCrcy
RABilledRblsAmtInSlsDocCrcy P_RAContractPostedAmtRbl PostedInvoiceInSlsDocCrcy
SalesDocumentCurrency P_RAContractPostedAmtRbl 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_RAContractPostedAmtSemiBill.
-- 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_RAContractPostedAmtSemiBill AS
SELECT
  sbill.RevenueAccountingContract AS RevenueAccountingContract,
  CompanyCode,
  sbill.PostedRevnInSlsDocCrcy AS PostedRevnInSlsDocCrcy,
  sbill.PostedInvoiceInSlsDocCrcy AS PostedInvoiceInSlsDocCrcy,
  sbill.RAContrLiabilitiesAmount AS RAContrLiabilitiesAmount,
  sbill.RAContractAssetsAmount AS RAContractAssetsAmount,
  sbill.RAPostedUnbilldRblsAmount AS RAPostedUnbilldRblsAmount,
  sbill.RADeferredRevenueInSlsDocCrcy AS RADeferredRevenueInSlsDocCrcy,
  sbill.RAReceivablesAmtInSlsDocCrcy AS RAReceivablesAmtInSlsDocCrcy,
  sbill.RAContrBalanceDerivationRule AS RAContrBalanceDerivationRule,
  sbill.TransactionPriceInSalesDocCrcy AS TransactionPriceInSalesDocCrcy,
  sbill.RARblAdjustmentAmtInSlsDocCrcy AS RARblAdjustmentAmtInSlsDocCrcy,
  sbill.PostedInvoiceInSlsDocCrcy AS RABilledRblsAmtInSlsDocCrcy,
  sbill.SalesDocumentCurrency AS SalesDocumentCurrency
FROM P_RAContractPostedAmtRbl AS sbill
;

Learn More