I_DELIVERYPICKVIEWITEM

CDS View

Delivery Pick List Item

I_DELIVERYPICKVIEWITEM is a CDS View in S/4HANA. Delivery Pick List Item. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PCLblProdCmbndByBusProc view union_all COMPOSITE Union Products by Business Processes 
@AbapCatalog.sqlViewName: 'IDELIVERYPICKI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Delivery Pick List Item'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #NONE ]

define view I_DeliveryPickViewItem
  as select from I_DeliveryDocumentItem
  association [1..1] to I_DeliveryDocumentItem    as _DeliveryDocumentItem  on  $projection.DeliveryDocument     = _DeliveryDocumentItem.DeliveryDocument
                                                                            and $projection.DeliveryDocumentItem = _DeliveryDocumentItem.DeliveryDocumentItem                                                                                                                                                        
  association [0..*] to I_DeliveryPickViewDocFlow as _DocumentFlow          on  _DocumentFlow.PrecedingDocument     = $projection.DeliveryDocument
                                                                            and _DocumentFlow.PrecedingDocumentItem = $projection.DeliveryDocumentItem
  association [0..1] to E_DeliveryDocumentItem    as _PickViewItemExtension on  $projection.DeliveryDocument     = _PickViewItemExtension.DeliveryDocument
                                                                            and $projection.DeliveryDocumentItem = _PickViewItemExtension.DeliveryDocumentItem
{

      // key

  key I_DeliveryDocumentItem.DeliveryDocument as DeliveryDocument,
  key I_DeliveryDocumentItem.DeliveryDocumentItem as DeliveryDocumentItem,

      I_DeliveryDocumentItem.DeliveryDocumentItemText,
      I_DeliveryDocumentItem.RetailPromotion,
      -- I_DeliveryDocumentItem.serail,
      -- I_DeliveryDocumentItem.sgt_rcat,
      --I_DeliveryDocumentItem.sgt_scat,
      -- I_DeliveryDocumentItem.wrf_charstc1,
      -- I_DeliveryDocumentItem.wrf_charstc2,
      -- I_DeliveryDocumentItem.wrf_charstc3,
      I_DeliveryDocumentItem.GoodsMovementType,
      --I_DeliveryDocumentItem.bwlvs,
      I_DeliveryDocumentItem.Batch,
      I_DeliveryDocumentItem.InventoryValuationType,
      I_DeliveryDocumentItem.MaterialByCustomer,
      --I_DeliveryDocumentItem.kzdlg,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      I_DeliveryDocumentItem.ActualDeliveryQuantity,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      I_DeliveryDocumentItem.ActualDeliveredQtyInBaseUnit,
      --I_DeliveryDocumentItem.lfimg_flo,
      --I_DeliveryDocumentItem.lgmng_flo,
      I_DeliveryDocumentItem.Warehouse,
      I_DeliveryDocumentItem.StorageLocation,
      I_DeliveryDocumentItem.WarehouseStorageBin,
      I_DeliveryDocumentItem.StorageBin,
      I_DeliveryDocumentItem.StorageType,
      -- I_DeliveryDocumentItem.flgwm,
      I_DeliveryDocumentItem.Material,
      I_DeliveryDocumentItem.ProductAvailabilityDate,
      @Semantics.unitOfMeasure: true
      I_DeliveryDocumentItem.BaseUnit,
//      I_DeliveryDocumentItem.DeliveryDocumentItem,

      I_DeliveryDocumentItem.HigherLvlItmOfBatSpltItm,
      I_DeliveryDocumentItem.DeliveryToBaseQuantityDnmntr,
      I_DeliveryDocumentItem.DeliveryToBaseQuantityNmrtr,
      --I_DeliveryDocumentItem.umrev,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_DeliveryDocumentStdVH', element: 'DeliveryDocument' } } ]
//      I_DeliveryDocumentItem.DeliveryDocument,

      I_DeliveryDocumentItem.DeliveryQuantityUnit,
      I_DeliveryDocumentItem.Plant,
      I_DeliveryDocumentItem.InventorySpecialStockType,
      I_DeliveryDocumentItem.PickingControl,
      I_DeliveryDocumentItem.ReferenceSDDocument,
      I_DeliveryDocumentItem.ReferenceSDDocumentItem,
      I_DeliveryDocumentItem.ReferenceSDDocumentCategory,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      I_DeliveryDocumentItem.ItemGrossWeight,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      I_DeliveryDocumentItem.ItemNetWeight,
      I_DeliveryDocumentItem.ItemWeightUnit,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      I_DeliveryDocumentItem.ItemVolume,
      I_DeliveryDocumentItem.ItemVolumeUnit,
      I_DeliveryDocumentItem.MaterialIsBatchManaged,
      I_DeliveryDocumentItem.MaterialIsIntBatchManaged,
      I_DeliveryDocumentItem.ReceivingPoint,
      I_DeliveryDocumentItem.DepartmentClassificationByCust,
      I_DeliveryDocumentItem.NumberOfSerialNumbers,
      -- I_DeliveryDocumentItem.kzwi1,
      --I_DeliveryDocumentItem.kzwi2,
      --I_DeliveryDocumentItem.kzwi3,
      --I_DeliveryDocumentItem.kzwi4,
      --I_DeliveryDocumentItem.kzwi5,
      --I_DeliveryDocumentItem.kzwi6,
      --I_DeliveryDocumentItem.kpein,
      --I_DeliveryDocumentItem.kmein,
      -- I_DeliveryDocumentItem.netpr,
      --I_DeliveryDocumentItem.netwr,
      --I_DeliveryDocumentItem.uecha,
      --I_DeliveryDocumentItem.ps_psp_pnr,
      --I_DeliveryDocumentItem.vbelv,
      --I_DeliveryDocumentItem.posnv,
      --I_DeliveryDocumentItem.magrv,
      --I_DeliveryDocumentItem.kzfme,
      I_DeliveryDocumentItem.BatchBySupplier,
      I_DeliveryDocumentItem.InternationalArticleNumber,
      --I_DeliveryDocumentItem.kzbew,
      -- I_DeliveryDocumentItem.mtart,
      -- I_DeliveryDocumentItem.rblvs,
      I_DeliveryDocumentItem.WarehouseStockCategory,
      I_DeliveryDocumentItem.IssgOrRcvgStockCategory,
      I_DeliveryDocumentItem.IssgOrRcvgMaterial,
      I_DeliveryDocumentItem.IssuingOrReceivingPlant,
      I_DeliveryDocumentItem.IssuingOrReceivingStorageLoc,
      I_DeliveryDocumentItem.IssgOrRcvgBatch,
      I_DeliveryDocumentItem.IssgOrRcvgSpclStockInd,
      -- I_DeliveryDocumentItem.sonum,
      --I_DeliveryDocumentItem.usonu,
      I_DeliveryDocumentItem.WarehouseStagingArea,
      --I_DeliveryDocumentItem.kzech,
      --I_DeliveryDocumentItem.hupos,
      I_DeliveryDocumentItem.PrimaryPostingSwitch,
      I_DeliveryDocumentItem.InspectionLot,
      --I_DeliveryDocumentItem.rsnum,
      --I_DeliveryDocumentItem.rsart,
      --I_DeliveryDocumentItem.rspos,
      I_DeliveryDocumentItem.OrderID,
      --I_DeliveryDocumentItem.pckpf,
      I_DeliveryDocumentItem.ShelfLifeExpirationDate,
      I_DeliveryDocumentItem.WarehouseActivityStatus,

      I_DeliveryDocumentItem.PickingStatus,

      I_DeliveryDocumentItem.HigherLevelItem,
      I_DeliveryDocumentItem.HigherLevelItemUsage,
      I_DeliveryDocumentItem.DeliveryGroup,
      
      /* Associations */
      _DeliveryDocument,
      _DeliveryDocumentItem,
      _DocumentFlow

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENTITEM"
],
"ASSOCIATED":
[
"E_DELIVERYDOCUMENTITEM",
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM",
"I_DELIVERYPICKVIEWDOCFLOW"
],
"BASE":
[
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More