I_DeliveryPickViewHeader

DDL: I_DELIVERYPICKVIEWHEADER SQL: IDELIVERYPICKH Type: view COMPOSITE

Delivery Pick List Header

I_DeliveryPickViewHeader is a Composite CDS View that provides data about "Delivery Pick List Header" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 31 fields with key field DeliveryDocument. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_DeliveryDocument _DeliveryDocument $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
[0..*] I_DeliveryPickViewDocFlow _DeliveryDocumentFlow _DeliveryDocumentFlow.PrecedingDocument = $projection.DeliveryDocument
[0..*] I_DeliveryPickViewItem _DeliveryDocumentItem _DeliveryDocumentItem.DeliveryDocument = $projection.DeliveryDocument
[0..1] I_DeliveryPickViewShpPoint _ShippingPoint _ShippingPoint.ShippingPoint = $projection.ShippingPoint
[0..1] E_DeliveryDocument _PickViewHeaderExtension $projection.DeliveryDocument = _PickViewHeaderExtension.DeliveryDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDELIVERYPICKH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Delivery Pick List Header view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocument DeliveryDocument
PickedItemsLocation I_DeliveryDocument PickedItemsLocation
HeaderGrossWeight I_DeliveryDocument HeaderGrossWeight
HeaderWeightUnit I_DeliveryDocument HeaderWeightUnit
PickingDate I_DeliveryDocument PickingDate
ShipToParty I_DeliveryDocument ShipToParty
LoadingDate I_DeliveryDocument LoadingDate
DeliveryPriority I_DeliveryDocument DeliveryPriority
ProposedDeliveryRoute I_DeliveryDocument ProposedDeliveryRoute
HeaderVolumeUnit I_DeliveryDocument HeaderVolumeUnit
HeaderVolume I_DeliveryDocument HeaderVolume
ShippingPoint I_DeliveryDocument ShippingPoint
WarehouseGate I_DeliveryDocument WarehouseGate
WarehouseStagingArea I_DeliveryDocument WarehouseStagingArea
DeliveryDocumentBySupplier I_DeliveryDocument DeliveryDocumentBySupplier
Supplier I_DeliveryDocument Supplier
DeliveryDate I_DeliveryDocument DeliveryDate
SDDocumentCategory I_DeliveryDocument SDDocumentCategory
OverallGoodsMovementStatus I_DeliveryDocument OverallGoodsMovementStatus
OverallWarehouseActivityStatus I_DeliveryDocument OverallWarehouseActivityStatus
TotalCreditCheckStatus I_DeliveryDocument TotalCreditCheckStatus
TransactionCurrency I_DeliveryDocument TransactionCurrency
OverallPickingStatus I_DeliveryDocument OverallPickingStatus
PlantName
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate
_Item I_DeliveryDocument _Item
_ShipToParty I_DeliveryDocument _ShipToParty
_DeliveryDocument _DeliveryDocument
_DeliveryDocumentFlow _DeliveryDocumentFlow
_DeliveryDocumentItem _DeliveryDocumentItem
_ShippingPoint _ShippingPoint
@AbapCatalog.sqlViewName: 'IDELIVERYPICKH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Delivery Pick List Header'
@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_DeliveryPickViewHeader as select from I_DeliveryDocument
association [1..1] to I_DeliveryDocument as _DeliveryDocument on $projection.DeliveryDocument = _DeliveryDocument.DeliveryDocument
association [0..*] to I_DeliveryPickViewDocFlow as _DeliveryDocumentFlow on _DeliveryDocumentFlow.PrecedingDocument = $projection.DeliveryDocument
association [0..*] to I_DeliveryPickViewItem as _DeliveryDocumentItem on _DeliveryDocumentItem.DeliveryDocument = $projection.DeliveryDocument
association [0..1] to I_DeliveryPickViewShpPoint as _ShippingPoint on _ShippingPoint.ShippingPoint = $projection.ShippingPoint
association [0..1] to E_DeliveryDocument as _PickViewHeaderExtension on $projection.DeliveryDocument = _PickViewHeaderExtension.DeliveryDocument
{
    key I_DeliveryDocument.DeliveryDocument,
    I_DeliveryDocument.PickedItemsLocation,
    @Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit'
    I_DeliveryDocument.HeaderGrossWeight,
    
    I_DeliveryDocument.HeaderWeightUnit,
    I_DeliveryDocument.PickingDate,
    @Consumption.valueHelpDefinition: [ { entity: { name: 'I_Customer_VH', element: 'Customer' } } ]    
    I_DeliveryDocument.ShipToParty,
    I_DeliveryDocument.LoadingDate,
    I_DeliveryDocument.DeliveryPriority,
    I_DeliveryDocument.ProposedDeliveryRoute,
    @Semantics.unitOfMeasure: true
    I_DeliveryDocument.HeaderVolumeUnit,
    @Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit'
    I_DeliveryDocument.HeaderVolume,
    @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ShippingPointStdVH', element: 'ShippingPoint' } } ]    
    I_DeliveryDocument.ShippingPoint,
    I_DeliveryDocument.WarehouseGate,
    I_DeliveryDocument.WarehouseStagingArea,
    I_DeliveryDocument.DeliveryDocumentBySupplier,
    I_DeliveryDocument.Supplier,
    I_DeliveryDocument.DeliveryDate,
    I_DeliveryDocument.SDDocumentCategory,
    //I_DeliveryDocument.kzwab, FEHLT in der View!

    I_DeliveryDocument.OverallGoodsMovementStatus,
    I_DeliveryDocument.OverallWarehouseActivityStatus,
    //I_DeliveryDocument.aufer  FEHLT IN LIKP,

    I_DeliveryDocument.TotalCreditCheckStatus,
    I_DeliveryDocument.TransactionCurrency,
    I_DeliveryDocument.OverallPickingStatus,
    I_DeliveryDocument._ReceivingPlant.PlantName,
    I_DeliveryDocument.PlannedGoodsIssueDate,
    
    /* Associations */
    I_DeliveryDocument._Item,
    I_DeliveryDocument._ShipToParty,
    _DeliveryDocument,
    _DeliveryDocumentFlow,
    _DeliveryDocumentItem,
    _ShippingPoint
    
    /*
        How to determine correct language ? No spras column in I_ShippingPoint
        [1: inner where spras = $session.system_language]
    */
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_PLANT"
],
"ASSOCIATED":
[
"E_DELIVERYDOCUMENT",
"I_CUSTOMER",
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM",
"I_DELIVERYPICKVIEWDOCFLOW",
"I_DELIVERYPICKVIEWITEM",
"I_DELIVERYPICKVIEWSHPPOINT"
],
"BASE":
[
"I_DELIVERYDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/