PR_ITM

PR_ITM is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
AcctAssignmentCategory AccountAssignmentCategory 1
DeliveryDate DeliveryDate 1
ManufacturerMaterial ManufacturerMaterial 1
Material Material 1
MaterialBaseUnit QuantityUnit 1
MaterialGroup MaterialGroup 1
PlantName PlantName 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 1
PurchaseRequisition PurchaseRequisition 1
PurchaseRequisitionItem PurchaseRequisitionItem 1
PurchaseRequisitionItemText PurchasingDocumentItemText 1
PurchasingDocument PurchaseOrder 1
PurchasingDocumentItem PurchaseOrderItem 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganization PurchasingOrganization 1
PurchasingOrganizationName PurchasingOrganizationName 1
PurgDocTransactionCurrency Currency 1
Quantity PurchasingDocumentItemQuantity 1
ServicePerformerName ServicePerformerName 1
status Status 1
SupplierAddressCity SupplierAddressCity 1
SupplierAddressCountry SupplierAddressCountry 1
SupplyingPlant SupplyingPlant 1
SupplyingPlantName SupplyingPlantName 1
vendor Supplier 1
vendorName SupplierName 1
WBSElementExternalID WBSElementExternalID 1
WorkPackageFullName WorkPackageFullName 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 PR_ITM (
    ACCTASSIGNMENTCATEGORY,
    DELIVERYDATE,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALGROUP,
    PLANTNAME,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASEREQUISITIONITEMTEXT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANIZATION,
    PURCHASINGORGANIZATIONNAME,
    PURGDOCTRANSACTIONCURRENCY,
    QUANTITY,
    SERVICEPERFORMERNAME,
    STATUS,
    SUPPLIERADDRESSCITY,
    SUPPLIERADDRESSCOUNTRY,
    SUPPLYINGPLANT,
    SUPPLYINGPLANTNAME,
    VENDOR,
    VENDORNAME,
    WBSELEMENTEXTERNALID,
    WORKPACKAGEFULLNAME
);