PD_ITM

33 Fields

PD_ITM is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY ekgrp PurchasingGroup 1
KEY lifnr Supplier 1
KEY matkl MaterialGroup 1
KEY werks Plant 1
AcctAssignmentCategory AccountAssignmentCategory 1
Currency Currency 1
DeliveryDate DeliveryDate 1
eknam PurchasingGroupName 1
ManufacturerMaterial ManufacturerMaterial 1
Material Material 1
MaterialGroup MaterialGroup 1
name1 SupplierName 1
name1_p PlantName 1
PlantName PlantName 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 1
PurchaseOrderItemText PurchasingDocumentItemText 1
PurchaseOrderQty PurchasingDocumentItemQuantity 1
PurchaseOrderQuantityUnit QuantityUnit 1
purchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganization PurchasingOrganization 1
PurchasingOrganizationName PurchasingOrganizationName 1
SalesOrderItem SalesOrderItem 1
status Status 1
supplier Supplier 1
SupplierAddressCity SupplierAddressCity 1
SupplierAddressCountry SupplierAddressCountry 1
SupplierName SupplierName 1
SupplyingPlant SupplyingPlant 1
SupplyingPlantName SupplyingPlantName 1

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PD_ITM (
    EKGRP,
    LIFNR,
    MATKL,
    WERKS,
    ACCTASSIGNMENTCATEGORY,
    CURRENCY,
    DELIVERYDATE,
    EKNAM,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALGROUP,
    NAME1,
    NAME1_P,
    PLANTNAME,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERITEMTEXT,
    PURCHASEORDERQTY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANIZATION,
    PURCHASINGORGANIZATIONNAME,
    SALESORDERITEM,
    STATUS,
    SUPPLIER,
    SUPPLIERADDRESSCITY,
    SUPPLIERADDRESSCOUNTRY,
    SUPPLIERNAME,
    SUPPLYINGPLANT,
    SUPPLYINGPLANTNAME,
    PRIMARY KEY (EKGRP, LIFNR, MATKL, WERKS)
);

Learn More