C_RAMnlRevnSprdgByPeriodTP

DDL: C_RAMNLREVNSPRDGBYPERIODTP Type: view_entity CONSUMPTION Package: ODATA_FARR_MANUALSPREADING
12 Fields 1 Data Sources 1 Associations 2 OData Services

RA Manual Spreading By Period

C_RAMnlRevnSprdgByPeriodTP is a Consumption CDS View that provides data about "RA Manual Spreading By Period" in SAP S/4HANA. It reads from 1 data source (P_RAMnlRevnSprdgByPeriodTP) and exposes 12 fields with key fields RevenueAccountingContract, PerformanceObligation, FiscalYear, FiscalPeriod. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F6122, UI_MANUALSPREADING). Part of development package ODATA_FARR_MANUALSPREADING.

Data Sources (1)

SourceAliasJoin Type
P_RAMnlRevnSprdgByPeriodTP _SprdgByPeriodTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_RAContrManualSpreadingTP _Contract $projection.RevenueAccountingContract = _Contract.RevenueAccountingContract

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RA Manual Spreading By Period view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6122 ASQL_F6122 C2 NOT_RELEASED
UI_MANUALSPREADING UI_MANUALSPREADING V4 C1 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract P_RAMnlRevnSprdgByPeriodTP RevenueAccountingContract Revenue Contract
KEY PerformanceObligation P_RAMnlRevnSprdgByPeriodTP PerformanceObligation Performance Obligation
KEY FiscalYear P_RAMnlRevnSprdgByPeriodTP FiscalYear G/L Fiscal Year
KEY FiscalPeriod P_RAMnlRevnSprdgByPeriodTP FiscalPeriod Tax period
FiscalYearPeriod
CompanyCode CompanyCode Receiver Company Code
AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
FulfilledAmountInSlsDocCrcy Previous Manual Spreading
RecgdCatchUpAmtInSlsDocCrcy RecgdCatchUpAmtInSlsDocCrcy Revenue Catch-up
ReportedFulfilledQuantity ReportedFulfilledQuantity Fulfilled Quantity
_PerformanceObligation _PerformanceObligation
_Contract _Contract

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_RAMnlRevnSprdgByPeriodTP.
-- 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_RAMnlRevnSprdgByPeriodTP AS
SELECT
  _SprdgByPeriodTP.RevenueAccountingContract AS RevenueAccountingContract,
  _SprdgByPeriodTP.PerformanceObligation AS PerformanceObligation,
  _SprdgByPeriodTP.FiscalYear AS FiscalYear,
  _SprdgByPeriodTP.FiscalPeriod AS FiscalPeriod,
  cast( concat(FiscalYear,FiscalPeriod) as fins_fyearperiod) AS FiscalYearPeriod,
  CompanyCode,
  AccountingPrinciple,
  cast(FulfilledAmountInSlsDocCrcy as farr_mnlsprdg_prev_mnl_sprdg preserving type) AS FulfilledAmountInSlsDocCrcy,
  RecgdCatchUpAmtInSlsDocCrcy,
  ReportedFulfilledQuantity
FROM P_RAMnlRevnSprdgByPeriodTP AS _SprdgByPeriodTP
LEFT OUTER JOIN C_RAContrManualSpreadingTP AS _Contract ON RevenueAccountingContract = _Contract.RevenueAccountingContract  -- association [1..1]
;

Learn More