P_RRBDynamicItemFlow00

DDL: P_RRBDYNAMICITEMFLOW00 SQL: PRRBDYNITMFLW00 Type: view CONSUMPTION
29 Fields 2 Data Sources 5 Associations

P_RRBDynamicItemFlow00 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_RRBDynamicItem, I_RRBDynamicItemFlow) and exposes 29 fields with key fields RRBDynamicItem, RRBDynItmProfileUsage, SalesDocument, SalesDocumentItem. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_RRBDynamicItem DynamicItem inner
I_RRBDynamicItemFlow DynamicItemFlow from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_SalesDocItemBillingPlanItem _BillingPlanDueDate $projection.BillingPlan = _BillingPlanDueDate.BillingPlan and $projection.BillingPlanItem = _BillingPlanDueDate.BillingPlanItem
[0..1] I_WBSElement _WBSElement $projection.ControllingObject = _WBSElement.WBSElementObject
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem
[0..1] I_PersonWorkAgreement_1 _PersonWorkAgreement_1 $projection.Personnel = _PersonWorkAgreement_1.PersonWorkAgreement
[0..*] I_RRBDynamicItemLongText _RRBDynamicItemLongText $projection.RRBDynamicItem = _RRBDynamicItemLongText.RRBDynamicItem

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRRBDYNITMFLW00 view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY RRBDynamicItem I_RRBDynamicItemFlow RRBDynamicItem DI No.
KEY RRBDynItmProfileUsage I_RRBDynamicItemFlow RRBDynItmProfileUsage DI usage
KEY SalesDocument I_RRBDynamicItemFlow SalesDocument SD Document
KEY SalesDocumentItem I_RRBDynamicItemFlow SalesDocumentItem Sales Document Item
FiscalYear I_RRBDynamicItem FiscalYear G/L Fiscal Year
DynItemProcessorPrfl I_RRBDynamicItem DynItemProcessorPrfl DIP Profile
ControllingObject I_RRBDynamicItem ControllingObject Object number
OriginObject I_RRBDynamicItem OriginObject Reference Document
LedgerGLLineItem I_RRBDynamicItem LedgerGLLineItem Journal Entry Item
BillingPlan I_RRBDynamicItem BillingPlan Bill. Plan No.
BillingPlanItem I_RRBDynamicItem BillingPlanItem Item
BillingDocumentCategory I_RRBDynamicItem BillingDocumentCategory BillingCategory
Personnel I_RRBDynamicItem Personnel Personnel No.
AccountingDocument I_RRBDynamicItem AccountingDocument Journal Entry
CostElement I_RRBDynamicItem CostElement G/L Account
CostCtrActivityType I_RRBDynamicItem CostCtrActivityType Activity Type
WorkItem I_RRBDynamicItem WorkItem Work Item ID
DocumentItemText I_RRBDynamicItem DocumentItemText Text
TimeSheetOvertimeCategory I_RRBDynamicItem TimeSheetOvertimeCategory Overtime Category
TransactionCurrency I_RRBDynamicItem TransactionCurrency Transaction Currency
UnitOfMeasure I_RRBDynamicItem UnitOfMeasure Unit Protected Qty
BilledQuantity I_RRBDynamicItemFlow BilledQuantity Total Quantity
_BillingPlanDueDate _BillingPlanDueDate
_WBSElement _WBSElement
_SalesDocumentItem _SalesDocumentItem
_PersonWorkAgreement_1 _PersonWorkAgreement_1
_TransactionCurrency I_RRBDynamicItem _TransactionCurrency
_UnitOfMeasure I_RRBDynamicItem _UnitOfMeasure
_RRBDynamicItemLongText _RRBDynamicItemLongText

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_RRBDynamicItemFlow00.
-- 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: PRRBDYNITMFLW00

CREATE VIEW P_RRBDynamicItemFlow00 AS
SELECT
  DynamicItemFlow.RRBDynamicItem AS RRBDynamicItem,
  DynamicItemFlow.RRBDynItmProfileUsage AS RRBDynItmProfileUsage,
  DynamicItemFlow.SalesDocument AS SalesDocument,
  DynamicItemFlow.SalesDocumentItem AS SalesDocumentItem,
  DynamicItem.FiscalYear AS FiscalYear,
  DynamicItem.DynItemProcessorPrfl AS DynItemProcessorPrfl,
  DynamicItem.ControllingObject AS ControllingObject,
  DynamicItem.OriginObject AS OriginObject,
  DynamicItem.LedgerGLLineItem AS LedgerGLLineItem,
  DynamicItem.BillingPlan AS BillingPlan,
  DynamicItem.BillingPlanItem AS BillingPlanItem,
  DynamicItem.BillingDocumentCategory AS BillingDocumentCategory,
  DynamicItem.Personnel AS Personnel,
  DynamicItem.AccountingDocument AS AccountingDocument,
  DynamicItem.CostElement AS CostElement,
  DynamicItem.CostCtrActivityType AS CostCtrActivityType,
  DynamicItem.WorkItem AS WorkItem,
  DynamicItem.DocumentItemText AS DocumentItemText,
  DynamicItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  DynamicItem.TransactionCurrency AS TransactionCurrency,
  DynamicItem.UnitOfMeasure AS UnitOfMeasure,
  DynamicItemFlow.BilledQuantity AS BilledQuantity,
  DynamicItem._TransactionCurrency AS _TransactionCurrency,
  DynamicItem._UnitOfMeasure AS _UnitOfMeasure
FROM I_RRBDynamicItemFlow AS DynamicItemFlow
INNER JOIN I_RRBDynamicItem AS DynamicItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocItemBillingPlanItem AS _BillingPlanDueDate ON BillingPlan = _BillingPlanDueDate.BillingPlan AND BillingPlanItem = _BillingPlanDueDate.BillingPlanItem  -- association [0..*]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON ControllingObject = _WBSElement.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON Personnel = _PersonWorkAgreement_1.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_RRBDynamicItemLongText AS _RRBDynamicItemLongText ON RRBDynamicItem = _RRBDynamicItemLongText.RRBDynamicItem  -- association [0..*]
;

Learn More