I_JOURNALENTRYITEM

CDS View
335 Fields 189 CDS Views

Journal Entry Item

I_JOURNALENTRYITEM is a CDS View in S/4HANA. Journal Entry Item. It contains 335 fields. 189 CDS views read from this table.

CDS Views using this table (189)

ViewTypeJoinVDMDescription
C_ActyTypeRcvgCostCtrItm view from CONSUMPTION Receiving Cost Centers Line Items
C_ActyTypeRcvgOrdItm view from CONSUMPTION Receiving Orders Line Items
C_ActyTypeRcvgWBSElmntItm view from CONSUMPTION Receiving Cost Centers WBS Element Line Items
C_ActyTypeSndgCostCtrItm view from CONSUMPTION Sending Cost Centers Line Items
C_AR_StRpJrnlEntrDocSelection view inner CONSUMPTION Argentina Journal Ledger Document Selection for Reporting
C_GRIROplAccountingDocItem view from CONSUMPTION GR/IR Operational Accounting Doc Item
C_JrnlEntrItmByLeadingLdgr_FM view from CONSUMPTION Journal Entry Item by Leading Ledger
C_JrnlEntrItmPriorFsclPerd view from CONSUMPTION Jrnl Entr Item Postd Prior Fiscal Period
C_JrnlEntryItemCorrespnc view from CONSUMPTION Correspondence SAP09 - Ledger View - Journal Entry - items
C_MX_AuxiliaryRptAcctDetailC view from CONSUMPTION MX Auxiliary Rpt for Acct Details Cube
C_NL_SAFTJournalItemBP view_entity from CONSUMPTION Audit File NL Journal Item BP
C_NL_SAFTJournalItemBP view_entity union CONSUMPTION Audit File NL Journal Item BP
C_NL_SAFTJournalItemRefDoc view_entity from CONSUMPTION Audit File NL Journal Item Ref Docs
C_NL_SAFTSubLedgerLine view from CONSUMPTION SAFT NL Sub Ledger Line
C_NO_SAFTJournalEntryCube view from CONSUMPTION SAF-T Norway Journal Entry Cube
C_NO_SAFTJournalItemCube view from CONSUMPTION SAF-T Norway Journal Item Cube
C_SetlDocJrnlEntrItmPubSec view from CONSUMPTION Journal entry item with public sector fields
C_SettlmtDocJournalEntryItem view from CONSUMPTION Journal entry items for settlement document
C_StRpJournalEntryItemCube view from CONSUMPTION Jrnl Entry Item Cube for Stat.Reporting
I_AccrEngnJournalEntryItem view from BASIC Accrual Engine posting line items
I_CrcyAdjmtItemToBeVerified view union_all COMPOSITE Union View of Crcy Adjmt to be verified
I_FinSGLPostedItem view_entity from BASIC Financial Services GL Posted Item
I_GLJrnlEntryItemToBeVerified view union_all COMPOSITE Union View of LI in GL JE to be verified
I_JournalEntryItemBrowser view_entity from COMPOSITE Journal Entry Item Browser
I_JournalEntryItemCube view_entity from COMPOSITE Journal Entry Item - Cube
I_JournalEntryItemWIP view from BASIC Interface View of Journal Entry Item Work In Process
I_JournalEntryOperationalView view from COMPOSITE Operational View on Journal Entry Item
I_JournalEntrySemanticKeyVH view from COMPOSITE Journal Entry Semantic Key Value Help
I_LU_SAFTGenLedgerDocumentBP view_entity from COMPOSITE Business Partner Document for SAFT LU
I_LU_SAFTGenLedgerDocumentBP view_entity union COMPOSITE Business Partner Document for SAFT LU
I_LU_SAFTGenLedgerMultiBP view_entity from COMPOSITE SAFT LU Multiple BP On Same Document
I_LU_SAFTGenLedgerMultiBP view_entity union COMPOSITE SAFT LU Multiple BP On Same Document
I_LU_SAFTJournalEntry view inner COMPOSITE SAFT LU General Ledger Documents
I_MaintOrderActualCostCube view from COMPOSITE Maintenance Order Actual Cost Cube
I_MaintOrderActualCostCube view union_all COMPOSITE Maintenance Order Actual Cost Cube
I_MaintOrderActualCostDataCube view from COMPOSITE Maint Order Actual Cost Data - Cube
I_ManagementAccountingCube view from COMPOSITE Management Accounting - Cube
I_MPJournalEntryItemCube view from COMPOSITE Master Project Accounting Journal Entry Item Cube
I_NL_SAFTBusinessPartner view from COMPOSITE SAF-T NL Business Partner
I_NL_SAFTBusinessPartner view union COMPOSITE SAF-T NL Business Partner
I_NL_SAFTSubLedgerNmbrEntries view from COMPOSITE SAFT NL Sub Ledger Total Entries
I_NL_SAFTSubLedgerTotalCheck view from COMPOSITE SAFT NL Sub Ledger Total Amount
I_NO_SAFTJournalItem view from COMPOSITE SAFT Norway Journal Items
I_NO_SAFTJournalItemAmount view_entity from COMPOSITE Journal Item Amounts to Totals Section
I_OplAcctgDocItemFreeDfndCrcy view from BASIC Amount in Freely Defined Currency
I_PL_SAFTJournalEntryCube view_entity from COMPOSITE SAFT PL Journal Entry - Cube
I_PT_SAFTBillgAcctgHeader view_entity inner COMPOSITE Accounting Document Header
I_REJournalEntryValnObjMapping view_entity from COMPOSITE RE Mapping between Journal Entry and Valuation Object
I_SAFTCompensationDocument view from COMPOSITE SAFT Compensation Documents
I_SAFTCustomerOpenItem view from COMPOSITE SAF-T Customer Open Items
I_SAFTGeneralLedgerOneTimeBP view inner COMPOSITE SAFT GLedger One Time Business Partner
I_SAFTGenLedgerCustomer view from COMPOSITE SAF-T Gen Ledger Customer
I_SAFTGenLedgerOneTimeCustomer view from COMPOSITE SAF-T Gen Ledger One Time Customer
I_SAFTGenLedgerOneTimeSupplier view from COMPOSITE SAF-T Gen Ledger OneTimeSupplier
I_SAFTJournalCode view from COMPOSITE SAF-T Journal Codes
I_SAFTJournalItem view from COMPOSITE SAF-T Journal Ledger Entry Item
I_SAFTJournalLineItem view from COMPOSITE SAF-T Journal Item
I_SAFTJournalLineItem view union COMPOSITE SAF-T Journal Item
I_SAFTLineItemCA view inner COMPOSITE SAF-T FI-CA GL Line Item
I_SAFTVendorOpenItem view from COMPOSITE SAF-T Vendor Open Items
P_AccrualCostProjectAmt view from CONSUMPTION Sum of accrued costs
P_AccrualCostSalesOrderAmt view from CONSUMPTION Accrued Costs sales order amount
P_AccrualCostSrvcDocAmt view from CONSUMPTION Accrued Costs service document amount
P_AccrualRevenueProjectAmt view from CONSUMPTION Sum of accrued revenue
P_AccrualRevenueSalesOrderAmt view from CONSUMPTION Accrued Revenue sales order amount
P_AccrualRevenueSrvcDocAmt view from CONSUMPTION Accrued Revenue service document amount
P_AddlLedgerAcctDocItemHistory view union COMPOSITE
P_AR_JournalEntryItem view_entity from CONSUMPTION
P_AR_StRpJrnlLdgrJrnlEntryItem view from CONSUMPTION
P_AUDIT_AT_BSEG view from BASIC
P_AUDIT_AT_HELPER_LEDGER view_entity from COMPOSITE Austrian Audit Helper Ledger
P_BG_SAFTANALYSISTYPEITEM view_entity from CONSUMPTION
P_BG_SAFTANALYSISTYPEITEM view_entity union_all CONSUMPTION
P_BG_SAFTJournalEntryItem view_entity from CONSUMPTION
P_BG_SAFTPAYMENTITEM view_entity from CONSUMPTION
P_BG_SAFTPURINVHDR view_entity from CONSUMPTION
P_BG_SAFTPURINVOICEITEM view_entity from CONSUMPTION
P_BG_SAFTSALESINVOICEITEM view_entity from CONSUMPTION
P_BG_SAFTSALINVHDR view_entity from CONSUMPTION
P_BOPRevnCostItemToFormItem00 view_entity inner COMPOSITE
P_CL_JournalEntryItemDocAmount view inner CONSUMPTION
P_CN_CADEAssetQuantity view left_outer COMPOSITE
P_CNSLDTNINTEGRPTDFINDATA_TN view inner COMPOSITE
P_CO_DIANInvoiceFinDocument view from CONSUMPTION
P_CO_DIANJrnlEntrWthInvcFinDoc view left_outer CONSUMPTION
P_COMfgOrdActlPlnUnion view from COMPOSITE
P_CtrlgOvhdJournalEntryItem view inner BASIC
P_DeferredCostProjectOrderAmt view from CONSUMPTION Sum of deferred costs
P_DeferredCostSalesOrderAmt view from CONSUMPTION Deferred Costs sales order amount
P_DeferredCostSrvcDocAmt view from CONSUMPTION Deferred Costs service document amount
P_DeferredRevenueProjectAmt view from CONSUMPTION Sum of deferred revenue
P_DeferredRevenueSalesOrderAmt view from CONSUMPTION Deferred Revenue sales order amount
P_DeferredRevenueSrvcDocAmt view from CONSUMPTION Deferred Revenue service document amount
P_EBOC_EventBasedVariance1 view from COMPOSITE
P_EBOC_Variance1 view from COMPOSITE
P_EBOC_WIP1 view from COMPOSITE
P_EBOrderSplitVarianceCost1 view from COMPOSITE
P_EBOrderVarianceCost1 view from COMPOSITE
P_EBOrderWIPCost1 view from COMPOSITE
P_EBPAO_TR_TotalVariance1 view from COMPOSITE
P_EBPAO_TR_VarianceByType1 view from COMPOSITE
P_EBPAO_VarianceOverview1 view from COMPOSITE
P_EBPAO_VarianceTrend1 view from COMPOSITE
P_EBPAO_WIPOverview1 view from COMPOSITE
P_EBPAO_WIPTrend1 view from COMPOSITE
P_EBPCC_ActualOutputQty view_entity from COMPOSITE Event-Based PCC Actual Output Quantity
P_EBWIP_FinalProductActOutQty view from COMPOSITE
P_EvtBsdOrdRelevantActualCosts view from COMPOSITE
P_EvtBsdOrdReserves view from COMPOSITE
P_EvtBsdOrdSubReserves view from COMPOSITE
P_EvtBsdOrdSubWIP view from COMPOSITE
P_EvtBsdOrdWIP view from COMPOSITE
P_GB_APPayment view_entity from COMPOSITE GB PPPR payments
P_GB_AROpenItem view_entity from COMPOSITE Great Britain AR Open items
P_GB_ARWRITEOFF view_entity from COMPOSITE GB bad debts
P_GB_ARWRITEOFF view_entity inner COMPOSITE GB bad debts
P_GB_ClrdPaytPracticePerf1 view_entity from COMPOSITE GB PPPR AP paid invoices Layer 1
P_GRIRAnalysis view from CONSUMPTION Analyze GR/IR Account Reconciliation
P_GRIRProcDigestInGlobalCrcy view from CONSUMPTION GR/IR Reconciliation Process Digest in Global Currency
P_GRIRReconciliation view from COMPOSITE
P_HU_ReverseGenItem view_entity from CONSUMPTION
P_JournalEntryPerformance view from COMPOSITE FINCS Check Performance of Journal Entry
P_JP_AssetQuantity view from COMPOSITE
P_JrnlEntrAmtAbvThreshold view from CONSUMPTION JE Amount Above Threshold
P_JrnlEntrItmAmtAbvThld view from CONSUMPTION JE Item Amount above Threshold
P_MfgOrderEvtBsdVariance1 view from COMPOSITE
P_MfgOrderEvtBsdWIP1 view from COMPOSITE
P_MPJournalEntry view from COMPOSITE
P_MstrProjActuals view inner COMPOSITE
P_MX_JournalEntryGRHistory view from COMPOSITE
P_MX_JournalEntryGRHistory2 view inner COMPOSITE
P_MX_OperationalAcctDocItem view inner CONSUMPTION
P_NL_SAFTCAOpngBalLineV2 view_entity from CONSUMPTION
P_NL_SAFTInvoiceType view from COMPOSITE
P_NL_SAFTJournalLineItem view from COMPOSITE
P_NL_SAFTOpngBalLine view_entity union_all COMPOSITE
P_NO_SAFTCustomerSpecialGL view from COMPOSITE
P_NO_SAFTJournalItem view from COMPOSITE
P_NO_SAFTJournalItemTotals view_entity from COMPOSITE Journal Items for SAFT NO Totals Section
P_NO_SAFTSpecialGLAmount view from COMPOSITE
P_NO_SAFTSupplierSpecialGL view from COMPOSITE
P_PCCActualCostBYLdgr view_entity from COMPOSITE
P_PCCOrderActualOutputQuantity view from COMPOSITE Manufacturing order actual output quantity
P_PE_JournalEntryFSStructure2 view inner CONSUMPTION
P_PE_OriginalJournalEntry view inner CONSUMPTION
P_PE_SalesOriginalJrnlEntry view inner CONSUMPTION Original Documents for Sales Ledger Peru
P_PL_SAFTJournalEntry view from CONSUMPTION
p_pl_saftjournalentrykrpdtag view_entity from CONSUMPTION
P_PurOrdAccrDefrlActlItem view_entity from BASIC
P_RealTimeRptdFinData_01 view from COMPOSITE
P_RealTimeRptdFinData_06 view inner COMPOSITE
P_REALTIMERPTDFINDATA_TN view inner COMPOSITE
P_REALTIMERPTDFINDATANRL_01 view from COMPOSITE
P_REALTIMERPTDFINDATANRL_TN view inner COMPOSITE
P_RepFinData_RT_Aggr_01 view from COMPOSITE
P_RepFinData_RT_AggrNRL_01 view from COMPOSITE
P_REPFINDATA_RT_AGGRSNRL_01 view from COMPOSITE
P_ReportedFinancialData_RT_01 view from COMPOSITE
P_RFD_RT_AGGR_simple_01 view from COMPOSITE
P_RO_SAFTJournalEntryItemBase view from CONSUMPTION RO SAFT acdoca
P_RO_SAFTNTRPURINVWIAHEADER view_entity inner CONSUMPTION
P_RO_SAFTNTRSLSINVWIAHEADER view_entity inner CONSUMPTION
P_RO_SAFTPaymentDocument view inner CONSUMPTION
P_RRBDynamicItemFlow03 view from CONSUMPTION
P_RRBSalesPricingDynamicItem01 view inner CONSUMPTION
P_RRBWrittenOffDynamicItem01 view inner CONSUMPTION
P_RTPCOrderOutputQuantity view from BASIC
P_RU_FixedAssetItem view left_outer CONSUMPTION
P_RU_FIXEDASSETITEMTEXT view from CONSUMPTION
P_RU_JrnlEntrRvsd view from CONSUMPTION
P_RU_VATTrdClassfctnNmbr1 view from CONSUMPTION
P_RunSettlmtJournalEntryItem view inner BASIC
P_SAFT_GeneralLedgerBP view from COMPOSITE
P_SAFT_GeneralLedgerOneTimeBP view from COMPOSITE
P_SAFT_GLMaxBuPa view from COMPOSITE
P_SAFTGLItems view from COMPOSITE
P_SAFTGLMaxCustomer view from COMPOSITE
P_SAFTGLMaxSupplier view from COMPOSITE
P_SAFTJournalCustVend view from COMPOSITE
P_SAFTJournalEntryLedger view from COMPOSITE
P_SAFTSumJournalLineItem view from COMPOSITE
P_SAFTSumJournalLineItem view union_all COMPOSITE
P_SalesOrdJournalEntryItem view from CONSUMPTION Journal Entry for Sales Order
P_StRpBPTaxItem view from COMPOSITE
P_StRpBPTaxItem3 view from COMPOSITE
P_UnbilledRevenueProjectAmt view from CONSUMPTION Sum of unbilled revenue
P_UnbilledRevenueSalesOrderAmt view from CONSUMPTION Unbilled Revenue sales order amount
P_UnbilledRevenueSrvcDocAmt view from CONSUMPTION Unbilled Revenue service document amount
P_UnrealizedCrcyDiff view from COMPOSITE

