C_BOMItemForCustomerReturn

DDL: C_BOMITEMFORCUSTOMERRETURN SQL: CSDCRETBOMITM Type: view CONSUMPTION

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 16 fields with key fields BillOfMaterial, BillOfMaterialVariant, BillOfMaterialVersion, Product, Plant.

1 data source(s) 16 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 (16)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterial BillOfMaterial
KEY BillOfMaterialVariant BillOfMaterialVariant
KEY BillOfMaterialVersion BillOfMaterialVersion
KEY Product _Mast Material
KEY Plant _Mast Plant
KEY BillOfMaterialComponent _BillOfMaterialItem BillOfMaterialComponent
BillOfMaterialCategory BillOfMaterialCategory
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
BOMHeaderBaseUnit BOMHeaderBaseUnit
BOMHeaderQuantityInBaseUnit BOMHeaderQuantityInBaseUnit
HeaderValidityStartDate HeaderValidityStartDate
HeaderValidityEndDate HeaderValidityEndDate
BillOfMaterialItemUnit _BillOfMaterialItem BillOfMaterialItemUnit
BillOfMaterialItemQuantity _BillOfMaterialItem BillOfMaterialItemQuantity
ValidityStartDate _BillOfMaterialItem ValidityStartDate
ValidityEndDate _BillOfMaterialItem ValidityEndDate 
@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,
     
     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
  
} where BillOfMaterialCategory = 'M'
      and  BillOfMaterialVariantUsage = '5'
      and  IsMarkedForDeletion <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIAL",
"I_BILLOFMATERIALITEM",
"I_MATERIALBOMLINK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More