_ITEM

_ITEM is an SAP database table in S/4HANA. It contains 364 fields.

Fields (364)

KeyField CDS FieldsUsed in Views
KEY AccountingClerk AccountingClerk 1
KEY AccountingDocument AccountingDocument,BillingDocument 4
KEY AccountingDocumentItem AccountingDocumentItem 4
KEY AccrSubobjectItmValdtyEndDte AccrSubobjectItmValdtyEndDte 1
KEY AccrualItemType AccrualItemType 1
KEY BaseUnit BaseUnit 1
KEY Batch Batch 3
KEY BillingDocument BillingDocument 3
KEY BillingDocumentItem BillingDocumentItem,DocumentItemNumber 5
KEY BillingQuantity BillingQuantity 2
KEY BillingQuantityUnit BillingQuantityUnit 2
KEY BusinessArea BusinessArea 5
KEY CentralFinanceBillingDocument BillingDocument 1
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField 2
KEY ChangeDocItemChangeType ChangeDocItemChangeType 2
KEY ChangeDocObject ChangeDocObject 2
KEY ChangeDocument ChangeDocument 2
KEY CompanyCode CompanyCode 7
KEY CostCenter CostCenter 1
KEY Customer Customer 6
KEY FinSGLErrorDocument FinSGLErrorDocument 1
KEY FinSGLErrorFiscalYear FinSGLErrorFiscalYear 1
KEY FinSGLErrorItemSeverity FinSGLErrorItemSeverity 1
KEY FinSGLPostedCompanyCode FinSGLPostedCompanyCode 1
KEY FinSGLPostedDocument FinSGLPostedDocument 1
KEY FinSGLPostedFiscalYear FinSGLPostedFiscalYear 1
KEY FinSGLRunID FinSGLRunID 1
KEY FiscalYear FiscalYear 4
KEY GLAccount GLAccount 7
KEY HandlingUnitItem HandlingUnitItem 1
KEY HandlingUnitRefDocumentItem HandlingUnitRefDocumentItem 1
KEY Ledger Ledger 2
KEY Material Material 24
KEY pi_date ItemDate,PaymentItemDate,pi_date 3
KEY pi_no ItemNumber,PaymentItemNumber,pi_no 3
KEY Plant Plant 4
KEY PricingDate PricingDate 1
KEY ProfitabilitySegment_2 ProfitabilitySegment 1
KEY ProfitCenter ProfitCenter 2
KEY ReconciliationAccount ReconciliationAccount 1
KEY REFERENCESDDOCUMENT REFERENCESDDOCUMENT,RequirementDocumentNumber 6
KEY ReverseDocument ReverseDocument 5
KEY SchedulingAgreement SchedulingAgreement 1
KEY ShippingPoint ShippingPoint 3
KEY SourceLedger SourceLedger 2
KEY SourcingProjectItemStableUUID SourcingProjectItemStableUUID 1
KEY SourcingProjectItemUUID SourcingProjectItemUUID 1
KEY SpecialGLCode SpecialGLCode 2
KEY StatryRptCategory StatryRptCategory 3
KEY StatryRptgEntity StatryRptgEntity 3
KEY StatryRptRunID StatryRptRunID 3
KEY StorageLocation StorageLocation 4
KEY SupplierInvoice BillingDocument,SupplierInvoice 2
KEY SupplierInvoiceItem BillingDocumentItem,DocumentItemNumber,SupplierInvoiceItem 2
KEY TaxCode TaxCode 6
KEY TransactionTypeDetermination TransactionTypeDetermination 4
_AccountingClerk _AccountingClerk 1
_ChangeDocLongTableKey _ChangeDocLongTableKey 2
_ChangeDocument _ChangeDocument 2
_ChangeDocumentItemExtension _ChangeDocumentItemExtension 2
_ChartOfAccounts _ChartOfAccounts 1
_Company _Company 1
_Customer _Customer 1
_DeliveryDocument _DeliveryDocument 1
_DisplayCurrency _DisplayCurrency 1
_Division _Division 2
_FinancialAccountType _FinancialAccountType 1
_GLAccount _GLAccount 1
_ReconciliationAccount _ReconciliationAccount 1
_SpecialGLCode _SpecialGLCode 1
AccountingDocumentItemType AccountingDocumentItemType 4
AccountingDocumentType AccountingDocumentType 5
AccrSubobjectItmValdtyStrtDte AccrSubobjectItmValdtyStrtDte 1
AccrSubobjHdrEndOfLifeDate AccrSubobjHdrEndOfLifeDate 1
AccrSubobjHdrStartOfLifeDate AccrSubobjHdrStartOfLifeDate 1
AccrualItemIsObsolete AccrualItemIsObsolete 1
AccrualMethod AccrualCalculationMethod 1
acct_cur acct_cur 1
acct_no acct_no 1
act_post_date act_post_date 1
ActualStartDateFrom ActualStartDateFrom 1
AdditionalCurrency1 AdditionalCurrency1 4
AdditionalCurrency2 AdditionalCurrency2 4
AmountInCompanyCodeCurrency ItemPrice 1
AuthorizationGroup AuthorizationGroup 1
bam_id bam_id 1
bank_tx_domain_code bank_tx_domain_code 1
bank_tx_family_code bank_tx_family_code 1
bank_tx_sub_family_code bank_tx_sub_family_code 1
bankkey bankkey 1
bic bic 1
BillingDocumentItemText BillingDocumentItemText 4
BILLINGDOCUMENTREQUESTITEMTEXT BILLINGDOCUMENTREQUESTITEMTEXT 1
BusinessPartnerName BusinessPartnerName 3
CAClrfctnStatus CAClrfctnStatus 1
CashDiscountAmount CashDiscountAmount,DiscountAmount 2
CashDiscountBaseAmount CashDiscountBaseAmount 1
ChangeDocNewCurrency ChangeDocNewCurrency 2
ChangeDocNewUnit ChangeDocNewUnit 2
ChangeDocObjectClass ChangeDocObjectClass 2
ChangeDocPreviousCurrency ChangeDocPreviousCurrency 2
ChangeDocPreviousUnit ChangeDocPreviousUnit 2
ChangeDocTableKey ChangeDocTableKey 2
ChartOfAccounts ChartOfAccounts 2
chdat chdat 1
chtim chtim 1
chusr chusr 1
CompanyCodeCountry CompanyCodeCountry 4
CompanyCodeCurrency CompanyCodeCurrency 6
ContractCommodityItem Commodity 3
ContractMaterial ContractMaterial 2
ContractPlant ContractPlant 3
country country 1
CountryCurrency CountryCurrency 4
crdat crdat 1
CreationDate WorklistItemCreationDate 1
CREDITMEMOREQUESTITEMTEXT CREDITMEMOREQUESTITEMTEXT 1
crtim crtim 1
crusr crusr 1
currency currency 2
currency_code currency_code 1
CustomerCountry CustomerCountry 1
CustomerSubtotal2Amount Subtotal2Amount 1
CustomerSupplierAddress CustomerSupplierAddress 3
DatabaseTable DatabaseTable 2
DebitCreditCode DebitCreditCode 4
DebitCreditCodeIsChanged DebitCreditCodeIsChanged 3
DEBITMEMOREQUESTITEMTEXT DEBITMEMOREQUESTITEMTEXT 1
DeliveryDocument DeliveryDocument 4
DeliveryDocumentItem DeliveryDocumentItem 3
DELIVERYDOCUMENTITEMTEXT DELIVERYDOCUMENTITEMTEXT 3
DeliveryGroup DeliveryGroup 1
DeliveryPriority DeliveryPriority 1
DepartureCountry DepartureCountry 1
disp_stat disp_stat 1
DisplayCurrency DisplayCurrency 1
DistributionChannel DistributionChannel 5
Division Division 3
DocumentCurrency DocumentCurrency 4
DocumentDate BillingDocumentDate,DocumentDate 5
DocumentItemText BillingDocumentItemText,DocumentItemText 2
DocumentReferenceID DocumentReferenceID 1
due_date due_date 1
end_to_end_id end_to_end_id 2
EngagementProjectUUID EngagementProjectUUID 1
ETag ETag 2
FinancialAccountType AccountType,FinancialAccountType 5
FinancialStmntCashFlowItemMode FinancialStmntCashFlowItemMode 2
FinSGLCorrectionCompanyCode FinSGLCorrectionCompanyCode 1
FinSGLCorrectionDocument FinSGLCorrectionDocument 1
FinSGLCorrectionFiscalYear FinSGLCorrectionFiscalYear 1
FinSGLCrrtnReversalDocument FinSGLCrrtnReversalDocument 1
FinSGLCrrtnRvslCompanyCode FinSGLCrrtnRvslCompanyCode 1
FinSGLCrrtnRvslFiscalYear FinSGLCrrtnRvslFiscalYear 1
FinStmntFormStrucItemFactor FinStmntFormStrucItemFactor 1
FinStmntFormStrucItemSign FinStmntFormStrucItemSign 1
FiscalPeriod FiscalPeriod 5
FldLogsContainerID FldLogsContainerID 3
FldLogsContainerUnitUUID FldLogsContainerUnitUUID 2
FldLogsCtnActualWeight FldLogsCtnActualWeight 3
FldLogsCtnActualWeightUnit FldLogsCtnActualWeightUnit 3
FldLogsReferenceDocumentNumber FldLogsReferenceDocumentNumber 2
FldLogsShptItemActlWeightUnit FldLogsShptItemActlWeightUnit 3
FldLogsShptItemActualWeight FldLogsShptItemActualWeight 3
FldLogsShptItmHndlgUnitID FldLogsShptItmHndlgUnitID 2
FreeDefinedCurrency1 FreeDefinedCurrency1 1
FreeDefinedCurrency2 FreeDefinedCurrency2 1
FreeDefinedCurrency3 FreeDefinedCurrency3 1
FreeDefinedCurrency4 FreeDefinedCurrency4 1
FreeDefinedCurrency5 FreeDefinedCurrency5 1
FreeDefinedCurrency6 FreeDefinedCurrency6 1
FreeDefinedCurrency7 FreeDefinedCurrency7 1
FreeDefinedCurrency8 FreeDefinedCurrency8 1
FunctionalArea FunctionalArea 1
GlobalCurrency GlobalCurrency 1
gross_amount item_amount,item_gross_amount 3
GrossWeight GrossWeight 2
HandlingUnitNestedInternalID HandlingUnitNestedInternalID 1
HandlingUnitQuantity HandlingUnitQuantity 1
HandlingUnitQuantityUnit HandlingUnitQuantityUnit 1
holder holder 1
iban iban 1
IntercompanyTransaction IntercompanyTransaction 1
InternationalArticleNumber InternationalArticleNumber 1
InvoiceReference InvoiceReference 4
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 4
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 3
IsCreditBalanceRelevant IsCreditBalanceRelevant 1
IsDebitBalanceRelevant IsDebitBalanceRelevant 1
Item Item 2
ItemBillingBlockReason ItemBillingBlockReason 1
ItemIsHiddenInReporting ItemIsHiddenInReporting 2
ItemSignIsReversed ItemSignIsReversed 2
ItemType DueItemType,ItemType 2
LedgerGroup LedgerGroup 1
MaterialByCustomer MaterialByCustomer 10
MaterialGroup MaterialGroup 4
MaterialPricingGroup MaterialPricingGroup 1
MatlAccountAssignmentGroup MatlAccountAssignmentGroup 1
NetAmount NetAmount 2
NetDueIntvl1AmtInCoCodeCrcy NetDueIntvl1AmtInCoCodeCrcy 1
NetDueIntvl1AmtInDspCrcy NetDueIntvl1AmtInDspCrcy 1
NetDueIntvl2AmtInCoCodeCrcy NetDueIntvl2AmtInCoCodeCrcy 1
NetDueIntvl2AmtInDspCrcy NetDueIntvl2AmtInDspCrcy 1
NetDueIntvl3AmtInCoCodeCrcy NetDueIntvl3AmtInCoCodeCrcy 1
NetDueIntvl3AmtInDspCrcy NetDueIntvl3AmtInDspCrcy 1
OrderQuantityUnit OrderQuantityUnit 3
OrganizationDivision OrganizationDivision 4
OriginalReferenceDocument OriginalReferenceDocument 5
OutputRequestItemStatus OutputRequestItemStatus 1
PackagingMaterial PackagingMaterial 2
parent_id root_id 1
parent_key parent_key 1
ParentItem ParentItem 2
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 1
PartialPaymentAmtInDspCrcy PartialPaymentAmtInDspCrcy 2
payment_scenario payment_scenario 1
PhysicalInventoryStatusText PhysicalInventoryStatusText 1
pi_kind pi_kind 1
pl_clr_date pl_clr_date 1
pl_clr_time pl_clr_time 1
PlannedReversalDate PlannedReversalDate 1
posnr item_position 2
PostingDate PostingDate 6
PostingKey PostingKey 2
priority priority 1
Product Product 1
ProductTaxClassification1 ProductTaxClassification1 1
PurchasingDocument PurchasingDocument 1
Quantity BillingQuantity 1
QuantityInActlPostg QuantityInActlPostg 4
QuantityInBaseUnit QuantityInBaseUnit 2
QuantityUnit QuantityUnit 4
ref_clearing ClearingAgreementID 1
ref_cust_sgm ref_cust_sgm 1
ref_item_ext ref_item_ext 2
ref_item_ext_out ref_item_ext_out 2
ref_route RouteID 1
ReferenceDocumentType ReferenceDocumentType 5
REFERENCESDDOCUMENTCATEGORY REFERENCESDDOCUMENTCATEGORY 2
REFERENCESDDOCUMENTITEM REFERENCESDDOCUMENTITEM,RequirementDocumentItem 4
release_activity release_activity 1
release_status release_status 1
ReportingCountry ReportingCountry 4
ReportingCurrency ReportingCurrency 3
ReportingDate ReportingDate,TaxReportingDate 4
ReportingPeriod ReportingPeriod 1
ReportingPeriodEndDate ReportingPeriodEndDate 1
ReportingPeriodStartDate ReportingPeriodStartDate 1
ReportingYear ReportingYear 1
RequestedQuantity RequestedQuantity 1
RequestedQuantityUnit RequestedQuantityUnit 1
RequirementSegment RequirementSegment 1
ResponseProfile ResponseProfile 1
return_code return_code 1
RETURNREASON RETURNREASON 1
ReversalReason ReversalReason 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 4
rldat rldat 1
rltim rltim 1
rlusr rlusr 1
SALESCONTRACTITEMTEXT SALESCONTRACTITEMTEXT 1
SALESINQUIRYITEMTEXT SALESINQUIRYITEMTEXT 1
SalesOrderItemCategory SalesOrderItemCategory 1
SALESORDERITEMTEXT SALESORDERITEMTEXT 2
SALESORDERWTHOUTCHRGITEMTEXT SALESORDERWTHOUTCHRGITEMTEXT 1
SalesOrganization SalesOrganization 4
SalesPromotion SalesPromotion 1
SALESQUOTATIONITEMTEXT SALESQUOTATIONITEMTEXT 1
SalesSchedgAgrmtType SalesSchedgAgrmtType 4
SDDocument SDDocument 1
SeasonCompletenessStatus SeasonCompletenessIndicator 1
ServiceProfile ServiceProfile 1
ServicesRenderedDate ServicesRenderedDate 2
so_item_pos item_position 1
SourcingProjectItem SourcingProjectItem 1
SourcingProjectUUID SourcingProjectUUID 1
SrcgProjItemDescription SrcgProjItemDescription 1
StatusFlagValue StatusFlagValue 1
StockSegment StockSegment 1
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd 3
Supplier Supplier 4
SupplierAccountGroup SupplierAccountGroup 3
TaxAmount TaxAmount 2
TaxCalculationDate TaxCalculationDate 1
TaxItemGroup TaxItemGroup 2
TaxNumber1 TaxNumber1 3
TaxNumber2 TaxNumber2 3
TaxNumber3 TaxNumber3 3
TaxRate TaxRate 4
tech_stat tech_stat 1
TotalAccrAmountInFreeDfndCrcy1 TotalAccrAmountInFreeDfndCrcy1 1
TotalAccrAmountInFreeDfndCrcy2 TotalAccrAmountInFreeDfndCrcy2 1
TotalAccrAmountInFreeDfndCrcy3 TotalAccrAmountInFreeDfndCrcy3 1
TotalAccrAmountInFreeDfndCrcy4 TotalAccrAmountInFreeDfndCrcy4 1
TotalAccrAmountInFreeDfndCrcy5 TotalAccrAmountInFreeDfndCrcy5 1
TotalAccrAmountInFreeDfndCrcy6 TotalAccrAmountInFreeDfndCrcy6 1
TotalAccrAmountInFreeDfndCrcy7 TotalAccrAmountInFreeDfndCrcy7 1
TotalAccrAmountInFreeDfndCrcy8 TotalAccrAmountInFreeDfndCrcy8 1
TotalAccrAmountInGlobalCrcy TotalAccrAmountInGlobalCrcy 1
TotalAccrAmountInTransCrcy TotalAccrAmountInTransCrcy 1
TotalAccrAmtInCompanyCodeCrcy TotalAccrAmtInCompanyCodeCrcy 1
TotalAccrualQuantity AccrualEngineTotalQtyInBsUnt,TotalAccrualQuantity 1
TotalAccrualQuantityUnit UnitOfMeasure 1
tr_amount tr_amount 1
tr_curr tr_curr 1
trans_type trans_type 1
trans_typet_l trans_typet_l 1
TransactionCurrency TransactionCurrency 2
uetr uetr 1
UnitedStatesTaxCategory UnitedStatesTaxCategory 1
US_TaxFreeDefinedValue1 US_TaxFreeDefinedValue1 1
US_TaxFreeDefinedValue10 US_TaxFreeDefinedValue10 1
US_TaxFreeDefinedValue11 US_TaxFreeDefinedValue11 1
US_TaxFreeDefinedValue12 US_TaxFreeDefinedValue12 1
US_TaxFreeDefinedValue13 US_TaxFreeDefinedValue13 1
US_TaxFreeDefinedValue14 US_TaxFreeDefinedValue14 1
US_TaxFreeDefinedValue15 US_TaxFreeDefinedValue15 1
US_TaxFreeDefinedValue16 US_TaxFreeDefinedValue16 1
US_TaxFreeDefinedValue17 US_TaxFreeDefinedValue17 1
US_TaxFreeDefinedValue18 US_TaxFreeDefinedValue18 1
US_TaxFreeDefinedValue19 US_TaxFreeDefinedValue19 1
US_TaxFreeDefinedValue2 US_TaxFreeDefinedValue2 1
US_TaxFreeDefinedValue20 US_TaxFreeDefinedValue20 1
US_TaxFreeDefinedValue21 US_TaxFreeDefinedValue21 1
US_TaxFreeDefinedValue22 US_TaxFreeDefinedValue22 1
US_TaxFreeDefinedValue23 US_TaxFreeDefinedValue23 1
US_TaxFreeDefinedValue24 US_TaxFreeDefinedValue24 1
US_TaxFreeDefinedValue25 US_TaxFreeDefinedValue25 1
US_TaxFreeDefinedValue26 US_TaxFreeDefinedValue26 1
US_TaxFreeDefinedValue27 US_TaxFreeDefinedValue27 1
US_TaxFreeDefinedValue28 US_TaxFreeDefinedValue28 1
US_TaxFreeDefinedValue29 US_TaxFreeDefinedValue29 1
US_TaxFreeDefinedValue3 US_TaxFreeDefinedValue3 1
US_TaxFreeDefinedValue30 US_TaxFreeDefinedValue30 1
US_TaxFreeDefinedValue31 US_TaxFreeDefinedValue31 1
US_TaxFreeDefinedValue32 US_TaxFreeDefinedValue32 1
US_TaxFreeDefinedValue33 US_TaxFreeDefinedValue33 1
US_TaxFreeDefinedValue34 US_TaxFreeDefinedValue34 1
US_TaxFreeDefinedValue35 US_TaxFreeDefinedValue35 1
US_TaxFreeDefinedValue36 US_TaxFreeDefinedValue36 1
US_TaxFreeDefinedValue37 US_TaxFreeDefinedValue37 1
US_TaxFreeDefinedValue38 US_TaxFreeDefinedValue38 1
US_TaxFreeDefinedValue39 US_TaxFreeDefinedValue39 1
US_TaxFreeDefinedValue4 US_TaxFreeDefinedValue4 1
US_TaxFreeDefinedValue40 US_TaxFreeDefinedValue40 1
US_TaxFreeDefinedValue41 US_TaxFreeDefinedValue41 1
US_TaxFreeDefinedValue42 US_TaxFreeDefinedValue42 1
US_TaxFreeDefinedValue43 US_TaxFreeDefinedValue43 1
US_TaxFreeDefinedValue44 US_TaxFreeDefinedValue44 1
US_TaxFreeDefinedValue45 US_TaxFreeDefinedValue45 1
US_TaxFreeDefinedValue46 US_TaxFreeDefinedValue46 1
US_TaxFreeDefinedValue47 US_TaxFreeDefinedValue47 1
US_TaxFreeDefinedValue48 US_TaxFreeDefinedValue48 1
US_TaxFreeDefinedValue49 US_TaxFreeDefinedValue49 1
US_TaxFreeDefinedValue5 US_TaxFreeDefinedValue5 1
US_TaxFreeDefinedValue50 US_TaxFreeDefinedValue50 1
US_TaxFreeDefinedValue6 US_TaxFreeDefinedValue6 1
US_TaxFreeDefinedValue7 US_TaxFreeDefinedValue7 1
US_TaxFreeDefinedValue8 US_TaxFreeDefinedValue8 1
US_TaxFreeDefinedValue9 US_TaxFreeDefinedValue9 1
US_TaxPartnerReceivedTaxDate US_TaxPartnerReceivedTaxDate 1
ValuationType ValuationType 1
WeightUnit WeightUnit 2