I_DELIVERYDOCUMENTITEM
Delivery Document Item
I_DELIVERYDOCUMENTITEM is a CDS View in S/4HANA. Delivery Document Item. It contains 234 fields. 78 CDS views read from this table.
CDS Views using this table (78)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_InbDeliveryItem | view | from | BASIC | CDS View for Inbound Delivery Item |
| A_InbDeliveryItem_1 | view | from | BASIC | CDS View for Inbound Delivery Item |
| A_OutbDeliveryItem | view | from | BASIC | CDS view for API exposure |
| A_OutbDeliveryItem_1 | view | from | BASIC | CDS view for API exposure |
| A_ReturnsDeliveryItem | view | from | BASIC | Returns Delivery Item |
| A_ReturnsDeliveryItem_1 | view | from | BASIC | Returns Delivery Item |
| C_BSOrdItmProcFlwRetDeliv | view | from | CONSUMPTION | Ret Delivery Item Attrib for BSOrd Prgrs |
| C_BSQPMOutboundDeliveryItem | view_entity | from | CONSUMPTION | BSQPM Outbound Delivery Item Attribute |
| C_CustRetSubsqntOutbDeliv | view | from | CONSUMPTION | Returns Order Subsqnt Outbound Delivery |
| C_CustReturnsDeliveryItemDEX | view_entity | from | CONSUMPTION | Data Extr for Cust Ret Delivery Item |
| C_DelivDocItemIncomplete | view | from | CONSUMPTION | Delivery Doc Item Incomplete Data |
| C_DelivDocItemOfResvnDocItem | view_entity | from | CONSUMPTION | Delivery Documents of Resvn Doc Items |
| C_DelivDocItemShippingBlkd | view | from | CONSUMPTION | Delivery Doc Item Shipping Blocked |
| C_DelivDocItemTrdCmplncIssue | view | from | CONSUMPTION | Delivery Doc Item Trade Compliance Issue |
| C_DeliveryItemOutputDetn | view | from | CONSUMPTION | Delivery Item Output Determination |
| C_DeliveryNoteItem | view | from | CONSUMPTION | Consumption view for Delivery Note Item |
| C_DelivProcFlowInbDelivItem | view_entity | from | CONSUMPTION | Inbound Delivery Item Process Flow |
| C_DelivProcFlowOutbDelivItem | view_entity | from | CONSUMPTION | Outbound Delivery Item Process Flow |
| C_ESJIOtbndDlvryItemQuery | view | from | CONSUMPTION | Outbound Delivery Item |
| C_InboundDeliveryItemDEX | view_entity | from | CONSUMPTION | Data Extr for Inbound Delivery Item |
| C_InhReprLogisticsProcessFlow | view_entity | inner | CONSUMPTION | Process Flow for Log Process of ServObj |
| C_OutboundDeliveryItemDEX | view_entity | from | CONSUMPTION | Data Extr for Outbound Delivery Item |
| C_PT_DeliveryNoteItem | view | from | CONSUMPTION | PT Delivery Note Form Item |
| C_QualityCertificateEmail | view | from | CONSUMPTION | Quality Certificate Email |
| C_RDPDeliveryDocumentItemDEX | view | from | CONSUMPTION | Delivery Document Item Extractor for RDP |
| C_SlsDocFlfmtDelivDocItem | view | from | CONSUMPTION | Sales Doc Fulfillment: Delivery Doc Item |
| C_SustDeliveryDocumentItemDEX | view_entity | from | CONSUMPTION | Delivery Document Item Extractor |
| CIC_OUTBOUNDDELIVERYITEM | view_entity | from | Projection on Outbound Delivery Items | |
| finoc_hard_dependency_dlv | view_entity | inner | Orgl Change: DLV Hard Dependencies | |
| FINOC_RULE_DLV_BASE | view_entity | inner | Orgl Change-Rule: Delivery Document Base | |
| I_ComplaintProcessFlowStatus | view_entity | union | COMPOSITE | Complaint Process Flow Status |
| I_CustomerReturnDeliveryItem | view | from | BASIC | Customer Returns Delivery Item |
| I_DelivDocumentItemIncomplete | view | from | COMPOSITE | SOFM Incomplete Delivery Document Item |
| I_DeliveryDocItemAnalytics | view | from | COMPOSITE | Delivery Document Item Analytics |
| I_DeliveryDocumentItemAmount | view | from | COMPOSITE | Delivery Document Item Amount |
| I_DeliveryDocumentItemVH | view | from | COMPOSITE | Delivery document items |
| I_DeliveryPickViewItem | view | from | COMPOSITE | Delivery Pick List Item |
| I_DelivItmWthoutRefQuickCrte | view | from | BASIC | Quick Create Deliv Itm w/o reference |
| I_FldLogsRcvdInboundDelivery | view_entity | from | COMPOSITE | FL Received Inbound Delivery |
| I_FldLogsRcvdOutboundDelivery | view_entity | from | COMPOSITE | FL Outbound Delivery |
| I_FldLogsReturnDocFlow | view | union_all | COMPOSITE | FL Return Docflow Union |
| I_HUPDeliveryItemReservation | view_entity | inner | COMPOSITE | DlvItems related to HU Resvn |
| I_HUPSchedAgrmtItemDlvRelshp | view_entity | from | COMPOSITE | DlvPos related to SchedAgrmt items |
| I_InboundDeliveryItem | view | from | BASIC | Inbound Delivery Item |
| I_JITOutbCallDelivDocRef | view | inner | COMPOSITE | Material Document Reference for Delivery |
| I_LstMiReloadRequestDeliveryVH | view_entity | inner | COMPOSITE | LMD Delivery Help for Reload Request |
| I_LstMiVisitCustomerDeliveryVH | view_entity | inner | COMPOSITE | LMD Customer Delivery Help for Visit |
| I_MRPSalesDemand | view | inner | COMPOSITE | MRP Sales Demand |
| I_OutboundDeliveryItem | view | from | BASIC | Outbound Delivery Item |
| I_ProdCmplncLicRlvtDelivDocs | view | from | COMPOSITE | License Relevant Outbound Delivery Items |
| I_PT_SAFTBillingDeliveryProd | view_entity | from | COMPOSITE | Product from Delivery Document |
| I_SAFTDeliveryItem | view | from | COMPOSITE | SAFT Delivery Item |
| I_SAFTDeliveryProduct | view | from | COMPOSITE | SAF-T Billing Product |
| P_DeliveryDocumentItemText | view_entity | inner | COMPOSITE | |
| P_DeliveryProcFlow | view | inner | CONSUMPTION | Delivery Process Flow |
| P_HndlgUnitItmCmptblty_F4674 | view | inner | COMPOSITE | |
| P_LogcDocDeliveryItem | view_entity | from | CONSUMPTION | |
| P_LstMiDeliveryToSalesDocument | view | from | COMPOSITE | |
| P_PackedDeliveryForStore_F4674 | view | inner | COMPOSITE | |
| P_PrdtdDelivProcgDlyTrngData1 | view | inner | COMPOSITE | |
| P_ReturnsReferenceDocument | view_entity | from | COMPOSITE | |
| P_SalesOrderInDelivDueDate | view | inner | COMPOSITE | |
| P_SalesOrderInDelivItmDueDate | view | inner | COMPOSITE | |
| P_SdPricingPrcd | view | inner | COMPOSITE | |
| P_SlsDocFlfmtProcHierarchyD21 | view | from | CONSUMPTION | |
| P_SlsDocItemPrdtvTrngData1 | view | from | COMPOSITE | |
| P_SlsOrdDelivdDueDte | view | inner | COMPOSITE | |
| P_SlsOrdDelivdDueDte2 | view | inner | COMPOSITE | |
| P_SlsOrdItmDelivAnlyts | view | from | COMPOSITE | |
| P_SlsOrdItmDelivdDueDte | view | inner | COMPOSITE | |
| P_SlsOrdItmDelivdDueDte2 | view | inner | COMPOSITE | |
| P_SlsOrdItmDelivDimnAnlyts | view | from | COMPOSITE | |
| P_SlsOrdProcFlow15 | view | inner | CONSUMPTION | Sales Order Process Flow: Level +1 Intercompany Delivery |
| P_STOItmDelivAnlyts | view | from | COMPOSITE | |
| P_StRpSalesInvoiceItem | view | left_outer | CONSUMPTION | Private View for Sales Invoice List |
| R_CustomerReturnsDelivItemTP | view_entity | from | TRANSACTIONAL | Customer Returns Delivery Item - TP |
| R_InboundDeliveryItemTP | view_entity | from | TRANSACTIONAL | Inbound Delivery Item - TP |
| R_OutboundDeliveryItemTP | view_entity | from | TRANSACTIONAL | Outbound Delivery Item - TP |
Fields (234)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DeliveryDocument | DeliveryDocument,Level1Document,OutboundDelivery,SubsequentDocument,vbeln | 34 |
| KEY | DeliveryDocumentItem | DeliveryDocumentItem,DocumentItemNumber,Level1DocumentItem,posnr,SubsequentDocumentItem | 35 |
| KEY | DeliveryDocumentItemCategory | DeliveryDocumentItemCategory,SalesDocumentItemCategory | 14 |
| KEY | DistributionChannel | DistributionChannel | 10 |
| KEY | Division | Division | 10 |
| KEY | Material | Material,Product,ProductID | 14 |
| KEY | ReferenceSDDocument | DelivSalesDoc,ReferenceSDDocument,SalesDocument,SDDocument | 17 |
| KEY | ReferenceSDDocumentCategory | PrecedingDocumentCategory,ReferenceSDDocumentCategory,SDDocumentCategory | 13 |
| KEY | ReferenceSDDocumentItem | DelivSalesDocItem,ReferenceSDDocumentItem,SalesDocumentItem | 15 |
| _AdditionalCustomerGroup1 | _AdditionalCustomerGroup1 | 1 | |
| _AdditionalCustomerGroup2 | _AdditionalCustomerGroup2 | 1 | |
| _AdditionalCustomerGroup3 | _AdditionalCustomerGroup3 | 1 | |
| _AdditionalCustomerGroup4 | _AdditionalCustomerGroup4 | 1 | |
| _AdditionalCustomerGroup5 | _AdditionalCustomerGroup5 | 1 | |
| _AdditionalMaterialGroup1 | _AdditionalMaterialGroup1 | 1 | |
| _AdditionalMaterialGroup2 | _AdditionalMaterialGroup2 | 1 | |
| _AdditionalMaterialGroup3 | _AdditionalMaterialGroup3 | 1 | |
| _AdditionalMaterialGroup4 | _AdditionalMaterialGroup4 | 1 | |
| _AdditionalMaterialGroup5 | _AdditionalMaterialGroup5 | 1 | |
| _BaseUnit | _BaseUnit | 1 | |
| _BOMExplosion | _BOMExplosion | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _ChmlCmplncStatus | _ChmlCmplncStatus | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| _DangerousGoodsStatus | _DangerousGoodsStatus | 1 | |
| _DeliveryDocument | _DeliveryDocument | 3 | |
| _DeliveryQuantityUnit | _DeliveryQuantityUnit | 1 | |
| _DeliveryRelatedBillingStatus | _DeliveryRelatedBillingStatus | 1 | |
| _DistributionChannel | _DistributionChannel | 1 | |
| _Division | _Division | 1 | |
| _GoodsMovementStatus | _GoodsMovementStatus | 1 | |
| _GoodsMovementType | _GoodsMovementType | 1 | |
| _InventorySpecialStockType | _InventorySpecialStockType | 1 | |
| _InventoryValuationType | _InventoryValuationType | 1 | |
| _ItemBillingBlockReason | _ItemBillingBlockReason | 1 | |
| _ItemBillingIncompletionStatus | _ItemBillingIncompletionStatus | 2 | |
| _ItemCategory | _ItemCategory | 1 | |
| _ItemDelivIncompletionSts | _ItemDelivIncompletionSts | 2 | |
| _ItemGdsMvtIncompletionSts | _ItemGdsMvtIncompletionSts | 2 | |
| _ItemGeneralIncompletionStatus | _ItemGeneralIncompletionStatus | 2 | |
| _ItemIsBillingRelevant | _ItemIsBillingRelevant | 1 | |
| _ItemPackingIncompletionStatus | _ItemPackingIncompletionStatus | 2 | |
| _ItemPickingIncompletionStatus | _ItemPickingIncompletionStatus | 2 | |
| _ItemVolumeUnit | _ItemVolumeUnit | 1 | |
| _ItemWeightUnit | _ItemWeightUnit | 1 | |
| _LoadingGroup | _LoadingGroup | 1 | |
| _LogicalSystem | _LogicalSystem | 1 | |
| _Material | _Material | 1 | |
| _MaterialFreightGroup | _MaterialFreightGroup | 1 | |
| _MaterialGroup | _MaterialGroup | 1 | |
| _OrderID | _OrderID | 1 | |
| _OriginallyRequestedMaterial | _OriginallyRequestedMaterial | 1 | |
| _PackingStatus | _PackingStatus | 1 | |
| _Partner | _Partner | 1 | |
| _PaymentGuaranteeForm | _PaymentGuaranteeForm | 1 | |
| _PickingConfirmationStatus | _PickingConfirmationStatus | 1 | |
| _PickingControl | _PickingControl | 1 | |
| _PickingStatus | _PickingStatus | 1 | |
| _Plant | _Plant | 1 | |
| _Product | _Product | 1 | |
| _ProductGroup | _ProductGroup | 1 | |
| _ProductHierarchyNode | _ProductHierarchyNode | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProofOfDeliveryStatus | _ProofOfDeliveryStatus | 1 | |
| _ReferenceSalesDocumentItem | _ReferenceSalesDocumentItem | 1 | |
| _ReferenceSDDocument | _ReferenceSDDocument | 1 | |
| _ReferenceSDDocumentCategory | _ReferenceSDDocumentCategory | 1 | |
| _SafetyDataSheetStatus | _SafetyDataSheetStatus | 1 | |
| _SalesDocumentItemType | _SalesDocumentItemType | 1 | |
| _SalesGroup | _SalesGroup | 1 | |
| _SalesOffice | _SalesOffice | 1 | |
| _SDDocumentCategory | _SDDocumentCategory | 1 | |
| _SDProcessStatus | _SDProcessStatus | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| _TransportationGroup | _TransportationGroup | 1 | |
| _TrdCmplncEmbargoSts | _TrdCmplncEmbargoSts | 1 | |
| _TrdCmplncLegalControlSts | _TrdCmplncLegalControlSts | 1 | |
| _TrdCmplncSnctndListChkSts | _TrdCmplncSnctndListChkSts | 1 | |
| _Warehouse | _Warehouse | 1 | |
| _WarehouseActivityStatus | _WarehouseActivityStatus | 1 | |
| _WarehouseStagingArea | _WarehouseStagingArea | 1 | |
| ActualDeliveredQtyInBaseUnit | ActualDeliveredQtyInBaseUnit | 9 | |
| ActualDeliveryQuantity | ActualDeliveryQuantity,Quantity | 18 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 7 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 7 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 7 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 7 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 7 | |
| AdditionalMaterialGroup1 | AdditionalMaterialGroup1 | 7 | |
| AdditionalMaterialGroup2 | AdditionalMaterialGroup2 | 7 | |
| AdditionalMaterialGroup3 | AdditionalMaterialGroup3 | 7 | |
| AdditionalMaterialGroup4 | AdditionalMaterialGroup4 | 7 | |
| AdditionalMaterialGroup5 | AdditionalMaterialGroup5 | 7 | |
| AlternateProductNumber | AlternateProductNumber | 7 | |
| BaseUnit | BaseUnit | 8 | |
| Batch | Batch | 13 | |
| BatchBySupplier | BatchBySupplier | 8 | |
| BatchClassification | BatchClassification | 7 | |
| BOMExplosion | BOMExplosion | 7 | |
| BusinessArea | BusinessArea | 7 | |
| ConsumptionPosting | ConsumptionPosting | 7 | |
| ControllingArea | ControllingArea | 7 | |
| CostCenter | CostCenter | 7 | |
| CreatedByUser | CreatedByUser | 8 | |
| CreationDate | CreationDate | 9 | |
| CreationTime | CreationTime | 7 | |
| CustEngineeringChgStatus | CustEngineeringChgStatus | 7 | |
| DeliveryDocumentItemBySupplier | DeliveryDocumentItemBySupplier | 1 | |
| DeliveryDocumentItemText | DeliveryDocumentItemText,DocumentItemText | 14 | |
| DeliveryGroup | DeliveryGroup | 8 | |
| DeliveryQuantityUnit | DeliveryQuantityUnit,QuantityUnit | 19 | |
| DeliveryRelatedBillingStatus | DeliveryRelatedBillingStatus | 11 | |
| DeliveryToBaseQuantityDnmntr | DeliveryToBaseQuantityDnmntr | 8 | |
| DeliveryToBaseQuantityNmrtr | DeliveryToBaseQuantityNmrtr | 8 | |
| DepartmentClassificationByCust | DepartmentClassificationByCust | 8 | |
| EU_DeliveryItemARCStatus | EU_DeliveryItemARCStatus | 1 | |
| FixedShipgProcgDurationInDays | FixedShipgProcgDurationInDays | 7 | |
| GLAccount | GLAccount | 7 | |
| GoodsMovementReasonCode | GoodsMovementReasonCode | 7 | |
| GoodsMovementStatus | GoodsMovementStatus | 16 | |
| GoodsMovementType | GoodsMovementType | 13 | |
| HigherLevelItem | HigherLevelItem | 8 | |
| HigherLevelItemUsage | HigherLevelItemUsage | 1 | |
| HigherLvlItmOfBatSpltItm | HigherLvlItmOfBatSpltItm | 5 | |
| InspectionLot | InspectionLot | 8 | |
| InspectionPartialLot | InspectionPartialLot | 7 | |
| IntercompanyBillingStatus | IntercompanyBillingStatus | 7 | |
| InternationalArticleNumber | InternationalArticleNumber | 8 | |
| InventorySpecialStockType | InventorySpecialStockType | 12 | |
| InventoryValuationType | InventoryValuationType | 7 | |
| IsCompletelyDelivered | IsCompletelyDelivered | 7 | |
| IsNotGoodsMovementsRelevant | IsNotGoodsMovementsRelevant | 7 | |
| IsSeparateValuation | IsSeparateValuation | 7 | |
| IssgOrRcvgBatch | IssgOrRcvgBatch | 8 | |
| IssgOrRcvgMaterial | IssgOrRcvgMaterial | 8 | |
| IssgOrRcvgSpclStockInd | IssgOrRcvgSpclStockInd | 8 | |
| IssgOrRcvgStockCategory | IssgOrRcvgStockCategory | 8 | |
| IssgOrRcvgValuationType | IssgOrRcvgValuationType | 7 | |
| IssuingOrReceivingPlant | IssuingOrReceivingPlant | 8 | |
| IssuingOrReceivingStorageLoc | IssuingOrReceivingStorageLoc | 8 | |
| ItemBillingBlockReason | ItemBillingBlockReason | 11 | |
| ItemBillingIncompletionStatus | ItemBillingIncompletionStatus | 8 | |
| ItemDeliveryIncompletionStatus | ItemDeliveryIncompletionStatus | 8 | |
| ItemGdsMvtIncompletionSts | ItemGdsMvtIncompletionSts | 8 | |
| ItemGeneralIncompletionStatus | ItemGeneralIncompletionStatus | 9 | |
| ItemGrossWeight | ItemGrossWeight | 12 | |
| ItemHasValueAddedService | ItemHasValueAddedService | 1 | |
| ItemIsBillingRelevant | ItemIsBillingRelevant | 7 | |
| ItemNetWeight | ItemNetWeight | 12 | |
| ItemPackingIncompletionStatus | ItemPackingIncompletionStatus | 8 | |
| ItemPickingIncompletionStatus | ItemPickingIncompletionStatus | 8 | |
| ItemVolume | ItemVolume | 12 | |
| ItemVolumeUnit | ItemVolumeUnit | 12 | |
| ItemWeightUnit | ItemWeightUnit | 12 | |
| LastChangeDate | LastChangeDate | 8 | |
| LoadingGroup | LoadingGroup | 11 | |
| ManufactureDate | ManufactureDate | 7 | |
| MaterialByCustomer | MaterialByCustomer | 12 | |
| MaterialFreightGroup | MaterialFreightGroup | 7 | |
| MaterialGroup | MaterialGroup | 7 | |
| MaterialIsBatchManaged | MaterialIsBatchManaged | 8 | |
| MaterialIsIntBatchManaged | MaterialIsIntBatchManaged | 8 | |
| NumberOfSerialNumbers | NumberOfSerialNumbers | 8 | |
| OrderID | OrderID | 9 | |
| OrderItem | OrderItem | 8 | |
| OriginalDeliveryQuantity | OriginalDeliveryQuantity | 8 | |
| OriginallyRequestedMaterial | OriginallyRequestedMaterial | 7 | |
| OverdelivTolrtdLmtRatioInPct | OverdelivTolrtdLmtRatioInPct | 11 | |
| PackingStatus | PackingStatus | 11 | |
| PartialDeliveryIsAllowed | PartialDeliveryIsAllowed | 7 | |
| PaymentGuaranteeForm | PaymentGuaranteeForm | 7 | |
| PickingConfirmationStatus | PickingConfirmationStatus | 11 | |
| PickingControl | PickingControl | 8 | |
| PickingStatus | PickingStatus | 12 | |
| Plant | Plant,SupplyingSite | 17 | |
| PrimaryPostingSwitch | PrimaryPostingSwitch | 8 | |
| Product | Product | 1 | |
| ProductAvailabilityDate | ProductAvailabilityDate | 6 | |
| ProductAvailabilityTime | ProductAvailabilityTime | 5 | |
| ProductCharacteristic1 | ProductCharacteristic1 | 2 | |
| ProductCharacteristic2 | ProductCharacteristic2 | 2 | |
| ProductCharacteristic3 | ProductCharacteristic3 | 2 | |
| ProductCollection | ProductCollection | 2 | |
| ProductConfiguration | ProductConfiguration | 7 | |
| ProductGroup | ProductGroup | 1 | |
| ProductHierarchyNode | ProductHierarchyNode | 7 | |
| ProductSeason | ProductSeason | 2 | |
| ProductSeasonYear | ProductSeasonYear | 2 | |
| ProductTheme | ProductTheme | 2 | |
| ProfitabilitySegment_2 | ProfitabilitySegment | 1 | |
| ProfitCenter | ProfitCenter | 7 | |
| ProofOfDeliveryRelevanceCode | ProofOfDeliveryRelevanceCode | 7 | |
| ProofOfDeliveryStatus | ProofOfDeliveryStatus | 7 | |
| PurchaseOrder | PurchaseOrder | 1 | |
| PurchaseOrderItem | PurchaseOrderItem | 1 | |
| QuantityIsFixed | QuantityIsFixed | 7 | |
| ReceivingPoint | ReceivingPoint | 8 | |
| ReferenceDocumentLogicalSystem | ReferenceDocumentLogicalSystem | 7 | |
| RequirementSegment | RequirementSegment | 2 | |
| Reservation | Reservation | 2 | |
| ReservationItem | ReservationItem | 2 | |
| ReservationRecordType | ReservationRecordType | 1 | |
| RetailPromotion | RetailPromotion | 8 | |
| SalesDocumentItemType | SalesDocumentItemType | 7 | |
| SalesGroup | SalesGroup | 7 | |
| SalesOffice | SalesOffice | 7 | |
| SDDocumentCategory | SDDocumentCategory | 8 | |
| SDProcessStatus | SDProcessStatus | 7 | |
| ShelfLifeExpirationDate | ShelfLifeExpirationDate | 8 | |
| StatisticsDate | StatisticsDate | 7 | |
| StockSegment | StockSegment | 3 | |
| StockType | StockType | 11 | |
| StorageBin | StorageBin | 8 | |
| StorageLocation | StorageLocation | 14 | |
| StorageType | StorageType | 8 | |
| SubsequentMovementType | SubsequentMovementType | 7 | |
| TransportationGroup | TransportationGroup | 11 | |
| TrdCmplncEmbargoSts | TrdCmplncEmbargoSts | 2 | |
| TrdCmplncLegalControlSts | TrdCmplncLegalControlSts | 2 | |
| TrdCmplncSnctndListChkSts | TrdCmplncSnctndListChkSts | 1 | |
| UnderdelivTolrtdLmtRatioInPct | UnderdelivTolrtdLmtRatioInPct | 11 | |
| UnlimitedOverdeliveryIsAllowed | UnlimitedOverdeliveryIsAllowed | 7 | |
| ValAddedSrvcItemGroup | ValAddedSrvcItemGroup | 1 | |
| ValAddedSrvcItemNumber | ValAddedSrvcItemNumber | 1 | |
| ValAddedSrvcParentItmNumber | ValAddedSrvcParentItmNumber | 1 | |
| ValAddedSrvcTransactionNumber | ValAddedSrvcTransactionNumber | 1 | |
| VarblShipgProcgDurationInDays | VarblShipgProcgDurationInDays | 7 | |
| Warehouse | Warehouse | 14 | |
| WarehouseActivityStatus | WarehouseActivityStatus | 12 | |
| WarehouseStagingArea | WarehouseStagingArea | 12 | |
| WarehouseStockCategory | WarehouseStockCategory | 8 | |
| WarehouseStorageBin | WarehouseStorageBin | 8 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Delivery Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DELIVERYDOCUMENTITEM (
DELIVERYDOCUMENT,
DELIVERYDOCUMENTITEM,
DELIVERYDOCUMENTITEMCATEGORY,
DISTRIBUTIONCHANNEL,
DIVISION,
MATERIAL,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
_ADDITIONALCUSTOMERGROUP1,
_ADDITIONALCUSTOMERGROUP2,
_ADDITIONALCUSTOMERGROUP3,
_ADDITIONALCUSTOMERGROUP4,
_ADDITIONALCUSTOMERGROUP5,
_ADDITIONALMATERIALGROUP1,
_ADDITIONALMATERIALGROUP2,
_ADDITIONALMATERIALGROUP3,
_ADDITIONALMATERIALGROUP4,
_ADDITIONALMATERIALGROUP5,
_BASEUNIT,
_BOMEXPLOSION,
_BUSINESSAREA,
_CHMLCMPLNCSTATUS,
_CONTROLLINGAREA,
_COSTCENTER,
_CREATEDBYUSER,
_DANGEROUSGOODSSTATUS,
_DELIVERYDOCUMENT,
_DELIVERYQUANTITYUNIT,
_DELIVERYRELATEDBILLINGSTATUS,
_DISTRIBUTIONCHANNEL,
_DIVISION,
_GOODSMOVEMENTSTATUS,
_GOODSMOVEMENTTYPE,
_INVENTORYSPECIALSTOCKTYPE,
_INVENTORYVALUATIONTYPE,
_ITEMBILLINGBLOCKREASON,
_ITEMBILLINGINCOMPLETIONSTATUS,
_ITEMCATEGORY,
_ITEMDELIVINCOMPLETIONSTS,
_ITEMGDSMVTINCOMPLETIONSTS,
_ITEMGENERALINCOMPLETIONSTATUS,
_ITEMISBILLINGRELEVANT,
_ITEMPACKINGINCOMPLETIONSTATUS,
_ITEMPICKINGINCOMPLETIONSTATUS,
_ITEMVOLUMEUNIT,
_ITEMWEIGHTUNIT,
_LOADINGGROUP,
_LOGICALSYSTEM,
_MATERIAL,
_MATERIALFREIGHTGROUP,
_MATERIALGROUP,
_ORDERID,
_ORIGINALLYREQUESTEDMATERIAL,
_PACKINGSTATUS,
_PARTNER,
_PAYMENTGUARANTEEFORM,
_PICKINGCONFIRMATIONSTATUS,
_PICKINGCONTROL,
_PICKINGSTATUS,
_PLANT,
_PRODUCT,
_PRODUCTGROUP,
_PRODUCTHIERARCHYNODE,
_PROFITCENTER,
_PROOFOFDELIVERYSTATUS,
_REFERENCESALESDOCUMENTITEM,
_REFERENCESDDOCUMENT,
_REFERENCESDDOCUMENTCATEGORY,
_SAFETYDATASHEETSTATUS,
_SALESDOCUMENTITEMTYPE,
_SALESGROUP,
_SALESOFFICE,
_SDDOCUMENTCATEGORY,
_SDPROCESSSTATUS,
_STORAGELOCATION,
_TRANSPORTATIONGROUP,
_TRDCMPLNCEMBARGOSTS,
_TRDCMPLNCLEGALCONTROLSTS,
_TRDCMPLNCSNCTNDLISTCHKSTS,
_WAREHOUSE,
_WAREHOUSEACTIVITYSTATUS,
_WAREHOUSESTAGINGAREA,
ACTUALDELIVEREDQTYINBASEUNIT,
ACTUALDELIVERYQUANTITY,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALMATERIALGROUP1,
ADDITIONALMATERIALGROUP2,
ADDITIONALMATERIALGROUP3,
ADDITIONALMATERIALGROUP4,
ADDITIONALMATERIALGROUP5,
ALTERNATEPRODUCTNUMBER,
BASEUNIT,
BATCH,
BATCHBYSUPPLIER,
BATCHCLASSIFICATION,
BOMEXPLOSION,
BUSINESSAREA,
CONSUMPTIONPOSTING,
CONTROLLINGAREA,
COSTCENTER,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CUSTENGINEERINGCHGSTATUS,
DELIVERYDOCUMENTITEMBYSUPPLIER,
DELIVERYDOCUMENTITEMTEXT,
DELIVERYGROUP,
DELIVERYQUANTITYUNIT,
DELIVERYRELATEDBILLINGSTATUS,
DELIVERYTOBASEQUANTITYDNMNTR,
DELIVERYTOBASEQUANTITYNMRTR,
DEPARTMENTCLASSIFICATIONBYCUST,
EU_DELIVERYITEMARCSTATUS,
FIXEDSHIPGPROCGDURATIONINDAYS,
GLACCOUNT,
GOODSMOVEMENTREASONCODE,
GOODSMOVEMENTSTATUS,
GOODSMOVEMENTTYPE,
HIGHERLEVELITEM,
HIGHERLEVELITEMUSAGE,
HIGHERLVLITMOFBATSPLTITM,
INSPECTIONLOT,
INSPECTIONPARTIALLOT,
INTERCOMPANYBILLINGSTATUS,
INTERNATIONALARTICLENUMBER,
INVENTORYSPECIALSTOCKTYPE,
INVENTORYVALUATIONTYPE,
ISCOMPLETELYDELIVERED,
ISNOTGOODSMOVEMENTSRELEVANT,
ISSEPARATEVALUATION,
ISSGORRCVGBATCH,
ISSGORRCVGMATERIAL,
ISSGORRCVGSPCLSTOCKIND,
ISSGORRCVGSTOCKCATEGORY,
ISSGORRCVGVALUATIONTYPE,
ISSUINGORRECEIVINGPLANT,
ISSUINGORRECEIVINGSTORAGELOC,
ITEMBILLINGBLOCKREASON,
ITEMBILLINGINCOMPLETIONSTATUS,
ITEMDELIVERYINCOMPLETIONSTATUS,
ITEMGDSMVTINCOMPLETIONSTS,
ITEMGENERALINCOMPLETIONSTATUS,
ITEMGROSSWEIGHT,
ITEMHASVALUEADDEDSERVICE,
ITEMISBILLINGRELEVANT,
ITEMNETWEIGHT,
ITEMPACKINGINCOMPLETIONSTATUS,
ITEMPICKINGINCOMPLETIONSTATUS,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
LASTCHANGEDATE,
LOADINGGROUP,
MANUFACTUREDATE,
MATERIALBYCUSTOMER,
MATERIALFREIGHTGROUP,
MATERIALGROUP,
MATERIALISBATCHMANAGED,
MATERIALISINTBATCHMANAGED,
NUMBEROFSERIALNUMBERS,
ORDERID,
ORDERITEM,
ORIGINALDELIVERYQUANTITY,
ORIGINALLYREQUESTEDMATERIAL,
OVERDELIVTOLRTDLMTRATIOINPCT,
PACKINGSTATUS,
PARTIALDELIVERYISALLOWED,
PAYMENTGUARANTEEFORM,
PICKINGCONFIRMATIONSTATUS,
PICKINGCONTROL,
PICKINGSTATUS,
PLANT,
PRIMARYPOSTINGSWITCH,
PRODUCT,
PRODUCTAVAILABILITYDATE,
PRODUCTAVAILABILITYTIME,
PRODUCTCHARACTERISTIC1,
PRODUCTCHARACTERISTIC2,
PRODUCTCHARACTERISTIC3,
PRODUCTCOLLECTION,
PRODUCTCONFIGURATION,
PRODUCTGROUP,
PRODUCTHIERARCHYNODE,
PRODUCTSEASON,
PRODUCTSEASONYEAR,
PRODUCTTHEME,
PROFITABILITYSEGMENT_2,
PROFITCENTER,
PROOFOFDELIVERYRELEVANCECODE,
PROOFOFDELIVERYSTATUS,
PURCHASEORDER,
PURCHASEORDERITEM,
QUANTITYISFIXED,
RECEIVINGPOINT,
REFERENCEDOCUMENTLOGICALSYSTEM,
REQUIREMENTSEGMENT,
RESERVATION,
RESERVATIONITEM,
RESERVATIONRECORDTYPE,
RETAILPROMOTION,
SALESDOCUMENTITEMTYPE,
SALESGROUP,
SALESOFFICE,
SDDOCUMENTCATEGORY,
SDPROCESSSTATUS,
SHELFLIFEEXPIRATIONDATE,
STATISTICSDATE,
STOCKSEGMENT,
STOCKTYPE,
STORAGEBIN,
STORAGELOCATION,
STORAGETYPE,
SUBSEQUENTMOVEMENTTYPE,
TRANSPORTATIONGROUP,
TRDCMPLNCEMBARGOSTS,
TRDCMPLNCLEGALCONTROLSTS,
TRDCMPLNCSNCTNDLISTCHKSTS,
UNDERDELIVTOLRTDLMTRATIOINPCT,
UNLIMITEDOVERDELIVERYISALLOWED,
VALADDEDSRVCITEMGROUP,
VALADDEDSRVCITEMNUMBER,
VALADDEDSRVCPARENTITMNUMBER,
VALADDEDSRVCTRANSACTIONNUMBER,
VARBLSHIPGPROCGDURATIONINDAYS,
WAREHOUSE,
WAREHOUSEACTIVITYSTATUS,
WAREHOUSESTAGINGAREA,
WAREHOUSESTOCKCATEGORY,
WAREHOUSESTORAGEBIN,
PRIMARY KEY (DELIVERYDOCUMENT, DELIVERYDOCUMENTITEM, DELIVERYDOCUMENTITEMCATEGORY, DISTRIBUTIONCHANNEL, DIVISION, MATERIAL, REFERENCESDDOCUMENT, REFERENCESDDOCUMENTCATEGORY, REFERENCESDDOCUMENTITEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA