P_RRBDynamicItemFlow02
P_RRBDynamicItemFlow02 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RRBDynamicItemFlow01) and exposes 50 fields with key fields RRBDynamicItem, RRBDynItmProfileUsage, SalesDocument, SalesDocumentItem. It has 3 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_RRBDynamicItemFlow01 | DynamicItemFlow | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_CostCenterActivityTypeText | _CostCenterActivityTypeText | $projection.controllingarea = _CostCenterActivityTypeText.ControllingArea and $projection.CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType and _CostCenterActivityTypeText.ValidityEndDate >= $session.system_date and _CostCenterActivityTypeText.Language = $session.system_language |
| [0..1] | I_TimeSheetOvertimeCatText | _TimeSheetOvertimeCatText | $projection.TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory and _TimeSheetOvertimeCatText.Language = $session.system_language |
| [0..1] | I_JournalEntry | _JournalEntry | $projection.companycode = _JournalEntry.CompanyCode and $projection.fiscalyear = _JournalEntry.FiscalYear and $projection.accountingdocument = _JournalEntry.AccountingDocument |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PRRBDYNITMFLW2 | view | |
| VDM.private | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (50)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | RRBDynamicItem | P_RRBDynamicItemFlow01 | RRBDynamicItem | |
| KEY | RRBDynItmProfileUsage | P_RRBDynamicItemFlow01 | RRBDynItmProfileUsage | |
| KEY | SalesDocument | P_RRBDynamicItemFlow01 | SalesDocument | SD Document |
| KEY | SalesDocumentItem | P_RRBDynamicItemFlow01 | SalesDocumentItem | Sales Document Item |
| BillingPlan | P_RRBDynamicItemFlow01 | BillingPlan | Bill. Plan No. | |
| BillingPlanItem | P_RRBDynamicItemFlow01 | BillingPlanItem | Item | |
| BillingDocumentCategory | P_RRBDynamicItemFlow01 | BillingDocumentCategory | BillingCategory | |
| DynItemProcessorPrfl | P_RRBDynamicItemFlow01 | DynItemProcessorPrfl | ||
| WBSElementObject | P_RRBDynamicItemFlow01 | WBSElementObject | Object number | |
| SourceLedger | ||||
| CompanyCode | ||||
| FiscalYear | ||||
| AccountingDocument | ||||
| LedgerGLLineItem | ||||
| CostElement | P_RRBDynamicItemFlow01 | CostElement | G/L Account | |
| ControllingArea | ||||
| ServicesRenderedDate | ||||
| PostingDate | ||||
| DocumentDate | ||||
| PartnerCompanyCode | ||||
| BillingPlanBillingDate | ||||
| Personnel | P_RRBDynamicItemFlow01 | Personnel | Personnel No. | |
| Employee | ||||
| EmployeeFullName | ||||
| CostCtrActivityType | P_RRBDynamicItemFlow01 | CostCtrActivityType | Activity Type | |
| Material | P_RRBDynamicItemFlow01 | Material | Vehicle Model | |
| MaterialGroup | ||||
| MaterialName | ||||
| DocumentText | P_RRBDynamicItemFlow01 | DocumentItemText | Text | |
| TimeSheetOvertimeCategory | P_RRBDynamicItemFlow01 | TimeSheetOvertimeCategory | ||
| RRBDynamicItemLongText | P_RRBDynamicItemFlow01 | RRBDynamicItemLongText | ||
| Project | ||||
| ProjectDescription | ||||
| WBSElementInternalID | ||||
| WBSElement | ||||
| WBSDescription | ||||
| WorkItem | P_RRBDynamicItemFlow01 | WorkItem | Work Item ID | |
| WorkItemNameendasWorkItemName | ||||
| UnitOfMeasure | P_RRBDynamicItemFlow01 | UnitOfMeasure | Unit Protected Qty | |
| BilledQuantity | P_RRBDynamicItemFlow01 | BilledQuantity | ||
| GlobalCurrency | ||||
| AmountInGlobalCurrency | ||||
| TransactionCurrency | P_RRBDynamicItemFlow01 | TransactionCurrency | Transaction Currency | |
| AmountInTransactionCurrency | ||||
| DocumentCurrency | P_RRBDynamicItemFlow01 | DocumentCurrency | Document Currency | |
| NetAmount | P_RRBDynamicItemFlow01 | NetAmount | Stated Amount | |
| NetPriceAmount | P_RRBDynamicItemFlow01 | NetPriceAmount | Net Price | |
| _JournalEntry | _JournalEntry | |||
| _CostCenterActivityTypeText | _CostCenterActivityTypeText | |||
| _TimeSheetOvertimeCatText | _TimeSheetOvertimeCatText |
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_RRBDynamicItemFlow02.
-- 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: PRRBDYNITMFLW2
CREATE VIEW P_RRBDynamicItemFlow02 AS
SELECT
DynamicItemFlow.RRBDynamicItem AS RRBDynamicItem,
DynamicItemFlow.RRBDynItmProfileUsage AS RRBDynItmProfileUsage,
DynamicItemFlow.SalesDocument AS SalesDocument,
DynamicItemFlow.SalesDocumentItem AS SalesDocumentItem,
DynamicItemFlow.BillingPlan AS BillingPlan,
DynamicItemFlow.BillingPlanItem AS BillingPlanItem,
DynamicItemFlow.BillingDocumentCategory AS BillingDocumentCategory,
DynamicItemFlow.DynItemProcessorPrfl AS DynItemProcessorPrfl,
DynamicItemFlow.WBSElementObject AS WBSElementObject,
DynamicItemFlow._JournalEntryItem.SourceLedger AS SourceLedger,
DynamicItemFlow._JournalEntryItem.CompanyCode AS CompanyCode,
DynamicItemFlow._JournalEntryItem.FiscalYear AS FiscalYear,
DynamicItemFlow._JournalEntryItem.AccountingDocument AS AccountingDocument,
DynamicItemFlow._JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
DynamicItemFlow.CostElement AS CostElement,
DynamicItemFlow._WBSElement.ControllingArea AS ControllingArea,
DynamicItemFlow._JournalEntryItem.ServicesRenderedDate AS ServicesRenderedDate,
DynamicItemFlow._JournalEntryItem.PostingDate AS PostingDate,
DynamicItemFlow._JournalEntryItem.DocumentDate AS DocumentDate,
DynamicItemFlow._JournalEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
DynamicItemFlow._BillingPlanDueDate.BillingPlanBillingDate AS BillingPlanBillingDate,
DynamicItemFlow.Personnel AS Personnel,
DynamicItemFlow._PersonWorkAgreement_1._WorkforcePerson.PersonExternalID AS Employee,
DynamicItemFlow._PersonWorkAgreement_1.PersonFullName AS EmployeeFullName,
DynamicItemFlow.CostCtrActivityType AS CostCtrActivityType,
DynamicItemFlow.Material AS Material,
DynamicItemFlow._Material.MaterialGroup AS MaterialGroup,
DynamicItemFlow._MaterialText.MaterialName AS MaterialName,
DynamicItemFlow.DocumentItemText AS DocumentText,
DynamicItemFlow.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
DynamicItemFlow.RRBDynamicItemLongText AS RRBDynamicItemLongText,
DynamicItemFlow._WBSElement.Project AS Project,
DynamicItemFlow._WBSElement._Project.ProjectDescription AS ProjectDescription,
DynamicItemFlow._WBSElement.WBSElementInternalID AS WBSElementInternalID,
DynamicItemFlow._WBSElement.WBSElement AS WBSElement,
DynamicItemFlow._WBSElement.WBSDescription AS WBSDescription,
DynamicItemFlow.WorkItem AS WorkItem,
case when DynamicItemFlow._WorkItem._Text[ Language = $session.system_language ].WorkItemName is not null then DynamicItemFlow._WorkItem._Text[ Language = $session.system_language ].WorkItemName else DynamicItemFlow._WorkPackageWorkItem.WorkItemName end as WorkItemName AS WorkItemNameendasWorkItemName,
DynamicItemFlow.UnitOfMeasure AS UnitOfMeasure,
DynamicItemFlow.BilledQuantity AS BilledQuantity,
DynamicItemFlow._JournalEntryItem.GlobalCurrency AS GlobalCurrency,
DynamicItemFlow._JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
DynamicItemFlow.TransactionCurrency AS TransactionCurrency,
DynamicItemFlow._JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
DynamicItemFlow.DocumentCurrency AS DocumentCurrency,
DynamicItemFlow.NetAmount AS NetAmount,
DynamicItemFlow.NetPriceAmount AS NetPriceAmount
FROM P_RRBDynamicItemFlow01 AS DynamicItemFlow
LEFT OUTER JOIN I_CostCenterActivityTypeText AS _CostCenterActivityTypeText ON controllingarea = _CostCenterActivityTypeText.ControllingArea AND CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType AND _CostCenterActivityTypeText.ValidityEndDate >= $session.system_date AND _CostCenterActivityTypeText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory AND _TimeSheetOvertimeCatText.Language = $session.system_language -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON companycode = _JournalEntry.CompanyCode AND fiscalyear = _JournalEntry.FiscalYear AND accountingdocument = _JournalEntry.AccountingDocument -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA