I_DELIVERYDOCUMENTITEM

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.representativeKey: 'DeliveryDocumentItem'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Delivery Document Item'
@Analytics.dataCategory: #DIMENSION
@Analytics.dataExtraction: { enabled: true,
                             delta.changeDataCapture:
                             { mapping:
                             [{role: #MAIN,
                               table: 'lips',
                               tableElement: ['vbeln','posnr'],
                               viewElement: ['DeliveryDocument', 'DeliveryDocumentItem']
                               }]
                             }
                           }
@Analytics.internalName:#LOCAL
@Metadata.allowExtensions: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#CHECK
@AbapCatalog.sqlViewName: 'ILEDELIVDOCITEM'
@AbapCatalog.preserveKey:true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]

define view I_DeliveryDocumentItem
  as select from lips

  // Associations

  association [1..1] to I_DeliveryDocument           as _DeliveryDocument              on  $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
  association [0..*] to I_SDDocumentItemPartner      as _Partner                       on  $projection.DeliveryDocument     = _Partner.SDDocument
                                                                                       and $projection.DeliveryDocumentItem = _Partner.SDDocumentItem
  association [0..1] to I_SDDocumentCategory         as _SDDocumentCategory            on  $projection.sddocumentcategory = _SDDocumentCategory.SDDocumentCategory
  association [0..1] to I_SalesDocumentItemCategory  as _ItemCategory                  on  $projection.DeliveryDocumentItemCategory = _ItemCategory.SalesDocumentItemCategory
  association [0..1] to I_SalesDocumentItemType      as _SalesDocumentItemType         on  $projection.SalesDocumentItemType = _SalesDocumentItemType.SalesDocumentItemType
  association [0..1] to I_User                       as _CreatedByUser                 on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_DistributionChannel        as _DistributionChannel           on  $projection.DistributionChannel = _DistributionChannel.DistributionChannel
  association [0..1] to I_Division                   as _Division                      on  $projection.Division = _Division.Division
  association [0..1] to I_SalesGroup                 as _SalesGroup                    on  $projection.SalesGroup = _SalesGroup.SalesGroup
  association [0..1] to I_SalesOffice                as _SalesOffice                   on  $projection.SalesOffice = _SalesOffice.SalesOffice
  association [0..1] to I_Material                   as _Material                      on  $projection.Material = _Material.Material
  association [0..1] to I_Product                    as _Product                       on  $projection.Product = _Product.Product
  association [0..1] to I_Material                   as _OriginallyRequestedMaterial   on  $projection.OriginallyRequestedMaterial = _OriginallyRequestedMaterial.Material
  association [0..1] to I_ProductHierarchyNode       as _ProductHierarchyNode          on  $projection.ProductHierarchyNode = _ProductHierarchyNode.ProductHierarchyNode
  association [0..1] to I_MaterialGroup              as _MaterialGroup                 on  $projection.MaterialGroup = _MaterialGroup.MaterialGroup
  association [0..1] to I_ProductGroup_2             as _ProductGroup                  on  $projection.ProductGroup = _ProductGroup.ProductGroup
  association [0..1] to I_MaterialFreightGroup       as _MaterialFreightGroup          on  $projection.MaterialFreightGroup = _MaterialFreightGroup.MaterialFreightGroup
  association [0..1] to I_AdditionalMaterialGroup1   as _AdditionalMaterialGroup1      on  $projection.AdditionalMaterialGroup1 = _AdditionalMaterialGroup1.AdditionalMaterialGroup1
  association [0..1] to I_AdditionalMaterialGroup2   as _AdditionalMaterialGroup2      on  $projection.AdditionalMaterialGroup2 = _AdditionalMaterialGroup2.AdditionalMaterialGroup2
  association [0..1] to I_AdditionalMaterialGroup3   as _AdditionalMaterialGroup3      on  $projection.AdditionalMaterialGroup3 = _AdditionalMaterialGroup3.AdditionalMaterialGroup3
  association [0..1] to I_AdditionalMaterialGroup4   as _AdditionalMaterialGroup4      on  $projection.AdditionalMaterialGroup4 = _AdditionalMaterialGroup4.AdditionalMaterialGroup4
  association [0..1] to I_AdditionalMaterialGroup5   as _AdditionalMaterialGroup5      on  $projection.AdditionalMaterialGroup5 = _AdditionalMaterialGroup5.AdditionalMaterialGroup5
  association [0..1] to I_Plant                      as _Plant                         on  $projection.Plant = _Plant.Plant
  association [0..1] to I_Warehouse                  as _Warehouse                     on  $projection.Warehouse = _Warehouse.Warehouse
  association [0..1] to I_StorageLocation            as _StorageLocation               on  $projection.Plant           = _StorageLocation.Plant
                                                                                       and $projection.StorageLocation = _StorageLocation.StorageLocation
  association [0..1] to I_InventorySpecialStockType  as _InventorySpecialStockType     on  $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType
  association [0..1] to I_UnitOfMeasure              as _DeliveryQuantityUnit          on  $projection.DeliveryQuantityUnit = _DeliveryQuantityUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _BaseUnit                      on  $projection.BaseUnit = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _ItemWeightUnit                on  $projection.ItemWeightUnit = _ItemWeightUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _ItemVolumeUnit                on  $projection.ItemVolumeUnit = _ItemVolumeUnit.UnitOfMeasure
  association [0..1] to I_BOMExplosionDate           as _BOMExplosion                  on  $projection.BOMExplosion = _BOMExplosion.BOMExplosionDateID
  association [0..1] to I_WarehouseStagingArea       as _WarehouseStagingArea          on  $projection.Warehouse            = _WarehouseStagingArea.Warehouse
                                                                                       and $projection.WarehouseStagingArea = _WarehouseStagingArea.WarehouseStagingArea
  association [0..1] to I_PickingControl             as _PickingControl                on  $projection.PickingControl = _PickingControl.PickingControl
  association [0..1] to I_LoadingGroup               as _LoadingGroup                  on  $projection.LoadingGroup = _LoadingGroup.LoadingGroup
  association [0..1] to I_GoodsMovementType          as _GoodsMovementType             on  $projection.GoodsMovementType = _GoodsMovementType.GoodsMovementType
  association [0..1] to I_TransportationGroup        as _TransportationGroup           on  $projection.TransportationGroup = _TransportationGroup.TransportationGroup
  association [0..1] to I_BillingRelevanceCode       as _ItemIsBillingRelevant         on  $projection.ItemIsBillingRelevant = _ItemIsBillingRelevant.BillingRelevanceCode
  association [0..1] to I_BillingBlockReason         as _ItemBillingBlockReason        on  $projection.ItemBillingBlockReason = _ItemBillingBlockReason.BillingBlockReason
  association [0..1] to I_PaymentGuaranteeForm       as _PaymentGuaranteeForm          on  $projection.PaymentGuaranteeForm = _PaymentGuaranteeForm.PaymentGuaranteeForm
  association [0..1] to I_BusinessArea               as _BusinessArea                  on  $projection.BusinessArea = _BusinessArea.BusinessArea
  association [0..1] to I_ControllingArea            as _ControllingArea               on  $projection.ControllingArea = _ControllingArea.ControllingArea
  association [0..1] to I_ProfitCenter               as _ProfitCenter                  on  $projection.ProfitCenter        = _ProfitCenter.ProfitCenter
                                                                                       and $projection.ControllingArea     = _ProfitCenter.ControllingArea
                                                                                       and _ProfitCenter.ValidityEndDate   >= $projection.CreationDate
                                                                                       and _ProfitCenter.ValidityStartDate <= $projection.CreationDate
  association [0..1] to I_InventoryValuationType     as _InventoryValuationType        on  $projection.InventoryValuationType = _InventoryValuationType.InventoryValuationType
  association [0..1] to I_MfgOrder                   as _OrderID                       on  $projection.OrderID = _OrderID.ManufacturingOrder
  association [0..1] to I_CostCenter                 as _CostCenter                    on  $projection.CostCenter        = _CostCenter.CostCenter
                                                                                       and $projection.ControllingArea   = _CostCenter.ControllingArea
                                                                                       and _CostCenter.ValidityEndDate   >= $projection.CreationDate
                                                                                       and _CostCenter.ValidityStartDate <= $projection.CreationDate
  association [0..1] to I_SalesDocument              as _ReferenceSDDocument           on  $projection.ReferenceSDDocument = _ReferenceSDDocument.SalesDocument
  association [0..1] to I_SalesDocumentItem          as _ReferenceSalesDocumentItem    on  $projection.ReferenceSDDocument           = _ReferenceSalesDocumentItem.SalesDocument
                                                                                       and $projection.ReferenceSDDocumentItem       = _ReferenceSalesDocumentItem.SalesDocumentItem
                                                                                       and (
                                                                                          $projection.ReferenceSDDocumentCategory    = 'C'
                                                                                          or $projection.ReferenceSDDocumentCategory = 'H'
                                                                                        )
  association [0..1] to I_PurchaseOrderAPI01         as _PurchaseOrder                 on $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder                                                                                      
  association [0..1] to I_PurchaseOrderItemAPI01     as _PurchaseOrderItem             on $projection.PurchaseOrder     = _PurchaseOrderItem.PurchaseOrder                                                                                      
                                                                                      and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem   
  association [0..1] to I_SDDocumentCategory         as _ReferenceSDDocumentCategory   on  $projection.ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory
  association [0..1] to I_SalesDocument              as _IntcoRefSDDocument            on  $projection.IntcoRefSDDocument  = _IntcoRefSDDocument.SalesDocument
  association [0..1] to I_SalesDocumentItem          as _IntcoRefSDDocumentItem        on  $projection.IntcoRefSDDocument            = _IntcoRefSDDocumentItem.SalesDocument
                                                                                       and $projection.IntcoRefSDDocumentItem        = _IntcoRefSDDocumentItem.SalesDocumentItem
                                                                                       and (
                                                                                          $projection.IntcoRefSDDocumentCategory     = 'C'
                                                                                          or $projection.IntcoRefSDDocumentCategory  = 'H'
                                                                                        )
  association [0..1] to I_SDDocumentCategory         as _IntcoRefSDDocumentCategory    on  $projection.IntcoRefSDDocumentCategory  = _IntcoRefSDDocumentCategory.SDDocumentCategory
  association [0..1] to I_LogicalSystem              as _LogicalSystem                 on  $projection.ReferenceDocumentLogicalSystem = _LogicalSystem.LogicalSystem
  association [0..1] to I_AdditionalCustomerGroup1   as _AdditionalCustomerGroup1      on  $projection.AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1
  association [0..1] to I_AdditionalCustomerGroup2   as _AdditionalCustomerGroup2      on  $projection.AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2
  association [0..1] to I_AdditionalCustomerGroup3   as _AdditionalCustomerGroup3      on  $projection.AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3
  association [0..1] to I_AdditionalCustomerGroup4   as _AdditionalCustomerGroup4      on  $projection.AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4
  association [0..1] to I_AdditionalCustomerGroup5   as _AdditionalCustomerGroup5      on  $projection.AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5
  association [0..1] to I_SDProcessStatus            as _SDProcessStatus               on  $projection.SDProcessStatus = _SDProcessStatus.SDProcessStatus
  association [0..1] to I_PickingConfirmationStatus  as _PickingConfirmationStatus     on  $projection.PickingConfirmationStatus = _PickingConfirmationStatus.PickingConfirmationStatus
  association [0..1] to I_PickingStatus              as _PickingStatus                 on  $projection.PickingStatus = _PickingStatus.PickingStatus
  association [0..1] to I_WarehouseActivityStatus    as _WarehouseActivityStatus       on  $projection.WarehouseActivityStatus = _WarehouseActivityStatus.WarehouseActivityStatus
  association [0..1] to I_PackingStatus              as _PackingStatus                 on  $projection.PackingStatus = _PackingStatus.PackingStatus
  association [0..1] to I_GoodsMovementStatus        as _GoodsMovementStatus           on  $projection.GoodsMovementStatus = _GoodsMovementStatus.GoodsMovementStatus
  association [0..1] to I_DeliveryRelatedBillgStatus as _DeliveryRelatedBillingStatus  on  $projection.DeliveryRelatedBillingStatus = _DeliveryRelatedBillingStatus.DeliveryRelatedBillingStatus
  association [0..1] to I_DeliveryRelatedBillgStatus as _IntercompanyBillingStatus     on  $projection.IntercompanyBillingStatus = _IntercompanyBillingStatus.DeliveryRelatedBillingStatus
  association [0..1] to I_ProofOfDeliveryStatus      as _ProofOfDeliveryStatus         on  $projection.ProofOfDeliveryStatus = _ProofOfDeliveryStatus.ProofOfDeliveryStatus
  association [0..1] to I_ItemGenIncompletionStatus  as _ItemGeneralIncompletionStatus on  $projection.ItemGeneralIncompletionStatus = _ItemGeneralIncompletionStatus.ItemGeneralIncompletionStatus
  association [0..1] to I_ItemDelivIncompletionSts   as _ItemDelivIncompletionSts      on  $projection.ItemDeliveryIncompletionStatus = _ItemDelivIncompletionSts.ItemDeliveryIncompletionStatus
  association [0..1] to I_ItemPickingIncompletionSts as _ItemPickingIncompletionStatus on  $projection.ItemPickingIncompletionStatus = _ItemPickingIncompletionStatus.ItemPickingIncompletionStatus
  association [0..1] to I_ItemGdsMvtIncompletionSts  as _ItemGdsMvtIncompletionSts     on  $projection.ItemGdsMvtIncompletionSts = _ItemGdsMvtIncompletionSts.ItemGdsMvtIncompletionSts
  association [0..1] to I_ItemPackingIncompletionSts as _ItemPackingIncompletionStatus on  $projection.ItemPackingIncompletionStatus = _ItemPackingIncompletionStatus.ItemPackingIncompletionStatus
  association [0..1] to I_ItemBillingIncompletionSts as _ItemBillingIncompletionStatus on  $projection.ItemBillingIncompletionStatus = _ItemBillingIncompletionStatus.ItemBillingIncompletionStatus
  association [0..1] to I_StockType                  as _StockType                     on  $projection.StockType = _StockType.StockType
  association [0..1] to I_StockType_2                as _StockType_2                   on  $projection.StockType = _StockType_2.StockType
  association [0..1] to I_StockCategory              as _StockCategory                 on  $projection.WarehouseStockCategory = _StockCategory.WarehouseStockCategory
  association [0..1] to I_DelivChmlCmplncStatus      as _ChmlCmplncStatus              on  $projection.ChmlCmplncStatus = _ChmlCmplncStatus.ChmlCmplncStatus
  association [0..1] to I_DelivDangerousGoodsStatus  as _DangerousGoodsStatus          on  $projection.DangerousGoodsStatus = _DangerousGoodsStatus.DangerousGoodsStatus
  association [0..1] to I_DelivSafetyDataSheetSts    as _SafetyDataSheetStatus         on  $projection.SafetyDataSheetStatus = _SafetyDataSheetStatus.SafetyDataSheetStatus
  association [0..1] to I_TrdCmplncCheckStatus       as _TrdCmplncEmbargoSts           on  $projection.TrdCmplncEmbargoSts = _TrdCmplncEmbargoSts.TrdCmplncCheckStatus
  association [0..1] to I_TrdCmplncCheckStatus       as _TrdCmplncSnctndListChkSts     on  $projection.TrdCmplncSnctndListChkSts = _TrdCmplncSnctndListChkSts.TrdCmplncCheckStatus
  association [0..1] to I_TrdCmplncCheckStatus       as _TrdCmplncLegalControlSts      on  $projection.TrdCmplncLegalControlSts = _TrdCmplncLegalControlSts.TrdCmplncCheckStatus
  association [0..1] to I_ExciseTaxStatus            as _ExciseTaxStatus               on  $projection.EU_DeliveryItemARCStatus = _ExciseTaxStatus.EU_ARCStatus
  association [0..1] to I_Batch                      as _Batch                         on  $projection.Batch    = _Batch.Batch
                                                                                       and $projection.Material = _Batch.Material
                                                                                       and $projection.Plant    = _Batch.Plant
  //  association [0..*] to I_SchedgAgrmtRelTypeT        as _SchedgAgrmtRelTypeText        on  $projection.SchedulingAgreementReleaseType = _SchedgAgrmtRelTypeText.SchedulingAgreementReleaseType

  association [0..1] to I_SchedgAgrmtRelType         as _SchedgAgrmtRelType            on  $projection.SchedulingAgreementReleaseType = _SchedgAgrmtRelType.SchedulingAgreementReleaseType
  
  association [0..1] to I_ValueChainCategory         as _ValueChainCategory            on $projection.ValueChainCategory = _ValueChainCategory.ValueChainCategory
  association [0..1] to I_FieldLogisticsIndicator    as _FieldLogisticsIndicator       on $projection.FldLogsStatus = _FieldLogisticsIndicator.FldLogsStatus   
  association [0..1] to I_WBSElementBasicData        as _WBSElementBasicData           on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID 

  association [0..1] to I_ServiceDocumentType        as _ServiceDocumentType           on  $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType

  //Extensibility

  association [0..1] to E_DeliveryDocumentItem       as _Extension                     on  $projection.DeliveryDocument     = _Extension.DeliveryDocument
                                                                                       and $projection.DeliveryDocumentItem = _Extension.DeliveryDocumentItem
  association [0..1] to I_HigherLevelItemUsage       as _HigherLevelItemUsage          on  $projection.HigherLevelItemUsage = _HigherLevelItemUsage.HigherLevelItemUsage



