I_DelivDocumentItemIncomplete

DDL: I_DELIVDOCUMENTITEMINCOMPLETE SQL: IDLVDOCITMDE03 Type: view COMPOSITE

SOFM Incomplete Delivery Document Item

I_DelivDocumentItemIncomplete is a Composite CDS View that provides data about "SOFM Incomplete Delivery Document Item" in SAP S/4HANA. It reads from 2 data sources (I_DeliveryDocumentItem, I_SalesOrderInDelivIncomplete) and exposes 30 fields with key fields DeliveryDocument, DeliveryDocumentItem.

2 data source(s) 30 fields

Data Sources (2)

SourceAliasJoin Type
I_DeliveryDocumentItem DE_Item from
I_SalesOrderInDelivIncomplete ISSUE_DE03 inner

Parameters (1)

NameTypeDefault
P_ReferenceDate sydate

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Incomplete Delivery Document Item view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IDLVDOCITMDE03 view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocumentItem DeliveryDocument
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem
DueDays DueDays
DeliveryDocumentType _DeliveryDocument DeliveryDocumentType
_DeliveryDocument _DeliveryDocument
DeliveryDocumentItemCategory DeliveryDocumentItemCategory
_ItemCategory _ItemCategory
DeliveryDocumentItemText DeliveryDocumentItemText
SalesOrganization I_SalesOrderInDelivIncomplete SalesOrganization
DistributionChannel I_SalesOrderInDelivIncomplete DistributionChannel
OrganizationDivision I_SalesOrderInDelivIncomplete OrganizationDivision
SalesOrderType SalesOrderType
Material Material
_Material _Material
SalesOrder SalesOrder
ActualDeliveryQuantity ActualDeliveryQuantity
DeliveryQuantityUnit DeliveryQuantityUnit
_DeliveryQuantityUnit _DeliveryQuantityUnit
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus
_ItemGeneralIncompletionStatus I_DeliveryDocumentItem _ItemGeneralIncompletionStatus
ItemBillingIncompletionStatus ItemBillingIncompletionStatus
_ItemBillingIncompletionStatus I_DeliveryDocumentItem _ItemBillingIncompletionStatus
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus
_ItemDelivIncompletionSts I_DeliveryDocumentItem _ItemDelivIncompletionSts
ItemPickingIncompletionStatus ItemPickingIncompletionStatus
_ItemPickingIncompletionStatus I_DeliveryDocumentItem _ItemPickingIncompletionStatus
ItemPackingIncompletionStatus ItemPackingIncompletionStatus
_ItemPackingIncompletionStatus I_DeliveryDocumentItem _ItemPackingIncompletionStatus
ItemGdsMvtIncompletionSts ItemGdsMvtIncompletionSts
_ItemGdsMvtIncompletionSts I_DeliveryDocumentItem _ItemGdsMvtIncompletionSts 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass: #MIXED 
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S 
@EndUserText.label: 'SOFM Incomplete Delivery Document Item'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IDLVDOCITMDE03'

define view I_DelivDocumentItemIncomplete
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_ReferenceDate : sydate
    
as select from I_DeliveryDocumentItem as DE_Item

inner join I_SalesOrderInDelivIncomplete  as ISSUE_DE03 --(P_ReferenceDate: $parameters.P_ReferenceDate)  as ISSUE_DE03
  on  DE_Item.DeliveryDocument     = ISSUE_DE03.DeliveryDocument  
  and DE_Item.DeliveryDocumentItem = ISSUE_DE03.DeliveryDocumentItem

{ 

  //Key

  @ObjectModel.foreignKey.association: '_DeliveryDocument' 
  key DE_Item.DeliveryDocument as DeliveryDocument,    
  key DE_Item.DeliveryDocumentItem as DeliveryDocumentItem, 
  
  //DueDays

  @DefaultAggregation: #MIN
  DueDays,
  
  //Category 

  _DeliveryDocument.DeliveryDocumentType as DeliveryDocumentType, 
  _DeliveryDocument,                                              
  DeliveryDocumentItemCategory,
  _ItemCategory,
  DeliveryDocumentItemText,
    
  //Organization

  ISSUE_DE03.SalesOrganization,
  ISSUE_DE03.DistributionChannel,
  ISSUE_DE03.OrganizationDivision,
  
  //Category

  SalesOrderType,

  //Product

  @ObjectModel.foreignKey.association: '_Material' 
  Material,
  _Material,
    
  //Sales 

  SalesOrder,
  @DefaultAggregation: #SUM
  @Semantics.quantity.unitOfMeasure: 'DeliveryQuantityUnit'
  ActualDeliveryQuantity,
  @Semantics.unitOfMeasure: true
  @ObjectModel.foreignKey.association: '_DeliveryQuantityUnit'
  DeliveryQuantityUnit,
  _DeliveryQuantityUnit,
    
  //Status 

  @ObjectModel.foreignKey.association: '_ItemGeneralIncompletionStatus' 
  ItemGeneralIncompletionStatus,
  DE_Item._ItemGeneralIncompletionStatus,
  @ObjectModel.foreignKey.association: '_ItemBillingIncompletionStatus' 
  ItemBillingIncompletionStatus,
  DE_Item._ItemBillingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  DE_Item._ItemDelivIncompletionSts,
  @ObjectModel.foreignKey.association: '_ItemPickingIncompletionStatus' 
  ItemPickingIncompletionStatus,
   DE_Item._ItemPickingIncompletionStatus,
  @ObjectModel.foreignKey.association: '_ItemPackingIncompletionStatus' 
  ItemPackingIncompletionStatus,
  DE_Item._ItemPackingIncompletionStatus,
  @ObjectModel.foreignKey.association: '_ItemGdsMvtIncompletionSts' 
  ItemGdsMvtIncompletionSts,
  DE_Item._ItemGdsMvtIncompletionSts
  
};                                         
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM",
"I_SALESORDERINDELIVINCOMPLETE"
],
"ASSOCIATED":
[
"I_DELIVERYDOCUMENT",
"I_ITEMBILLINGINCOMPLETIONSTS",
"I_ITEMDELIVINCOMPLETIONSTS",
"I_ITEMGDSMVTINCOMPLETIONSTS",
"I_ITEMGENINCOMPLETIONSTATUS",
"I_ITEMPACKINGINCOMPLETIONSTS",
"I_ITEMPICKINGINCOMPLETIONSTS",
"I_MATERIAL",
"I_SALESDOCUMENTITEMCATEGORY",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More