Fields (335)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,belnr,IncgInvoiceAccountingDocument,InvoiceReference,JournalEntry,MaterialDocumentNumber 80
KEY AccountingDocumentItem AccountingDocumentItem,InvoiceItemReference 28
KEY AccountingDocumentType AccountingDocumentType,blart 24
KEY CompanyCode bukrs,CompanyCode,robukrs,SourceCompanyCode 95
KEY Customer Customer 34
KEY FiscalYear FiscalYear,gjahr,InvoiceReferenceFiscalYear,ReferenceFiscalYear,refryear 80
KEY FixedAsset FixedAsset 8
KEY GLAccount GLAccount,racct 48
KEY Ledger Ledger 82
KEY LedgerFiscalYear FiscalYear,LedgerFiscalYear 6
KEY LedgerGLLineItem AccountingDocumentItem,docln,docln_fin,LedgerGLLineItem 50
KEY MasterFixedAsset MasterFixedAsset 8
KEY PostingDate budat,PostingDate 44
KEY PostingKey bschl,PostingKey 8
KEY PurchasingDocument PurchasingDocument 11
KEY PurchasingDocumentItem PurchasingDocumentItem 9
KEY SourceLedger Ledger,LedgerGroup,rldnr_fin,SourceLedger 52
KEY SpecialGLCode SpecialGLCode,umskz 10
KEY Supplier Supplier 36
_AccountingDocumentCategory _AccountingDocumentCategory 3
_AccountingDocumentType _AccountingDocumentType 2
_BalanceTransactionCurrency _BalanceTransactionCurrency 2
_BaseUnit _BaseUnit 2
_BusinessArea _BusinessArea 1
_BusinessTransactionType _BusinessTransactionType 1
_ChartOfAccounts _ChartOfAccounts 7
_ClearingAccountingDocument _ClearingAccountingDocument 1
_ClearingJournalEntry _ClearingJournalEntry 1
_ClearingJrnlEntryFiscalYear _ClearingJrnlEntryFiscalYear 1
_CompanyCode _CompanyCode 22
_CompanyCodeCurrency _CompanyCodeCurrency 9
_ControllingArea _ControllingArea 2
_CostAnalysisResource _CostAnalysisResource 1
_CostCenter _CostCenter 2
_CostCenterTxt _CostCenterTxt 1
_CurrentCostCenter _CurrentCostCenter 1
_CurrentProfitCenter _CurrentProfitCenter 1
_Customer _Customer 7
_DebitCreditCode _DebitCreditCode 3
_FinancialAccountType _FinancialAccountType 2
_FiscalPeriod _FiscalPeriod 2
_FiscalYear _FiscalYear 20
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant 1
_FiscalYearVariant _FiscalYearVariant 1
_FreeDefinedCurrency1 _FreeDefinedCurrency1 2
_FreeDefinedCurrency2 _FreeDefinedCurrency2 2
_FreeDefinedCurrency3 _FreeDefinedCurrency3 2
_FreeDefinedCurrency4 _FreeDefinedCurrency4 2
_FreeDefinedCurrency5 _FreeDefinedCurrency5 2
_FreeDefinedCurrency6 _FreeDefinedCurrency6 2
_FreeDefinedCurrency7 _FreeDefinedCurrency7 2
_FreeDefinedCurrency8 _FreeDefinedCurrency8 2
_FunctionalArea _FunctionalArea 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 6
_GLAccountInCompanyCode _GLAccountInCompanyCode 2
_GlobalCurrency _GlobalCurrency 2
_Grant _Grant 1
_InvtrySpclStkWBSElmntBscData _InvtrySpclStkWBSElmntBscData 1
_JournalEntry _JournalEntry 18
_Ledger _Ledger 19
_LedgerFiscalYear _LedgerFiscalYear 1
_Material _Material 1
_OffsettingAccount _OffsettingAccount 1
_OffsettingAccountType _OffsettingAccountType 1
_OffsettingAccountWithBP _OffsettingAccountWithBP 1
_OffsettingChartOfAccounts _OffsettingChartOfAccounts 1
_Order _Order 1
_PartnerGrant _PartnerGrant 1
_PartnerProjectBasicData _PartnerProjectBasicData 1
_PartnerWBSElementBasicData _PartnerWBSElementBasicData 1
_Plant _Plant 1
_PostingKey _PostingKey 1
_Product _Product 1
_ProfitCenter _ProfitCenter 1
_ProfitCenterTxt _ProfitCenterTxt 1
_Project _Project 1
_ProjectBasicData _ProjectBasicData 1
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
_ReferenceDocumentType _ReferenceDocumentType 1
_Segment _Segment 1
_SegmentText _SegmentText 1
_SourceLedger _SourceLedger 8
_Supplier _Supplier 6
_TaxCode _TaxCode 1
_TransactionCurrency _TransactionCurrency 5
_WBSElement _WBSElement 1
_WBSElementBasicData _WBSElementBasicData 1
_WBSElementBasicDataText _WBSElementBasicDataText 1
_WBSElementInternalID _WBSElementInternalID 2
AccountAssignment AccountAssignment 2
AccountAssignmentNumber AccountAssignmentNumber 3
AccountAssignmentType AccountAssignmentType 2
AccountingDocCreatedByUser AccountingDocCreatedByUser,usnam 7
AccountingDocumentCategory AccountingDocumentCategory 12
AlternativeGLAccount AlternativeGLAccount 5
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy,AmountInTransactionCurrency,tsl 5
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency,AmountInLocalCurrency,hsl 21
AmountInFreeDefinedCurrency1 osl 3
AmountInFreeDefinedCurrency2 vsl 3
AmountInFreeDefinedCurrency3 bsl 3
AmountInFreeDefinedCurrency4 csl 3
AmountInFreeDefinedCurrency5 dsl 3
AmountInFreeDefinedCurrency6 esl 3
AmountInFreeDefinedCurrency7 fsl 3
AmountInFreeDefinedCurrency8 gsl 3
AmountInFunctionalCurrency AmountInFunctionalCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency,AmountInGroupCurrency,ksl 10
AmountInObjectCurrency AmountInObjectCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 20
AssetAcctTransClassfctn AssetAcctTransClassfctn 2
AssetClass AssetClass 1
AssetDepreciationArea AssetDepreciationArea 2
AssetTransactionType AssetTransactionType 1
AssetValueDate AssetValueDate 2
AssignmentReference AssignmentReference 12
BalanceTransactionCurrency BalanceTransactionCurrency,rtcur 10
BaseUnit BaseUnit,runit 12
BillingDocumentType BillingDocumentType 7
BillToParty BillToParty 7
BudgetPeriod BudgetPeriod 2
BusinessArea BusinessArea,rbusa 17
BusinessProcess BusinessProcess 2
BusinessTransactionType BusinessTransactionType 4
CashLedgerAccount CashLedgerAccount 6
CashLedgerCompanyCode CashLedgerCompanyCode 4
ChartOfAccounts ChartOfAccounts 24
ClearingAccountingDocument ClearingAccountingDocument 3
ClearingDate ClearingDate 6
ClearingDocFiscalYear ClearingDocFiscalYear 3
ClearingJournalEntry ClearingJournalEntry 3
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 3
CompanyCodeCurrency CompanyCodeCurrency 43
ControllingArea ControllingArea 25
ControllingBusTransacType ControllingBusTransacType 1
ControllingDebitCreditCode ControllingDebitCreditCode 1
ControllingObject ControllingObject 5
ControllingObjectCurrency ControllingObjectCurrency 2
ControllingObjectDebitType ControllingObjectDebitType 3
CostAnalysisResource CostAnalysisResource 1
CostCenter BG_SAFTAnalysisEntry,CostCenter,rcntr 24
CostCtrActivityType CostCtrActivityType 1
CostEstimate CostEstimate 1
CostObject CostObject 2
CostOriginGroup CostOriginGroup 2
CountryChartOfAccounts CountryChartOfAccounts 4
CreationDate AccountingDocumentCreationDate,CreationDate 4
CreationDateTime CreationDateTime,timestamp 4
CreditAmountInBalanceTransCrcy CreditAmountInBalanceTransCrcy 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 3
CreditAmountInFreeDefinedCrcy1 CreditAmountInFreeDefinedCrcy1 1
CreditAmountInFreeDefinedCrcy2 CreditAmountInFreeDefinedCrcy2 1
CreditAmountInFreeDefinedCrcy3 CreditAmountInFreeDefinedCrcy3 1
CreditAmountInFreeDefinedCrcy4 CreditAmountInFreeDefinedCrcy4 1
CreditAmountInFreeDefinedCrcy5 CreditAmountInFreeDefinedCrcy5 1
CreditAmountInFreeDefinedCrcy6 CreditAmountInFreeDefinedCrcy6 1
CreditAmountInFreeDefinedCrcy7 CreditAmountInFreeDefinedCrcy7 1
CreditAmountInFreeDefinedCrcy8 CreditAmountInFreeDefinedCrcy8 1
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy 1
CreditAmountInTransCrcy CreditAmountInTransCrcy 3
CustomerGroup CustomerGroup 8
CustomerServiceNotification CustomerServiceNotification 1
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 7
CustomerSupplierCountry CustomerSupplierCountry 8
CustomerSupplierIndustry CustomerSupplierIndustry 8
DebitAmountInBalanceTransCrcy DebitAmountInBalanceTransCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 3
DebitAmountInFreeDefinedCrcy1 DebitAmountInFreeDefinedCrcy1 1
DebitAmountInFreeDefinedCrcy2 DebitAmountInFreeDefinedCrcy2 1
DebitAmountInFreeDefinedCrcy3 DebitAmountInFreeDefinedCrcy3 1
DebitAmountInFreeDefinedCrcy4 DebitAmountInFreeDefinedCrcy4 1
DebitAmountInFreeDefinedCrcy5 DebitAmountInFreeDefinedCrcy5 1
DebitAmountInFreeDefinedCrcy6 DebitAmountInFreeDefinedCrcy6 1
DebitAmountInFreeDefinedCrcy7 DebitAmountInFreeDefinedCrcy7 1
DebitAmountInFreeDefinedCrcy8 DebitAmountInFreeDefinedCrcy8 1
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy 1
DebitAmountInTransCrcy DebitAmountInTransCrcy 3
DebitCreditCode DebitCreditCode 20
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
DistributionChannel DistributionChannel 11
DocumentDate DocumentDate,TransactionDate 15
DocumentItemText DocumentItemText 13
EliminationProfitCenter EliminationProfitCenter 1
Equipment Equipment 2
FinancialAccountType FinancialAccountType 28
FinancialDataSource FinancialDataSource 7
FinancialManagementArea FinancialManagementArea 8
FinancialServicesBranch FinancialServicesBranch 7
FinancialServicesProductGroup FinancialServicesProductGroup 7
FinancialTransactionType FinancialTransactionType,rmvct 9
FiscalPeriod FiscalPeriod,LedgerFiscalPeriod 14
FiscalYearPeriod FiscalYearPeriod,LedgerFiscalYearPeriod 8
FiscalYearVariant FiscalYearVariant 2
FollowOnDocumentType FollowOnDocumentType 4
FreeDefinedCurrency1 FreeDefinedCurrency1 3
FreeDefinedCurrency2 FreeDefinedCurrency2 1
FreeDefinedCurrency3 FreeDefinedCurrency3 1
FreeDefinedCurrency4 FreeDefinedCurrency4 1
FreeDefinedCurrency5 FreeDefinedCurrency5 1
FreeDefinedCurrency6 FreeDefinedCurrency6 1
FreeDefinedCurrency7 FreeDefinedCurrency7 1
FreeDefinedCurrency8 FreeDefinedCurrency8 1
FunctionalArea FunctionalArea,rfarea 12
FunctionalCurrency FunctionalCurrency 3
FunctionalLocation FunctionalLocation 1
Fund Fund 9
FundedProgram FundedProgram 2
FundsCenter FundsCenter 2
GLAccountType GLAccountType 3
GlobalCurrency GlobalCurrency 10
GrantID GrantID 9
GroupFixedAsset GroupFixedAsset 1
GroupMasterFixedAsset GroupMasterFixedAsset 1
HouseBank HouseBank 2
HouseBankAccount HouseBankAccount 2
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm 1
InventorySpclStkSalesDocument InventorySpclStkSalesDocument 1
InventorySpclStockWBSElement InventorySpclStockWBSElement 1
InventorySpecialStockSupplier InventorySpecialStockSupplier 1
InventorySpecialStockType InventorySpecialStockType 1
InventoryValuationType InventoryValuationType 1
InvoiceItemReference InvoiceItemReference 7
InvoiceReference InvoiceReference 11
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 6
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID 1
IsOpenItemManaged IsOpenItemManaged 2
IsReversal IsReversal 8
IsReversed IsReversed 6
IsStatisticalCostCenter IsStatisticalCostCenter 1
IsStatisticalOrder IsStatisticalOrder 1
IsStatisticalSalesDocument IsStatisticalSalesDocument 1
JointVenture JointVenture 1
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 1
JointVentureEquityGroup JointVentureEquityGroup 1
JointVentureEquityType JointVentureEquityType 1
LastChangeDateTime LastChangeDateTime 3
LineItemIsCompleted LineItemIsCompleted 1
LogicalSystem LogicalSystem,logsys 9
Material Material 11
MaterialGroup MaterialGroup 7
NetDueDate NetDueDate 3
OffsettingAccount OffsettingAccount 4
OffsettingAccountType OffsettingAccountType 2
OffsettingChartOfAccounts OffsettingChartOfAccounts 2
OperatingConcern OperatingConcern 1
OrderCategory OrderCategory 2
OrderID BG_SAFTAnalysisEntry,OrderID 19
OrganizationDivision OrganizationDivision 11
OriginCostCenter OriginCostCenter 1
OriginCostCtrActivityType OriginCostCtrActivityType 2
OriginObjectType OriginObjectType 1
OriginSenderObject OriginSenderObject 1
PartnerAccountAssignment PartnerAccountAssignment 1
PartnerAccountAssignmentType PartnerAccountAssignmentType 1
PartnerBudgetPeriod PartnerBudgetPeriod 2
PartnerBusinessArea PartnerBusinessArea,sbusa 8
PartnerBusinessProcess PartnerBusinessProcess 1
PartnerCompany PartnerCompany,rassc 12
PartnerCompanyCode PartnerCompanyCode 4
PartnerControllingObjectClass PartnerControllingObjectClass 1
PartnerCostCenter PartnerCostCenter 6
PartnerCostCtrActivityType PartnerCostCtrActivityType 1
PartnerCostObject PartnerCostObject 1
PartnerFixedAsset PartnerFixedAsset 1
PartnerFunctionalArea PartnerFunctionalArea 7
PartnerFund PartnerFund 8
PartnerGrant PartnerGrant 2
PartnerMasterFixedAsset PartnerMasterFixedAsset 1
PartnerOrder PartnerOrder 1
PartnerOrder_2 PartnerOrder_2 1
PartnerOrderCategory PartnerOrderCategory 1
PartnerProfitCenter PartnerProfitCenter 8
PartnerProject PartnerProject 1
PartnerProjectInternalID PartnerProjectInternalID 1
PartnerProjectNetwork PartnerProjectNetwork 1
PartnerProjectNetworkActivity PartnerProjectNetworkActivity 1
PartnerSalesDocument PartnerSalesDocument 1
PartnerSalesDocumentItem PartnerSalesDocumentItem 1
PartnerSegment PartnerSegment,Segment 8
PartnerWBSElement PartnerWBSElement 1
PartnerWBSElementInternalID PartnerWBSElementInternalID 1
PersonnelNumber PersonnelNumber 8
Plant Plant 15
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt 1
PredecessorReferenceDocItem PredecessorReferenceDocItem 1
PredecessorReferenceDocType PredecessorReferenceDocType 1
PredecessorReferenceDocument PredecessorReferenceDocument 1
Product Product 5
ProductGroup ProductGroup 7
ProfitCenter prctr,ProfitCenter 20
Project Project 8
ProjectInternalID ProjectInternalID 2
ProjectNetwork ProjectNetwork 2
Quantity msl,Quantity,QuantityInBaseUnit 10
QuantityIsIncomplete QuantityIsIncomplete 1
ReferenceDocument refdocnr,ReferenceDocument 12
ReferenceDocumentContext aworg,ReferenceDocumentContext 8
ReferenceDocumentItem ReferenceDocumentItem 3
ReferenceDocumentItemGroup ReferenceDocumentItemGroup 1
ReferenceDocumentType awtyp,ReferenceDocumentType 11
ReversalReferenceDocument ReversalReferenceDocument 6
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 1
SalesDistrict SalesDistrict 7
SalesDocument SalesDocument 10
SalesDocumentItem SalesDocumentItem 6
SalesOrder SalesOrder 4
SalesOrderItem SalesOrderItem 4
SalesOrganization SalesOrganization 11
Segment BG_SAFTAnalysisEntry,Segment 18
SenderAccountAssignment SenderAccountAssignment 1
SenderAccountAssignmentType SenderAccountAssignmentType 1
SenderCompanyCode SenderCompanyCode 1
SenderGLAccount SenderGLAccount 1
ServiceDocument ServiceDocument 2
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 2
ServicesRenderedDate ServicesRenderedDate 4
SettlementReferenceDate SettlementReferenceDate 1
ShipToParty ShipToParty 7
SoldMaterial SoldMaterial 1
SoldProduct SoldProduct 7
SoldProductGroup SoldProductGroup 7
SubLedgerAcctLineItemType SubLedgerAcctLineItemType 3
TaxCode TaxCode 16
TaxCountry TaxCountry 4
TransactionCurrency TransactionCurrency 32
TransactionTypeDetermination TransactionTypeDetermination 16
ValuationArea ValuationArea 6
ValuationQuantity ValuationQuantity 1
ValueDate ValueDate 5
WBSElement BG_SAFTAnalysisEntry,WBSElement,WBSElementExternalID 14
WBSElementInternalID WBSElementInternalID 13
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement 2
WorkItem WorkItem 1
WorkPackage WorkPackage 2

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.

