SV_ITM

SV_ITM is an SAP database table in S/4HANA. It contains 31 fields.

Fields (31)

KeyField CDS FieldsUsed in Views
AccountAssignmentCategory AccountAssignmentCategory 1
AccountingDocumentType AccountingDocumentType 1
DeliveryDate DeliveryDate 1
GoodsMovementQuantity GoodsMovementQuantity 1
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
InvoicingStatus Status 1
ManufacturerMaterial ManufacturerMaterial 1
Material Material 1
MaterialGroup MaterialGroup 1
PlantName PlantName 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderCurrency Currency 1
PurchaseOrderItem PurchaseOrderItem 1
PurchaseOrderItemCategory PurchaseOrderItemCategory 1
PurchasingDocument InvoiceReference 1
PurchasingDocumentItem AccountingDocumentItem 1
PurchasingDocumentItemText PurchasingDocumentItemText 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganisationName PurchasingOrganizationName 1
PurchasingOrganization PurchasingOrganization 1
Quantity PurchasingDocumentItemQuantity 1
QuantityUnit QuantityUnit 1
SalesOrderItem SalesOrderItem 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 SV_ITM (
    ACCOUNTASSIGNMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    DELIVERYDATE,
    GOODSMOVEMENTQUANTITY,
    INVOICEREFERENCEFISCALYEAR,
    INVOICINGSTATUS,
    MANUFACTURERMATERIAL,
    MATERIAL,
    MATERIALGROUP,
    PLANTNAME,
    PURCHASEORDER,
    PURCHASEORDERCURRENCY,
    PURCHASEORDERITEM,
    PURCHASEORDERITEMCATEGORY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGORGANISATIONNAME,
    PURCHASINGORGANIZATION,
    QUANTITY,
    QUANTITYUNIT,
    SALESORDERITEM,
    SUPPLIER,
    SUPPLIERADDRESSCITY,
    SUPPLIERADDRESSCOUNTRY,
    SUPPLIERNAME,
    SUPPLYINGPLANT,
    SUPPLYINGPLANTNAME
);