C_BOMItemForCustomerReturn

DDL: C_BOMITEMFORCUSTOMERRETURN SQL: CSDCRETBOMITM Type: view CONSUMPTION Package: ODATA_SD_RETURN_V2
18 Fields 1 Data Sources

BOM Items for Customer Return

C_BOMItemForCustomerReturn is a Consumption CDS View that provides data about "BOM Items for Customer Return" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterial) and exposes 18 fields with key fields BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, Product, Plant. Part of development package ODATA_SD_RETURN_V2.

Data Sources (1)

SourceAliasJoin Type
I_BillOfMaterial I_BillOfMaterial from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CSDCRETBOMITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
EndUserText.label BOM Items for Customer Return view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial BOM
KEY BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
KEY BillOfMaterialVersion BillOfMaterialVersion BOM Version
KEY Product _Mast Material Vehicle Model
KEY Plant _Mast Plant Valuation Area
KEY BillOfMaterialComponent _BillOfMaterialItem BillOfMaterialComponent Component
KEY BillOfMaterialItemUUID _BillOfMaterialItem BillOfMaterialItemUUID Guid
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BOMHeaderBaseUnit BOMHeaderBaseUnit Base UoM
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit Base quantity
HeaderValidityStartDate HeaderValidityStartDate Valid From
HeaderValidityEndDate HeaderValidityEndDate to
BillOfMaterialItemUnit _BillOfMaterialItem BillOfMaterialItemUnit Component UoM
BillOfMaterialItemQuantity _BillOfMaterialItem BillOfMaterialItemQuantity Quantity
ValidityStartDate _BillOfMaterialItem ValidityStartDate Validity Start Date
ValidityEndDate _BillOfMaterialItem ValidityEndDate ValidTo
UnitOfMeasureNumberOfDecimals _UnitOfMeasure UnitOfMeasureNumberOfDecimals

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_BOMItemForCustomerReturn.
-- 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: CSDCRETBOMITM

CREATE VIEW C_BOMItemForCustomerReturn AS
SELECT
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  _Mast.Material AS Product,
  _Mast.Plant AS Plant,
  _BillOfMaterialItem.BillOfMaterialComponent AS BillOfMaterialComponent,
  _BillOfMaterialItem.BillOfMaterialItemUUID AS BillOfMaterialItemUUID,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  BOMHeaderBaseUnit,
  BOMHeaderQuantityInBaseUnit,
  HeaderValidityStartDate,
  HeaderValidityEndDate,
  _BillOfMaterialItem.BillOfMaterialItemUnit AS BillOfMaterialItemUnit,
  _BillOfMaterialItem.BillOfMaterialItemQuantity AS BillOfMaterialItemQuantity,
  _BillOfMaterialItem.ValidityStartDate AS ValidityStartDate,
  _BillOfMaterialItem.ValidityEndDate AS ValidityEndDate,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals
FROM I_BillOfMaterial
;

Learn More