I_DeliveryPickViewHeader
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)
| Source | Alias | Join Type |
|---|---|---|
| I_DeliveryDocument | I_DeliveryDocument | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
*/
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA