What is C_RRBWrittenOffDynamicItem in SAP S/4HANA?

C_RRBWrittenOffDynamicItem is a consumption CDS view in SAP S/4HANA. Written Off Dynamic Item It contains 49 fields.

Which tables does C_RRBWrittenOffDynamicItem read from?

C_RRBWrittenOffDynamicItem reads data from: P_RRBWrittenOffDynamicItem.

What VDM layer is C_RRBWrittenOffDynamicItem?

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

C_RRBWrittenOffDynamicItem

DDL: C_RRBWRITTENOFFDYNAMICITEM SQL: CRRBWRTOFFDYNITM Type: view CONSUMPTION Package: PS_BILLING_PROPOSALS

49 Fields 1 Data Sources 6 Associations

Written Off Dynamic Item

C_RRBWrittenOffDynamicItem is a Consumption CDS View that provides data about "Written Off Dynamic Item" in SAP S/4HANA. It reads from 1 data source (P_RRBWrittenOffDynamicItem) and exposes 49 fields with key fields RRBSalesPricingDocument, RRBDynamicItem. It has 6 associations to related views. Part of development package PS_BILLING_PROPOSALS.

Data Sources (1)

Source	Alias	Join Type
P_RRBWrittenOffDynamicItem	RRBWrittenOffDynamicItem	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..1]	I_WorkPackage	_CustomerProjectWorkPackage	`$projection.ControllingObject = _CustomerProjectWorkPackage.WBSElementObject and $projection.SalesDocument = _CustomerProjectWorkPackage.SalesOrder and $projection.SalesDocumentItem = _CustomerProjectWorkPackage.SalesOrderItem`
[0..1]	I_WorkPackageWorkItem	_WorkPackageWorkItem	`$projection.WorkItem = _WorkPackageWorkItem.WorkItem and $projection.ControllingObject = _WorkPackageWorkItem.WBSElementObject`
[0..1]	I_WorkItem	_WorkItem	`$projection.WorkItem = _WorkItem.WorkItem`
[0..1]	I_BillingControlCategoryText	_BillingControlCategoryText	`$projection.BillingControlCategory = _BillingControlCategoryText.BillingControlCategory and _BillingControlCategoryText.Language = $session.system_language`
[0..1]	I_SalesDocumentItem	_SalesDocumentItem	`$projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem`
[0..1]	I_TimeSheetOvertimeCatText	_TimeSheetOvertimeCatText	`$projection.TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory and _TimeSheetOvertimeCatText.Language = $session.system_language`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CRRBWRTOFFDYNITM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Written Off Dynamic Item	view
VDM.viewType	#CONSUMPTION	view
VDM.lifecycle.status	#DEPRECATED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	RRBSalesPricingDocument	P_RRBWrittenOffDynamicItem	RRBSalesPricingDocument
KEY	RRBDynamicItem	P_RRBWrittenOffDynamicItem	RRBDynamicItem
	SalesDocumentItem	P_RRBWrittenOffDynamicItem	SalesDocumentItem	Sales Document Item
	TransactionCurrency	P_RRBWrittenOffDynamicItem	TransactionCurrency	Transaction Currency
	UnitOfMeasure	P_RRBWrittenOffDynamicItem	UnitOfMeasure	Unit Protected Qty
	DocumentCurrency	P_RRBWrittenOffDynamicItem	DocumentCurrency	Document Currency
	Material	P_RRBWrittenOffDynamicItem	Material	Vehicle Model
	NetAmount	P_RRBWrittenOffDynamicItem	NetAmount	Stated Amount
	SalesDocument	P_RRBWrittenOffDynamicItem	SalesDocument	SD Document
	WorkItem	P_RRBWrittenOffDynamicItem	WorkItem	Work Item ID
	BillingPlanItemUsage	P_RRBWrittenOffDynamicItem	BillingPlanItemUsage	Usage
	ControllingObject	P_RRBWrittenOffDynamicItem	ControllingObject	Object number
	BillingControlCategory	P_RRBWrittenOffDynamicItem	BillingControlCategory	Billing Category
	SalesDocumentItemText	P_RRBWrittenOffDynamicItem	SalesDocumentItemText	Item Descr.
	ReferenceDocument	P_RRBWrittenOffDynamicItem	ReferenceDocument	Reference Document
	ReferenceDocumentItem	P_RRBWrittenOffDynamicItem	ReferenceDocumentItem	Reference item
	TimeSheetOvertimeCategory	P_RRBWrittenOffDynamicItem	TimeSheetOvertimeCategory
	TimeSheetOvertimeCategoryText	_TimeSheetOvertimeCatText	TimeSheetOvertimeCategoryText
	LedgerGLLineItem	P_RRBWrittenOffDynamicItem	LedgerGLLineItem	Item
	AccountingDocument	P_RRBWrittenOffDynamicItem	AccountingDocument	Journal Entry
	FiscalYear	P_RRBWrittenOffDynamicItem	FiscalYear	G/L Fiscal Year
	CompanyCode	P_RRBWrittenOffDynamicItem	CompanyCode	Receiver Company Code
	BillingPlan	P_RRBWrittenOffDynamicItem	BillingPlan	Bill. Plan No.
	BillingPlanItem	P_RRBWrittenOffDynamicItem	BillingPlanItem	Item
	RejectedAmtInTransCrcy	P_RRBWrittenOffDynamicItem	RejectedAmtInTransCrcy	Amount to be Written Off
	BilledAmountInTransacCrcy	P_RRBWrittenOffDynamicItem	BilledAmountInTransacCrcy
	OriginalAmountInTransacCrcy	P_RRBWrittenOffDynamicItem	OriginalAmountInTransacCrcy	Origl Amt Trans Crcy
	OpenAmountInTransCrcy	P_RRBWrittenOffDynamicItem	OpenAmountInTransCrcy	Open Amt Trans Crcy
	AmountToBeBilledInTransacCrcy	P_RRBWrittenOffDynamicItem	AmountToBeBilledInTransacCrcy
	AmtToBeRejectedInTransacCrcy	P_RRBWrittenOffDynamicItem	AmtToBeRejectedInTransacCrcy
	AmtToBePostponedInTransacCrcy	P_RRBWrittenOffDynamicItem	AmtToBePostponedInTransacCrcy
	CanceledAmountInTransacCrcy	P_RRBWrittenOffDynamicItem	CanceledAmountInTransacCrcy
	OpenQuantity	P_RRBWrittenOffDynamicItem	OpenQuantity	PBE Entry Open Qty
	RejectedQuantity	P_RRBWrittenOffDynamicItem	RejectedQuantity
	BilledQuantity	P_RRBWrittenOffDynamicItem	BilledQuantity
	TotalBillableQtyInBaseUnit	P_RRBWrittenOffDynamicItem	TotalBillableQtyInBaseUnit
	Personnel
	PostingDate
	MaterialNameendasMaterialName			Expense Type/Activity Type
	BillingControlCategoryText
	_TransactionCurrency	P_RRBWrittenOffDynamicItem	_TransactionCurrency
	_UnitOfMeasure	P_RRBWrittenOffDynamicItem	_UnitOfMeasure
	_SalesDocumentItem		_SalesDocumentItem
	_RRBDynamicItemLongText		_RRBDynamicItemLongText
	_TimeSheetOvertimeCatText		_TimeSheetOvertimeCatText
	SalesDocumentType
	SalesOrganization
	OrganizationDivision
	DistributionChannel

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_RRBWrittenOffDynamicItem.
-- 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: CRRBWRTOFFDYNITM

CREATE VIEW C_RRBWrittenOffDynamicItem AS
SELECT
  RRBWrittenOffDynamicItem.RRBSalesPricingDocument AS RRBSalesPricingDocument,
  RRBWrittenOffDynamicItem.RRBDynamicItem AS RRBDynamicItem,
  RRBWrittenOffDynamicItem.SalesDocumentItem AS SalesDocumentItem,
  RRBWrittenOffDynamicItem.TransactionCurrency AS TransactionCurrency,
  RRBWrittenOffDynamicItem.UnitOfMeasure AS UnitOfMeasure,
  RRBWrittenOffDynamicItem.DocumentCurrency AS DocumentCurrency,
  RRBWrittenOffDynamicItem.Material AS Material,
  RRBWrittenOffDynamicItem.NetAmount AS NetAmount,
  RRBWrittenOffDynamicItem.SalesDocument AS SalesDocument,
  RRBWrittenOffDynamicItem.WorkItem AS WorkItem,
  RRBWrittenOffDynamicItem.BillingPlanItemUsage AS BillingPlanItemUsage,
  RRBWrittenOffDynamicItem.ControllingObject AS ControllingObject,
  RRBWrittenOffDynamicItem.BillingControlCategory AS BillingControlCategory,
  RRBWrittenOffDynamicItem.SalesDocumentItemText AS SalesDocumentItemText,
  RRBWrittenOffDynamicItem.ReferenceDocument AS ReferenceDocument,
  RRBWrittenOffDynamicItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  RRBWrittenOffDynamicItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  _TimeSheetOvertimeCatText.TimeSheetOvertimeCategoryText AS TimeSheetOvertimeCategoryText,
  RRBWrittenOffDynamicItem.LedgerGLLineItem AS LedgerGLLineItem,
  RRBWrittenOffDynamicItem.AccountingDocument AS AccountingDocument,
  RRBWrittenOffDynamicItem.FiscalYear AS FiscalYear,
  RRBWrittenOffDynamicItem.CompanyCode AS CompanyCode,
  RRBWrittenOffDynamicItem.BillingPlan AS BillingPlan,
  RRBWrittenOffDynamicItem.BillingPlanItem AS BillingPlanItem,
  RRBWrittenOffDynamicItem.RejectedAmtInTransCrcy AS RejectedAmtInTransCrcy,
  RRBWrittenOffDynamicItem.BilledAmountInTransacCrcy AS BilledAmountInTransacCrcy,
  RRBWrittenOffDynamicItem.OriginalAmountInTransacCrcy AS OriginalAmountInTransacCrcy,
  RRBWrittenOffDynamicItem.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  RRBWrittenOffDynamicItem.AmountToBeBilledInTransacCrcy AS AmountToBeBilledInTransacCrcy,
  RRBWrittenOffDynamicItem.AmtToBeRejectedInTransacCrcy AS AmtToBeRejectedInTransacCrcy,
  RRBWrittenOffDynamicItem.AmtToBePostponedInTransacCrcy AS AmtToBePostponedInTransacCrcy,
  RRBWrittenOffDynamicItem.CanceledAmountInTransacCrcy AS CanceledAmountInTransacCrcy,
  RRBWrittenOffDynamicItem.OpenQuantity AS OpenQuantity,
  RRBWrittenOffDynamicItem.RejectedQuantity AS RejectedQuantity,
  RRBWrittenOffDynamicItem.BilledQuantity AS BilledQuantity,
  RRBWrittenOffDynamicItem.TotalBillableQtyInBaseUnit AS TotalBillableQtyInBaseUnit,
  cast( RRBWrittenOffDynamicItem.Personnel as ps_s4_hr_pernr preserving type ) AS Personnel,
  cast( RRBWrittenOffDynamicItem.PostingDate as ps_s4_fis_bldat preserving type ) AS PostingDate,
  case when _Material._Text[1:Language = $session.system_language].MaterialName is null then '' else _Material._Text[1:Language = $session.system_language].MaterialName end as MaterialName AS MaterialNameendasMaterialName,
  cast( _BillingControlCategoryText.BillingControlCategoryText as billgctrlcattext preserving type ) AS BillingControlCategoryText,
  RRBWrittenOffDynamicItem._TransactionCurrency AS _TransactionCurrency,
  RRBWrittenOffDynamicItem._UnitOfMeasure AS _UnitOfMeasure,
  _SalesDocumentItem._SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocumentItem._SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocumentItem._SalesDocument.OrganizationDivision AS OrganizationDivision,
  _SalesDocumentItem._SalesDocument.DistributionChannel AS DistributionChannel
FROM P_RRBWrittenOffDynamicItem AS RRBWrittenOffDynamicItem
LEFT OUTER JOIN I_WorkPackage AS _CustomerProjectWorkPackage ON ControllingObject = _CustomerProjectWorkPackage.WBSElementObject AND SalesDocument = _CustomerProjectWorkPackage.SalesOrder AND SalesDocumentItem = _CustomerProjectWorkPackage.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _WorkPackageWorkItem ON WorkItem = _WorkPackageWorkItem.WorkItem AND ControllingObject = _WorkPackageWorkItem.WBSElementObject  -- association [0..1]
LEFT OUTER JOIN I_WorkItem AS _WorkItem ON WorkItem = _WorkItem.WorkItem  -- association [0..1]
LEFT OUTER JOIN I_BillingControlCategoryText AS _BillingControlCategoryText ON BillingControlCategory = _BillingControlCategoryText.BillingControlCategory AND _BillingControlCategoryText.Language = $session.system_language  -- 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_TimeSheetOvertimeCatText AS _TimeSheetOvertimeCatText ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCatText.TimeSheetOvertimeCategory AND _TimeSheetOvertimeCatText.Language = $session.system_language  -- association [0..1]
;

Depth:

C_RRBWrittenOffDynamicItem view

P_RRBWrittenOffDynamicItem view