C_DelivDocumentItemIncompleteQ

DDL: C_DELIVDOCUMENTITEMINCOMPLETEQ SQL: CDLVDOCITMDE03Q Type: view CONSUMPTION Package: VDM_SD_SOF_OLD
27 Fields 1 Data Sources

SOFM Incomplete Delivery Document Item Query

C_DelivDocumentItemIncompleteQ is a Consumption CDS View that provides data about "SOFM Incomplete Delivery Document Item Query" in SAP S/4HANA. It reads from 1 data source (I_DelivDocumentItemIncomplete) and exposes 27 fields with key fields DeliveryDocument, DeliveryDocumentItem. Part of development package VDM_SD_SOF_OLD.

Data Sources (1)

SourceAliasJoin Type
I_DelivDocumentItemIncomplete I_DelivDocumentItemIncomplete from

Parameters (2)

NameTypeDefault
P_Language sylangu
P_ReferenceDate sydate

Annotations (8)

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 Query view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CDLVDOCITMDE03Q view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem Outb. Delivery Item
DueDays DueDays Processing Time
DeliveryDocumentType DeliveryDocumentType Delivery Type
DeliveryDocumentItemCategory DeliveryDocumentItemCategory Item Category
DeliveryDocumentItemCatName
DeliveryDocumentItemText DeliveryDocumentItemText
SalesOrderType SalesOrderType Sales Order Type
Material Material Vehicle Model
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesOrder SalesOrder SD Document
ActualDeliveryQuantity ActualDeliveryQuantity Base quantity
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus
ItemGenIncompletionStatusDesc
ItemBillingIncompletionStatus ItemBillingIncompletionStatus
ItemBillingIncompletionStsDesc
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus
ItemDelivIncompletionStsDesc
ItemPickingIncompletionStatus ItemPickingIncompletionStatus
ItemPickingIncompletionStsDesc
ItemPackingIncompletionStatus ItemPackingIncompletionStatus
ItemPackingIncompletionStsDesc
ItemGdsMvtIncompletionSts ItemGdsMvtIncompletionSts
ItemGdsMvtIncompletionStsDesc

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 C_DelivDocumentItemIncompleteQ.
-- 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: CDLVDOCITMDE03Q
-- Parameters: P_Language : sylangu, P_ReferenceDate : sydate

CREATE VIEW C_DelivDocumentItemIncompleteQ AS
SELECT
  cast(DeliveryDocument as outbound_delivery) AS DeliveryDocument,
  cast(DeliveryDocumentItem as outbound_delivery_item) AS DeliveryDocumentItem,
  DueDays,
  DeliveryDocumentType,
  DeliveryDocumentItemCategory,
  _ItemCategory._Text[1: Language=$parameters.P_Language].SalesDocumentItemCategoryName AS DeliveryDocumentItemCatName,
  DeliveryDocumentItemText,
  SalesOrderType,
  Material,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesOrder,
  ActualDeliveryQuantity,
  DeliveryQuantityUnit,
  ItemGeneralIncompletionStatus,
  _ItemGeneralIncompletionStatus._Text[1: Language=$parameters.P_Language].ItemGenIncompletionStatusDesc AS ItemGenIncompletionStatusDesc,
  ItemBillingIncompletionStatus,
  _ItemBillingIncompletionStatus._Text[1: Language=$parameters.P_Language].ItemBillingIncompletionStsDesc AS ItemBillingIncompletionStsDesc,
  ItemDeliveryIncompletionStatus,
  _ItemDelivIncompletionSts._Text[1: Language=$parameters.P_Language].ItemDelivIncompletionStsDesc AS ItemDelivIncompletionStsDesc,
  ItemPickingIncompletionStatus,
  _ItemPickingIncompletionStatus._Text[1: Language=$parameters.P_Language].ItemPickingIncompletionStsDesc AS ItemPickingIncompletionStsDesc,
  ItemPackingIncompletionStatus,
  _ItemPackingIncompletionStatus._Text[1: Language=$parameters.P_Language].ItemPackingIncompletionStsDesc AS ItemPackingIncompletionStsDesc,
  ItemGdsMvtIncompletionSts,
  _ItemGdsMvtIncompletionSts._Text[1: Language=$parameters.P_Language].ItemGdsMvtIncompletionStsDesc AS ItemGdsMvtIncompletionStsDesc
FROM I_DelivDocumentItemIncomplete
;

Learn More