C_RAContrMngRevnContrTP_2

DDL: C_RACONTRMNGREVNCONTRTP_2 Type: view_entity CONSUMPTION Package: ODATA_FARR_MANAGE_CONTRACT

Manage Revenue Contracts V4

C_RAContrMngRevnContrTP_2 is a Consumption CDS View that provides data about "Manage Revenue Contracts V4" in SAP S/4HANA. It reads from 1 data source (R_RAContrMngRevnContrTP) and exposes 71 fields with key field RevenueAccountingContract. It is exposed through 2 OData services (ASQL_F3883A, UI_MANAGEREVENUECONTRACTS_V4). Part of development package ODATA_FARR_MANAGE_CONTRACT.

Data Sources (1)

SourceAliasJoin Type
R_RAContrMngRevnContrTP R_RAContrMngRevnContrTP projection

Annotations (14)

NameValueLevelField
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix RCH view
AbapCatalog.extensibility.quota.maximumFields 200 view
AbapCatalog.extensibility.quota.maximumBytes 2200 view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Manage Revenue Contracts V4 view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name RevenueAccountingContract view
Search.searchable true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3883A ASQL_F3883A C2 NOT_RELEASED
UI_MANAGEREVENUECONTRACTS_V4 UI_MANAGEREVENUECONTRACTS_V4 V4 C1 NOT_RELEASED

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
SAPObjectNodeType SAPObjectNodeType SONT Name
RevnAcctgContractDescription RevnAcctgContractDescription Description
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
AccountingPrincipleNamelocalized
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 Has Attachment
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 Revenue Contract
RAContrIsNotActvUnivRevnRecgn RAContrIsNotActvUnivRevnRecgn TRUE
PartnerIsHidden PartnerIsHidden
curr242
curr232
RAContractPostingMode RAContractPostingMode Posting Mode
RAContractPostingModeName RAContractPostingModeName Posting Mode
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
curr282
curr282
curr232
curr232
curr282
curr232
curr232
curr312
curr302
_AccountingPrinciple _AccountingPrinciple
_BusinessPartner _BusinessPartner
_CompanyCode _CompanyCode
_RAContrMnlChgBusinessRsnText _RAContrMnlChgBusinessRsnText
_SalesOrganization _SalesOrganization
_SAPObjectType _SAPObjectType
_NoteBasicredirectedtoC_NoteBasicTP
_CreatedBy _CreatedBy
_LastChangedBy _LastChangedBy

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_RAContrMngRevnContrTP_2.
-- 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_RAContrMngRevnContrTP_2 AS
SELECT
  RevenueAccountingContract,
  SAPObjectNodeType,
  RevnAcctgContractDescription,
  CompanyCode,
  RAContract._CompanyCode.CompanyCodeName AS CompanyCodeName,
  AccountingPrinciple,
  RAContract._AccountingPrinciple._Text.AccountingPrincipleName : localized AS AccountingPrincipleNamelocalized,
  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,
  PartnerIsHidden,
  virtual SuspendedRevnAmtInSlsDocCrcy : abap.curr(24,2) AS curr242,
  virtual SuspendedCostAmtInSlsDocCrcy : abap.curr(23,2) AS curr232,
  RAContractPostingMode,
  RAContractPostingModeName,
  RARevnLbltyAssetCalcIsEnabled,
  RARevenuePostIsEnabled,
  FiscalYear,
  FiscalPeriod,
  RevnAcctgContractCreatedByUser,
  RAContractLastChangedByUsr,
  virtual RAContrLiabilitiesAmount : abap.curr(28, 2) AS curr282,
  virtual RAUnbilledRblsAmount : abap.curr(31, 2) AS curr312,
  virtual RAReceivablesAmtInSlsDocCrcy : abap.curr(30, 2) AS curr302
FROM R_RAContrMngRevnContrTP
;