GR_ITM

GR_ITM is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
AccountAssignmentCategory AccountAssignmentCategory 1
DeliveryDate DeliveryDate 1
GoodsMovementType1 Status 1
ManufacturerMaterial ManufacturerMaterial 1
Material Material 1
MaterialGroup MaterialGroup 1
PlantName PlantName 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderItem PurchaseOrderItem 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 1
PurchaseOrderQuantityUnit QuantityUnit 1
PurchasingDocument MaterialDocument 1
PurchasingDocumentItemText PurchasingDocumentItemText 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganization PurchasingOrganization 1
PurchasingOrganizationName PurchasingOrganizationName 1
Quantity PurchasingDocumentItemQuantity 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 GR_ITM (
    ACCOUNTASSIGNMENTCATEGORY,
    DELIVERYDATE,
    GOODSMOVEMENTTYPE1,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALGROUP,
    PLANTNAME,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    PURCHASEORDERITEMCATEGORY,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANIZATION,
    PURCHASINGORGANIZATIONNAME,
    QUANTITY,
    SUPPLIER,
    SUPPLIERADDRESSCITY,
    SUPPLIERADDRESSCOUNTRY,
    SUPPLIERNAME,
    SUPPLYINGPLANT,
    SUPPLYINGPLANTNAME
);