P_RARevnExplMigrationItem

DDL: P_RAREVNEXPLMIGRATIONITEM SQL: PRAREMIGITEM Type: view COMPOSITE
11 Fields 1 Data Sources

P_RARevnExplMigrationItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RARevnExplMigrationRevn) and exposes 11 fields with key fields PerformanceObligation, RAContractTransformRecnclnKey, RevenueAccountingContract.

Data Sources (1)

SourceAliasJoin Type
P_RARevnExplMigrationRevn RevnExplMigrationItem from

Annotations (6)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PRAREMIGITEM view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation P_RARevnExplMigrationRevn PerformanceObligation Performance Obligation
KEY RAContractTransformRecnclnKey P_RARevnExplMigrationRevn RAContractTransformRecnclnKey
KEY RevenueAccountingContract P_RARevnExplMigrationRevn RevenueAccountingContract Revenue Contract
DeltaRecognizedAmtInSlsDocCrcy P_RARevnExplMigrationRevn DeltaRecognizedAmtInSlsDocCrcy
CumltvEffectiveAmtInSlsDocCrcy P_RARevnExplMigrationRevn CumltvEffectiveAmtInSlsDocCrcy
ContractualPrcInSlsDocCrcy P_RARevnExplMigrationRevn ContractualPrcInSlsDocCrcy Contractual Price
SalesDocumentCurrency P_RARevnExplMigrationRevn SalesDocumentCurrency Currency
PerfOblgnCumltvEffectiveQty P_RARevnExplMigrationRevn PerfOblgnCumltvEffectiveQty
ReportedFulfilledQuantity Fulfillment ReportedFulfilledQuantity
FulfilledQuantityUnit Fulfillment FulfilledQuantityUnit
FulfilledAmountInSlsDocCrcy Fulfillment FulfilledAmountInSlsDocCrcy

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 P_RARevnExplMigrationItem.
-- 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: PRAREMIGITEM

CREATE VIEW P_RARevnExplMigrationItem AS
SELECT
  RevnExplMigrationItem.PerformanceObligation AS PerformanceObligation,
  RevnExplMigrationItem.RAContractTransformRecnclnKey AS RAContractTransformRecnclnKey,
  RevnExplMigrationItem.RevenueAccountingContract AS RevenueAccountingContract,
  RevnExplMigrationItem.DeltaRecognizedAmtInSlsDocCrcy AS DeltaRecognizedAmtInSlsDocCrcy,
  RevnExplMigrationItem.CumltvEffectiveAmtInSlsDocCrcy AS CumltvEffectiveAmtInSlsDocCrcy,
  RevnExplMigrationItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  RevnExplMigrationItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevnExplMigrationItem.PerfOblgnCumltvEffectiveQty AS PerfOblgnCumltvEffectiveQty,
  Fulfillment.ReportedFulfilledQuantity AS ReportedFulfilledQuantity,
  Fulfillment.FulfilledQuantityUnit AS FulfilledQuantityUnit,
  Fulfillment.FulfilledAmountInSlsDocCrcy AS FulfilledAmountInSlsDocCrcy
FROM P_RARevnExplMigrationRevn AS RevnExplMigrationItem
;

Learn More