I_RAContrWithPostedBalance

DDL: I_RACONTRWITHPOSTEDBALANCE SQL: IRACONTRBALANCE Type: view COMPOSITE
15 Fields 1 Data Sources

Interface RA Posted Contract Balance

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

Data Sources (1)

SourceAliasJoin Type
I_RevenueAccountingContract I_RevenueAccountingContract from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IRACONTRBALANCE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Interface RA Posted Contract Balance view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract I_RevenueAccountingContract RevenueAccountingContract Revenue Contract
RevnAcctgContractDescription RevnAcctgContractDescription Description
CompanyCode I_RevenueAccountingContract CompanyCode Receiver Company Code
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
BusinessPartner BusinessPartner Issuing Authority
Customer Customer Sold-to Party
TotContractualPrcInSlsDocCrcy TotContractualPrcInSlsDocCrcy Contractual Price
_BusinessPartner
_Customer I_RevenueAccountingContract _Customer
_CompanyCode I_RevenueAccountingContract _CompanyCode
_AccountingPrinciple I_RevenueAccountingContract _AccountingPrinciple
_Currency I_RevenueAccountingContract _Currency
_SalesOrganization I_RevenueAccountingContract _SalesOrganization
_CreatedByUser I_RevenueAccountingContract _CreatedByUser
_ChangedByUser I_RevenueAccountingContract _ChangedByUser

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_RAContrWithPostedBalance.
-- 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.
-- SQL view name: IRACONTRBALANCE

CREATE VIEW I_RAContrWithPostedBalance AS
SELECT
  I_RevenueAccountingContract.RevenueAccountingContract AS RevenueAccountingContract,
  RevnAcctgContractDescription,
  I_RevenueAccountingContract.CompanyCode AS CompanyCode,
  AccountingPrinciple,
  BusinessPartner,
  Customer,
  TotContractualPrcInSlsDocCrcy,
  / I_RevenueAccountingContract._BusinessPartner AS _BusinessPartner,
  I_RevenueAccountingContract._Customer AS _Customer,
  I_RevenueAccountingContract._CompanyCode AS _CompanyCode,
  I_RevenueAccountingContract._AccountingPrinciple AS _AccountingPrinciple,
  I_RevenueAccountingContract._Currency AS _Currency,
  I_RevenueAccountingContract._SalesOrganization AS _SalesOrganization,
  I_RevenueAccountingContract._CreatedByUser AS _CreatedByUser,
  I_RevenueAccountingContract._ChangedByUser AS _ChangedByUser
FROM I_RevenueAccountingContract
;

Learn More