ITEM

ITEM is an SAP database table in S/4HANA. It contains 891 fields.

Fields (891)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 43
KEY AccountingDocumentItem AccountingDocumentItem 23
KEY AccountingDocumentType AccountingDocumentType 24
KEY ACMDocumentSide ACMDocumentSide 2
KEY alloc_run_id alloc_run_id,RunId 3
KEY ApplicationDocument ApplicationDocument 2
KEY ApplicationDocumentItem ApplicationDocumentItem 2
KEY ApplicationDocumentSubItem ApplicationDocumentSubItem 2
KEY BG_SAFTAnalysisType BG_SAFTAnalysisType 1
KEY BillingDocument BillingDocument 4
KEY BillingDocumentItem BillingDocumentItem 2
KEY BillingDocumentRequest BillingDocumentRequest 1
KEY BillingDocumentRequestItem BillingDocumentRequestItem 1
KEY BOPForm BOPForm 1
KEY BOPRptgCntry BOPRptgCntry 1
KEY BR_NotaFiscal BR_NotaFiscal 1
KEY BusinessPartner BusinessPartner 8
KEY CABPItemNumber CABPItemNumber 3
KEY CADocumentNumber CADocumentNumber 14
KEY CAItemType CAItemType 6
KEY CARepetitionItemNumber CARepetitionItemNumber 2
KEY CASrcDocumentCat CASrcDocumentCat,RO_CASourceDocumentCategory 9
KEY CASrcDocumentNumber CASrcDocumentNumber,RO_CASourceDocumentNumber 11
KEY CASrcDocumentType CASrcDocumentType,RO_CASourceDocumentType 11
KEY CASubItemNumber CASubItemNumber 3
KEY ChangeDocItemChangeType ChangeDocItemChangeType 1
KEY ChangeDocObject ChangeDocObject 1
KEY ChangeDocObjectClass ChangeDocObjectClass 1
KEY ChangeDocTableKey ChangeDocTableKey 1
KEY ClearedDocumentNumber ClearedDocumentNumber 2
KEY CnsldtnGroupJrnlEntry ConsolidationDocumentNumber 1
KEY CnsldtnGroupJrnlEntryItem ConsolidationPostingItem 1
KEY collection_id collection_id 1
KEY collection_version collection_version 1
KEY CompanyCode CompanyCode 71
KEY ConditionType ConditionType 2
KEY ConsolidationDimension ConsolidationDimension 1
KEY ConsolidationLedger ConsolidationLedger 1
KEY CountryCode CountryCode 3
KEY Customer Customer 16
KEY DatabaseTable DatabaseTable 1
KEY dest_node_id dest_node_id,DestinationNode 2
KEY FinalPriceDate FinalPriceDate 2
KEY FiscalYear FiscalYear 49
KEY FXvaluationDate FXvaluationDate 2
KEY FXvaluationDateDocToStstc FXvaluationDateDocToStstc 2
KEY HCMTimeReqItemListSqncNumber HCMTimeReqItemListSqncNumber 1
KEY id id,ItemIdentifier 3
KEY IndustrySector IndustrySector 5
KEY IsEndOfPurposeBlocked IsEndOfPurposeBlocked 1
KEY Item Item 3
KEY item_list_no HCMTimeReqItemListSqncNumber 1
KEY item_type item_type 1
KEY ItemNumber ItemNumber 6
KEY JP_CentralBkPaymentReportStyle JP_CentralBkPaymentReportStyle 7
KEY LDCKey LDCKey 1
KEY Ledger Ledger 34
KEY LedgerGLLineItem LedgerGLLineItem 25
KEY LineIndexOfPInvItem LineIndexOfPInvItem 1
KEY ManufacturingOrder ManufacturingOrder 1
KEY ManufacturingOrderItem ManufacturingOrderItem 1
KEY note note 4
KEY OrderID InternalOrder,OrderID 9
KEY origin_node_id OriginNode,WellCompletion 2
KEY PaymentReason PaymentReason 2
KEY PhysicalInventoryChangeVersion PhysicalInventoryChangeVersion 1
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 1
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 1
KEY PInvDocumentItemType PInvDocumentItemType 1
KEY PostingDate PostingDate 39
KEY PricingDocumentItem PricingDocumentItem 2
KEY ProcmtHubExtReferencedMaterial Material 2
KEY PurchaseContractItemText MaterialName 2
KEY PurchaseContractType PurchaseContractType 1
KEY PurchasingDocument PurchasingDocument 4
KEY PurchasingDocumentItem PurchasingDocumentItem 4
KEY PurchasingGroup PurchasingGroup 2
KEY PurchasingOrganization PurchasingOrganization 4
KEY QuotationGroupItem QuotationGroupItem 2
KEY ReferenceFiscalYear ReferenceFiscalYear 1
KEY RO_SAFTAnalysisType RO_SAFTAnalysisType 2
KEY RO_SAFTStandardAccount RO_SAFTStandardAccount 18
KEY RU_ImportNotificationItem RU_ImportNotificationItem 1
KEY RU_ImprtNotifInternalNumber RU_ImprtNotifInternalNumber 2
KEY Scenario Scenario 2
KEY ServiceDocument ServiceDocument 5
KEY ServiceDocumentItem ServiceDocumentItem 5
KEY ServiceObjectType ServiceObjectType 4
KEY SourceLedger SourceLedger 28
KEY StatryRptCategory StatryRptCategory 17
KEY StatryRptgEntity StatryRptgEntity 17
KEY StatryRptRunID StatryRptRunID 17
KEY SubConditionType SubConditionType 2
KEY SubItemNumber CASubItemNumber,SubItemNumber 3
KEY Supplier Supplier 16
KEY TaxCode TaxCode 19
KEY TaxDeclnAmountType TaxDeclnAmountType 1
KEY TaxItemGroup TaxItemGroup 2
KEY TransactionCurrency CASrcTransactionCurrency,TransactionCurrency 37
KEY TransactionTypeDetermination TransactionTypeDetermination 15
KEY valuationDate valuationDate 2
KEY ValueChainBusinessObject ValueChainBusinessObject 2
KEY ValueChainBusinessObjectItem ValueChainBusinessObjectItem 2
KEY ValueChainDocumentItemOrigin ValueChainDocumentItemOrigin 1
KEY ValueChainInstanceUUID ValueChainInstanceUUID 2
KEY ValueChainPrdcssrBusObjItem ValueChainPrdcssrBusObjItem 2
KEY ValueChainPrdcssrDocItmOrigin ValueChainPrdcssrDocItmOrigin 1
KEY ValueChainPredecessorBusObj ValueChainPredecessorBusObj 2
KEY ValueChainStepInstanceUUID ValueChainStepInstanceUUID 2
KEY ValueChainStepPredecessorUUID ValueChainStepPredecessorUUID 1
KEY Version Version 7
_AccountingDocumentTypeText _AccountingDocumentTypeText 2
_BudgetPeriod _BudgetPeriod 1
_ChangeDocChangeIndT _ChangeDocChangeIndT 1
_CompanyCode _CompanyCode 4
_CompanyCodeCurrency _CompanyCodeCurrency 1
_CostCenter _CostCenter 1
_CostCenterText _CostCenterText 1
_CostCenterTxt _CostCenterTxt 4
_CurrentCostCenter _CurrentCostCenter 3
_CurrentProfitCenter _CurrentProfitCenter 3
_Customer _Customer 3
_FinancialManagementArea _FinancialManagementArea 1
_FiscalYear _FiscalYear 3
_FunctionalArea _FunctionalArea 1
_Fund _Fund 3
_FundType _FundType 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 3
_GlobalCurrency _GlobalCurrency 1
_Grant _Grant 3
_InventoryUsabilityCode _InventoryUsabilityCode 1
_JournalEntry _JournalEntry 4
_Ledger _Ledger 2
_Material _Material 2
_OneTimeAccountBP _OneTimeAccountBP 2
_Order _Order 6
_PlannedOrder _PlannedOrder 2
_ProfitCenter _ProfitCenter 1
_ProfitCenterText _ProfitCenterText 1
_ProfitCenterTxt _ProfitCenterTxt 4
_PubSecBdgtAcctRevnExpnCode _PubSecBdgtAcctRevnExpnCode 1
_PubSecBdgtCnsmpnType _PubSecBdgtCnsmpnType 1
_PubSecBudgetAccount _PubSecBudgetAccount 1
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
_ReportingCurrency _ReportingCurrency 2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2 3
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2 3
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 3
_Segment _Segment 1
_SegmentText _SegmentText 5
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2 3
_SourceReferenceDocumentType _SourceReferenceDocumentType 1
_Supplier _Supplier 3
_SupplierText _SupplierText 1
_TransactionCurrency _TransactionCurrency 1
_WBSElementBasicData _WBSElementBasicData 2
_WBSElementBasicDataText _WBSElementBasicDataText 5
_WBSElementExternalID _WBSElementExternalID 1
AccountAssignmentNumber AccountAssignmentNumber 5
AccountingDocCreatedByUser AccountingDocCreatedByUser 7
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentCreationDate AccountingDocumentCreationDate 4
AccountingDocumentHeaderText AccountingDocumentHeaderText 2
AccountingDocumentItemType AccountingDocumentItemType 1
AccountingDocumentTypeName AccountingDocumentTypeName 2
ACMPrcgCmmdtyOrdSubAccountID ACMPrcgCmmdtyOrdSubAccountID 1
ACMPrcgIntendedPrcType ACMPrcgIntendedPrcType 1
ACMPricingItemQuantity ACMPricingItemQuantity 1
ACMScaleTicketNumber ACMScaleTicketNumber 1
ActiveChartOfAccounts ActiveChartOfAccounts 8
ActiveGLAccount ActiveGLAccount 8
ActualDeliveryDate MfgOrderItemActualDeliveryDate 1
ActualPriceDate ActualPriceDate 2
AdditionalMaterialGroup1 AdditionalMaterialGroup1 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 1
AdditionalMaterialGroup3 AdditionalMaterialGroup3 1
AdditionalMaterialGroup4 AdditionalMaterialGroup4 1
AdditionalMaterialGroup5 AdditionalMaterialGroup5 1
AlternativeGLAccount AlternativeGLAccount 12
AlternativeReferenceDocument AlternativeReferenceDocument 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 25
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 2
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 2
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 2
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 2
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 2
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 2
AmountInGlobalCurrency AmountInGlobalCurrency 2
AmountInGroupCurrency AmountInGroupCurrency 1
AmountInLocalCurrency AmountInLocalCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 24
AssignmentReference AssignmentReference 3
BaseUnit BaseUnit,BaseUnitSAPCode 20
BasisID BasisID 2
BasisMarketRefAdjustmentSpread BasisMarketRefAdjustmentSpread 2
BasisMarketRefKeyDate BasisMarketRefKeyDate 2
BasisMarketRefRate BasisMarketRefRate 2
BasisMarketRefRateCurrency BasisMarketRefRateCurrency 2
Batch Batch 6
BatchUUID BatchUUID 1
BG_SAFTAnalysisEntry BG_SAFTAnalysisEntry 1
BG_SAFTAnalysisEntryDesc BG_SAFTAnalysisEntryDesc 1
BG_SAFTGoodsService BG_SAFTGoodsService 2
BG_SAFTPaymentMethod BG_SAFTPaymentMethod 1
BillgDocReqBillgSts BillgDocReqBillgSts 1
BillgDocRequestItemInPartSgmt BillgDocRequestItemInPartSgmt 1
BillingBlockReason BillingBlockReason 3
BillingDocumentRequestItemText BillingDocumentRequestItemText 1
BillingDocumentRequestType BillingDocumentRequestType 1
BillingDocumentType BillingDocumentType 2
BillingPeriodOfPerfEndDate BillingPeriodOfPerfEndDate 1
BillingPeriodOfPerfStartDate BillingPeriodOfPerfStartDate 1
BillingQuantity BillingQuantity 1
BillingQuantityInBaseUnit BillingQuantityInBaseUnit 1
BillingQuantityUnit BillingQuantityUnitSAPCode 1
BillingToBaseQuantityDnmntr BillingToBaseQuantityDnmntr 1
BillingToBaseQuantityNmrtr BillingToBaseQuantityNmrtr 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVersion BillOfMaterialVersion 1
BillToParty BillToParty 1
BookQtyOfPInvItemInBookQtyUoM BookQtyOfPInvItemInBookQtyUoM 1
BookQuantityUnitOfMeasure BookQuantityUnitOfMeasure 1
BPTaxNumber BPTaxNumber 1
BranchAccount BranchAccount 2
BsegDebitCreditCode BsegDebitCreditCode 1
BsMktRefDrvtvContrMaturityCode BsMktRefDrvtvContrMaturityCode 2
BudgetPeriod BudgetPeriod 3
BusinessArea BusinessArea 6
BusinessPartnerName BusinessPartnerName 1
BusinessPlace BusinessPlace 1
BusinessSolutionOrder BusinessSolutionOrder 1
BusinessSolutionOrderItem BusinessSolutionOrderItem 1
CAAmountInLocalCurrency CAAmountInLocalCurrency 1
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 1
CABPItemText CABPItemText 1
CAClearingDate CAClearingDate 1
CAClearingDocumentNumber CAClearingDocumentNumber 2
CADocumentOriginCode CADocumentOriginCode 4
CADocumentType CADocumentType 4
CADocumentTypeForGLTransfer CADocumentTypeForGLTransfer 2
CAInvcgCategory CAInvcgCategory 3
CAInvcgCorrectionCategory CAInvcgCorrectionCategory 3
CAInvcgProcess CAInvcgProcess 3
CAInvcgReversalDocument CAInvcgReversalDocument 1
CAInvcgType CAInvcgType 3
CAMainTransaction CAMainTransaction 2
CANetDueDate CANetDueDate 1
CAPostingDate CAPostingDate 1
CARecnclnKeyIsTransferredToGL CARecnclnKeyIsTransferredToGL 6
CAReconciliationAccount CAReconciliationAccount 1
CAReconciliationKey CAReconciliationKey 3
CAReferenceDocument CAReferenceDocument 5
CarryFwdBalAmtInCCCrcy CarryFwdBalAmtInCCCrcy 3
CashDiscount1Days CashDiscount1Days 2
CashDiscount1DueDate CashDiscount1DueDate 1
CashDiscount1Percent CashDiscount1Percent 2
CashDiscount2Days CashDiscount2Days 2
CashDiscount2Percent CashDiscount2Percent 2
CashDiscountAmount CashDiscountAmount 2
CashDiscountBaseAmount CashDiscountBaseAmount 2
CashDiscountIsDeductible CashDiscountIsDeductible 1
CashFlowAccountFrom CashFlowAccountFrom 1
CashFlowAccountIsExcluded CashFlowAccountIsExcluded 1
CashFlowAccountTo CashFlowAccountTo 1
CashFlowItemUUID CashFlowItemUUID 1
CashFlowParameterFromValue CashFlowParameterFromValue 1
CashFlowParameterName CashFlowParameterName 1
CashFlowParameterToValue CashFlowParameterToValue 1
CashFlowParentItemUUID CashFlowParentItemUUID 1
CashLedgerAccount CashLedgerAccount 1
CASrcActiveGLAccount CASrcActiveGLAccount 5
CASrcBusinessPartner CASrcBusinessPartner 5
CASrcDebitCreditCode CASrcDebitCreditCode 1
CASrcOfficialDocumentNumber CASrcOfficialDocumentNumber,RO_SAFTSourceDocument 5
CASrcSaftStandardAccount CASrcSaftStandardAccount 1
CASubTransaction CASubTransaction 2
CASubTransactionName CASubTransactionName 1
category category 1
CATransactionKeyAccountDetn CATransactionKeyAccountDetn 2
ChangedDateTime ChangedDateTime 1
ChangeDocNewCurrency ChangeDocNewCurrency 1
ChangeDocNewStrFieldValue ChangeDocNewStrFieldValue 1
ChangeDocNewUnit ChangeDocNewUnit 1
ChangeDocObjectUUID ChangeDocObjectUUID 1
ChangeDocPreviousCurrency ChangeDocPreviousCurrency 1
ChangeDocPreviousStrFieldValue ChangeDocPreviousStrFieldValue 1
ChangeDocPreviousUnit ChangeDocPreviousUnit 1
ChangeDocTableKeyUUID ChangeDocTableKeyUUID 1
ChartOfAccounts ChartOfAccounts 18
CITReportingLine CITReportingLine 1
CITReportingLineDescription CITReportingLineDescription 1
CITReportVersion CITReportVersion 1
ClearingAccountingDocument ClearingAccountingDocument 2
ClearingDate ClearingDate 1
ClearingJournalEntry ClearingJournalEntry 2
CmmdtyDealDetEffectiveFromDate CmmdtyDealDetEffectiveFromDate 1
CmmdtyDealDetEffectiveToDate CmmdtyDealDetEffectiveToDate 1
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming 2
CndnTermExchRateFixationDate CndnTermExchRateFixationDate 2
CndnTermExchRateFixationTime CndnTermExchRateFixationTime 2
CndnTermRateFixationDate CndnTermRateFixationDate 2
CndnTermRateFixationTime CndnTermRateFixationTime 2
CnsldtnAdhocItem CnsldtnAdhocItem 1
CnsldtnAdhocSet CnsldtnAdhocSet 1
CnsldtnCashLedgerChartOfAccts CnsldtnCashLedgerChartOfAccts 1
CnsldtnCstmSignAmtInGrpCrcy CnsldtnCstmSignAmtInGrpCrcy 1
CnsldtnCstmSignAmtInLoclCrcy CnsldtnCstmSignAmtInLoclCrcy 1
CnsldtnCstmSignAmtInTransCrcy CnsldtnCstmSignAmtInTransCrcy 1
CnsldtnCstmSignLongQtyInBsUnit CnsldtnCstmSignLongQtyInBsUnit 1
CnsldtnFinancialStatementItem FinancialStatementItem 1
CnsldtnQuantityInBaseUnit CnsldtnQuantityInBaseUnit 1
CommodityContractMaturityCode CommodityContractMaturityCode 2
CommodityQuantityInTermUnit CommodityQuantityInTermUnit 2
CommodityUnit CommodityUnit 2
Company Company 1
CompanyCodeCurrency CompanyCodeCurrency 39
ConditionApplication ConditionApplication 2
ConditionTermExchRateIsFixed ConditionTermExchRateIsFixed 2
ConditionTermExtensionUsage ConditionTermExtensionUsage 2
ConditionTermName ConditionTermName 2
ConditionTermRateCurrency ConditionTermRateCurrency 2
ConditionTermRateDnmntr ConditionTermRateDnmntr 2
ConditionTermRateFixation ConditionTermRateFixation 2
ConditionTermRateIsFixed ConditionTermRateIsFixed 2
ConditionTermRateIsRounded ConditionTermRateIsRounded 2
ConditionTermRateNmrtr ConditionTermRateNmrtr 2
ConditionTermRateQuantity ConditionTermRateQuantity 2
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit,ItemQuantityUnit 2
ConditionTermStatus ConditionTermStatus 2
ConditionTermValue ConditionTermValue 2
ConditionTermValueCurrency ConditionTermValueCurrency 2
ConfirmedReworkAmountInCCCrcy ConfirmedReworkAmountInCCCrcy 1
ConfirmedReworkAmountInDspCrcy ConfirmedReworkAmountInDspCrcy 1
ConfirmedScrapAmountInCCCrcy ConfirmedScrapAmountInCCCrcy 1
ConfirmedScrapAmountInDspCrcy ConfirmedScrapAmountInDspCrcy 1
ConfirmedYieldAmountInCCCrcy ConfirmedYieldAmountInCCCrcy 1
ConfirmedYieldAmountInDspCrcy ConfirmedYieldAmountInDspCrcy 1
ConsolidateODNDocumentClass ODNDocumentClass 1
ConsolidationAcquisitionPeriod ConsolidationAcquisitionPeriod 1
ConsolidationAcquisitionYear ConsolidationAcquisitionYear 1
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
ConsolidationDocumentType ConsolidationDocumentType 1
ConsolidationGroup ConsolidationGroup 1
ConsolidationPostgItemAutoFlag ConsolidationPostgItemAutoFlag 1
ConsolidationPostingItem ConsolidationPostingItem1 1
ConsolidationUnit ConsolidationUnit 1
ContactPerson ContactPerson 3
ContractMaterial ContractMaterial 1
ContractPlant ContractPlant 1
ControllingArea ControllingArea 13
ControllingObject ControllingObject 1
ControllingObjectType ControllingObjectType 1
ConversionFactor ConversionFactor 4
CostAmount CostAmount 1
CostCenter CostCenter 11
CostEstimate CostEstimate 1
CountryChartOfAccounts CountryChartOfAccounts 10
CountryOfOrigin CountryOfOrigin 1
CreatedByUser CreatedByUser 9
CreatedByUserName CreatedByUserName 1
CreationDate CreationDate 9
CreationDateTime CreationDateTime 2
CreationTime CreationTime 2
CreditAmountCurrency CreditAmountCurrency 3
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 14
CreditAmountInTransCrcy CreditAmountInTransCrcy 6
CreditCarryFwdBalAmtInCCCrcy CreditCarryFwdBalAmtInCCCrcy 3
Creditor Creditor 3
CreditPrevPeriodYTDAmtInCCCrcy CreditPrevPeriodYTDAmtInCCCrcy 3
CreditRelatedPrice CreditRelatedPrice 1
CshFlowItmSignIsRvsdInOutput CshFlowItmSignIsRvsdInOutput 1
CumulativeBalAmtInCoCodeCrcy CumulativeBalAmtInCoCodeCrcy 3
Currency CompanyCodeCurrency,Currency 3
currency_code currency_code 3
CurrencyConversionsDiffType CurrencyConversionsDiffType 1
CustomerCountry CustomerCountry 1
CustomerGroup CustomerGroup 1
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 1
CustomerSupplierCountry CustomerSupplierCountry 1
CustomerSupplierIndustry CustomerSupplierIndustry 1
CustomerTaxID5 CustomerTaxID5,TaxID5 2
DataSelectionType DataSelectionType 2
DebitAmountCurrency DebitAmountCurrency 3
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 14
DebitAmountInTransCrcy DebitAmountInTransCrcy 6
DebitCarryFwdBalAmtInCCCrcy DebitCarryFwdBalAmtInCCCrcy 3
DebitCreditCode DebitCreditCode 22
DebitPrevPeriodYTDAmtInCCCrcy DebitPrevPeriodYTDAmtInCCCrcy 3
DeductionType DeductionType 1
DeliveryDate DeliveryDate 2
DeliveryDocument DeliveryDocument 1
DeliveryDocumentItem DeliveryDocumentItem 1
DepartureCountry DepartureCountry 1
DisplayCurrency DisplayCurrency 1
DistributionChannel DistributionChannel 6
Division Division 6
DocumentCategory DocumentCategory 1
DocumentCurrency DocumentCurrency 2
DocumentDate DocumentDate 23
DocumentId DocumentId 2
DocumentItemText DocumentItemText 17
DrillDownState DrillDownState 1
DueCalculationBaseDate DueCalculationBaseDate 3
EarmarkedFundsDocument EarmarkedFundsDocument 2
eff_to_dt eff_to_dt 1
EffectivityParameterVariant EffectivityParameterVariant 1
EmployeeWageGroup EmployeeWageGroup 1
EmployeeWageType EmployeeWageType 1
EndDate EndDate 1
EndDateHour EndDateHour 1
EndDateMonth EndDateMonth 1
EndDateWeek EndDateWeek 1
EndDateWeekDay EndDateWeekDay 1
EndDateYear EndDateYear 1
EndDateYearMonth EndDateYearMonth 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 3
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey 2
EndOfDaySnapshotDate EndOfDaySnapshotDate 2
EndOfDayTimestampFrom EndOfDayTimestampFrom 2
EndOfDayTimestampTo EndOfDayTimestampTo 2
EntitledToDisposeParty EntitledToDisposeParty 1
EWMStockOwner EWMStockOwner 1
EWMStockType EWMStockType 1
EWMStockUsage EWMStockUsage 1
EWMWarehouse EWMWarehouse 1
ExchangeRate ExchangeRate 2
ExchRateMaturityDate ExchRateMaturityDate 2
ExpectedPaymentDate ExpectedPaymentDate 2
FashionCancelDate FashionCancelDate 1
field_name CnsldtnCharcGlobalFieldName 1
FinancialAccountType FinancialAccountType 9
FinancialDataSource FinancialDataSource 1
FinancialManagementArea FinancialManagementArea 4
FinancialServicesBranch FinancialServicesBranch 1
FinancialServicesProductGroup FinancialServicesProductGroup 1
FinancialStatementItem FinancialStatementItem 1
FINANCIALSTATEMENTVARIANT FINANCIALSTATEMENTVARIANT 1
FinancialStmntCashFlowItemMode FinancialStmntCashFlowItemMode 1
FinancialTransactionType FinancialTransactionType 1
FiscalPeriod FiscalPeriod,PostingFiscalPeriod,RU_UnifiedTxNoticePeriodNumber 4
FiscalYear_2 FiscalYear_2 1
FixedCashDiscount FixedCashDiscount 2
FixedExchRateDate FixedExchRateDate 2
FormatCode AccountingDocumentClass 1
FreeDefinedCurrency1 FreeDefinedCurrency1 2
FreeDefinedCurrency2 FreeDefinedCurrency2 2
FreeDefinedCurrency3 FreeDefinedCurrency3 2
FreeDefinedCurrency4 FreeDefinedCurrency4 2
FreeDefinedCurrency5 FreeDefinedCurrency5 2
FreeDefinedCurrency6 FreeDefinedCurrency6 2
FreeDefinedCurrency7 FreeDefinedCurrency7 2
FreeDefinedCurrency8 FreeDefinedCurrency8 1
FreeDefinedIndicator1 FreeDefinedIndicator1 1
FreeDefinedIndicator2 FreeDefinedIndicator2 1
FunctionalArea FunctionalArea 4
Fund Fund 4
FundType FundType 3
GHGCategory GHGCategory 1
GHGDataQualityCharacteristic GHGDataQualityCharacteristic 1
GHGEnergyClassification GHGEnergyClassification 1
GHGEnergyMix GHGEnergyMix 1
GHGEnergySourcingType GHGEnergySourcingType 1
GHGScope GHGScope 1
GHGScope2CalculationMethod GHGScope2CalculationMethod 1
GHGScope2ContractualInstrument GHGScope2ContractualInstrument 1
GLAccount GLAccount 19
GLAccountType GLAccountType 7
GLAccountTypeFlowType GLAccountTypeFlowType 2
GlobalCurrency GlobalCurrency 5
GLRecordType GLRecordType 1
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmount 1
GoodsRecipientName GoodsRecipientName 2
GrantID GrantID 4
gross_price gross_price 1
GrossAmount GrossAmount 1
GroupCurrency GroupCurrency 1
HandlingUnitNumber HandlingUnitNumber 1
HCMOvertimeCompensationType HCMOvertimeCompensationType 1
HCMPersonnelNumber HCMPersonnelNumber 1
HCMTimeQuotaTotalQuantityValue HCMTimeQuotaTotalQuantityValue 1
HCMTimeQuotaType HCMTimeQuotaType 1
HCMTimeRecordEndTime HCMTimeRecordEndTime 1
HCMTimeRecordStartTime HCMTimeRecordStartTime 1
HCMTimeRequestItemOperation HCMTimeRequestItemOperation 1
HierarchyLevel HierarchyLevel 1
HigherLevelItem HigherLevelItem 1
HigherParentHandlingUnitNumber HigherParentHandlingUnitNumber 1
HigherParentStorageBin HigherParentStorageBin 1
IncotermsClassification IncotermsClassification 2
IncotermsTransferLocation IncotermsTransferLocation 2
Industry Industry 3
InputFiscalYear InputFiscalYear 1
IntcoValueChainDocItmStatus IntcoValueChainDocItmStatus 1
InternationalArticleNumber InternationalArticleNumber 1
InventoryPrice InventoryPrice 1
InventorySpecialStockType InventorySpecialStockType,SupAssgmtCategory 1
InventoryUsabilityCode InventoryUsabilityCode 2
InventoryValuationType InventoryValuationType 1
InvesteeConsolidationUnit InvesteeConsolidationUnit 1
InvestmentActivity InvestmentActivity 1
InvestmentActivityType InvestmentActivityType 1
InvoiceReference InvoiceReference 3
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 3
invt_dt invt_dt 1
IsCompletelyDelivered IsCompletelyDelivered 2
IsIntercompanyTransfer IsIntercompanyTransfer 2
IsNegativePosting IsNegativePosting 5
IsReversal IsMarkedForDeletion 1
IsReversalDocument IsReversalDocument 1
IssueDate IssueDate 1
IsUsedInPaymentTransaction IsUsedInPaymentTransaction 1
item_number item_number 1
ItemCurrency ItemCurrency 1
ItemGrossWeight ItemGrossWeight 1
ItemIsHiddenInReporting ItemIsHiddenInReporting 1
ItemIsRelevantForCredit ItemIsRelevantForCredit 1
ItemNetWeight ItemNetWeight 1
ItemQuantityUnit ItemQuantityUnit 1
ItemSignIsReversed ItemSignIsReversed 1
ItemType ItemType 1
ItemVolume ItemVolume 1
ItemVolumeUnit ItemVolumeUnitSAPCode 1
ItemWeightUnit ItemWeightUnitSAPCode 1
JrnlEntryCntrySpecificRef3 JrnlEntryCntrySpecificRef3 1
kwmeng kwmeng 1
LastChangedByUserName LastChangedByUserName 1
LoadDataCaptureApplInstruction LoadDataCaptureApplInstruction 1
LoadDataCaptureObjectID LoadDataCaptureObjectID 1
LoadDataObjectUUID LoadDataObjectUUID 1
LocalCurrency Currency,LocalCurrency 2
LogicalDocumentClass LogicalDocumentClass 1
LogicalSystem LogicalSystem 5
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
ManufacturingOrderUnit ManufacturingOrderUnit 1
MarketIdentifierCode MarketIdentifierCode 2
Material Material 7
MaterialDocument MaterialDocument 1
MaterialGoodsReceiptDuration MaterialGoodsReceiptDuration 2
MaterialGroup MaterialGroup 4
MaterialPriceUnitQty MaterialPriceUnitQty 1
MatlAccountAssignmentGroup MatlAccountAssignmentGroup 1
MaturityKeyDate MaturityKeyDate 2
MaximumVersion MaximumVersion 2
MfgOrderConfirmedEndDate MfgOrderConfirmedEndDate 1
MfgOrderConfirmedEndTime MfgOrderConfirmedEndTime 1
MfgOrderConfirmedReworkInPct MfgOrderConfirmedReworkInPct 1
MfgOrderConfirmedReworkQty MfgOrderConfirmedReworkQty 1
MfgOrderConfirmedScrapInPct MfgOrderConfirmedScrapInPct 1
MfgOrderConfirmedScrapQty MfgOrderConfirmedScrapQty 1
MfgOrderConfirmedTotalQty MfgOrderConfirmedTotalQty 1
MfgOrderConfirmedYieldInPct MfgOrderConfirmedYieldInPct 1
MfgOrderConfirmedYieldQty MfgOrderConfirmedYieldQty 1
MfgOrderItemActualDeliveryDate MfgOrderItemActualDeliveryDate 1
MfgOrderItemActualDeviationQty MfgOrderItemActualDeviationQty 1
MfgOrderItemGoodsReceiptQty ActualDeliveredQuantity,MfgOrderItemGoodsReceiptQty 3
MfgOrderItemPlannedScrapPct MfgOrderItemPlannedScrapPct 1
MfgOrderItemPlannedScrapQty MfgOrderItemPlannedScrapQty 1
MfgOrderItemPlannedTotalQty MfgOrderItemPlannedTotalQty 1
MfgOrderItemPlannedYieldQty MfgOrderItemPlannedYieldQty 1
MRPArea MRPArea 2
MRPController MRPController 1
MRPPlant MRPPlant,PlanningPlant 2
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit 1
MTMAdjustmentType MTMAdjustmentType 2
MTMCalcGrpMarketPriceCondition MTMCalcGrpMarketPriceCondition 2
MTMCalculationGroup MTMCalculationGroup 2
MTMConditionGroup MTMConditionGroup 2
MTMConditionGroupCategory MTMConditionGroupCategory 2
MTMDataSourceType MTMDataSourceType 2
net_price net_price 1
NetAmount NetAmount 1
NetDueDate NetDueDate 2
NetPaymentDays NetPaymentDays 2
Numbering SequenceNumber 1
Numpg NmbrOfPages 1
OldConditionTermrate OldConditionTermrate 2
OldConditionTermValue OldConditionTermValue 2
OrderCategory OrderCategory 2
OrderDescription OrderDescription 2
OrderItem OrderItem 1
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 1
OrderQuantityUnit PurchaseOrderItemQuantityUnit 1
OrderType OrderType 2
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 1
OrganizationDivision OrganizationDivision 2
OriginalTaxBaseAmount OriginalTaxBaseAmount 1
OriginReferenceDocBusObjType OriginReferenceDocBusObjType 2
OriginReferenceDocument OriginReferenceDocument 2
OriginReferenceDocumentItem OriginReferenceDocumentItem 2
OriglTaxBaseAmountInCoCodeCrcy OriglTaxBaseAmountInCoCodeCrcy 1
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 1
parent_id SalesOrderIdentifer 1
ParentHandlingUnitNumber ParentHandlingUnitNumber 1
ParentItem ParentItem 1
ParentStorageBin ParentStorageBin 1
PartnerBusinessArea PartnerBusinessArea 1
PartnerCompany PartnerCompany 1
PartnerConsolidationUnit PartnerConsolidationUnit 1
PartnerCostCenter PartnerCostCenter 1
PartnerFunctionalArea PartnerFunctionalArea 1
PartnerProfitCenter PartnerProfitCenter 1
PartnerSegment PartnerSegment 1
PaymentBlockingReason PaymentBlockingReason 2
PaymentDifferenceReason PaymentDifferenceReason 2
PaymentMethod PaymentMethod 1
PaymentTerms PaymentTerms 3
PeriodAmountInCompanyCodeCrcy PeriodAmountInCompanyCodeCrcy 2
PeriodAmountInFreeDfndCrcy1 PeriodAmountInFreeDfndCrcy1 2
PeriodAmountInFreeDfndCrcy2 PeriodAmountInFreeDfndCrcy2 2
PeriodAmountInFreeDfndCrcy3 PeriodAmountInFreeDfndCrcy3 2
PeriodAmountInFreeDfndCrcy4 PeriodAmountInFreeDfndCrcy4 2
PeriodAmountInFreeDfndCrcy5 PeriodAmountInFreeDfndCrcy5 2
PeriodAmountInFreeDfndCrcy6 PeriodAmountInFreeDfndCrcy6 2
PeriodAmountInFreeDfndCrcy7 PeriodAmountInFreeDfndCrcy7 2
PeriodAmountInFreeDfndCrcy8 PeriodAmountInFreeDfndCrcy8 2
PeriodAmountInGlobalCurrency PeriodAmountInGlobalCurrency 2
Personnel Personnel 1
PhysicalCommodity PhysicalCommodity 2
PhysicalInventoryDocumentType PhysicalInventoryDocumentType 2
PhysicalInventoryStatusText PhysicalInventoryStatusText 1
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays 1
PlannedOrder PlannedOrder 2
PlannedScrapAmountInCCCrcy PlannedScrapAmountInCCCrcy 1
PlannedScrapAmountInDspCrcy PlannedScrapAmountInDspCrcy 1
PlannedServiceEndDateTime PlannedServiceEndDateTime 3
PlannedServiceStartDateTime PlannedServiceStartDateTime 3
PlanningPlant PlanningPlant 1
Plant Plant 10
PostingKey PostingKey 2
PostingLevel PostingLevel 1
PreviousSubConditionType PreviousSubConditionType 2
PreviousVersion PreviousVersion 2
PreviousVersionQuantitySign PreviousVersionQuantitySign 2
PrevPeriodYTDAmtInCCCrcy PrevPeriodYTDAmtInCCCrcy 3
PrevVersCndnTermRateCurrency PrevVersCndnTermRateCurrency 2
PrevVersionCommodityQuantity PrevVersionCommodityQuantity 2
PrevVersionConditionTermValue PrevVersionConditionTermValue 2
PriceDetnExchangeRateDate PriceDetnExchangeRateDate 1
PricingDate PricingDate 1
PricingReferenceMaterial PricingReferenceMaterial 1
PricingScaleQuantityInBaseUnit PricingScaleQuantityInBaseUnit 1
PricingStatus PricingStatus 2
prod_id_content_char prod_id_content_char 1
ProducedMaterial ProducedMaterial 1
Product Product 14
ProductCollection ProductCollection 4
ProductDescription ProductDescription 8
ProductGroup ProductGroup 1
ProductHierarchyNode ProductHierarchyNode 1
ProductionPlant ProductionPlant 1
ProductionSupervisor ProductionSupervisor 1
ProductionUnit MfgOrderItemProductionUnit 1
ProductionVersion ProductionVersion 2
ProductSeason ProductSeason 4
ProductSeasonYear ProductSeasonYear 4
ProductTaxClassification1 ProductTaxClassification1 1
ProductTaxClassification2 ProductTaxClassification2 1
ProductTaxClassification3 ProductTaxClassification3 1
ProductTaxClassification4 ProductTaxClassification4 1
ProductTaxClassification5 ProductTaxClassification5 1
ProductTaxClassification6 ProductTaxClassification6 1
ProductTaxClassification7 ProductTaxClassification7 1
ProductTaxClassification8 ProductTaxClassification8 1
ProductTaxClassification9 ProductTaxClassification9 1
ProductTheme ProductTheme 4
ProductUUID ProductUUID 1
ProfitCenter ProfitCenter 21
Project Project 1
ProviderContract ProviderContract 1
ProviderContractItem ProviderContractItem 1
PubSecBdgtAcctRevnExpnCode PubSecBdgtAcctRevnExpnCode 3
PubSecBudgetAccount PubSecBudgetAccount 3
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode 1
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 3
PubSecOpenCmtmtAgingDate PubSecOpenCmtmtAgingDate 3
PubSecOpnCmtmtAmtInCoCodeCrcy PubSecOpnCmtmtAmtInCoCodeCrcy 3
PubSecOpnCmtmtAmtInGlobCrcy PubSecOpnCmtmtAmtInGlobCrcy 3
PubSecOpnCmtmtAmtInGlobCrcy1 PubSecOpnCmtmtAmtInGlobCrcy1 2
PubSecOpnCmtmtAmtInGlobCrcy2 PubSecOpnCmtmtAmtInGlobCrcy2 2
PubSecOpnCmtmtAmtInGlobCrcy3 PubSecOpnCmtmtAmtInGlobCrcy3 2
PubSecOpnCmtmtAmtInGlobCrcy4 PubSecOpnCmtmtAmtInGlobCrcy4 2
PubSecOpnCmtmtAmtInGlobCrcy5 PubSecOpnCmtmtAmtInGlobCrcy5 2
PubSecOpnCmtmtAmtInTransCrcy PubSecOpnCmtmtAmtInTransCrcy 3
PubSecOpnCmtmtDays PubSecOpnCmtmtDays 1
PubSecOpnCmtmtTme1 PubSecOpnCmtmtTme1 1
PubSecOpnCmtmtTme2 PubSecOpnCmtmtTme2 1
PubSecOpnCmtmtTme3 PubSecOpnCmtmtTme3 1
PubSecOpnCmtmtTme4 PubSecOpnCmtmtTme4 1
PubSecOpnCmtmtTme5 PubSecOpnCmtmtTme5 1
PubSecOpnCmtmtTmeIntvl PubSecOpnCmtmtTmeIntvl 2
PurchaseOrder PurchaseOrder 2
PurchaseRequisition PurchaseRequisition 2
PurchasingInfoRecord PurchasingInfoRecord 1
Quantity Quantity 9
QuantityDistributionKey QuantityDistributionKey 1
QuantityInBaseUnit QuantityInBaseUnit 3
QuotationCPEUoM QuotationCPEUoM 2
QuotationCurrency QuotationCurrency 2
QuotationGroupCalculationRule QuotationGroupCalculationRule 2
QuotationPeriodEndDate QuotationPeriodEndDate 2
QuotationPeriodReferenceDate QuotationPeriodReferenceDate 2
QuotationPeriodStartDate QuotationPeriodStartDate 2
QuotationPrice QuotationPrice 2
QuotationPriceType QuotationPriceType 2
RefBusinessSolutionOrder RefBusinessSolutionOrder 3
RefBusinessSolutionOrderItem RefBusinessSolutionOrderItem 3
RefConsolidationDocumentType RefConsolidationDocumentType 1
Reference1IDByBusinessPartner JrnlEntryCntrySpecificRef1 1
ReferenceDocBusObjType ReferenceDocBusObjType 2
ReferenceDocSDDocCategory ReferenceDocSDDocCategory 1
ReferenceDocument ReferenceDocument 7
ReferenceDocumentContext ReferenceDocumentContext 2
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear 2
ReferenceDocumentItem ReferenceDocumentItem 6
ReferenceDocumentItemGroup ReferenceDocumentItemGroup 1
ReferenceDocumentType ReferenceDocumentType 3
ReferenceLogicalSystem ReferenceLogicalSystem 1
ReferenceNumber DocumentReferenceID 1
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory 1
ReferenceQuantity ReferenceQuantity 1
ReferenceQuantityUnit ReferenceQuantityUnit 1
RefInHouseRepairIsExisting RefInHouseRepairIsExisting 3
Remark MultipleInvoiceType 1
RemarkAtCustom GoodsAreCleared 1
RepetitiveMfgConfirmationItem RepetitiveMfgConfirmationItem 1
ReportingCurrency ReportingCurrency 2
ReportingDate ReportingDate 1
ReportingPeriod ReportingPeriod 1
RequestedServiceEndDateTime RequestedServiceEndDateTime 3
RequestedServiceStartDateTime RequestedServiceStartDateTime 3
ResponseProfile ResponseProfile 3
ResponsibleEmployee ResponsibleEmployee 3
ReturnApplicationDocType ReturnApplicationDocType 1
ReturnItemProcessingType ReturnItemProcessingType 1
ReverseDocument ReverseDocument 1
ReverseDocumentFiscalYear ReverseDocumentFiscalYear 1
RO_SAFTAnalysisEntry RO_SAFTAnalysisEntry 2
RO_SAFTAnalysisEntryDesc RO_SAFTAnalysisEntryDesc 2
RO_SAFTCustomerTaxType RO_SAFTCustomerTaxType 1
RO_SAFTExchangeRate RO_SAFTExchangeRate 8
RO_SAFTGoodsService RO_SAFTGoodsService 6
RO_SAFTIsDefaultZeroQuantity RO_SAFTIsDefaultZeroQuantity 3
RO_SAFTJournalTransaction RO_SAFTJournalTransaction 3
RO_SAFTJournalTransactionType RO_SAFTJournalTransactionType 2
RO_SAFTJournalTransDescription RO_SAFTJournalTransDescription 7
RO_SAFTPaymentMethod RO_SAFTPaymentMethod 1
RO_SAFTSourceDocument RO_SAFTSourceDocument 7
RO_SAFTSourceDocumentType RO_SAFTSourceDocumentType 1
RO_SAFTSupplierTaxType RO_SAFTSupplierTaxType 1
RoundingDecimalPlaces RoundingDecimalPlaces 2
RU_BudgetClassificationCode RU_BudgetClassificationCode 1
RU_ImportNotificationItemRef RU_ImportNotificationItemRef 1
RU_ImportNotificationReference RU_ImportNotificationReference 1
RU_SupplierKPP RU_SupplierKPP 1
RU_TerritoryClassfctnOKTMO RU_TerritoryClassfctnOKTMO 1
RU_UnifiedTaxNoticePeriodCode RU_UnifiedTaxNoticePeriodCode 1
SalesDistrict SalesDistrict 1
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
SalesDocumentItemCategory SalesDocumentItemCategory 1
SalesDocumentItemType SalesDocumentItemType 1
SalesGroup SalesGroup 4
SalesGroupOrgUnitID SalesGroupOrgUnitID 3
SalesOffice SalesOffice 4
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 3
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SalesOrganization SalesOrganization 7
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 3
SalesSDDocumentCategory SalesSDDocumentCategory 1
Segment Segment 16
SequenceOfPInvDocumentItems SequenceOfPInvDocumentItems 1
ServiceDocItemBillingStatus ServiceDocItemBillingStatus 3
ServiceDocItemGrossAmount SrvcOrdGrossAmount 3
ServiceDocItemRejectionReason ServiceDocItemRejectionReason 3
ServiceDocumentItemHasError ServiceDocumentItemHasError 3
ServiceDocumentItemStatus ServiceDocumentItemStatus 3
ServiceDocumentType ServiceDocumentType 1
ServiceEmployee ServiceEmployee 3
ServiceFirstResponseByDateTime ServiceFirstResponseByDateTime 3
ServiceOrganization ServiceOrganization 3
ServiceProfile ServiceProfile 3
ServiceTeam ServiceTeam 3
ShelfLifeExpirationDate ShelfLifeExpirationDate 1
ShipToParty ShipToParty 1
Side Side 1
SnapshotDate0 SnapshotDate0 2
SnapshotDate1 SnapshotDate1 2
SoldProduct SoldProduct 1
SoldProductGroup SoldProductGroup 1
SoldToParty SoldToParty 5
SoldToPartyCountry SoldToPartyCountry 3
SoldToPartyRegion SoldToPartyRegion 3
SourceDocument SourceDocument 2
SourceDocumentBusObjType SourceDocumentBusObjType 2
SourceLogicalSystem SourceLogicalSystem 3
SourceReferenceDocSubitem SourceReferenceDocSubitem 3
SourceReferenceDocument SourceReferenceDocument 3
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt 3
SourceReferenceDocumentItem SourceReferenceDocumentItem 3
SourceReferenceDocumentType SourceReferenceDocumentType 3
SourceTransacEventEndDateTime SourceTransacEventEndDateTime 2
SourceTransactionEventDateTime SourceTransactionEventDateTime 2
SourceUnitOfMeasureFactor SourceUnitOfMeasureFactor 8
SourcingProject SourcingProject 1
SourcingProjectVersion SourcingProjectVersion 1
SpecialGLCode SpecialGLCode 4
SpecialTaxRate IndustrialTaxRateCategory 1
SpecValAssgmtItemChangeNumber ProdSpecCompItemChangeNumber 1
SponsoredClass SponsoredClass 3
SponsoredProgram SponsoredProgram 3
SrvcDocItemSLADueByDateTime SrvcDocItemSLADueByDateTime 3
SrvcDocItemTransferStatus SrvcDocItemTransferStatus 3
SrvcDocItmIsReleasedForBilling SrvcDocItmIsReleasedForBilling 3
StartDate StartDate 1
StatisticalValueControl StatisticalValueControl 1
StatisticsCurrency StatisticsCurrency 2
StatusCode StatusCode 1
StockDocumentCategory StockDocumentCategory 1
StockDocumentNumber StockDocumentNumber 1
StockItemNumber StockItemNumber 1
StockOwner StockOwner 1
StockSegment StockSegment 6
StockType StockType 1
StockUsage StockUsage 1
StorageLocation StorageLocation 7
SubItem SubItem 1
SubItemCategory SubItemCategory 1
Subtotal1Amount Subtotal1Amount 1
Subtotal2Amount Subtotal2Amount 1
Subtotal3Amount Subtotal3Amount 1
Subtotal4Amount Subtotal4Amount 1
Subtotal5Amount Subtotal5Amount 1
Subtotal6Amount Subtotal6Amount 1
SupplierCountry SupplierCountry 1
SupplierRecipientType SupplierRecipientType 1
SupplierTaxID5 TaxID5 1
SustainabilityModeOfTransport SustainabilityModeOfTransport 1
TaxAmount TaxAmount 1
TaxBaseAmount TaxBaseAmount 2
TaxCategory TaxCategory 1
TaxCountry TaxCountry 5
TaxItem TaxItem 6
TaxJurisdiction TaxJurisdiction 1
TaxNumber1 TaxNumber1 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxReportingDate TaxReportingDate 14
TaxType TaxType 1
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 1
TimeToMaturity TimeToMaturity 2
TransactionAmountInLocalCrcy TransactionAmountInLocalCrcy 1
TransactionCode TransactionCode 1
TransactionCurrencyDecimals TransactionCurrencyDecimals 4
TrdgContractItemUnitOfMeasure TrdgContractItemUnitOfMeasure 1
TW_EDocGvmntUniformInvcNumber TW_EDocGvmntUniformInvcNumber 1
type_code type_code 1
umzin umzin 1
umziz umziz 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 1
unit TheoUnit,unit 2
UnitOfMeasure UnitOfMeasure 1
UnitPriceAmountInReportingCrcy UnitPriceAmountInReportingCrcy 4
UnloadingPointName UnloadingPointName 2
ValChainProcessBlockTypeDesc ValChainProcessBlockTypeDesc 1
ValidityEndDate ValidityEndDate 2
ValidityEndDateTime ValidityEndDateTime 2
ValidityStartDate ValidityStartDate 2
ValidityStartDateTime ValidityStartDateTime 2
ValuationArea ValuationArea 1
ValuationPoint ValuationPoint 1
ValueChainBusinessObjectCat ValueChainBusinessObjectCat 1
ValueChainItemUUID ValueChainItemUUID 2
ValueChainPredecessorStpBusObj ValueChainPredecessorStpBusObj 1
ValueChainStepBusinessObject ValueChainStepBusinessObject 1
ValueChainType ValueChainType 1
ValueDate ValueDate 8
VATRegistration VATRegistration 3
vbtyp vbtyp 1
volume TheoVal 1
Warehouse Warehouse 1
WBSElement WBSElement 4
WBSElementExternalID WBSElementExternalID 2
WBSElementInternalID WBSElementInternalID 8
WBSElementInternalID_2 WBSElementInternalID 1
wcdvlh_no wcdvlh_no 1
WhseTaskGoodsReceiptDateTime WhseTaskGoodsReceiptDateTime 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 ITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ACMDOCUMENTSIDE,
    ALLOC_RUN_ID,
    APPLICATIONDOCUMENT,
    APPLICATIONDOCUMENTITEM,
    APPLICATIONDOCUMENTSUBITEM,
    BG_SAFTANALYSISTYPE,
    BILLINGDOCUMENT,
    BILLINGDOCUMENTITEM,
    BILLINGDOCUMENTREQUEST,
    BILLINGDOCUMENTREQUESTITEM,
    BOPFORM,
    BOPRPTGCNTRY,
    BR_NOTAFISCAL,
    BUSINESSPARTNER,
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAITEMTYPE,
    CAREPETITIONITEMNUMBER,
    CASRCDOCUMENTCAT,
    CASRCDOCUMENTNUMBER,
    CASRCDOCUMENTTYPE,
    CASUBITEMNUMBER,
    CHANGEDOCITEMCHANGETYPE,
    CHANGEDOCOBJECT,
    CHANGEDOCOBJECTCLASS,
    CHANGEDOCTABLEKEY,
    CLEAREDDOCUMENTNUMBER,
    CNSLDTNGROUPJRNLENTRY,
    CNSLDTNGROUPJRNLENTRYITEM,
    COLLECTION_ID,
    COLLECTION_VERSION,
    COMPANYCODE,
    CONDITIONTYPE,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONLEDGER,
    COUNTRYCODE,
    CUSTOMER,
    DATABASETABLE,
    DEST_NODE_ID,
    FINALPRICEDATE,
    FISCALYEAR,
    FXVALUATIONDATE,
    FXVALUATIONDATEDOCTOSTSTC,
    HCMTIMEREQITEMLISTSQNCNUMBER,
    ID,
    INDUSTRYSECTOR,
    ISENDOFPURPOSEBLOCKED,
    ITEM,
    ITEM_LIST_NO,
    ITEM_TYPE,
    ITEMNUMBER,
    JP_CENTRALBKPAYMENTREPORTSTYLE,
    LDCKEY,
    LEDGER,
    LEDGERGLLINEITEM,
    LINEINDEXOFPINVITEM,
    MANUFACTURINGORDER,
    MANUFACTURINGORDERITEM,
    NOTE,
    ORDERID,
    ORIGIN_NODE_ID,
    PAYMENTREASON,
    PHYSICALINVENTORYCHANGEVERSION,
    PHYSICALINVENTORYDOCUMENTUUID,
    PHYSICALINVENTORYITEMNUMBER,
    PINVDOCUMENTITEMTYPE,
    POSTINGDATE,
    PRICINGDOCUMENTITEM,
    PROCMTHUBEXTREFERENCEDMATERIAL,
    PURCHASECONTRACTITEMTEXT,
    PURCHASECONTRACTTYPE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUOTATIONGROUPITEM,
    REFERENCEFISCALYEAR,
    RO_SAFTANALYSISTYPE,
    RO_SAFTSTANDARDACCOUNT,
    RU_IMPORTNOTIFICATIONITEM,
    RU_IMPRTNOTIFINTERNALNUMBER,
    SCENARIO,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEOBJECTTYPE,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    SUBCONDITIONTYPE,
    SUBITEMNUMBER,
    SUPPLIER,
    TAXCODE,
    TAXDECLNAMOUNTTYPE,
    TAXITEMGROUP,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONDATE,
    VALUECHAINBUSINESSOBJECT,
    VALUECHAINBUSINESSOBJECTITEM,
    VALUECHAINDOCUMENTITEMORIGIN,
    VALUECHAININSTANCEUUID,
    VALUECHAINPRDCSSRBUSOBJITEM,
    VALUECHAINPRDCSSRDOCITMORIGIN,
    VALUECHAINPREDECESSORBUSOBJ,
    VALUECHAINSTEPINSTANCEUUID,
    VALUECHAINSTEPPREDECESSORUUID,
    VERSION,
    _ACCOUNTINGDOCUMENTTYPETEXT,
    _BUDGETPERIOD,
    _CHANGEDOCCHANGEINDT,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _COSTCENTER,
    _COSTCENTERTEXT,
    _COSTCENTERTXT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _FINANCIALMANAGEMENTAREA,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _FUND,
    _FUNDTYPE,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _INVENTORYUSABILITYCODE,
    _JOURNALENTRY,
    _LEDGER,
    _MATERIAL,
    _ONETIMEACCOUNTBP,
    _ORDER,
    _PLANNEDORDER,
    _PROFITCENTER,
    _PROFITCENTERTEXT,
    _PROFITCENTERTXT,
    _PUBSECBDGTACCTREVNEXPNCODE,
    _PUBSECBDGTCNSMPNTYPE,
    _PUBSECBUDGETACCOUNT,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _REPORTINGCURRENCY,
    _SALESGROUPORGUNIT_2,
    _SALESOFFICEORGUNIT_2,
    _SALESORGANIZATIONORGUNIT_2,
    _SEGMENT,
    _SEGMENTTEXT,
    _SERVICEORGANIZATIONORGUNIT_2,
    _SOURCEREFERENCEDOCUMENTTYPE,
    _SUPPLIER,
    _SUPPLIERTEXT,
    _TRANSACTIONCURRENCY,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTBASICDATATEXT,
    _WBSELEMENTEXTERNALID,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTITEMTYPE,
    ACCOUNTINGDOCUMENTTYPENAME,
    ACMPRCGCMMDTYORDSUBACCOUNTID,
    ACMPRCGINTENDEDPRCTYPE,
    ACMPRICINGITEMQUANTITY,
    ACMSCALETICKETNUMBER,
    ACTIVECHARTOFACCOUNTS,
    ACTIVEGLACCOUNT,
    ACTUALDELIVERYDATE,
    ACTUALPRICEDATE,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    ALTERNATIVEGLACCOUNT,
    ALTERNATIVEREFERENCEDOCUMENT,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINGROUPCURRENCY,
    AMOUNTINLOCALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BASISID,
    BASISMARKETREFADJUSTMENTSPREAD,
    BASISMARKETREFKEYDATE,
    BASISMARKETREFRATE,
    BASISMARKETREFRATECURRENCY,
    BATCH,
    BATCHUUID,
    BG_SAFTANALYSISENTRY,
    BG_SAFTANALYSISENTRYDESC,
    BG_SAFTGOODSSERVICE,
    BG_SAFTPAYMENTMETHOD,
    BILLGDOCREQBILLGSTS,
    BILLGDOCREQUESTITEMINPARTSGMT,
    BILLINGBLOCKREASON,
    BILLINGDOCUMENTREQUESTITEMTEXT,
    BILLINGDOCUMENTREQUESTTYPE,
    BILLINGDOCUMENTTYPE,
    BILLINGPERIODOFPERFENDDATE,
    BILLINGPERIODOFPERFSTARTDATE,
    BILLINGQUANTITY,
    BILLINGQUANTITYINBASEUNIT,
    BILLINGQUANTITYUNIT,
    BILLINGTOBASEQUANTITYDNMNTR,
    BILLINGTOBASEQUANTITYNMRTR,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVERSION,
    BILLTOPARTY,
    BOOKQTYOFPINVITEMINBOOKQTYUOM,
    BOOKQUANTITYUNITOFMEASURE,
    BPTAXNUMBER,
    BRANCHACCOUNT,
    BSEGDEBITCREDITCODE,
    BSMKTREFDRVTVCONTRMATURITYCODE,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPARTNERNAME,
    BUSINESSPLACE,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CABPITEMTEXT,
    CACLEARINGDATE,
    CACLEARINGDOCUMENTNUMBER,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CADOCUMENTTYPEFORGLTRANSFER,
    CAINVCGCATEGORY,
    CAINVCGCORRECTIONCATEGORY,
    CAINVCGPROCESS,
    CAINVCGREVERSALDOCUMENT,
    CAINVCGTYPE,
    CAMAINTRANSACTION,
    CANETDUEDATE,
    CAPOSTINGDATE,
    CARECNCLNKEYISTRANSFERREDTOGL,
    CARECONCILIATIONACCOUNT,
    CARECONCILIATIONKEY,
    CAREFERENCEDOCUMENT,
    CARRYFWDBALAMTINCCCRCY,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1DUEDATE,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    CASHDISCOUNTAMOUNT,
    CASHDISCOUNTBASEAMOUNT,
    CASHDISCOUNTISDEDUCTIBLE,
    CASHFLOWACCOUNTFROM,
    CASHFLOWACCOUNTISEXCLUDED,
    CASHFLOWACCOUNTTO,
    CASHFLOWITEMUUID,
    CASHFLOWPARAMETERFROMVALUE,
    CASHFLOWPARAMETERNAME,
    CASHFLOWPARAMETERTOVALUE,
    CASHFLOWPARENTITEMUUID,
    CASHLEDGERACCOUNT,
    CASRCACTIVEGLACCOUNT,
    CASRCBUSINESSPARTNER,
    CASRCDEBITCREDITCODE,
    CASRCOFFICIALDOCUMENTNUMBER,
    CASRCSAFTSTANDARDACCOUNT,
    CASUBTRANSACTION,
    CASUBTRANSACTIONNAME,
    CATEGORY,
    CATRANSACTIONKEYACCOUNTDETN,
    CHANGEDDATETIME,
    CHANGEDOCNEWCURRENCY,
    CHANGEDOCNEWSTRFIELDVALUE,
    CHANGEDOCNEWUNIT,
    CHANGEDOCOBJECTUUID,
    CHANGEDOCPREVIOUSCURRENCY,
    CHANGEDOCPREVIOUSSTRFIELDVALUE,
    CHANGEDOCPREVIOUSUNIT,
    CHANGEDOCTABLEKEYUUID,
    CHARTOFACCOUNTS,
    CITREPORTINGLINE,
    CITREPORTINGLINEDESCRIPTION,
    CITREPORTVERSION,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CMMDTYDEALDETEFFECTIVEFROMDATE,
    CMMDTYDEALDETEFFECTIVETODATE,
    CMMDTYFORWARDINDEXTIMING,
    CNDNTERMEXCHRATEFIXATIONDATE,
    CNDNTERMEXCHRATEFIXATIONTIME,
    CNDNTERMRATEFIXATIONDATE,
    CNDNTERMRATEFIXATIONTIME,
    CNSLDTNADHOCITEM,
    CNSLDTNADHOCSET,
    CNSLDTNCASHLEDGERCHARTOFACCTS,
    CNSLDTNCSTMSIGNAMTINGRPCRCY,
    CNSLDTNCSTMSIGNAMTINLOCLCRCY,
    CNSLDTNCSTMSIGNAMTINTRANSCRCY,
    CNSLDTNCSTMSIGNLONGQTYINBSUNIT,
    CNSLDTNFINANCIALSTATEMENTITEM,
    CNSLDTNQUANTITYINBASEUNIT,
    COMMODITYCONTRACTMATURITYCODE,
    COMMODITYQUANTITYINTERMUNIT,
    COMMODITYUNIT,
    COMPANY,
    COMPANYCODECURRENCY,
    CONDITIONAPPLICATION,
    CONDITIONTERMEXCHRATEISFIXED,
    CONDITIONTERMEXTENSIONUSAGE,
    CONDITIONTERMNAME,
    CONDITIONTERMRATECURRENCY,
    CONDITIONTERMRATEDNMNTR,
    CONDITIONTERMRATEFIXATION,
    CONDITIONTERMRATEISFIXED,
    CONDITIONTERMRATEISROUNDED,
    CONDITIONTERMRATENMRTR,
    CONDITIONTERMRATEQUANTITY,
    CONDITIONTERMRATEQUANTITYUNIT,
    CONDITIONTERMSTATUS,
    CONDITIONTERMVALUE,
    CONDITIONTERMVALUECURRENCY,
    CONFIRMEDREWORKAMOUNTINCCCRCY,
    CONFIRMEDREWORKAMOUNTINDSPCRCY,
    CONFIRMEDSCRAPAMOUNTINCCCRCY,
    CONFIRMEDSCRAPAMOUNTINDSPCRCY,
    CONFIRMEDYIELDAMOUNTINCCCRCY,
    CONFIRMEDYIELDAMOUNTINDSPCRCY,
    CONSOLIDATEODNDOCUMENTCLASS,
    CONSOLIDATIONACQUISITIONPERIOD,
    CONSOLIDATIONACQUISITIONYEAR,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDOCUMENTTYPE,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONPOSTGITEMAUTOFLAG,
    CONSOLIDATIONPOSTINGITEM,
    CONSOLIDATIONUNIT,
    CONTACTPERSON,
    CONTRACTMATERIAL,
    CONTRACTPLANT,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTTYPE,
    CONVERSIONFACTOR,
    COSTAMOUNT,
    COSTCENTER,
    COSTESTIMATE,
    COUNTRYCHARTOFACCOUNTS,
    COUNTRYOFORIGIN,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CREDITAMOUNTCURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINTRANSCRCY,
    CREDITCARRYFWDBALAMTINCCCRCY,
    CREDITOR,
    CREDITPREVPERIODYTDAMTINCCCRCY,
    CREDITRELATEDPRICE,
    CSHFLOWITMSIGNISRVSDINOUTPUT,
    CUMULATIVEBALAMTINCOCODECRCY,
    CURRENCY,
    CURRENCY_CODE,
    CURRENCYCONVERSIONSDIFFTYPE,
    CUSTOMERCOUNTRY,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    CUSTOMERTAXID5,
    DATASELECTIONTYPE,
    DEBITAMOUNTCURRENCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCARRYFWDBALAMTINCCCRCY,
    DEBITCREDITCODE,
    DEBITPREVPERIODYTDAMTINCCCRCY,
    DEDUCTIONTYPE,
    DELIVERYDATE,
    DELIVERYDOCUMENT,
    DELIVERYDOCUMENTITEM,
    DEPARTURECOUNTRY,
    DISPLAYCURRENCY,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTCATEGORY,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    DOCUMENTID,
    DOCUMENTITEMTEXT,
    DRILLDOWNSTATE,
    DUECALCULATIONBASEDATE,
    EARMARKEDFUNDSDOCUMENT,
    EFF_TO_DT,
    EFFECTIVITYPARAMETERVARIANT,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGETYPE,
    ENDDATE,
    ENDDATEHOUR,
    ENDDATEMONTH,
    ENDDATEWEEK,
    ENDDATEWEEKDAY,
    ENDDATEYEAR,
    ENDDATEYEARMONTH,
    ENDINGBALANCEAMTINCOCODECRCY,
    ENDOFDAYBUSINESSENTITYKEY,
    ENDOFDAYSNAPSHOTDATE,
    ENDOFDAYTIMESTAMPFROM,
    ENDOFDAYTIMESTAMPTO,
    ENTITLEDTODISPOSEPARTY,
    EWMSTOCKOWNER,
    EWMSTOCKTYPE,
    EWMSTOCKUSAGE,
    EWMWAREHOUSE,
    EXCHANGERATE,
    EXCHRATEMATURITYDATE,
    EXPECTEDPAYMENTDATE,
    FASHIONCANCELDATE,
    FIELD_NAME,
    FINANCIALACCOUNTTYPE,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALSTATEMENTITEM,
    FINANCIALSTATEMENTVARIANT,
    FINANCIALSTMNTCASHFLOWITEMMODE,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEAR_2,
    FIXEDCASHDISCOUNT,
    FIXEDEXCHRATEDATE,
    FORMATCODE,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FREEDEFINEDINDICATOR1,
    FREEDEFINEDINDICATOR2,
    FUNCTIONALAREA,
    FUND,
    FUNDTYPE,
    GHGCATEGORY,
    GHGDATAQUALITYCHARACTERISTIC,
    GHGENERGYCLASSIFICATION,
    GHGENERGYMIX,
    GHGENERGYSOURCINGTYPE,
    GHGSCOPE,
    GHGSCOPE2CALCULATIONMETHOD,
    GHGSCOPE2CONTRACTUALINSTRUMENT,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLACCOUNTTYPEFLOWTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    GOODSRECEIPTAMOUNTINCOCODECRCY,
    GOODSRECIPIENTNAME,
    GRANTID,
    GROSS_PRICE,
    GROSSAMOUNT,
    GROUPCURRENCY,
    HANDLINGUNITNUMBER,
    HCMOVERTIMECOMPENSATIONTYPE,
    HCMPERSONNELNUMBER,
    HCMTIMEQUOTATOTALQUANTITYVALUE,
    HCMTIMEQUOTATYPE,
    HCMTIMERECORDENDTIME,
    HCMTIMERECORDSTARTTIME,
    HCMTIMEREQUESTITEMOPERATION,
    HIERARCHYLEVEL,
    HIGHERLEVELITEM,
    HIGHERPARENTHANDLINGUNITNUMBER,
    HIGHERPARENTSTORAGEBIN,
    INCOTERMSCLASSIFICATION,
    INCOTERMSTRANSFERLOCATION,
    INDUSTRY,
    INPUTFISCALYEAR,
    INTCOVALUECHAINDOCITMSTATUS,
    INTERNATIONALARTICLENUMBER,
    INVENTORYPRICE,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYUSABILITYCODE,
    INVENTORYVALUATIONTYPE,
    INVESTEECONSOLIDATIONUNIT,
    INVESTMENTACTIVITY,
    INVESTMENTACTIVITYTYPE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    INVT_DT,
    ISCOMPLETELYDELIVERED,
    ISINTERCOMPANYTRANSFER,
    ISNEGATIVEPOSTING,
    ISREVERSAL,
    ISREVERSALDOCUMENT,
    ISSUEDATE,
    ISUSEDINPAYMENTTRANSACTION,
    ITEM_NUMBER,
    ITEMCURRENCY,
    ITEMGROSSWEIGHT,
    ITEMISHIDDENINREPORTING,
    ITEMISRELEVANTFORCREDIT,
    ITEMNETWEIGHT,
    ITEMQUANTITYUNIT,
    ITEMSIGNISREVERSED,
    ITEMTYPE,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    JRNLENTRYCNTRYSPECIFICREF3,
    KWMENG,
    LASTCHANGEDBYUSERNAME,
    LOADDATACAPTUREAPPLINSTRUCTION,
    LOADDATACAPTUREOBJECTID,
    LOADDATAOBJECTUUID,
    LOCALCURRENCY,
    LOGICALDOCUMENTCLASS,
    LOGICALSYSTEM,
    MANUFACTURINGORDERCATEGORY,
    MANUFACTURINGORDERTYPE,
    MANUFACTURINGORDERUNIT,
    MARKETIDENTIFIERCODE,
    MATERIAL,
    MATERIALDOCUMENT,
    MATERIALGOODSRECEIPTDURATION,
    MATERIALGROUP,
    MATERIALPRICEUNITQTY,
    MATLACCOUNTASSIGNMENTGROUP,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    MFGORDERCONFIRMEDENDDATE,
    MFGORDERCONFIRMEDENDTIME,
    MFGORDERCONFIRMEDREWORKINPCT,
    MFGORDERCONFIRMEDREWORKQTY,
    MFGORDERCONFIRMEDSCRAPINPCT,
    MFGORDERCONFIRMEDSCRAPQTY,
    MFGORDERCONFIRMEDTOTALQTY,
    MFGORDERCONFIRMEDYIELDINPCT,
    MFGORDERCONFIRMEDYIELDQTY,
    MFGORDERITEMACTUALDELIVERYDATE,
    MFGORDERITEMACTUALDEVIATIONQTY,
    MFGORDERITEMGOODSRECEIPTQTY,
    MFGORDERITEMPLANNEDSCRAPPCT,
    MFGORDERITEMPLANNEDSCRAPQTY,
    MFGORDERITEMPLANNEDTOTALQTY,
    MFGORDERITEMPLANNEDYIELDQTY,
    MRPAREA,
    MRPCONTROLLER,
    MRPPLANT,
    MRPREQUIREDQUANTITYINBASEUNIT,
    MTMADJUSTMENTTYPE,
    MTMCALCGRPMARKETPRICECONDITION,
    MTMCALCULATIONGROUP,
    MTMCONDITIONGROUP,
    MTMCONDITIONGROUPCATEGORY,
    MTMDATASOURCETYPE,
    NET_PRICE,
    NETAMOUNT,
    NETDUEDATE,
    NETPAYMENTDAYS,
    NUMBERING,
    NUMPG,
    OLDCONDITIONTERMRATE,
    OLDCONDITIONTERMVALUE,
    ORDERCATEGORY,
    ORDERDESCRIPTION,
    ORDERITEM,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDERTYPE,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    ORGANIZATIONDIVISION,
    ORIGINALTAXBASEAMOUNT,
    ORIGINREFERENCEDOCBUSOBJTYPE,
    ORIGINREFERENCEDOCUMENT,
    ORIGINREFERENCEDOCUMENTITEM,
    ORIGLTAXBASEAMOUNTINCOCODECRCY,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    PARENT_ID,
    PARENTHANDLINGUNITNUMBER,
    PARENTITEM,
    PARENTSTORAGEBIN,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREA,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PAYMENTBLOCKINGREASON,
    PAYMENTDIFFERENCEREASON,
    PAYMENTMETHOD,
    PAYMENTTERMS,
    PERIODAMOUNTINCOMPANYCODECRCY,
    PERIODAMOUNTINFREEDFNDCRCY1,
    PERIODAMOUNTINFREEDFNDCRCY2,
    PERIODAMOUNTINFREEDFNDCRCY3,
    PERIODAMOUNTINFREEDFNDCRCY4,
    PERIODAMOUNTINFREEDFNDCRCY5,
    PERIODAMOUNTINFREEDFNDCRCY6,
    PERIODAMOUNTINFREEDFNDCRCY7,
    PERIODAMOUNTINFREEDFNDCRCY8,
    PERIODAMOUNTINGLOBALCURRENCY,
    PERSONNEL,
    PHYSICALCOMMODITY,
    PHYSICALINVENTORYDOCUMENTTYPE,
    PHYSICALINVENTORYSTATUSTEXT,
    PLANNEDDELIVERYDURATIONINDAYS,
    PLANNEDORDER,
    PLANNEDSCRAPAMOUNTINCCCRCY,
    PLANNEDSCRAPAMOUNTINDSPCRCY,
    PLANNEDSERVICEENDDATETIME,
    PLANNEDSERVICESTARTDATETIME,
    PLANNINGPLANT,
    PLANT,
    POSTINGKEY,
    POSTINGLEVEL,
    PREVIOUSSUBCONDITIONTYPE,
    PREVIOUSVERSION,
    PREVIOUSVERSIONQUANTITYSIGN,
    PREVPERIODYTDAMTINCCCRCY,
    PREVVERSCNDNTERMRATECURRENCY,
    PREVVERSIONCOMMODITYQUANTITY,
    PREVVERSIONCONDITIONTERMVALUE,
    PRICEDETNEXCHANGERATEDATE,
    PRICINGDATE,
    PRICINGREFERENCEMATERIAL,
    PRICINGSCALEQUANTITYINBASEUNIT,
    PRICINGSTATUS,
    PROD_ID_CONTENT_CHAR,
    PRODUCEDMATERIAL,
    PRODUCT,
    PRODUCTCOLLECTION,
    PRODUCTDESCRIPTION,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PRODUCTIONPLANT,
    PRODUCTIONSUPERVISOR,
    PRODUCTIONUNIT,
    PRODUCTIONVERSION,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTAXCLASSIFICATION1,
    PRODUCTTAXCLASSIFICATION2,
    PRODUCTTAXCLASSIFICATION3,
    PRODUCTTAXCLASSIFICATION4,
    PRODUCTTAXCLASSIFICATION5,
    PRODUCTTAXCLASSIFICATION6,
    PRODUCTTAXCLASSIFICATION7,
    PRODUCTTAXCLASSIFICATION8,
    PRODUCTTAXCLASSIFICATION9,
    PRODUCTTHEME,
    PRODUCTUUID,
    PROFITCENTER,
    PROJECT,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PUBSECBDGTACCTREVNEXPNCODE,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECOPENCMTMTAGINGDATE,
    PUBSECOPNCMTMTAMTINCOCODECRCY,
    PUBSECOPNCMTMTAMTINGLOBCRCY,
    PUBSECOPNCMTMTAMTINGLOBCRCY1,
    PUBSECOPNCMTMTAMTINGLOBCRCY2,
    PUBSECOPNCMTMTAMTINGLOBCRCY3,
    PUBSECOPNCMTMTAMTINGLOBCRCY4,
    PUBSECOPNCMTMTAMTINGLOBCRCY5,
    PUBSECOPNCMTMTAMTINTRANSCRCY,
    PUBSECOPNCMTMTDAYS,
    PUBSECOPNCMTMTTME1,
    PUBSECOPNCMTMTTME2,
    PUBSECOPNCMTMTTME3,
    PUBSECOPNCMTMTTME4,
    PUBSECOPNCMTMTTME5,
    PUBSECOPNCMTMTTMEINTVL,
    PURCHASEORDER,
    PURCHASEREQUISITION,
    PURCHASINGINFORECORD,
    QUANTITY,
    QUANTITYDISTRIBUTIONKEY,
    QUANTITYINBASEUNIT,
    QUOTATIONCPEUOM,
    QUOTATIONCURRENCY,
    QUOTATIONGROUPCALCULATIONRULE,
    QUOTATIONPERIODENDDATE,
    QUOTATIONPERIODREFERENCEDATE,
    QUOTATIONPERIODSTARTDATE,
    QUOTATIONPRICE,
    QUOTATIONPRICETYPE,
    REFBUSINESSSOLUTIONORDER,
    REFBUSINESSSOLUTIONORDERITEM,
    REFCONSOLIDATIONDOCUMENTTYPE,
    REFERENCE1IDBYBUSINESSPARTNER,
    REFERENCEDOCBUSOBJTYPE,
    REFERENCEDOCSDDOCCATEGORY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTFISCALYEAR,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEDOCUMENTTYPE,
    REFERENCELOGICALSYSTEM,
    REFERENCENUMBER,
    REFERENCEPURCHASEORDERCATEGORY,
    REFERENCEQUANTITY,
    REFERENCEQUANTITYUNIT,
    REFINHOUSEREPAIRISEXISTING,
    REMARK,
    REMARKATCUSTOM,
    REPETITIVEMFGCONFIRMATIONITEM,
    REPORTINGCURRENCY,
    REPORTINGDATE,
    REPORTINGPERIOD,
    REQUESTEDSERVICEENDDATETIME,
    REQUESTEDSERVICESTARTDATETIME,
    RESPONSEPROFILE,
    RESPONSIBLEEMPLOYEE,
    RETURNAPPLICATIONDOCTYPE,
    RETURNITEMPROCESSINGTYPE,
    REVERSEDOCUMENT,
    REVERSEDOCUMENTFISCALYEAR,
    RO_SAFTANALYSISENTRY,
    RO_SAFTANALYSISENTRYDESC,
    RO_SAFTCUSTOMERTAXTYPE,
    RO_SAFTEXCHANGERATE,
    RO_SAFTGOODSSERVICE,
    RO_SAFTISDEFAULTZEROQUANTITY,
    RO_SAFTJOURNALTRANSACTION,
    RO_SAFTJOURNALTRANSACTIONTYPE,
    RO_SAFTJOURNALTRANSDESCRIPTION,
    RO_SAFTPAYMENTMETHOD,
    RO_SAFTSOURCEDOCUMENT,
    RO_SAFTSOURCEDOCUMENTTYPE,
    RO_SAFTSUPPLIERTAXTYPE,
    ROUNDINGDECIMALPLACES,
    RU_BUDGETCLASSIFICATIONCODE,
    RU_IMPORTNOTIFICATIONITEMREF,
    RU_IMPORTNOTIFICATIONREFERENCE,
    RU_SUPPLIERKPP,
    RU_TERRITORYCLASSFCTNOKTMO,
    RU_UNIFIEDTAXNOTICEPERIODCODE,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTYPE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SALESSDDOCUMENTCATEGORY,
    SEGMENT,
    SEQUENCEOFPINVDOCUMENTITEMS,
    SERVICEDOCITEMBILLINGSTATUS,
    SERVICEDOCITEMGROSSAMOUNT,
    SERVICEDOCITEMREJECTIONREASON,
    SERVICEDOCUMENTITEMHASERROR,
    SERVICEDOCUMENTITEMSTATUS,
    SERVICEDOCUMENTTYPE,
    SERVICEEMPLOYEE,
    SERVICEFIRSTRESPONSEBYDATETIME,
    SERVICEORGANIZATION,
    SERVICEPROFILE,
    SERVICETEAM,
    SHELFLIFEEXPIRATIONDATE,
    SHIPTOPARTY,
    SIDE,
    SNAPSHOTDATE0,
    SNAPSHOTDATE1,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOLDTOPARTY,
    SOLDTOPARTYCOUNTRY,
    SOLDTOPARTYREGION,
    SOURCEDOCUMENT,
    SOURCEDOCUMENTBUSOBJTYPE,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SOURCETRANSACEVENTENDDATETIME,
    SOURCETRANSACTIONEVENTDATETIME,
    SOURCEUNITOFMEASUREFACTOR,
    SOURCINGPROJECT,
    SOURCINGPROJECTVERSION,
    SPECIALGLCODE,
    SPECIALTAXRATE,
    SPECVALASSGMTITEMCHANGENUMBER,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SRVCDOCITEMSLADUEBYDATETIME,
    SRVCDOCITEMTRANSFERSTATUS,
    SRVCDOCITMISRELEASEDFORBILLING,
    STARTDATE,
    STATISTICALVALUECONTROL,
    STATISTICSCURRENCY,
    STATUSCODE,
    STOCKDOCUMENTCATEGORY,
    STOCKDOCUMENTNUMBER,
    STOCKITEMNUMBER,
    STOCKOWNER,
    STOCKSEGMENT,
    STOCKTYPE,
    STOCKUSAGE,
    STORAGELOCATION,
    SUBITEM,
    SUBITEMCATEGORY,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    SUPPLIERCOUNTRY,
    SUPPLIERRECIPIENTTYPE,
    SUPPLIERTAXID5,
    SUSTAINABILITYMODEOFTRANSPORT,
    TAXAMOUNT,
    TAXBASEAMOUNT,
    TAXCATEGORY,
    TAXCOUNTRY,
    TAXITEM,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    TIMESHEETOVERTIMECATEGORY,
    TIMETOMATURITY,
    TRANSACTIONAMOUNTINLOCALCRCY,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCYDECIMALS,
    TRDGCONTRACTITEMUNITOFMEASURE,
    TW_EDOCGVMNTUNIFORMINVCNUMBER,
    TYPE_CODE,
    UMZIN,
    UMZIZ,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNIT,
    UNITOFMEASURE,
    UNITPRICEAMOUNTINREPORTINGCRCY,
    UNLOADINGPOINTNAME,
    VALCHAINPROCESSBLOCKTYPEDESC,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALUATIONAREA,
    VALUATIONPOINT,
    VALUECHAINBUSINESSOBJECTCAT,
    VALUECHAINITEMUUID,
    VALUECHAINPREDECESSORSTPBUSOBJ,
    VALUECHAINSTEPBUSINESSOBJECT,
    VALUECHAINTYPE,
    VALUEDATE,
    VATREGISTRATION,
    VBTYP,
    VOLUME,
    WAREHOUSE,
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    WCDVLH_NO,
    WHSETASKGOODSRECEIPTDATETIME,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCOUNTINGDOCUMENTTYPE, ACMDOCUMENTSIDE, ALLOC_RUN_ID, APPLICATIONDOCUMENT, APPLICATIONDOCUMENTITEM, APPLICATIONDOCUMENTSUBITEM, BG_SAFTANALYSISTYPE, BILLINGDOCUMENT, BILLINGDOCUMENTITEM, BILLINGDOCUMENTREQUEST, BILLINGDOCUMENTREQUESTITEM, BOPFORM, BOPRPTGCNTRY, BR_NOTAFISCAL, BUSINESSPARTNER, CABPITEMNUMBER, CADOCUMENTNUMBER, CAITEMTYPE, CAREPETITIONITEMNUMBER, CASRCDOCUMENTCAT, CASRCDOCUMENTNUMBER, CASRCDOCUMENTTYPE, CASUBITEMNUMBER, CHANGEDOCITEMCHANGETYPE, CHANGEDOCOBJECT, CHANGEDOCOBJECTCLASS, CHANGEDOCTABLEKEY, CLEAREDDOCUMENTNUMBER, CNSLDTNGROUPJRNLENTRY, CNSLDTNGROUPJRNLENTRYITEM, COLLECTION_ID, COLLECTION_VERSION, COMPANYCODE, CONDITIONTYPE, CONSOLIDATIONDIMENSION, CONSOLIDATIONLEDGER, COUNTRYCODE, CUSTOMER, DATABASETABLE, DEST_NODE_ID, FINALPRICEDATE, FISCALYEAR, FXVALUATIONDATE, FXVALUATIONDATEDOCTOSTSTC, HCMTIMEREQITEMLISTSQNCNUMBER, ID, INDUSTRYSECTOR, ISENDOFPURPOSEBLOCKED, ITEM, ITEM_LIST_NO, ITEM_TYPE, ITEMNUMBER, JP_CENTRALBKPAYMENTREPORTSTYLE, LDCKEY, LEDGER, LEDGERGLLINEITEM, LINEINDEXOFPINVITEM, MANUFACTURINGORDER, MANUFACTURINGORDERITEM, NOTE, ORDERID, ORIGIN_NODE_ID, PAYMENTREASON, PHYSICALINVENTORYCHANGEVERSION, PHYSICALINVENTORYDOCUMENTUUID, PHYSICALINVENTORYITEMNUMBER, PINVDOCUMENTITEMTYPE, POSTINGDATE, PRICINGDOCUMENTITEM, PROCMTHUBEXTREFERENCEDMATERIAL, PURCHASECONTRACTITEMTEXT, PURCHASECONTRACTTYPE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, PURCHASINGGROUP, PURCHASINGORGANIZATION, QUOTATIONGROUPITEM, REFERENCEFISCALYEAR, RO_SAFTANALYSISTYPE, RO_SAFTSTANDARDACCOUNT, RU_IMPORTNOTIFICATIONITEM, RU_IMPRTNOTIFINTERNALNUMBER, SCENARIO, SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEOBJECTTYPE, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, SUBCONDITIONTYPE, SUBITEMNUMBER, SUPPLIER, TAXCODE, TAXDECLNAMOUNTTYPE, TAXITEMGROUP, TRANSACTIONCURRENCY, TRANSACTIONTYPEDETERMINATION, VALUATIONDATE, VALUECHAINBUSINESSOBJECT, VALUECHAINBUSINESSOBJECTITEM, VALUECHAINDOCUMENTITEMORIGIN, VALUECHAININSTANCEUUID, VALUECHAINPRDCSSRBUSOBJITEM, VALUECHAINPRDCSSRDOCITMORIGIN, VALUECHAINPREDECESSORBUSOBJ, VALUECHAINSTEPINSTANCEUUID, VALUECHAINSTEPPREDECESSORUUID, VERSION)
);