{
      //key

      @ObjectModel.foreignKey.association: '_DeliveryDocument'
  key vbeln                                                                    as DeliveryDocument,
  key posnr                                                                    as DeliveryDocumentItem,

      
      //category

      @ObjectModel.foreignKey.association: '_SDDocumentCategory'
      _DeliveryDocument.SDDocumentCategory,
      @Semantics.currencyCode: true
      _DeliveryDocument.TransactionCurrency,
      @ObjectModel.foreignKey.association: '_ItemCategory'
      pstyv                                                                    as DeliveryDocumentItemCategory,
      @ObjectModel.foreignKey.association: '_SalesDocumentItemType'
      posar                                                                    as SalesDocumentItemType,

      //admin

      ernam                                                                    as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      erdat                                                                    as CreationDate,
      erzet                                                                    as CreationTime,
      @Semantics.systemDate.lastChangedAt: true
      aedat                                                                    as LastChangeDate,

      //organization

      @ObjectModel.foreignKey.association: '_DistributionChannel'
      vtweg                                                                    as DistributionChannel,
      @ObjectModel.foreignKey.association: '_Division'
      spart                                                                    as Division,
      @ObjectModel.foreignKey.association: '_SalesGroup'
      vkgrp                                                                    as SalesGroup,
      @ObjectModel.foreignKey.association: '_SalesOffice'
      vkbur                                                                    as SalesOffice,
      abtnr                                                                    as DepartmentClassificationByCust,

      //product

      @ObjectModel.foreignKey.association: '_Material'
      matnr                                                                    as Material,
      @ObjectModel.foreignKey.association: '_Product'
      cast (matnr as productnumber preserving type )                           as Product,
      kdmat                                                                    as MaterialByCustomer,
      @ObjectModel.foreignKey.association: '_OriginallyRequestedMaterial'
      matwa                                                                    as OriginallyRequestedMaterial,
      ean11                                                                    as InternationalArticleNumber,
      charg                                                                    as Batch,
      cuobj_ch                                                                 as BatchClassification,
      lichn                                                                    as BatchBySupplier,
      xchar                                                                    as MaterialIsIntBatchManaged,
      xchpf                                                                    as MaterialIsBatchManaged,
      @ObjectModel.foreignKey.association: '_MaterialGroup'
      matkl                                                                    as MaterialGroup,
      @ObjectModel.foreignKey.association: '_ProductGroup'
      cast(matkl as productgroup preserving type )                             as ProductGroup,
      @ObjectModel.foreignKey.association: '_MaterialFreightGroup'
      mfrgr                                                                    as MaterialFreightGroup,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup1'
      mvgr1                                                                    as AdditionalMaterialGroup1,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup2'
      mvgr2                                                                    as AdditionalMaterialGroup2,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup3'
      mvgr3                                                                    as AdditionalMaterialGroup3,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup4'
      mvgr4                                                                    as AdditionalMaterialGroup4,
      @ObjectModel.foreignKey.association: '_AdditionalMaterialGroup5'
      mvgr5                                                                    as AdditionalMaterialGroup5,
      @ObjectModel.foreignKey.association: '_Plant'
      werks                                                                    as Plant,
      @ObjectModel.foreignKey.association: '_Warehouse'
      lgnum                                                                    as Warehouse,
      @ObjectModel.foreignKey.association: '_StorageLocation'
      lgort                                                                    as StorageLocation,
      lgpla                                                                    as StorageBin,
      lgtyp                                                                    as StorageType,
      resource_id                                                              as DeliveryItemResourceID,

      loading_point                                                            as LoadingPointForDelivery,

      @ObjectModel.foreignKey.association: '_InventorySpecialStockType'
      sobkz                                                                    as InventorySpecialStockType,
      vfdat                                                                    as ShelfLifeExpirationDate,
      @Aggregation.default: #SUM
      anzsn                                                                    as NumberOfSerialNumbers,
      cuobj                                                                    as ProductConfiguration,
      prodh                                                                    as ProductHierarchyNode,
      hsdat                                                                    as ManufactureDate,

      //delivery

      arktx                                                                    as DeliveryDocumentItemText,
      uepos                                                                    as HigherLevelItem,
      uecha                                                                    as HigherLvlItmOfBatSpltItm,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
      lfimg                                                                    as ActualDeliveryQuantity,
      fmeng                                                                    as QuantityIsFixed,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
      ormng                                                                    as OriginalDeliveryQuantity,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_DeliveryQuantityUnit'
      vrkme                                                                    as DeliveryQuantityUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      lgmng                                                                    as ActualDeliveredQtyInBaseUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      meins                                                                    as BaseUnit,
      umvkn                                                                    as DeliveryToBaseQuantityDnmntr,
      umvkz                                                                    as DeliveryToBaseQuantityNmrtr,
      mbdat                                                                    as ProductAvailabilityDate,
      mbuhr                                                                    as ProductAvailabilityTime,
      grkor                                                                    as DeliveryGroup,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      brgew                                                                    as ItemGrossWeight,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      ntgew                                                                    as ItemNetWeight,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ItemWeightUnit'
      gewei                                                                    as ItemWeightUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      volum                                                                    as ItemVolume,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_ItemVolumeUnit'
      voleh                                                                    as ItemVolumeUnit,
      qplos                                                                    as InspectionLot,
      qtlos                                                                    as InspectionPartialLot,
      kztlf                                                                    as PartialDeliveryIsAllowed,
      uebtk                                                                    as UnlimitedOverdeliveryIsAllowed,
      @Aggregation.default: #SUM
      uebto