-- Journal Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JOURNALENTRYITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    CUSTOMER,
    FISCALYEAR,
    FIXEDASSET,
    GLACCOUNT,
    LEDGER,
    LEDGERFISCALYEAR,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    POSTINGDATE,
    POSTINGKEY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    SOURCELEDGER,
    SPECIALGLCODE,
    SUPPLIER,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _BALANCETRANSACTIONCURRENCY,
    _BASEUNIT,
    _BUSINESSAREA,
    _BUSINESSTRANSACTIONTYPE,
    _CHARTOFACCOUNTS,
    _CLEARINGACCOUNTINGDOCUMENT,
    _CLEARINGJOURNALENTRY,
    _CLEARINGJRNLENTRYFISCALYEAR,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTCENTERTXT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _DEBITCREDITCODE,
    _FINANCIALACCOUNTTYPE,
    _FISCALPERIOD,
    _FISCALYEAR,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _FUNCTIONALAREA,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _INVTRYSPCLSTKWBSELMNTBSCDATA,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEAR,
    _MATERIAL,
    _OFFSETTINGACCOUNT,
    _OFFSETTINGACCOUNTTYPE,
    _OFFSETTINGACCOUNTWITHBP,
    _OFFSETTINGCHARTOFACCOUNTS,
    _ORDER,
    _PARTNERGRANT,
    _PARTNERPROJECTBASICDATA,
    _PARTNERWBSELEMENTBASICDATA,
    _PLANT,
    _POSTINGKEY,
    _PRODUCT,
    _PROFITCENTER,
    _PROFITCENTERTXT,
    _PROJECT,
    _PROJECTBASICDATA,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _REFERENCEDOCUMENTTYPE,
    _SEGMENT,
    _SEGMENTTEXT,
    _SOURCELEDGER,
    _SUPPLIER,
    _TAXCODE,
    _TRANSACTIONCURRENCY,
    _WBSELEMENT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTBASICDATATEXT,
    _WBSELEMENTINTERNALID,
    ACCOUNTASSIGNMENT,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCLASS,
    ASSETDEPRECIATIONAREA,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSTRANSACTIONTYPE,
    CASHLEDGERACCOUNT,
    CASHLEDGERCOMPANYCODE,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGBUSTRANSACTYPE,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLLINGOBJECTDEBITTYPE,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTESTIMATE,
    COSTOBJECT,
    COSTORIGINGROUP,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONDATE,
    CREATIONDATETIME,
    CREDITAMOUNTINBALANCETRANSCRCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINFREEDEFINEDCRCY1,
    CREDITAMOUNTINFREEDEFINEDCRCY2,
    CREDITAMOUNTINFREEDEFINEDCRCY3,
    CREDITAMOUNTINFREEDEFINEDCRCY4,
    CREDITAMOUNTINFREEDEFINEDCRCY5,
    CREDITAMOUNTINFREEDEFINEDCRCY6,
    CREDITAMOUNTINFREEDEFINEDCRCY7,
    CREDITAMOUNTINFREEDEFINEDCRCY8,
    CREDITAMOUNTINGLOBALCRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMERGROUP,
    CUSTOMERSERVICENOTIFICATION,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DEBITAMOUNTINBALANCETRANSCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINFREEDEFINEDCRCY1,
    DEBITAMOUNTINFREEDEFINEDCRCY2,
    DEBITAMOUNTINFREEDEFINEDCRCY3,
    DEBITAMOUNTINFREEDEFINEDCRCY4,
    DEBITAMOUNTINFREEDEFINEDCRCY5,
    DEBITAMOUNTINFREEDEFINEDCRCY6,
    DEBITAMOUNTINFREEDEFINEDCRCY7,
    DEBITAMOUNTINFREEDEFINEDCRCY8,
    DEBITAMOUNTINGLOBALCRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DEPRECIATIONFISCALPERIOD,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    ELIMINATIONPROFITCENTER,
    EQUIPMENT,
    FINANCIALACCOUNTTYPE,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FOLLOWONDOCUMENTTYPE,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUNCTIONALLOCATION,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    INVENTORYSPCLSTOCKWBSELEMENT,
    INVENTORYSPECIALSTOCKSUPPLIER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYVALUATIONTYPE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    INVTRYSPCLSTOCKWBSELMNTINTID,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    ISSTATISTICALCOSTCENTER,
    ISSTATISTICALORDER,
    ISSTATISTICALSALESDOCUMENT,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREEQUITYTYPE,
    LASTCHANGEDATETIME,
    LINEITEMISCOMPLETED,
    LOGICALSYSTEM,
    MATERIAL,
    MATERIALGROUP,
    NETDUEDATE,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGCHARTOFACCOUNTS,
    OPERATINGCONCERN,
    ORDERCATEGORY,
    ORDERID,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINOBJECTTYPE,
    ORIGINSENDEROBJECT,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERBUDGETPERIOD,
    PARTNERBUSINESSAREA,
    PARTNERBUSINESSPROCESS,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERCONTROLLINGOBJECTCLASS,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERCOSTOBJECT,
    PARTNERFIXEDASSET,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERGRANT,
    PARTNERMASTERFIXEDASSET,
    PARTNERORDER,
    PARTNERORDER_2,
    PARTNERORDERCATEGORY,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTINTERNALID,
    PARTNERPROJECTNETWORK,
    PARTNERPROJECTNETWORKACTIVITY,
    PARTNERSALESDOCUMENT,
    PARTNERSALESDOCUMENTITEM,
    PARTNERSEGMENT,
    PARTNERWBSELEMENT,
    PARTNERWBSELEMENTINTERNALID,
    PERSONNELNUMBER,
    PLANT,
    PREDECESSORREFERENCEDOCCNTXT,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCTYPE,
    PREDECESSORREFERENCEDOCUMENT,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    PROJECT,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    QUANTITY,
    QUANTITYISINCOMPLETE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEDOCUMENTTYPE,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SENDERACCOUNTASSIGNMENT,
    SENDERACCOUNTASSIGNMENTTYPE,
    SENDERCOMPANYCODE,
    SENDERGLACCOUNT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SETTLEMENTREFERENCEDATE,
    SHIPTOPARTY,
    SOLDMATERIAL,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBLEDGERACCTLINEITEMTYPE,
    TAXCODE,
    TAXCOUNTRY,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    VALUATIONQUANTITY,
    VALUEDATE,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WBSISSTATISTICALWBSELEMENT,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, CUSTOMER, FISCALYEAR, FIXEDASSET, GLACCOUNT, LEDGER, LEDGERFISCALYEAR, LEDGERGLLINEITEM, MASTERFIXEDASSET, POSTINGDATE, POSTINGKEY, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, SOURCELEDGER, SPECIALGLCODE, SUPPLIER)
);

Learn More