I_RAContrMngRevnContrTP

DDL: I_RACONTRMNGREVNCONTRTP Type: view_entity TRANSACTIONAL Package: ODATA_FARR_MANAGE_CONTRACT

Revenue Contract - TP

I_RAContrMngRevnContrTP is a Transactional CDS View that provides data about "Revenue Contract - TP" in SAP S/4HANA. It reads from 1 data source (R_RAContrMngRevnContrTP) and exposes 52 fields with key field RevenueAccountingContract. Part of development package ODATA_FARR_MANAGE_CONTRACT.

Data Sources (1)

SourceAliasJoin Type
R_RAContrMngRevnContrTP R_RAContrMngRevnContrTP projection

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Revenue Contract - TP view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.sapObjectNodeType.name RevenueAccountingContract view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix RCH view
AbapCatalog.extensibility.quota.maximumFields 200 view
AbapCatalog.extensibility.quota.maximumBytes 2200 view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
RevnAcctgContractDescription RevnAcctgContractDescription Description
CompanyCode CompanyCode Receiver Company Code
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
Customer Customer Sold-to Party
CustomerName CustomerName Name of Customer
TotContractualPrcInSlsDocCrcy TotContractualPrcInSlsDocCrcy Contractual Price
RAContrBalanceIsDfrrdRevn RAContrBalanceIsDfrrdRevn TRUE
RAContrBalanceIsLiability RAContrBalanceIsLiability TRUE
NumberOfPerformanceObligations NumberOfPerformanceObligations Number of Performance Obligations
AllocEffctAmountInSalesDocCrcy AllocEffctAmountInSalesDocCrcy Allocation Effect
RevnContrAssetsImpairmentDate RevnContrAssetsImpairmentDate Early Termination Date
RAContractHasAssetsImpairment RAContractHasAssetsImpairment Contract was Terminated Early
RevnAcctgContractStatus RevnAcctgContractStatus Contract Status
RevnAcctgContractStatusName RevnAcctgContractStatusName Contract Status Description
RAContractStatusCriticality RAContractStatusCriticality INT1
RAContractCompletionDate RAContractCompletionDate Completion Date
SalesDocumentCurrency SalesDocumentCurrency Currency
RevnAcctgSalesOrganization RevnAcctgSalesOrganization Sales Org.
RAContractHasAllocationEffect RAContractHasAllocationEffect Has Allocation Effect
CreatedByUserDescription CreatedByUserDescription Description
RevnAcctgContractCreationDate RevnAcctgContractCreationDate Created On
LastChangedByUserDescription LastChangedByUserDescription Description
RAContractLastChangeDate RAContractLastChangeDate Changed on
RAContractIsSoftDeleted RAContractIsSoftDeleted Soft Deleted
RAContrManualChgBusinessReason RAContrManualChgBusinessReason Bus Chg Reason
HasAttachment HasAttachment Truth Value
RAContractHasCompoundPerfOblgn RAContractHasCompoundPerfOblgn TRUE
RAContractIsManuallyAllocated RAContractIsManuallyAllocated Price Allocated Manually
RAContrHasMnlPrcAllocConflict RAContrHasMnlPrcAllocConflict Allocation Conflict
RAAttributeHasConflict RAAttributeHasConflict Attr conflict
PerfOblgnHasSprdgConflict PerfOblgnHasSprdgConflict Spreading Conflict
PerfOblgnHasManualSpreading PerfOblgnHasManualSpreading Spreading Changed Manually
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
RAContractLastSavedDateTime RAContractLastSavedDateTime Time Stamp
RAContractIsUniversal RAContractIsUniversal Universal Rev Contr
RAContrIsNotActvUnivRevnRecgn RAContrIsNotActvUnivRevnRecgn TRUE
RAContractPostingMode RAContractPostingMode Posting Mode
RAContractPostingModeName RAContractPostingModeName Short Description
RARevnLbltyAssetCalcIsEnabled RARevnLbltyAssetCalcIsEnabled Revenue Calculation is Allowed
RARevenuePostIsEnabled RARevenuePostIsEnabled Revenue Post is Allowed
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
RevnAcctgContractCreatedByUser RevnAcctgContractCreatedByUser Last Changed By
RAContractLastChangedByUsr RAContractLastChangedByUsr Last Changed By
_AccountingPrinciple _AccountingPrinciple
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_RAContrMnlChgBusinessRsnText _RAContrMnlChgBusinessRsnText
_SalesOrganization _SalesOrganization

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_RAContrMngRevnContrTP.
-- 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_RAContrMngRevnContrTP AS
SELECT
  RevenueAccountingContract,
  RevnAcctgContractDescription,
  CompanyCode,
  AccountingPrinciple,
  BusinessPartner,
  BusinessPartnerName,
  Customer,
  CustomerName,
  TotContractualPrcInSlsDocCrcy,
  RAContrBalanceIsDfrrdRevn,
  RAContrBalanceIsLiability,
  NumberOfPerformanceObligations,
  AllocEffctAmountInSalesDocCrcy,
  RevnContrAssetsImpairmentDate,
  RAContractHasAssetsImpairment,
  RevnAcctgContractStatus,
  RevnAcctgContractStatusName,
  RAContractStatusCriticality,
  RAContractCompletionDate,
  SalesDocumentCurrency,
  RevnAcctgSalesOrganization,
  RAContractHasAllocationEffect,
  CreatedByUserDescription,
  RevnAcctgContractCreationDate,
  LastChangedByUserDescription,
  RAContractLastChangeDate,
  RAContractIsSoftDeleted,
  RAContrManualChgBusinessReason,
  HasAttachment,
  RAContractHasCompoundPerfOblgn,
  RAContractIsManuallyAllocated,
  RAContrHasMnlPrcAllocConflict,
  RAAttributeHasConflict,
  PerfOblgnHasSprdgConflict,
  PerfOblgnHasManualSpreading,
  IsBusinessPurposeCompleted,
  RAContractLastSavedDateTime,
  RAContractIsUniversal,
  RAContrIsNotActvUnivRevnRecgn,
  RAContractPostingMode,
  RAContractPostingModeName,
  RARevnLbltyAssetCalcIsEnabled,
  RARevenuePostIsEnabled,
  FiscalYear,
  FiscalPeriod,
  RevnAcctgContractCreatedByUser,
  RAContractLastChangedByUsr
FROM R_RAContrMngRevnContrTP
;