ITEMS

112 Fields

ITEMS is an SAP database table in S/4HANA. It contains 112 fields.

Fields (112)

KeyField CDS FieldsUsed in Views
KEY BillOfMaterial BillOfMaterial 1
KEY BillOfMaterialCategory BillOfMaterialCategory 1
KEY BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 1
KEY BillOfMaterialVariant BillOfMaterialVariant 1
KEY BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
KEY BillOfMaterialVersion BillOfMaterialVersion 1
KEY EngineeringChangeDocument EngineeringChangeDocument 1
KEY Plant Plant 2
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
KEY TechnicalObject TechnicalObject 1
AlternativeItemGroup AlternativeItemGroup 1
BillOfMaterialComponent BillOfMaterialComponent 1
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID 1
BillOfMaterialItemCategory BillOfMaterialItemCategory 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
BillOfMaterialItemQuantity BillOfMaterialItemQuantity 1
BillOfMaterialItemUnit BillOfMaterialItemUnit 1
BillOfMaterialItemUUID BillOfMaterialItemUUID 1
BOMIsRecursive BOMIsRecursive 1
BOMItemCreatedByUser BOMItemCreatedByUser 1
BOMItemDescription BOMItemDescription 1
BOMItemInternalChangeCount BOMItemInternalChangeCount 1
BOMItemIsCostingRelevant BOMItemIsCostingRelevant 1
BOMItemIsPlantMaintRelevant BOMItemIsPlantMaintRelevant 1
BOMItemIsSalesRelevant BOMItemIsSalesRelevant 1
BOMItemIsSparePart BOMItemIsSparePart 1
BOMItemLastChangeDate BOMItemLastChangeDate 1
BOMItemLastChangedByUser BOMItemLastChangedByUser 1
BOMItemRecordCreationDate BOMItemRecordCreationDate 1
BOMItemSorter BOMItemSorter 1
BOMItemText2 BOMItemText2 1
ChgToEngineeringChgDocument ChgToEngineeringChgDocument 1
ClassNumber ClassNumber 1
ClassType ClassType 1
ComponentDescription ComponentDescription 1
ComponentScrapInPercent ComponentScrapInPercent 1
CostElement CostElement 1
Creditor Creditor 1
Currency Currency 1
currency_code item_curr_code,item_currency_code 3
DeliveryDurationInDays DeliveryDurationInDays 1
DependencyObjectNumber DependencyObjectNumber 1
DiscontinuationGroup DiscontinuationGroup 1
DistrKeyCompConsumption DistrKeyCompConsumption 1
DocNumber DocNumber 1
DocumentIsCreatedByCAD DocumentIsCreatedByCAD 1
DocumentPart DocumentPart 1
DocumentType DocumentType 1
DocumentVersion DocumentVersion 1
ExplosionType ExplosionType 1
FollowUpGroup FollowUpGroup 1
FormulaKey FormulaKey 1
GoodsReceiptDuration GoodsReceiptDuration 1
gross_amount item_gross_amount 2
IdentifierBOMItem IdentifierBOMItem 1
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem 1
IsALE IsALE 1
IsAssembly IsAssembly 1
IsBOMRecursiveAllowed IsBOMRecursiveAllowed 1
IsBulkMaterial IsBulkMaterial 1
IsClassificationRelevant IsClassificationRelevant 1
IsConfigurableBOM IsConfigurableBOM 1
IsDeleted IsDeleted 1
IsEngineeringRelevant IsEngineeringRelevant 1
IsMaterialProvision IsMaterialProvision 1
IsNetScrap IsNetScrap 1
IsProductionRelevant IsProductionRelevant 1
IsSubItem IsSubItem 1
item_position item_position 2
LeadTimeOffset LeadTimeOffset 1
Material Material 1
MaterialComponentPrice MaterialComponentPrice 1
MaterialGroup MaterialGroup 4
MaterialIsCoProduct MaterialIsCoProduct 1
MaterialPriceUnitQty MaterialPriceUnitQty 1
MultipleSelectionAllowed MultipleSelectionAllowed 1
net_amount item_net_amount 2
NetAmount NetAmount 1
NODE_KEY inode_key 1
number_of_marked_as_helpful number_of_marked_as_helpful 1
number_of_marked_total number_of_marked_total 1
ObjectType ObjectType 1
OperationLeadTimeOffset OperationLeadTimeOffset 1
OperationScrapInPercent OperationScrapInPercent 1
OpsLeadTimeOffsetUnit OpsLeadTimeOffsetUnit 1
ProdOrderIssueLocation ProdOrderIssueLocation 1
ProductionSupplyArea ProductionSupplyArea 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
PurchasingGroup PurchasingGroup 2
PurchasingOrganization PurchasingOrganization 2
QuantityVariableSizeItem QuantityVariableSizeItem 1
rated_by_contact_key rated_by_contact_key 1
rating rating 1
rating_text rating_text 1
rating_title rating_title 1
ReferencePoint ReferencePoint 1
RequiredComponent RequiredComponent 1
ResultingItemCategory ResultingItemCategory 1
review_item_key review_item_key 1
sales_order_item_key sales_order_item_key 1
Size1 Size1 1
Size2 Size2 1
Size3 Size3 1
so_item_pos so_item_pos 1
SpecialProcurementType SpecialProcurementType 1
Supplier Supplier 1
tax_amount item_tax_amount 2
UnitOfMeasureForSize1To3 UnitOfMeasureForSize1To3 1
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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 ITEMS (
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    ENGINEERINGCHANGEDOCUMENT,
    PLANT,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    TECHNICALOBJECT,
    ALTERNATIVEITEMGROUP,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALHEADERUUID,
    BILLOFMATERIALITEMCATEGORY,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMQUANTITY,
    BILLOFMATERIALITEMUNIT,
    BILLOFMATERIALITEMUUID,
    BOMISRECURSIVE,
    BOMITEMCREATEDBYUSER,
    BOMITEMDESCRIPTION,
    BOMITEMINTERNALCHANGECOUNT,
    BOMITEMISCOSTINGRELEVANT,
    BOMITEMISPLANTMAINTRELEVANT,
    BOMITEMISSALESRELEVANT,
    BOMITEMISSPAREPART,
    BOMITEMLASTCHANGEDATE,
    BOMITEMLASTCHANGEDBYUSER,
    BOMITEMRECORDCREATIONDATE,
    BOMITEMSORTER,
    BOMITEMTEXT2,
    CHGTOENGINEERINGCHGDOCUMENT,
    CLASSNUMBER,
    CLASSTYPE,
    COMPONENTDESCRIPTION,
    COMPONENTSCRAPINPERCENT,
    COSTELEMENT,
    CREDITOR,
    CURRENCY,
    CURRENCY_CODE,
    DELIVERYDURATIONINDAYS,
    DEPENDENCYOBJECTNUMBER,
    DISCONTINUATIONGROUP,
    DISTRKEYCOMPCONSUMPTION,
    DOCNUMBER,
    DOCUMENTISCREATEDBYCAD,
    DOCUMENTPART,
    DOCUMENTTYPE,
    DOCUMENTVERSION,
    EXPLOSIONTYPE,
    FOLLOWUPGROUP,
    FORMULAKEY,
    GOODSRECEIPTDURATION,
    GROSS_AMOUNT,
    IDENTIFIERBOMITEM,
    INHERITEDNODENUMBERFORBOMITEM,
    ISALE,
    ISASSEMBLY,
    ISBOMRECURSIVEALLOWED,
    ISBULKMATERIAL,
    ISCLASSIFICATIONRELEVANT,
    ISCONFIGURABLEBOM,
    ISDELETED,
    ISENGINEERINGRELEVANT,
    ISMATERIALPROVISION,
    ISNETSCRAP,
    ISPRODUCTIONRELEVANT,
    ISSUBITEM,
    ITEM_POSITION,
    LEADTIMEOFFSET,
    MATERIAL,
    MATERIALCOMPONENTPRICE,
    MATERIALGROUP,
    MATERIALISCOPRODUCT,
    MATERIALPRICEUNITQTY,
    MULTIPLESELECTIONALLOWED,
    NET_AMOUNT,
    NETAMOUNT,
    NODE_KEY,
    NUMBER_OF_MARKED_AS_HELPFUL,
    NUMBER_OF_MARKED_TOTAL,
    OBJECTTYPE,
    OPERATIONLEADTIMEOFFSET,
    OPERATIONSCRAPINPERCENT,
    OPSLEADTIMEOFFSETUNIT,
    PRODORDERISSUELOCATION,
    PRODUCTIONSUPPLYAREA,
    PURCHASEORDERDATE,
    PURCHASEORDERQUANTITYUNIT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUANTITYVARIABLESIZEITEM,
    RATED_BY_CONTACT_KEY,
    RATING,
    RATING_TEXT,
    RATING_TITLE,
    REFERENCEPOINT,
    REQUIREDCOMPONENT,
    RESULTINGITEMCATEGORY,
    REVIEW_ITEM_KEY,
    SALES_ORDER_ITEM_KEY,
    SIZE1,
    SIZE2,
    SIZE3,
    SO_ITEM_POS,
    SPECIALPROCUREMENTTYPE,
    SUPPLIER,
    TAX_AMOUNT,
    UNITOFMEASUREFORSIZE1TO3,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFMATERIAL, BILLOFMATERIALCATEGORY, BILLOFMATERIALITEMNODENUMBER, BILLOFMATERIALVARIANT, BILLOFMATERIALVARIANTUSAGE, BILLOFMATERIALVERSION, ENGINEERINGCHANGEDOCUMENT, PLANT, PURCHASEORDER, PURCHASEORDERITEM, TECHNICALOBJECT)
);

Learn More