I_RAPostedBalancePerContract

DDL: I_RAPOSTEDBALANCEPERCONTRACT Type: view_entity COMPOSITE
12 Fields 1 Data Sources

Interface RA Posted Balance Per Contract

I_RAPostedBalancePerContract is a Composite CDS View that provides data about "Interface RA Posted Balance Per Contract" in SAP S/4HANA. It reads from 1 data source (P_RAContrPostedAmtUnbill) and exposes 12 fields with key field RevenueAccountingContract.

Data Sources (1)

SourceAliasJoin Type
P_RAContrPostedAmtUnbill ContrBal from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Interface RA Posted Balance Per Contract view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract P_RAContrPostedAmtUnbill RevenueAccountingContract Revenue Contract
CompanyCode P_RAContrPostedAmtUnbill CompanyCode Receiver Company Code
PostedRevnInSlsDocCrcy P_RAContrPostedAmtUnbill PostedRevnInSlsDocCrcy
RAContrLiabilitiesAmount P_RAContrPostedAmtUnbill RAContrLiabilitiesAmount
RAContractAssetsAmount P_RAContrPostedAmtUnbill RAContractAssetsAmount
RAPostedUnbilldRblsAmount P_RAContrPostedAmtUnbill RAPostedUnbilldRblsAmount
RADeferredRevenueInSlsDocCrcy P_RAContrPostedAmtUnbill RADeferredRevenueInSlsDocCrcy
RAReceivablesAmtInSlsDocCrcy P_RAContrPostedAmtUnbill RAReceivablesAmtInSlsDocCrcy
RABilledRblsAmtInSlsDocCrcy P_RAContrPostedAmtUnbill RABilledRblsAmtInSlsDocCrcy
RAUnbilledRblsAmount P_RAContrPostedAmtUnbill RAUnbilledRblsAmount
RARblAdjustmentAmtInSlsDocCrcy P_RAContrPostedAmtUnbill RARblAdjustmentAmtInSlsDocCrcy
SalesDocumentCurrency P_RAContrPostedAmtUnbill 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 I_RAPostedBalancePerContract.
-- 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 I_RAPostedBalancePerContract AS
SELECT
  ContrBal.RevenueAccountingContract AS RevenueAccountingContract,
  ContrBal.CompanyCode AS CompanyCode,
  ContrBal.PostedRevnInSlsDocCrcy AS PostedRevnInSlsDocCrcy,
  ContrBal.RAContrLiabilitiesAmount AS RAContrLiabilitiesAmount,
  ContrBal.RAContractAssetsAmount AS RAContractAssetsAmount,
  ContrBal.RAPostedUnbilldRblsAmount AS RAPostedUnbilldRblsAmount,
  ContrBal.RADeferredRevenueInSlsDocCrcy AS RADeferredRevenueInSlsDocCrcy,
  ContrBal.RAReceivablesAmtInSlsDocCrcy AS RAReceivablesAmtInSlsDocCrcy,
  ContrBal.RABilledRblsAmtInSlsDocCrcy AS RABilledRblsAmtInSlsDocCrcy,
  ContrBal.RAUnbilledRblsAmount AS RAUnbilledRblsAmount,
  ContrBal.RARblAdjustmentAmtInSlsDocCrcy AS RARblAdjustmentAmtInSlsDocCrcy,
  ContrBal.SalesDocumentCurrency AS SalesDocumentCurrency
FROM P_RAContrPostedAmtUnbill AS ContrBal
;

Learn More