A_OutbDeliveryItem

@AbapCatalog.sqlViewName: 'AOUTBDELIVERYI'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@EndUserText.label: 'CDS view for API exposure'
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType: #BASIC
@ObjectModel: {
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #B,
  usageType.sizeCategory: #L
}

define view A_OutbDeliveryItem
    as select from I_DeliveryDocumentItem

association [0..*] to A_OutbDeliveryDocFlow as _DocumentFlow       on _DocumentFlow.PrecedingDocument       = $projection.DeliveryDocument and _DocumentFlow.PrecedingDocumentItem        = $projection.DeliveryDocumentItem
association [1..1] to A_OutbDeliveryHeader  as _DeliveryDocument   on _DeliveryDocument.DeliveryDocument    = $projection.DeliveryDocument
association [0..1] to A_SerialNmbrDelivery  as _SerialDeliveryItem on _SerialDeliveryItem.DeliveryDocument  = $projection.DeliveryDocument and _SerialDeliveryItem.DeliveryDocumentItem   =  $projection.DeliveryDocumentItem

//Extensibility

association [0..1] to E_DeliveryDocumentItem as _Extension    on  $projection.DeliveryDocument    = _Extension.DeliveryDocument
                                                                  and $projection.DeliveryDocumentItem = _Extension.DeliveryDocumentItem
                                                                  
