I_DelivDocumentItemIncomplete

DDL: I_DELIVDOCUMENTITEMINCOMPLETE SQL: IDLVDOCITMDE03 Type: view COMPOSITE
30 Fields 2 Data Sources

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.

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 Outbound Delivery
KEY DeliveryDocumentItem I_DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
DueDays DueDays Processing Time
DeliveryDocumentType _DeliveryDocument DeliveryDocumentType Delivery Type
_DeliveryDocument _DeliveryDocument
DeliveryDocumentItemCategory DeliveryDocumentItemCategory Item Category
_ItemCategory _ItemCategory
DeliveryDocumentItemText DeliveryDocumentItemText
SalesOrganization I_SalesOrderInDelivIncomplete SalesOrganization Sales Organization
DistributionChannel I_SalesOrderInDelivIncomplete DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision I_SalesOrderInDelivIncomplete OrganizationDivision Org. Division
SalesOrderType SalesOrderType Sales Order Type
Material Material Vehicle Model
_Material _Material
SalesOrder SalesOrder SD Document
ActualDeliveryQuantity ActualDeliveryQuantity Base quantity
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_DelivDocumentItemIncomplete.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IDLVDOCITMDE03
-- Parameters: P_ReferenceDate : sydate

CREATE VIEW I_DelivDocumentItemIncomplete AS
SELECT
  DE_Item.DeliveryDocument AS DeliveryDocument,
  DE_Item.DeliveryDocumentItem AS DeliveryDocumentItem,
  DueDays,
  _DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  DeliveryDocumentItemCategory,
  DeliveryDocumentItemText,
  ISSUE_DE03.SalesOrganization AS SalesOrganization,
  ISSUE_DE03.DistributionChannel AS DistributionChannel,
  ISSUE_DE03.OrganizationDivision AS OrganizationDivision,
  SalesOrderType,
  Material,
  SalesOrder,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  ItemGeneralIncompletionStatus,
  DE_Item._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  ItemBillingIncompletionStatus,
  DE_Item._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  ItemDeliveryIncompletionStatus,
  DE_Item._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  ItemPickingIncompletionStatus,
  DE_Item._ItemPickingIncompletionStatus AS _ItemPickingIncompletionStatus,
  ItemPackingIncompletionStatus,
  DE_Item._ItemPackingIncompletionStatus AS _ItemPackingIncompletionStatus,
  ItemGdsMvtIncompletionSts,
  DE_Item._ItemGdsMvtIncompletionSts AS _ItemGdsMvtIncompletionSts
FROM I_DeliveryDocumentItem AS DE_Item
INNER JOIN I_SalesOrderInDelivIncomplete AS ISSUE_DE03 ON /* join condition not captured in parsed metadata */
;

Learn More