C_BOMItemForCustomerReturn

DDL: C_BOMITEMFORCUSTOMERRETURN SQL: CSDCRETBOMITM Type: view CONSUMPTION Package: ODATA_SD_RETURN_V2

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.

1 data source(s) 18 fields

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
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY BillOfMaterialVersion BillOfMaterialVersion
KEY Product _Mast Material
KEY Plant _Mast Plant
KEY BillOfMaterialComponent _BillOfMaterialItem BillOfMaterialComponent
KEY BillOfMaterialItemUUID _BillOfMaterialItem BillOfMaterialItemUUID
BillOfMaterialCategory BillOfMaterialCategory
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BOMHeaderBaseUnit BOMHeaderBaseUnit
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit
HeaderValidityStartDate HeaderValidityStartDate
HeaderValidityEndDate HeaderValidityEndDate
BillOfMaterialItemUnit _BillOfMaterialItem BillOfMaterialItemUnit
BillOfMaterialItemQuantity _BillOfMaterialItem BillOfMaterialItemQuantity
ValidityStartDate _BillOfMaterialItem ValidityStartDate
ValidityEndDate _BillOfMaterialItem ValidityEndDate
UnitOfMeasureNumberOfDecimals _UnitOfMeasure UnitOfMeasureNumberOfDecimals 
@AbapCatalog.sqlViewName: 'CSDCRETBOMITM'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.preserveKey: true
@EndUserText.label: 'BOM Items for Customer Return'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

define view C_BOMItemForCustomerReturn
  as select from I_BillOfMaterial
{
  key  BillOfMaterial                                 as BillOfMaterial,
  key  BillOfMaterialVariant                          as BillOfMaterialVariant,
  key  BillOfMaterialVersion                          as BillOfMaterialVersion,
  key  _Mast.Material                                 as Product,
  key  _Mast.Plant                                    as Plant,
  key  _BillOfMaterialItem.BillOfMaterialComponent    as BillOfMaterialComponent,
  key  _BillOfMaterialItem.BillOfMaterialItemUUID     as BillOfMaterialItemUUID,

       BillOfMaterialCategory,
       BillOfMaterialVariantUsage,

       @Semantics.unitOfMeasure: true
       BOMHeaderBaseUnit                              as BOMHeaderBaseUnit,

       @Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
       BOMHeaderQuantityInBaseUnit                    as BOMHeaderQuantityInBaseUnit,

       HeaderValidityStartDate                        as HeaderValidityStartDate,
       HeaderValidityEndDate                          as HeaderValidityEndDate,

       @Semantics.unitOfMeasure: true
       _BillOfMaterialItem.BillOfMaterialItemUnit     as BillOfMaterialItemUnit,

       @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
       _BillOfMaterialItem.BillOfMaterialItemQuantity as BillOfMaterialItemQuantity,
       _BillOfMaterialItem.ValidityStartDate          as ValidityStartDate,
       _BillOfMaterialItem.ValidityEndDate            as ValidityEndDate,
       
       _UnitOfMeasure.UnitOfMeasureNumberOfDecimals

}
where
      BillOfMaterialCategory     =  'M'
  and BillOfMaterialVariantUsage =  '5'
  and IsMarkedForDeletion        <> 'X'

Learn More