{
    key I_DeliveryDocumentItem.DeliveryDocument,
    key I_DeliveryDocumentItem.DeliveryDocumentItem, 
    I_DeliveryDocumentItem.SDDocumentCategory, 
    I_DeliveryDocumentItem.DeliveryDocumentItemCategory, 
    I_DeliveryDocumentItem.SalesDocumentItemType, 
    I_DeliveryDocumentItem.CreatedByUser, 
    I_DeliveryDocumentItem.CreationDate, 
    I_DeliveryDocumentItem.CreationTime, 
    I_DeliveryDocumentItem.LastChangeDate, 
    I_DeliveryDocumentItem.DistributionChannel, 
    I_DeliveryDocumentItem.Division, 
    I_DeliveryDocumentItem.SalesGroup, 
    I_DeliveryDocumentItem.SalesOffice, 
    I_DeliveryDocumentItem.DepartmentClassificationByCust, 
    I_DeliveryDocumentItem.Material, 
    I_DeliveryDocumentItem.MaterialByCustomer, 
    I_DeliveryDocumentItem.OriginallyRequestedMaterial, 
    I_DeliveryDocumentItem.InternationalArticleNumber, 
    I_DeliveryDocumentItem.Batch, 
    I_DeliveryDocumentItem.BatchClassification, 
    I_DeliveryDocumentItem.BatchBySupplier, 
    I_DeliveryDocumentItem.MaterialIsIntBatchManaged, 
    I_DeliveryDocumentItem.MaterialIsBatchManaged, 
    I_DeliveryDocumentItem.MaterialGroup, 
    I_DeliveryDocumentItem.MaterialFreightGroup, 
    I_DeliveryDocumentItem.AdditionalMaterialGroup1, 
    I_DeliveryDocumentItem.AdditionalMaterialGroup2, 
    I_DeliveryDocumentItem.AdditionalMaterialGroup3, 
    I_DeliveryDocumentItem.AdditionalMaterialGroup4, 
    I_DeliveryDocumentItem.AdditionalMaterialGroup5, 
    I_DeliveryDocumentItem.Plant, 
    I_DeliveryDocumentItem.Warehouse, 
    I_DeliveryDocumentItem.StorageLocation, 
    I_DeliveryDocumentItem.StorageBin, 
    I_DeliveryDocumentItem.StorageType, 
    I_DeliveryDocumentItem.InventorySpecialStockType, 
    I_DeliveryDocumentItem.ShelfLifeExpirationDate, 
    I_DeliveryDocumentItem.NumberOfSerialNumbers, 
    I_DeliveryDocumentItem.ProductConfiguration, 
    I_DeliveryDocumentItem.ProductHierarchyNode, 
    I_DeliveryDocumentItem.ManufactureDate, 
    I_DeliveryDocumentItem.DeliveryDocumentItemText, 
    I_DeliveryDocumentItem.HigherLevelItem, 
    I_DeliveryDocumentItem.HigherLvlItmOfBatSpltItm, 
    @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
    I_DeliveryDocumentItem.ActualDeliveryQuantity, 
    I_DeliveryDocumentItem.QuantityIsFixed, 
    @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
    I_DeliveryDocumentItem.OriginalDeliveryQuantity, 
    @Semantics.unitOfMeasure: true
    I_DeliveryDocumentItem.DeliveryQuantityUnit, 
    @Semantics.quantity.unitOfMeasure: 'BaseUnit'
    I_DeliveryDocumentItem.ActualDeliveredQtyInBaseUnit, 
    @Semantics.unitOfMeasure: true
    I_DeliveryDocumentItem.BaseUnit, 
    I_DeliveryDocumentItem.DeliveryToBaseQuantityDnmntr, 
    I_DeliveryDocumentItem.DeliveryToBaseQuantityNmrtr, 
    I_DeliveryDocumentItem.ProductAvailabilityDate, 
    I_DeliveryDocumentItem.ProductAvailabilityTime, 
    I_DeliveryDocumentItem.DeliveryGroup,
    @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit' 
    I_DeliveryDocumentItem.ItemGrossWeight, 
    @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
    I_DeliveryDocumentItem.ItemNetWeight,
    @Semantics.unitOfMeasure: true 
    I_DeliveryDocumentItem.ItemWeightUnit,
    @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
    I_DeliveryDocumentItem.ItemVolume, 
    @Semantics.unitOfMeasure: true
    I_DeliveryDocumentItem.ItemVolumeUnit, 
    I_DeliveryDocumentItem.InspectionLot, 
    I_DeliveryDocumentItem.InspectionPartialLot, 
    I_DeliveryDocumentItem.PartialDeliveryIsAllowed, 
    I_DeliveryDocumentItem.UnlimitedOverdeliveryIsAllowed, 
    I_DeliveryDocumentItem.OverdelivTolrtdLmtRatioInPct, 
    I_DeliveryDocumentItem.UnderdelivTolrtdLmtRatioInPct, 
    I_DeliveryDocumentItem.WarehouseStorageBin, 
    I_DeliveryDocumentItem.BOMExplosion, 
    I_DeliveryDocumentItem.CustEngineeringChgStatus, 
    I_DeliveryDocumentItem.WarehouseStagingArea, 
    I_DeliveryDocumentItem.WarehouseStockCategory, 
    I_DeliveryDocumentItem.IssgOrRcvgStockCategory, 
    I_DeliveryDocumentItem.IssgOrRcvgMaterial, 
    I_DeliveryDocumentItem.IssuingOrReceivingPlant, 
    I_DeliveryDocumentItem.IssuingOrReceivingStorageLoc, 
    I_DeliveryDocumentItem.IssgOrRcvgBatch, 
    I_DeliveryDocumentItem.IssgOrRcvgValuationType, 
    I_DeliveryDocumentItem.IssgOrRcvgSpclStockInd, 
    I_DeliveryDocumentItem.PrimaryPostingSwitch, 
    I_DeliveryDocumentItem.StockType, 
    I_DeliveryDocumentItem.IsNotGoodsMovementsRelevant, 
    I_DeliveryDocumentItem.GLAccount, 
    I_DeliveryDocumentItem.GoodsMovementReasonCode, 
    I_DeliveryDocumentItem.SubsequentMovementType, 
    I_DeliveryDocumentItem.IsCompletelyDelivered, 
    I_DeliveryDocumentItem.AlternateProductNumber, 
    I_DeliveryDocumentItem.PickingControl, 
    I_DeliveryDocumentItem.LoadingGroup, 
    I_DeliveryDocumentItem.GoodsMovementType, 
    I_DeliveryDocumentItem.TransportationGroup, 
    I_DeliveryDocumentItem.ReceivingPoint, 
    I_DeliveryDocumentItem.FixedShipgProcgDurationInDays, 
    I_DeliveryDocumentItem.VarblShipgProcgDurationInDays, 
    I_DeliveryDocumentItem.ProofOfDeliveryRelevanceCode, 
    I_DeliveryDocumentItem.ItemIsBillingRelevant, 
    I_DeliveryDocumentItem.ItemBillingBlockReason, 
    I_DeliveryDocumentItem.PaymentGuaranteeForm, 
    I_DeliveryDocumentItem.IntercompanyBillingStatus, 
    I_DeliveryDocumentItem.BusinessArea, 
    I_DeliveryDocumentItem.ControllingArea, 
    case when I_DeliveryDocumentItem.ProfitabilitySegment_2 = '' then '0000000000' 
         else cast( I_DeliveryDocumentItem.ProfitabilitySegment_2 as rkeobjnr_char_no_alpha preserving type ) 
    end as ProfitabilitySegment, 
    I_DeliveryDocumentItem.ProfitCenter, 
    I_DeliveryDocumentItem.InventoryValuationType, 
    I_DeliveryDocumentItem.IsSeparateValuation, 
    I_DeliveryDocumentItem.ConsumptionPosting, 
    I_DeliveryDocumentItem.OrderID, 
    I_DeliveryDocumentItem.OrderItem, 
    I_DeliveryDocumentItem.CostCenter, 
    I_DeliveryDocumentItem.ReferenceSDDocument, 
    I_DeliveryDocumentItem.ReferenceSDDocumentItem, 
    I_DeliveryDocumentItem.ReferenceSDDocumentCategory, 
    I_DeliveryDocumentItem.ReferenceDocumentLogicalSystem, 
    I_DeliveryDocumentItem.AdditionalCustomerGroup1, 
    I_DeliveryDocumentItem.AdditionalCustomerGroup2, 
    I_DeliveryDocumentItem.AdditionalCustomerGroup3, 
    I_DeliveryDocumentItem.AdditionalCustomerGroup4, 
    I_DeliveryDocumentItem.AdditionalCustomerGroup5, 
    I_DeliveryDocumentItem.RetailPromotion, 
    I_DeliveryDocumentItem.StatisticsDate, 
    I_DeliveryDocumentItem.SDProcessStatus, 
    I_DeliveryDocumentItem.PickingConfirmationStatus, 
    I_DeliveryDocumentItem.PickingStatus, 
    I_DeliveryDocumentItem.WarehouseActivityStatus, 
    I_DeliveryDocumentItem.PackingStatus, 
    I_DeliveryDocumentItem.GoodsMovementStatus, 
    I_DeliveryDocumentItem.DeliveryRelatedBillingStatus, 
    I_DeliveryDocumentItem.ProofOfDeliveryStatus, 
    I_DeliveryDocumentItem.ItemGeneralIncompletionStatus, 
    I_DeliveryDocumentItem.ItemDeliveryIncompletionStatus, 
    I_DeliveryDocumentItem.ItemPickingIncompletionStatus, 
    I_DeliveryDocumentItem.ItemGdsMvtIncompletionSts, 
    I_DeliveryDocumentItem.ItemPackingIncompletionStatus, 
    I_DeliveryDocumentItem.ItemBillingIncompletionStatus,
    
    /* Associations */
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
    _DocumentFlow,
    @ObjectModel.association.type:  [#TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT] 
    _DeliveryDocument,
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
   _SerialDeliveryItem

} where I_DeliveryDocumentItem.SDDocumentCategory = 'J' ;
                                                                                                                   
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM"
],
"ASSOCIATED":
[
"A_OUTBDELIVERYDOCFLOW",
"A_OUTBDELIVERYHEADER",
"A_SERIALNMBRDELIVERY",
"E_DELIVERYDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/