What is C_RRBDynamicItemFlow in SAP S/4HANA?

C_RRBDynamicItemFlow is a consumption CDS view in SAP S/4HANA. Dynamic Item Flow With Characteristics It contains 50 fields.

Which tables does C_RRBDynamicItemFlow read from?

C_RRBDynamicItemFlow reads data from: P_RRBDynamicItemFlow02.

What VDM layer is C_RRBDynamicItemFlow?

C_RRBDynamicItemFlow is classified as a Consumption view optimized for specific business scenarios and reporting.

C_RRBDynamicItemFlow

DDL: C_RRBDYNAMICITEMFLOW SQL: CRRBDYNITMFLW Type: view CONSUMPTION Package: PS_BILLING_PROPOSALS

50 Fields 1 Data Sources 1 Associations

Dynamic Item Flow With Characteristics

C_RRBDynamicItemFlow is a Consumption CDS View that provides data about "Dynamic Item Flow With Characteristics" in SAP S/4HANA. It reads from 1 data source (P_RRBDynamicItemFlow02) and exposes 50 fields with key fields RRBDynamicItem, RRBDynItmProfileUsage, SalesDocument, SalesDocumentItem. It has 1 association to related views. Part of development package PS_BILLING_PROPOSALS.

Data Sources (1)

Source	Alias	Join Type
P_RRBDynamicItemFlow02	DynamicItemFlow	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	E_JournalEntryItem	_JournalEntryItemExtension	`$projection.SourceLedger = _JournalEntryItemExtension.SourceLedger and $projection.CompanyCode = _JournalEntryItemExtension.CompanyCode and $projection.FiscalYear = _JournalEntryItemExtension.FiscalYear and $projection.AccountingDocument = _JournalEntryItemExtension.AccountingDocument and $projection.LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	CRRBDYNITMFLW	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Dynamic Item Flow With Characteristics	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (50)

Key	Field	Source Table	Source Field	Description
KEY	RRBDynamicItem	P_RRBDynamicItemFlow02	RRBDynamicItem
KEY	RRBDynItmProfileUsage	P_RRBDynamicItemFlow02	RRBDynItmProfileUsage
KEY	SalesDocument	P_RRBDynamicItemFlow02	SalesDocument	SD Document
KEY	SalesDocumentItem	P_RRBDynamicItemFlow02	SalesDocumentItem	Sales Document Item
	BillingPlan	P_RRBDynamicItemFlow02	BillingPlan	Bill. Plan No.
	BillingPlanItem	P_RRBDynamicItemFlow02	BillingPlanItem	Item
	BillingDocumentCategory	P_RRBDynamicItemFlow02	BillingDocumentCategory	BillingCategory
	DynItemProcessorPrfl	P_RRBDynamicItemFlow02	DynItemProcessorPrfl
	WBSElementObject	P_RRBDynamicItemFlow02	WBSElementObject	Object number
	SourceLedger	P_RRBDynamicItemFlow02	SourceLedger	Source Ledger
	CompanyCode	P_RRBDynamicItemFlow02	CompanyCode	Receiver Company Code
	FiscalYear	P_RRBDynamicItemFlow02	FiscalYear	G/L Fiscal Year
	AccountingDocument	P_RRBDynamicItemFlow02	AccountingDocument	Journal Entry
	LedgerGLLineItem	P_RRBDynamicItemFlow02	LedgerGLLineItem	Journal Entry Item
	PartnerCompanyCode	P_RRBDynamicItemFlow02	PartnerCompanyCode	Partner Company Code
	CostElement	P_RRBDynamicItemFlow02	CostElement	G/L Account
	ControllingArea	P_RRBDynamicItemFlow02	ControllingArea	Controlling Area
	ServicesRenderedDate	P_RRBDynamicItemFlow02	ServicesRenderedDate	Services Rendered Date
	PostingDate	P_RRBDynamicItemFlow02	PostingDate	Posting Date for GR
	BillingPlanBillingDate	P_RRBDynamicItemFlow02	BillingPlanBillingDate
	DocumentDate	P_RRBDynamicItemFlow02	DocumentDate	Journal Entry Date
	Personnel	P_RRBDynamicItemFlow02	Personnel	Personnel No.
	Employee	P_RRBDynamicItemFlow02	Employee	Object ID
	EmployeeFullName	P_RRBDynamicItemFlow02	EmployeeFullName
	CostCtrActivityType	P_RRBDynamicItemFlow02	CostCtrActivityType	Activity Type
	CostCtrActivityTypeName
	Material	P_RRBDynamicItemFlow02	Material	Vehicle Model
	MaterialGroup	P_RRBDynamicItemFlow02	MaterialGroup	Product Group
	MaterialName	P_RRBDynamicItemFlow02	MaterialName	Material Description
	DocumentText	P_RRBDynamicItemFlow02	DocumentText	Text ID
	RRBDynamicItemLongText	P_RRBDynamicItemFlow02	RRBDynamicItemLongText
	Project	P_RRBDynamicItemFlow02	Project	WBS Element
	ProjectDescription	P_RRBDynamicItemFlow02	ProjectDescription	Project Name
	WBSElementInternalID	P_RRBDynamicItemFlow02	WBSElementInternalID	WBS Internal ID
	WBSElement	P_RRBDynamicItemFlow02	WBSElement	WBS Internal ID
	WBSDescription	P_RRBDynamicItemFlow02	WBSDescription	WBS Element Name
	TimeSheetOvertimeCategory	P_RRBDynamicItemFlow02	TimeSheetOvertimeCategory
	TimeSheetOvertimeCategoryText
	WorkItem	P_RRBDynamicItemFlow02	WorkItem	Work Item ID
	WorkItemName	P_RRBDynamicItemFlow02	WorkItemName
	UnitOfMeasure	P_RRBDynamicItemFlow02	UnitOfMeasure	Unit Protected Qty
	BilledQuantity	P_RRBDynamicItemFlow02	BilledQuantity
	GlobalCurrency	P_RRBDynamicItemFlow02	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_RRBDynamicItemFlow02	AmountInGlobalCurrency	Amount in Global Currency
	TransactionCurrency	P_RRBDynamicItemFlow02	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	P_RRBDynamicItemFlow02	AmountInTransactionCurrency	Pt Crcy Amt
	DocumentCurrency	P_RRBDynamicItemFlow02	DocumentCurrency	Document Currency
	NetAmount	P_RRBDynamicItemFlow02	NetAmount	Stated Amount
	NetPriceAmount	P_RRBDynamicItemFlow02	NetPriceAmount	Net Price
	DocumentReferenceID	_JournalEntry	DocumentReferenceID	Reference

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_RRBDynamicItemFlow.
-- 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: CRRBDYNITMFLW

CREATE VIEW C_RRBDynamicItemFlow 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.SourceLedger AS SourceLedger,
  DynamicItemFlow.CompanyCode AS CompanyCode,
  DynamicItemFlow.FiscalYear AS FiscalYear,
  DynamicItemFlow.AccountingDocument AS AccountingDocument,
  DynamicItemFlow.LedgerGLLineItem AS LedgerGLLineItem,
  DynamicItemFlow.PartnerCompanyCode AS PartnerCompanyCode,
  DynamicItemFlow.CostElement AS CostElement,
  DynamicItemFlow.ControllingArea AS ControllingArea,
  DynamicItemFlow.ServicesRenderedDate AS ServicesRenderedDate,
  DynamicItemFlow.PostingDate AS PostingDate,
  DynamicItemFlow.BillingPlanBillingDate AS BillingPlanBillingDate,
  DynamicItemFlow.DocumentDate AS DocumentDate,
  DynamicItemFlow.Personnel AS Personnel,
  DynamicItemFlow.Employee AS Employee,
  DynamicItemFlow.EmployeeFullName AS EmployeeFullName,
  DynamicItemFlow.CostCtrActivityType AS CostCtrActivityType,
  DynamicItemFlow._CostCenterActivityTypeText.CostCtrActivityTypeName AS CostCtrActivityTypeName,
  DynamicItemFlow.Material AS Material,
  DynamicItemFlow.MaterialGroup AS MaterialGroup,
  DynamicItemFlow.MaterialName AS MaterialName,
  DynamicItemFlow.DocumentText AS DocumentText,
  DynamicItemFlow.RRBDynamicItemLongText AS RRBDynamicItemLongText,
  DynamicItemFlow.Project AS Project,
  DynamicItemFlow.ProjectDescription AS ProjectDescription,
  DynamicItemFlow.WBSElementInternalID AS WBSElementInternalID,
  DynamicItemFlow.WBSElement AS WBSElement,
  DynamicItemFlow.WBSDescription AS WBSDescription,
  DynamicItemFlow.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  DynamicItemFlow._TimeSheetOvertimeCatText.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  DynamicItemFlow.WorkItem AS WorkItem,
  DynamicItemFlow.WorkItemName AS WorkItemName,
  DynamicItemFlow.UnitOfMeasure AS UnitOfMeasure,
  DynamicItemFlow.BilledQuantity AS BilledQuantity,
  DynamicItemFlow.GlobalCurrency AS GlobalCurrency,
  DynamicItemFlow.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  DynamicItemFlow.TransactionCurrency AS TransactionCurrency,
  DynamicItemFlow.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  DynamicItemFlow.DocumentCurrency AS DocumentCurrency,
  DynamicItemFlow.NetAmount AS NetAmount,
  DynamicItemFlow.NetPriceAmount AS NetPriceAmount,
  _JournalEntry.DocumentReferenceID AS DocumentReferenceID
FROM P_RRBDynamicItemFlow02 AS DynamicItemFlow
LEFT OUTER JOIN E_JournalEntryItem AS _JournalEntryItemExtension ON SourceLedger = _JournalEntryItemExtension.SourceLedger AND CompanyCode = _JournalEntryItemExtension.CompanyCode AND FiscalYear = _JournalEntryItemExtension.FiscalYear AND AccountingDocument = _JournalEntryItemExtension.AccountingDocument AND LedgerGLLineItem = _JournalEntryItemExtension.LedgerGLLineItem  -- association [1..1]
;

Depth:

C_RRBDynamicItemFlow view

P_RRBDynamicItemFlow02 view