C_ESJIOtbndDlvryItemQuery

DDL: C_ESJIOTBNDDLVRYITEMQUERY SQL: CESJIOTBDLIVITM Type: view CONSUMPTION

Outbound Delivery Item

C_ESJIOtbndDlvryItemQuery is a Consumption CDS View that provides data about "Outbound Delivery Item" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 57 fields with key fields OutboundDelivery, OutboundDeliveryItem.

1 data source(s) 57 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CESJIOTBDLIVITM view
EndUserText.label Outbound Delivery Item view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery DeliveryDocument
KEY OutboundDeliveryItem DeliveryDocumentItem
ObjectType
DeliveryDocumentItemCategory DeliveryDocumentItemCategory
SalesDocumentItemType SalesDocumentItemType
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
DistributionChannel DistributionChannel
Division Division
SalesGroup SalesGroup
SalesOffice SalesOffice
Material Material
Plant Plant
StorageLocation StorageLocation
StorageType StorageType
Warehouse Warehouse
DeliveryDocumentItemText DeliveryDocumentItemText
ActualDeliveryQuantity ActualDeliveryQuantity
OriginalDeliveryQuantity OriginalDeliveryQuantity
DeliveryQuantityUnit DeliveryQuantityUnit
ActualDeliveredQtyInBaseUnit ActualDeliveredQtyInBaseUnit
BaseUnit BaseUnit
DeliveryToBaseQuantityDnmntr DeliveryToBaseQuantityDnmntr
DeliveryToBaseQuantityNmrtr DeliveryToBaseQuantityNmrtr
ProductAvailabilityDate ProductAvailabilityDate
ItemGrossWeight ItemGrossWeight
ItemNetWeight ItemNetWeight
ItemWeightUnit ItemWeightUnit
ItemVolume ItemVolume
ItemVolumeUnit ItemVolumeUnit
PickingControl PickingControl
LoadingGroup LoadingGroup
GoodsMovementType GoodsMovementType
TransportationGroup TransportationGroup
ShippingPoint _DeliveryDocument ShippingPoint
ItemIsBillingRelevant ItemIsBillingRelevant
ItemBillingBlockReason ItemBillingBlockReason
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentItem ReferenceSDDocumentItem
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
_Partner _Partner
_ItemCategory _ItemCategory
_SalesDocumentItemType _SalesDocumentItemType
_CreatedByUser _CreatedByUser
_DistributionChannel _DistributionChannel
_Division _Division
_SalesGroup _SalesGroup
_Material _Material
_DeliveryQuantityUnit _DeliveryQuantityUnit
_BaseUnit _BaseUnit
_ItemWeightUnit _ItemWeightUnit
_ItemVolumeUnit _ItemVolumeUnit
_ItemBillingBlockReason _ItemBillingBlockReason
_ReferenceSalesDocumentItem _ReferenceSalesDocumentItem
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 
@AbapCatalog.sqlViewName: 'CESJIOTBDLIVITM'
@EndUserText.label: 'Outbound Delivery Item'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
define view C_ESJIOtbndDlvryItemQuery  
with parameters P_Language : sylangu
as select from I_DeliveryDocumentItem
//Association

{
    //Key

    key DeliveryDocument as OutboundDelivery,
    key DeliveryDocumentItem as OutboundDeliveryItem,
    'LIKP' as ObjectType,
    //Category

    DeliveryDocumentItemCategory,
    SalesDocumentItemType,

    //Admin

    CreatedByUser,
    @Semantics.businessDate.createdAt: true
    CreationDate,
    CreationTime,
    @Semantics.businessDate.lastChangedAt: true
    LastChangeDate,

    //Organization

    DistributionChannel,
    Division,
    SalesGroup,
    SalesOffice,

    //Product

    Material,
    Plant,
    StorageLocation,
    StorageType,
    Warehouse,

    //Delivery

    DeliveryDocumentItemText,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
    ActualDeliveryQuantity,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
    OriginalDeliveryQuantity,
    @Semantics.unitOfMeasure: true
    DeliveryQuantityUnit,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'BaseUnit'
    ActualDeliveredQtyInBaseUnit,
    @Semantics.unitOfMeasure: true
    BaseUnit,
    DeliveryToBaseQuantityDnmntr,
    DeliveryToBaseQuantityNmrtr,
    ProductAvailabilityDate,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
    ItemGrossWeight,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
    ItemNetWeight,
    @Semantics.unitOfMeasure: true
    ItemWeightUnit,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
    ItemVolume,
    @Semantics.unitOfMeasure: true
    ItemVolumeUnit,

    //Pick Pack Load

    PickingControl,
    LoadingGroup,
    GoodsMovementType,

    //Shipping

    TransportationGroup,
    _DeliveryDocument.ShippingPoint,

    //Billing

    ItemIsBillingRelevant,
    ItemBillingBlockReason,

    //Reference

    ReferenceSDDocument,
    ReferenceSDDocumentItem,
    ReferenceSDDocumentCategory,

    //Status

//    SDProcessStatus,

//    PickingConfirmationStatus,

//    PickingStatus,

//    GoodsMovementStatus,

//    DeliveryRelatedBillingStatus,


    //Associations

    //_OutboundDelivery,

    _Partner,
    _ItemCategory,
    _SalesDocumentItemType,
    _CreatedByUser,
    _DistributionChannel,
    _Division,
    _SalesGroup,
    _Material,
    _DeliveryQuantityUnit,
    _BaseUnit,
    _ItemWeightUnit,
    _ItemVolumeUnit,
    _ItemBillingBlockReason,
    _ReferenceSalesDocumentItem,
    _ReferenceSDDocumentCategory
}                                        
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_BILLINGBLOCKREASON",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_MATERIAL",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTITEMTYPE",
"I_SALESGROUP",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTITEMPARTNER",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More