ITEMS
ITEMS is an SAP database table in S/4HANA. It contains 112 fields.
Fields (112)
| Key | Field | CDS Fields | Used 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 |