C_RAContrChgRecdByEffctvDate

DDL: C_RACONTRCHGRECDBYEFFCTVDATE Type: view_entity CONSUMPTION Package: ODATA_FARR_ALLOC_AMT_EXPLAIN
25 Fields 1 Data Sources 2 Associations 1 OData Services

RA Contr Chg Record By Effctv Date

C_RAContrChgRecdByEffctvDate is a Consumption CDS View that provides data about "RA Contr Chg Record By Effctv Date" in SAP S/4HANA. It reads from 1 data source (I_RAContrChgRecdByEffctvDate) and exposes 25 fields with key fields RevenueAccountingContract, RevnAcctgContrChangeEffctvDate. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F4424). Part of development package ODATA_FARR_ALLOC_AMT_EXPLAIN.

Data Sources (1)

SourceAliasJoin Type
I_RAContrChgRecdByEffctvDate I_RAContrChgRecdByEffctvDate from

Associations (2)

CardinalityTargetAliasCondition
[1..*] C_RAPriceAllocationDetails _Item $projection.RevenueAccountingContract = _Item.RevenueAccountingContract and $projection.RevnAcctgContrChangeEffctvDate = _Item.RevnAcctgContrChangeEffctvDate
[1..*] C_RAChangeTypeItemChangeHist _ChangeHistory $projection.RevenueAccountingContract = _ChangeHistory.RevenueAccountingContract and $projection.RevnAcctgContrChangeEffctvDate = _ChangeHistory.RACurrentContrChangeEffctvDate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label RA Contr Chg Record By Effctv Date view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4424 ASQL_F4424 C2 NOT_RELEASED

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
KEY RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate
RevnAcctgContractDescription RevnAcctgContractDescription Description
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy Contractual Price
PrevContractualPrcInSlsDocCrcy PrevContractualPrcInSlsDocCrcy
SalesDocumentCurrency SalesDocumentCurrency Currency
CompanyCode CompanyCode Receiver Company Code
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
AccountingPrincipleName
Customer Customer Sold-to Party
CustomerName
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
RevnContrAssetsImpairmentDate RevnContrAssetsImpairmentDate Early Termination Date
ContrAssetsImprmtDateIsHidden ContrAssetsImprmtDateIsHidden
RAContractChangeDate RAContractChangeDate
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
RAContractIsUniversal RAContractIsUniversal Universal Revenue Contract
_Item _Item
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_AccountingPrinciple _AccountingPrinciple
_ChangeHistory _ChangeHistory

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 C_RAContrChgRecdByEffctvDate.
-- 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 C_RAContrChgRecdByEffctvDate AS
SELECT
  RevenueAccountingContract,
  RevnAcctgContrChangeEffctvDate,
  RevnAcctgContractDescription,
  ContractualPrcInSlsDocCrcy,
  PrevContractualPrcInSlsDocCrcy,
  SalesDocumentCurrency,
  CompanyCode,
  AccountingPrinciple,
  _AccountingPrinciple._Text[1: Language = $session.system_language].AccountingPrincipleName AS AccountingPrincipleName,
  Customer,
  I_RAContrChgRecdByEffctvDate._Customer.CustomerName AS CustomerName,
  BusinessPartner,
  I_RAContrChgRecdByEffctvDate._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  FiscalYear,
  FiscalPeriod,
  RevnContrAssetsImpairmentDate,
  ContrAssetsImprmtDateIsHidden,
  RAContractChangeDate,
  IsBusinessPurposeCompleted,
  RAContractIsUniversal
FROM I_RAContrChgRecdByEffctvDate
LEFT OUTER JOIN C_RAPriceAllocationDetails AS _Item ON RevenueAccountingContract = _Item.RevenueAccountingContract AND RevnAcctgContrChangeEffctvDate = _Item.RevnAcctgContrChangeEffctvDate  -- association [1..*]
LEFT OUTER JOIN C_RAChangeTypeItemChangeHist AS _ChangeHistory ON RevenueAccountingContract = _ChangeHistory.RevenueAccountingContract AND RevnAcctgContrChangeEffctvDate = _ChangeHistory.RACurrentContrChangeEffctvDate  -- association [1..*]
;

Learn More