I_DeliveryPickViewDocFlow

DDL: I_DELIVERYPICKVIEWDOCFLOW SQL: IDELIVERYPICKF Type: view COMPOSITE

Delivery Pick View

I_DeliveryPickViewDocFlow is a Composite CDS View that provides data about "Delivery Pick View" in SAP S/4HANA. It has 1 association to related views.

11 fields

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DeliveryPickViewItem _Item _Item.DeliveryDocument = $projection.PrecedingDocument and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDELIVERYPICKF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Delivery Pick View view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.query true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
PrecedingDocument I_SDDocumentProcessFlow PrecedingDocument
SubsequentDocumentCategory I_SDDocumentProcessFlow SubsequentDocumentCategory
SDFulfillmentCalculationRule I_SDDocumentProcessFlow SDFulfillmentCalculationRule
QuantityInBaseUnit I_SDDocumentProcessFlow QuantityInBaseUnit
BaseUnitNOTUNIQUE
TransferOrderInWrhsMgmtIsConfd I_SDDocumentProcessFlow TransferOrderInWrhsMgmtIsConfd
PrecedingDocumentItem I_SDDocumentProcessFlow PrecedingDocumentItem
DeliveryDocument _Item DeliveryDocument
ShippingPoint
_Item _Item
_DeliveryDocument _Item _DeliveryDocument 
@AbapCatalog.sqlViewName: 'IDELIVERYPICKF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Delivery Pick View'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
--@Analytics.query: true

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

define view I_DeliveryPickViewDocFlow
  as select distinct from I_SDDocumentProcessFlow
  association [0..1] to I_DeliveryPickViewItem as _Item on  _Item.DeliveryDocument     = $projection.PrecedingDocument
                                                        and _Item.DeliveryDocumentItem = $projection.PrecedingDocumentItem
{
  I_SDDocumentProcessFlow.PrecedingDocument,
  I_SDDocumentProcessFlow.SubsequentDocumentCategory,
  I_SDDocumentProcessFlow.SDFulfillmentCalculationRule,
  I_SDDocumentProcessFlow.QuantityInBaseUnit,
  --I_SDDocumentProcessFlow.BaseUnit NOT UNIQUE,
  I_SDDocumentProcessFlow.TransferOrderInWrhsMgmtIsConfd,
  I_SDDocumentProcessFlow.PrecedingDocumentItem,
  _Item.DeliveryDocument,
  @Consumption.hidden: true
  _Item._DeliveryDocument.ShippingPoint,

  /* Associations */
  _Item,
  _Item._DeliveryDocument

}
where
  I_SDDocumentProcessFlow.SubsequentDocumentCategory = 'Q'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYPICKVIEWITEM",
"I_SDDOCUMENTPROCESSFLOW"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYPICKVIEWITEM"
],
"BASE":
[
"I_DELIVERYPICKVIEWITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More