I_GLACCOUNTLINEITEMRAWDATA

CDS View

Raw Data of G/L Account Line Item

I_GLACCOUNTLINEITEMRAWDATA is a CDS View in S/4HANA. Raw Data of G/L Account Line Item. It contains 582 fields. 130 CDS views read from this table.

CDS Views using this table (130)

ViewTypeJoinVDMDescription
A_GLAccountLineItem view from BASIC API G/L Account Line Item
C_CL_StRpJournalEntryItemCube view from CONSUMPTION Jrnl Entr Items for Chile Reporting Cube
C_CO_DIANVatTaxReturnBoxLog view_entity inner CONSUMPTION Colombia DIAN VAT Tax Box Item Log
C_CostRevnReassgmtRcvrCount view from CONSUMPTION Cost, Revenue Reassignment Receiver Count
C_CostRevnReassgmtRcvrCount view union_all CONSUMPTION Cost, Revenue Reassignment Receiver Count
C_CostRevnReassgmtSenderCount view from CONSUMPTION Cost, Revenue Reassignment Sender Count
C_CostRevnReassgmtSenderCount view union_all CONSUMPTION Cost, Revenue Reassignment Sender Count
C_DrctActyAllocSenderCount view from CONSUMPTION Direct Activity Allocation Sender Count
C_JrnlEntrItmWeekendPostg view from CONSUMPTION Journal Entry Item Postings on Weekends
C_MnllyCreatedJournalEntry view from CONSUMPTION Manual Postings created by dialog IDs
C_NoTrdgPartIntcoJrnlEntr view from CONSUMPTION No Trading Partner Intercompany JE
C_PE_StRpAstJrnlEntryItemC view_entity from CONSUMPTION Asset Journal Entry Item for Peru - Cube
C_ProjBillgElmntEntrSrceAttrib view inner CONSUMPTION Proj Billg Elmnt Entr Source Attributes
C_ProjBillgRequestItemWithErr view inner CONSUMPTION PBR excluded posting items
C_SameAcctDescJrnlEntrItm view from CONSUMPTION Same G/L Account and Description JE Item
C_SameAmtDescJrnlEntrItm view from CONSUMPTION Same Amount and Description JE Item
C_SameGLAcctAmtJrnlEntrItm view from CONSUMPTION Same G/L Account and Amount JE Item
FIN_SubValProfSegmentLineitem view_entity from Profitability Segment Substitution
FIS_COGS view from Cost of Goods Sold
I_AcctgNotifJournalEntry view_entity from COMPOSITE Accounting Notification Journal Entry
I_AROAccrualPostings view from BASIC ARO Accrual Postings
I_CashGeneralLedgerBalance view_entity from COMPOSITE General Ledger Balance from Cash
I_CO_DIANVatTaxReturnBox view_entity inner COMPOSITE
I_CostRevenueReassignmentItem view from COMPOSITE Cost, Revenue Reassgmt Item - Basic
I_CostRevenueReassignmentItem view union_all COMPOSITE Cost, Revenue Reassgmt Item - Basic
I_DirectActivityAllocationItem view from COMPOSITE Direct Activity Allocation Item
I_DrctActyAllocCoCodeCount view from COMPOSITE Direct Activity Allocation - CoCd Count
I_GLAccountLineItem view from BASIC General Ledger Account Line Item
I_JournalEntryItem view from BASIC Journal Entry Item
I_JVAActualBudgetLineItem view left_outer COMPOSITE Actual Cost and JV Budget
I_JVAActualCashCallLineItem view from COMPOSITE Actual Cost and Cash Call for UJE
I_JVAGrossNetAmtByCostObjC view from COMPOSITE Gross and Net Amounts - Cube
I_MaintenanceOrderCostBalance view_entity from COMPOSITE Calculates Balance per Ledger
I_MaintOrderCostSettlement view_entity from COMPOSITE Calculates Settlement per Ledger
I_NO_SAFTCustomerMasterData view_entity union_all COMPOSITE Master data of customers for SAFT
I_NO_SAFTCustomersInPeriod view_entity from COMPOSITE List of all customers in report period
I_NO_SAFTSupplierMasterData view_entity union_all COMPOSITE Master data of suppliers for SAFT
I_NO_SAFTSuppliersInPeriod view_entity from COMPOSITE List of all customers in report period
I_RO_SAFTMatlStockValue view from COMPOSITE Material Stock Value for Romania SAFT
I_RO_SAFTStockMovementLine view from COMPOSITE Stock Movement Line Items
I_USFedAPInvoiceStatusCube view_entity from COMPOSITE US Fed AP Invoice Status - Cube
I_USFedAPInvoiceTradingPartner view_entity from BASIC AP Invoice Trading Partner details
P_ActlHrsInLdgrForProjects view from COMPOSITE
P_ActualsForEngmntProject view inner COMPOSITE
P_ActvENTERPRISEPROJCMTMTCOSTS view inner COMPOSITE
P_ACTVENTPROJACTCOSTSFORLEDGER view inner COMPOSITE
P_AllocRunJournalEntryItem1 view inner CONSUMPTION
P_AR_CashJournalEntry view_entity inner COMPOSITE
P_AR_GLAccountItem view_entity inner COMPOSITE
P_CO_DIANFrmt1007JrnlEntrItem view_entity inner CONSUMPTION
P_CostAccountingDocument view from COMPOSITE
P_CostCenterActualPlan view union_all COMPOSITE
P_CostCenterBudget view from COMPOSITE
P_CostCenterBudget view union_all COMPOSITE
P_CostCenterCommitmentUnion view union_all COMPOSITE
P_CostCenterCommitmentUnion_2 view union_all COMPOSITE
P_DirectActivityAllocation view from COMPOSITE
P_EngmntProjGLAcctRawData view from COMPOSITE
P_EnterpriseProjectActCosts view from COMPOSITE
P_EnterpriseProjectCmtmtCosts view from COMPOSITE
P_ENTPROJECTACTCOSTS view inner COMPOSITE
P_ENTPROJECTCMTMTCOSTS view inner COMPOSITE
P_EventBasedTotalVariance view_entity from COMPOSITE Event based total variance
P_EventBasedTotalVarianceRvsl view_entity from COMPOSITE Event based total variance reversal
P_EvtBsdRevnRecgnProjWipJrnAmt view inner COMPOSITE
P_EvtBsdRevnRecgnProjWIPNpi view inner COMPOSITE
P_FxdAstActualLineItem view from COMPOSITE
P_FxdAstActualLineItem view union_all COMPOSITE
P_GLAcctMaxPostgDteBfrKDte view from CONSUMPTION GL accounts with last posting date
P_GLIncgOrdPrdtvAnalysisUnion view from COMPOSITE
P_GLIncgOrdPrdtvAnalysisUnion view union_all COMPOSITE
P_GranteeMgmtMnlBilledItem view inner COMPOSITE Grantee Management Manual Billed Items
P_GranteeMgmtRRBBilledItem view inner COMPOSITE Grantee Management RRB Billed Items
P_GRIRAccountRecncln1 view_entity from COMPOSITE
P_GrossMarginUnion_2 view from COMPOSITE
P_GrossMarginUnion_2 view union_all COMPOSITE
P_JP_TradeCreditBalanceItems4 view left_outer CONSUMPTION View for Trade Credit Check Detail Items4
P_ManageJournalEntryLedgerView view_entity from COMPOSITE
P_ManageJournalEntryLedgerView view_entity union_all COMPOSITE
P_ML_Balance_Bcf view inner COMPOSITE
P_MngJrnlEntrPrdtvDocument view_entity from COMPOSITE Predictive Journal Entry
P_MngJrnlEntryLedgerViewAmount view_entity from COMPOSITE Journal Entry
P_MngJrnlEntryLedgerViewAmount view_entity union COMPOSITE Journal Entry
P_MngProjDmndWorkActual view from COMPOSITE
P_MX_GLAcctWithJournalEntry view inner COMPOSITE
P_NoTrdgPartIntcoJrnlEntr view from CONSUMPTION No Trading Partner Intercompany JE
P_PE_PurDmstcSuplrEntryAggrgd view inner CONSUMPTION
P_PE_PurFrgnSuplrJEItemAggrgd view from CONSUMPTION
P_PE_StRpGLAcctLineItemDocSel view_entity from CONSUMPTION
P_PE_StRpJournalEntryItem view from CONSUMPTION Journal Entry Item for Peru in StRp
P_PPM_PrjActCostLineitems view from COMPOSITE
P_PPM_PrjActCstLineItemsSemTag view from COMPOSITE
P_PrimaNotaEntriesNotSettled view_entity from COMPOSITE Prima nota entries not settled
P_PrimaNotaEntriesWithoutEBWP view_entity from COMPOSITE Prima nota entries without EBWP posting
P_PrimaNotaWithoutOitEBDP view_entity from COMPOSITE Prima nota entries without header to item EBDP posting
P_PrimaNotaWithoutOthRcvEBDP view_entity from COMPOSITE Prima nota entries without other receiver EBDP posting
P_PROJACTUALBUDGETLINEITEMS view inner COMPOSITE
P_PROJCMTMTBUDGETLINEITMS view inner COMPOSITE Project Budget Commitment
P_PROJCMTMTBUDGETLINEITMS view union_all COMPOSITE Project Budget Commitment
P_ProjectActualCostLineItem view from COMPOSITE
P_ProjectActualCostLineItem view union_all COMPOSITE
P_RblsItmForKeyDteDuePerd1b view from COMPOSITE
P_RblsItmForKeyDteDuePerd3A view from COMPOSITE
P_RealTimePCCInspPostedVarc view from COMPOSITE
P_RealTimePCCInspPostedWIP view from COMPOSITE
P_RealTimePCCPostedVarc view from COMPOSITE
P_RealTimePCCPostedWIP view from COMPOSITE
P_RO_SAFTAccountMapping view inner CONSUMPTION SAFT RO Account Mapping
P_RO_SAFTBP view inner CONSUMPTION
P_RTPC_REM_Order_Actual_Cost view from COMPOSITE
P_RTPC_REM_UnsettledActualCost view from COMPOSITE
P_RTPCOrderWIPReserve view from COMPOSITE
P_RTPCOrderWIPReserve view union COMPOSITE
P_SameAcctDescJrnlEntrItm view from CONSUMPTION Same G/L Account and Description JE Item
P_SameAmtDescJrnlEntrItm view from CONSUMPTION Same Amount and Description JE Item
P_SameGLAcctAmtJrnlEntrItm view from CONSUMPTION Same G/L Account and Amount JE Item
P_SettlementActualSettledValue view inner CONSUMPTION
P_SI_CBRGLAcctLineItemPrprocg view_entity from COMPOSITE
P_StkPostgHistAcctg view_entity from COMPOSITE Stock posting history accounting document
P_StkPostgHistAcctgNoStkQty view_entity from COMPOSITE Stock posting history acc document with stock quantity 0
P_StkPostgHistBasic view_entity union_all COMPOSITE Stock posting history basic view
P_StkPostgHistBasicNoReversal view_entity union_all COMPOSITE Stock posting history documents without reversal
P_USFedObligationStatus view_entity from COMPOSITE Obligation Status Basic View
P_USFedRblStatusBasic view_entity from COMPOSITE
P_USFedStatusOfFund view_entity from COMPOSITE Status of Funding
P_VE_StRpSupplierCustomerItem view_entity inner COMPOSITE
P_WorkCenterActlPlnUnion view from COMPOSITE
R_CostAccountingLineItem view_entity from COMPOSITE Cost Accounting Line Item
R_CostRevnProfitabilitySegment view_entity from COMPOSITE Cost Revenue Reassignment Profitability Segment
R_SetlMgmtUnivJrnlEntrBizVol view_entity from BASIC ACDOCA entries for Business Volume

Fields (582)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,JournalEntry 60
KEY AccountingDocumentItem AccountingDocumentItem 12
KEY AssetDepreciationArea AssetDepreciationArea 7
KEY BusinessArea BusinessArea 20
KEY CompanyCode CompanyCode,CompanyCodeForEdit 60
KEY ControllingArea ControllingArea,ControllingAreaForEdit 33
KEY ControllingObject ControllingObject,PartnerControllingObject 12
KEY Customer Customer 25
KEY FinancialAccountType FinancialAccountType 20
KEY FiscalPeriod FiscalPeriod 26
KEY FiscalYear FiscalYear,FiscalYearForEdit,PostingFiscalYear 57
KEY FiscalYearPeriod FiscalYearPeriod 23
KEY FixedAsset FixedAsset 7
KEY FunctionalArea FunctionalArea 23
KEY GLAccount GLAccount 34
KEY LedgerFiscalYear LedgerFiscalYear 20
KEY LedgerGLLineItem LedgerGLLineItem,LedgerGLLineItemForEdit 48
KEY MasterFixedAsset MasterFixedAsset 7
KEY OrderID InternalOrder,MaintenanceOrder,ManufacturingOrder,ObjectInternalID,OrderID,ProductionOrder,ProjectObjectNode 32
KEY OrderItem ManufacturingOrderItem,OrderItem 12
KEY PartnerCostCenter CostCenter,PartnerCostCenter 13
KEY PartnerCostCtrActivityType ActivityType,PartnerCostCtrActivityType 9
KEY Plant Plant 18
KEY PostingDate MatlDocLatestPostgDate,PostingDate 40
KEY Product Material,Product 16
KEY ProfitCenter ProfitCenter 26
KEY ProjectInternalID ProjectInternalID 13
KEY ReferenceDocument ReferenceDocument 18
KEY ReferenceDocumentContext ReferenceDocumentContext 14
KEY ReferenceDocumentItem ReferenceDocumentItem,ReferenceDocumentItemForEdit 12
KEY ReferenceDocumentType ReferenceDocumentType 23
KEY SourceLedger Ledger,SourceLedger 55
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType 7
KEY Supplier Supplier 18
KEY WorkCenterInternalID WorkCenterInternalID 4
_AccountAssignmentType _AccountAssignmentType 2
_AccountingDocumentCategory _AccountingDocumentCategory 2
_AccountingDocumentType _AccountingDocumentType 10
_AccrualItemType _AccrualItemType 1
_AccrualObject _AccrualObject 1
_AccrualObjectType _AccrualObjectType 1
_AccrualSubobject _AccrualSubobject 1
_AdditionalQuantity1Unit _AdditionalQuantity1Unit 1
_AdditionalQuantity2Unit _AdditionalQuantity2Unit 1
_AdditionalQuantity3Unit _AdditionalQuantity3Unit 1
_AlternativeGLAccount _AlternativeGLAccount 3
_Assembly _Assembly 1
_AssetTransactionType _AssetTransactionType 1
_BalanceTransactionCurrency _BalanceTransactionCurrency 2
_BaseUnit _BaseUnit 2
_BillableControl _BillableControl 1
_BillingDocumentType _BillingDocumentType 1
_BillToParty _BillToParty 1
_BudgetPeriod _BudgetPeriod 2
_BusinessArea _BusinessArea 3
_BusinessProcess _BusinessProcess 1
_BusinessTransactionCategory _BusinessTransactionCategory 2
_BusinessTransactionType _BusinessTransactionType 6
_CalendarDate _CalendarDate 2
_CashLedgerAccount _CashLedgerAccount 2
_CashLedgerCompanyCode _CashLedgerCompanyCode 2
_ChartOfAccounts _ChartOfAccounts 8
_ClearingJournalEntry _ClearingJournalEntry 2
_ClearingJrnlEntryFiscalYear _ClearingJrnlEntryFiscalYear 1
_CnsldtnFinancialStatementItem _CnsldtnFinancialStatementItem 2
_CnsldtnSubitem _CnsldtnSubitem 2
_CnsldtnSubitemCategory _CnsldtnSubitemCategory 2
_Company _Company 2
_CompanyCode _CompanyCode,_CompanyCodeText 16
_CompanyCodeCurrency _CompanyCodeCurrency 9
_ConditionContract _ConditionContract 1
_ConsolidationChartOfAccounts _ConsolidationChartOfAccounts 2
_ConsolidationUnit _ConsolidationUnit 1
_ControllingArea _ControllingArea 8
_ControllingObjectClass _ControllingObjectClass 1
_CostAnalysisResource _CostAnalysisResource 1
_CostCenter _CostCenter 7
_CostCtrActivityType _CostCtrActivityType 1
_CostOriginGroup _CostOriginGroup 1
_CostSourceUnit _CostSourceUnit 2
_CountryChartOfAccounts _CountryChartOfAccounts 3
_CreditRiskClass _CreditRiskClass 1
_Customer _Customer 11
_CustomerCompany _CustomerCompany 3
_CustomerGroup _CustomerGroup 1
_CustomerSupplierCountry _CustomerSupplierCountry 1
_DebitCreditCode _DebitCreditCode 7
_DistributionChannel _DistributionChannel 1
_EliminationProfitCenter _EliminationProfitCenter 1
_Equipment _Equipment 1
_FinancialAccountType _FinancialAccountType 7
_FinancialManagementArea _FinancialManagementArea 2
_FinancialTransactionType _FinancialTransactionType 3
_FinValuationObjectType _FinValuationObjectType 1
_FiscalCalendarDate _FiscalCalendarDate 1
_FiscalPeriodForVariant _FiscalPeriodForVariant 2
_FiscalYear _FiscalYear 8
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant 1
_FiscalYearVariant _FiscalYearVariant 6
_FixedAsset _FixedAsset 1
_FreeDefinedCurrency1 _FreeDefinedCurrency1 3
_FreeDefinedCurrency2 _FreeDefinedCurrency2 3
_FreeDefinedCurrency3 _FreeDefinedCurrency3 3
_FreeDefinedCurrency4 _FreeDefinedCurrency4 3
_FreeDefinedCurrency5 _FreeDefinedCurrency5 3
_FreeDefinedCurrency6 _FreeDefinedCurrency6 3
_FreeDefinedCurrency7 _FreeDefinedCurrency7 3
_FreeDefinedCurrency8 _FreeDefinedCurrency8 3
_FunctionalArea _FunctionalArea 5
_FunctionalCurrency _FunctionalCurrency 2
_Fund _Fund 2
_FundedProgram _FundedProgram 3
_FundsCenter _FundsCenter 2
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 6
_GLAccountInCompanyCode _GLAccountInCompanyCode 7
_GLAccountType _GLAccountType 2
_GlobalCurrency _GlobalCurrency 4
_Grant _Grant 2
_GroupFixedAsset _GroupFixedAsset 1
_GroupMasterFixedAsset _GroupMasterFixedAsset 1
_InventorySpclStkSalesDocItm _InventorySpclStkSalesDocItm 1
_InventorySpclStkSalesDocument _InventorySpclStkSalesDocument 1
_InventorySpclStockValnType _InventorySpclStockValnType 1
_InventorySpecialStockSupplier _InventorySpecialStockSupplier 1
_InventorySpecialStockType _InventorySpecialStockType 1
_InventoryValuationType _InventoryValuationType 1
_InvtrySpclStockWBSElmntBasic _InvtrySpclStockWBSElmntBasic 1
_JournalEntry _JournalEntry 9
_Ledger _Ledger,_SourceLedger 8
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant 6
_MaintenanceActivityType _MaintenanceActivityType 1
_MaintenanceOrder _MaintenanceOrder 1
_MaintenanceOrderOperation _MaintenanceOrderOperation 1
_MaintenanceOrderSubOperation _MaintenanceOrderSubOperation 1
_MasterFixedAsset _MasterFixedAsset 1
_MovementCategory _MovementCategory 1
_OffsettingAccount _OffsettingAccount 2
_OffsettingAccountType _OffsettingAccountType 2
_OffsettingChartOfAccounts _OffsettingChartOfAccounts 2
_OperatingConcern _OperatingConcern 1
_Order _Order 4
_OrderCategory _OrderCategory 1
_OriginCostCenter _OriginCostCenter 1
_OriginCostCtrActivityType _OriginCostCtrActivityType 1
_OriginProduct _OriginProduct 2
_OriginProfitCenter _OriginProfitCenter 1
_OriginSenderObject _OriginSenderObject 1
_PartnerBudgetPeriod _PartnerBudgetPeriod 2
_PartnerBusinessArea _PartnerBusinessArea 2
_PartnerBusinessProcess _PartnerBusinessProcess 1
_PartnerCompany _PartnerCompany 2
_PartnerCompanyCode _PartnerCompanyCode 1
_PartnerConsolidationUnit _PartnerConsolidationUnit 1
_PartnerControllingObjectClass _PartnerControllingObjectClass 1
_PartnerCostCenter _PartnerCostCenter 2
_PartnerCostCtrActivityType _PartnerCostCtrActivityType 1
_PartnerFixedAsset _PartnerFixedAsset 2
_PartnerFunctionalArea _PartnerFunctionalArea 1
_PartnerFund _PartnerFund 1
_PartnerGrant _PartnerGrant 2
_PartnerMasterFixedAsset _PartnerMasterFixedAsset 2
_PartnerOrder _PartnerOrder 1
_PartnerOrderCategory _PartnerOrderCategory 1
_PartnerProfitCenter _PartnerProfitCenter 2
_PartnerProjectBasicData _PartnerProjectBasicData 1
_PartnerSalesDocument _PartnerSalesDocument 1
_PartnerSalesDocumentItem _PartnerSalesDocumentItem 1
_PartnerSegment _PartnerSegment 1
_PartnerServiceDocument _PartnerServiceDocument 1
_PartnerServiceDocumentItem _PartnerServiceDocumentItem 1
_PartnerServiceDocumentType _PartnerServiceDocumentType 1
_PartnerWBSElementBasicData _PartnerWBSElementBasicData 1
_Plant _Plant 1
_PostingKey _PostingKey 1
_PredecessorReferenceDocType _PredecessorReferenceDocType 1
_Product _Product 2
_ProductGroup_2 _ProductGroup 1
_ProfitCenter _ProfitCenter 7
_ProjectBasicData _ProjectBasicData 1
_ProviderContract _ProviderContract 3
_ProviderContractItem _ProviderContractItem 3
_PubSecBudgetAccount _PubSecBudgetAccount 2
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode 2
_PubSecBudgetCnsmpnAmtType _PubSecBudgetCnsmpnAmtType 2
_PubSecBudgetCnsmpnDate _PubSecBudgetCnsmpnDate 2
_PubSecBudgetCnsmpnFsclPeriod _PubSecBudgetCnsmpnFsclPeriod 2
_PubSecBudgetCnsmpnFsclYear _PubSecBudgetCnsmpnFsclYear 2
_PubSecBudgetCnsmpnType _PubSecBudgetCnsmpnType 2
_ReferenceDocumentType _ReferenceDocumentType 4
_ReferenceQuantityUnit _ReferenceQuantityUnit 2
_SalesDistrict _SalesDistrict 1
_SalesDocument _SalesDocument 4
_SalesDocumentItem _SalesDocumentItem 1
_SalesOrganization _SalesOrganization 1
_Segment _Segment 4
_SemTagGLAccount _SemTagGLAccount 1
_ServiceContract _ServiceContract 1
_ServiceContractItem _ServiceContractItem 1
_ServiceContractType _ServiceContractType 1
_ServiceDocument _ServiceDocument 4
_ServiceDocumentItem _ServiceDocumentItem 1
_ServiceDocumentType _ServiceDocumentType 1
_ShipToParty _ShipToParty 1
_SoldProduct _SoldProduct 1
_SoldProductGroup_2 _SoldProductGroup 1
_SpecialGLCode _SpecialGLCode 2
_SponsoredClass _SponsoredClass 1
_SponsoredProgram _SponsoredProgram 1
_SubLedgerAccLineItemType _SubLedgerAccLineItemType 1
_Supplier _Supplier 10
_SupplierCompany _SupplierCompany 2
_TaxCode _TaxCode 1
_TaxCountry _TaxCountry 2
_TimeSheetOvertimeCat _TimeSheetOvertimeCat 1
_TransactionCurrency _TransactionCurrency 6
_ValuationArea _ValuationArea 1
_WBSElementBasicData _WBSElementBasicData 1
_WorkCenter _WorkCenter 1
_WorkPackage _WorkPackage 1
_WorkPackageWorkItem _WorkPackageWorkItem 1
AccountAssignment AccountAssignment 7
AccountAssignmentNumber AccountAssignmentNumber 6
AccountAssignmentType AccountAssignmentType 10
AccountingDocCreatedByUser AccountingDocCreatedByUser 18
AccountingDocumentCategory AccountingDocumentCategory 11
AccountingDocumentType AccountingDocumentType 24
AccountingNotificationUUID AccountingNotificationUUID 2
AccrualItemType AccrualItemType 4
AccrualObject AccrualObject 4
AccrualObjectLogicalSystem AccrualObjectLogicalSystem 4
AccrualObjectType AccrualObjectType 4
AccrualReferenceObject AccrualReferenceObject 4
AccrualSubobject AccrualSubobject 4
AccrualValueDate AccrualValueDate 4
AdditionalQuantity1 AdditionalQuantity1 6
AdditionalQuantity1Unit AdditionalQuantity1Unit 6
AdditionalQuantity2 AdditionalQuantity2 6
AdditionalQuantity2Unit AdditionalQuantity2Unit 6
AdditionalQuantity3 AdditionalQuantity3 6
AdditionalQuantity3Unit AdditionalQuantity3Unit 6
AlternativeGLAccount AlternativeGLAccount 10
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 8
AmountInCompanyCodeCurrency ActAmountInCompanyCodeCurrency,ActualAmountInCompanyCodeCrcy,ActualCostAmtInCCCrcy,AmountInCompanyCodeCurrency,CmtmtCostInCCCrcy,TotAssgdAmtInCoCodeCurrency,TransactionAmountInLocalCrcy 33
AmountInFreeDefinedCurrency1 ActualAmountInFreeDfndCrcy1,AmountInFreeDefinedCurrency1 15
AmountInFreeDefinedCurrency2 ActualAmountInFreeDfndCrcy2,AmountInFreeDefinedCurrency2 15
AmountInFreeDefinedCurrency3 ActualAmountInFreeDfndCrcy3,AmountInFreeDefinedCurrency3 15
AmountInFreeDefinedCurrency4 ActualAmountInFreeDfndCrcy4,AmountInFreeDefinedCurrency4 15
AmountInFreeDefinedCurrency5 ActualAmountInFreeDfndCrcy5,AmountInFreeDefinedCurrency5 15
AmountInFreeDefinedCurrency6 ActualAmountInFreeDfndCrcy6,AmountInFreeDefinedCurrency6 15
AmountInFreeDefinedCurrency7 ActualAmountInFreeDfndCrcy7,AmountInFreeDefinedCurrency7 15
AmountInFreeDefinedCurrency8 ActualAmountInFreeDfndCrcy8,AmountInFreeDefinedCurrency8 15
AmountInFunctionalCurrency ActualAmountInFunctionalCrcy,AmountInFunctionalCurrency,CmtmtAmountInFunctionalCrcy 10
AmountInGlobalCurrency ActualAmountInGlobalCurrency,ActualCostInGlobalCrcy,AmountInGlobalCurrency,AmountInGroupCurrency,CmtmtCostInGlobalCurrency,TotAssgdAmtInGlobalCurrency 22
AmountInGrantCurrency AmountInGrantCurrency 4
AmountInObjectCurrency ActlCostInProjCrcy,AmountInObjectCurrency,CmtmtCostInProjCrcy 10
AmountInTransactionCurrency ActualAmountInTransactionCrcy,AmountInTransactionCurrency,CmtmtCostInTransacCrcy 15
Assembly Assembly 3
AssetAcctTransClassfctn AssetAcctTransClassfctn 6
AssetClass AssetClass 7
AssetTransactionType AssetTransactionType 6
AssetValueDate AssetValueDate 6
AssignmentReference AssignmentReference 8
BalanceTransactionCurrency BalanceTransactionCurrency 9
BaseUnit BaseUnit,UnitOfMeasure 10
BillableControl BillableControl 9
BillingDocumentType BillingDocumentType 7
BillToParty BillToParty 9
BudgetPeriod BudgetPeriod 8
BusinessProcess BusinessProcess 9
BusinessSolutionOrder BusinessSolutionOrder 5
BusinessSolutionOrderItem BusinessSolutionOrderItem 5
BusinessTransactionCategory BusinessTransactionCategory 8
BusinessTransactionType BusinessTransactionType 17
CashLedgerAccount CashLedgerAccount 4
CashLedgerCompanyCode CashLedgerCompanyCode 4
ChartOfAccounts ChartOfAccounts 26
ClearingAccountingDocument ClearingAccountingDocument 3
ClearingDate ClearingDate 14
ClearingDocFiscalYear ClearingDocFiscalYear 1
ClearingJournalEntry ClearingAccountingDocument,ClearingJournalEntry 8
ClearingJournalEntryFiscalYear ClearingDocFiscalYear,ClearingJournalEntryFiscalYear 7
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 5
CnsldtnSubitem CnsldtnSubitem 5
CnsldtnSubitemCategory CnsldtnSubitemCategory 5
CommitmentItem CommitmentItem 3
Company Company 5
CompanyCodeCurrency CompanyCodeCurrency 41
ConditionContract ConditionContract 6
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 5
ConsolidationUnit ConsolidationUnit 4
ControllingBusTransacType ControllingBusTransacType 11
ControllingDebitCreditCode ControllingDebitCreditCode 6
ControllingDocumentItem ControllingDocumentItem 5
ControllingObjectClass ControllingObjectClass 6
ControllingObjectCurrency ControllingObjectCurrency 10
ControllingObjectDebitType ControllingObjectDebitType 6
CostAnalysisResource CostAnalysisResource 6
CostCenter CostCenter 25
CostCtrActivityType CostCtrActivityType 11
CostEstimate CostEstimate 10
CostObject CostObject 9
CostOriginGroup CostOriginGroup 6
CostSourceUnit CostSourceUnit,MaterialBaseUnit,UnitOfMeasure 11
CountryChartOfAccounts CountryChartOfAccounts 9
CreationDate CreationDate 14
CreationDateTime CreationDateTime 6
CreditRiskClass CreditRiskClass 4
CustomerGroup CustomerGroup 9
CustomerServiceNotification CustomerServiceNotification 6
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 6
CustomerSupplierCountry CustomerSupplierCountry 9
CustomerSupplierIndustry CustomerSupplierIndustry 9
CutbackAccount CutbackAccount 5
CutbackCostObject CutbackCostObject 5
CutbackRun CutbackRun 4
DebitCreditCode DebitCreditCode 24
DepreciationFiscalPeriod DepreciationFiscalPeriod 6
DistributionChannel DistributionChannel 10
DocumentDate DocumentDate 28
DocumentItemText DocumentItemText 12
EarmarkedFundsDocument EarmarkedFundsDocument 2
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 2
EliminationProfitCenter EliminationProfitCenter 6
Equipment Equipment 3
ExchangeRateDate ExchangeRateDate 1
FinancialClosingStep FinancialClosingStep 2
FinancialDataSource FinancialDataSource 2
FinancialManagementArea FinancialManagementArea 9
FinancialServicesBranch FinancialServicesBranch 2
FinancialServicesProductGroup FinancialServicesProductGroup 2
FinancialTransactionType FinancialTransactionType 8
FinancialValuationObject FinancialValuationObject 4
FinancialValuationObjectType FinancialValuationObjectType 4
FinancialValuationSubobject FinancialValuationSubobject 4
FiscalYearVariant FiscalYearVariant 21
FixedAmountInCoCodeCrcy FixedAmountInCoCodeCrcy 4
FixedAmountInGlobalCrcy ActFixedAmountInGlobalCurrency,FixedAmountInGlobalCrcy 6
FixedAmountInTransCrcy FixedAmountInTransCrcy 2
FixedPriceVarcInGlobalCrcy FixedPriceVarcInGlobalCrcy 5
FixedQuantity FixedQuantity 6
FollowOnDocumentType FollowOnDocumentType 7
FreeDefinedCurrency1 FreeDefinedCurrency1 16
FreeDefinedCurrency2 FreeDefinedCurrency2 16
FreeDefinedCurrency3 FreeDefinedCurrency3 15
FreeDefinedCurrency4 FreeDefinedCurrency4 15
FreeDefinedCurrency5 FreeDefinedCurrency5 15
FreeDefinedCurrency6 FreeDefinedCurrency6 15
FreeDefinedCurrency7 FreeDefinedCurrency7 15
FreeDefinedCurrency8 FreeDefinedCurrency8 15
FunctionalCurrency FunctionalCurrency 12
FunctionalLocation FunctionalLocation 2
Fund Fund 8
FundedProgram FundedProgram 7
FundsCenter FundsCenter 7
GeneralLedgerAgingIncrement GeneralLedgerAgingIncrement 4
GeneralLedgerAgingScope GeneralLedgerAgingScope 4
GLAccountType GLAccountType 8
GLBusinessTransactionType GLBusinessTransactionType 3
GlobalCurrency GlobalCurrency,GroupCurrency 32
GLRecordType GLRecordType 7
GrantCurrency GrantCurrency 4
GrantID GrantID 7
GroupFixedAsset GroupFixedAsset 6
GroupMasterFixedAsset GroupMasterFixedAsset 6
GrpValnFixedAmtInGlobCrcy GrpValnFixedAmtInGlobCrcy 5
GrpValnFixedPrcVarcInGlobCrcy GrpValnFixedPrcVarcInGlobCrcy 5
GrpValnTotPrcVarcInGlobCrcy GrpValnTotPrcVarcInGlobCrcy 5
GteeMBudgetValidityNumber GteeMBudgetValidityNumber 3
HouseBank HouseBank 6
HouseBankAccount HouseBankAccount 6
IncmpltSummableValnFxdQty IncmpltSummableValnFxdQty 1
IncmpltSummableValnQty IncmpltSummableValnQty 1
IncmpltSummableValnQtyUnt IncmpltSummableValnQtyUnt 1
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm 7
InventorySpclStkSalesDocument InventorySpclStkSalesDocument 7
InventorySpclStockWBSElement InventorySpclStockWBSElement 1
InventorySpecialStockSupplier InventorySpecialStockSupplier 7
InventorySpecialStockType InventorySpecialStockType,SpecialStockType 7
InventorySpecialStockValnType InventorySpecialStockValnType,InvtrySpecialStockValnType_2 7
InventoryValuationType InventoryValuationType 10
InvoiceItemReference InvoiceItemReference 8
InvoiceReference InvoiceReference 8
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 8
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID 6
IsCommitment IsCommitment 11
IsOpenItemManaged IsOpenItemManaged 6
IsReversal IsReversal 14
IsReversed IsReversed 14
IsSettled IsSettled 9
IsSettlement IsSettlement 7
IsSupplierStockValuation IsSupplierStockValuation 3
ItemIsSplit ItemIsSplit 3
JointVenture JointVenture 8
JointVentureAccountingActivity JointVentureAccountingActivity 5
JointVentureBillingDate JointVentureBillingDate 5
JointVentureBillingType JointVentureBillingType 6
JointVentureCostRecoveryCode JointVentureCostRecoveryCode,JointVentureRecoveryCode 10
JointVentureEquityGroup JointVentureEquityGroup 8
JointVentureEquityType JointVentureEquityType 6
JointVentureOperationalDate JointVentureOperationalDate 5
JointVenturePartner JointVenturePartner 6
JointVentureProductionDate JointVentureProductionDate 5
JournalEntryItemCategory JournalEntryItemCategory 3
JrnlEntrAltvFYConsecutiveID JrnlEntrAltvFYConsecutiveID 4
JrnlEntryItemMigrationSource JrnlEntryItemMigrationSource 4
JrnlEntryItemObsoleteReason JrnlEntryItemObsoleteReason 6
JrnlPeriodEndClosingRunLogUUID JrnlPeriodEndClosingRunLogUUID 3
LastChangeDateTime LastChangeDateTime 11
LineItemIsCompleted LineItemIsCompleted 6
LogicalSystem LogicalSystem 7
MaintenanceActivityType MaintenanceActivityType 3
MaintenanceOrderIsPlanned MaintenanceOrderIsPlanned 3
MaintenanceOrderPlanningCode MaintenanceOrderPlanningCode 3
MaintPriority MaintPriority 3
MaintPriorityType MaintPriorityType 3
MaterialBaseUnit MaterialBaseUnit 2
MaterialDocument MaterialDocument 2
MaterialDocumentItem MaterialDocumentItem 2
MaterialDocumentYear MaterialDocumentYear 2
MaterialLedgerCategory MaterialLedgerCategory 3
MaterialLedgerProcessType MaterialLedgerProcessType 3
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit 2
NetDueDate NetDueDate 10
OffsettingAccount OffsettingAccount 8
OffsettingAccountType OffsettingAccountType 8
OffsettingChartOfAccounts OffsettingChartOfAccounts 6
OffsettingLedgerGLLineItem OffsettingLedgerGLLineItem 1
OperatingConcern OperatingConcern 8
OrderCategory OrderCategory 7
OrderOperation OrderOperation 5
OrderSuboperation OrderSuboperation 4
OrganizationalChange OrganizationalChange 4
OrganizationDivision OrganizationDivision 10
OriginCostCenter OriginCostCenter 7
OriginCostCtrActivityType ActivityType,OriginCostCtrActivityType 9
OriginCtrlgDebitCreditCode OriginCtrlgDebitCreditCode 3
OriginObjectType OriginObjectType 7
OriginOrder OriginOrder 1
OriginOrderOperation OriginOrderOperation 1
OriginProduct OriginProduct 4
OriginProfitCenter OriginProfitCenter 6
OriginSenderObject OriginSenderObject 6
PartnerAccountAssignment PartnerAccountAssignment 7
PartnerAccountAssignmentType PartnerAccountAssignmentType 10
PartnerBudgetPeriod PartnerBudgetPeriod 5
PartnerBusinessArea PartnerBusinessArea 8
PartnerBusinessProcess PartnerBusinessProcess 6
PartnerCompany PartnerCompany 7
PartnerCompanyCode PartnerCompanyCode 10
PartnerConsolidationUnit PartnerConsolidationUnit 4
PartnerControllingObjectClass PartnerControllingObjectClass 6
PartnerCostObject PartnerCostObject 6
PartnerEquityGroup PartnerEquityGroup 5
PartnerFixedAsset PartnerFixedAsset 4
PartnerFunctionalArea PartnerFunctionalArea 8
PartnerFund PartnerFund 5
PartnerGrant PartnerGrant 5
PartnerMasterFixedAsset PartnerMasterFixedAsset 4
PartnerOrder PartnerOrder 6
PartnerOrderCategory PartnerOrderCategory 9
PartnerOrderItem PartnerOrderItem 3
PartnerProfitCenter PartnerProfitCenter 11
PartnerProject PartnerProject 2
PartnerProjectInternalID PartnerProjectInternalID 6
PartnerProjectNetwork PartnerProjectNetwork 7
PartnerProjectNetworkActivity PartnerProjectNetworkActivity 4
PartnerSalesDocument PartnerSalesDocument 6
PartnerSalesDocumentItem PartnerSalesDocumentItem 6
PartnerSegment PartnerSegment 6
PartnerServiceDocument PartnerServiceDocument 6
PartnerServiceDocumentItem PartnerServiceDocumentItem 6
PartnerServiceDocumentType PartnerServiceDocumentType 6
PartnerSettlementReferenceDate PartnerSettlementReferenceDate 3
PartnerVenture PartnerVenture 4
PartnerWBSElement PartnerWBSElement,ProjectPartnerObject 2
PartnerWBSElementInternalID PartnerWBSElementInternalID 8
PerformanceObligation PerformanceObligation 2
PerformancePeriodEndDate PerformancePeriodEndDate 2
PerformancePeriodStartDate PerformancePeriodStartDate 2
PersonnelNumber PersonnelNumber 10
PostingKey PostingKey 8
PrdcssrJournalEntryCompanyCode PrdcssrJournalEntryCompanyCode 5
PrdcssrJournalEntryFiscalYear PrdcssrJournalEntryFiscalYear 5
PredecessorJournalEntry PredecessorJournalEntry 5
PredecessorJournalEntryItem PredecessorJournalEntryItem 5
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt 6
PredecessorReferenceDocItem PredecessorReferenceDocItem 7
PredecessorReferenceDocType PredecessorReferenceDocType 6
PredecessorReferenceDocument PredecessorReferenceDocument 8
PrftCtrValnFxdAmtInGlobCrcy PrftCtrValnFxdAmtInGlobCrcy 5
PrftCtrValnFxdPrcVarcInGlbCrcy PrftCtrValnFxdPrcVarcInGlbCrcy 5
PrftCtrValnTotPrcVarcInGlbCrcy PrftCtrValnTotPrcVarcInGlbCrcy 5
ProductGroup MaterialGroup,ProductGroup 5
ProductPriceControl ProductPriceControl 3
Project Project 2
ProjectNetwork ProjectNetwork 10
ProviderContract ProviderContract 5
ProviderContractItem ProviderContractItem 5
PubSecBudgetAccount PubSecBudgetAccount 4
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode 4
PubSecBudgetCnsmpnAmtType PubSecBudgetCnsmpnAmtType 4
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate 4
PubSecBudgetCnsmpnFsclPeriod PubSecBudgetCnsmpnFsclPeriod 4
PubSecBudgetCnsmpnFsclYear PubSecBudgetCnsmpnFsclYear 4
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 4
PubSecBudgetIsRelevant PubSecBudgetIsRelevant 4
PurchasingDocument PurchaseOrder,PurchasingDocument 11
PurchasingDocumentItem PurchaseOrderItem,PurchasingDocumentItem 10
Quantity ActlEffortQty,Quantity 10
QuantityIsIncomplete QuantityIsIncomplete 6
RealEstateBuilding RealEstateBuilding 5
RealEstateContract RealEstateContract 5
RealEstatePartnerBuilding RealEstatePartnerBuilding 3
RealEstatePartnerContract RealEstatePartnerContract 3
RealEstatePartnerProperty RealEstatePartnerProperty 3
RealEstateProperty RealEstateProperty 5
REBusinessEntity REBusinessEntity 5
ReferenceDocumentItemGroup ReferenceDocumentItemGroup 7
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory 6
ReferenceQuantity ReferenceQuantity 4
ReferenceQuantityUnit ReferenceQuantityUnit 4
RelatedNetworkActivity RelatedNetworkActivity 5
REPartnerBusinessEntity REPartnerBusinessEntity 3
REPartnerRentalObject REPartnerRentalObject 3
REPartnerServiceChargeKey REPartnerServiceChargeKey 3
REPartnerSettlementUnitID REPartnerSettlementUnitID 3
RERentalObject RERentalObject 5
REServiceChargeKey REServiceChargeKey 5
RESettlementUnitID RESettlementUnitID 5
RevenueAccountingContract RevenueAccountingContract 2
ReversalReferenceDocument ReversalReferenceDocument 12
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 8
ReversalTransactionSubitem ReversalTransactionSubitem 2
SalesDistrict SalesDistrict 9
SalesDocument SalesDocument 11
SalesDocumentItem SalesDocumentItem 10
SalesOrganization SalesOrganization 10
Segment Segment 13
SenderAccountAssignment SenderAccountAssignment 5
SenderAccountAssignmentType SenderAccountAssignmentType 5
SenderCompanyCode SenderCompanyCode 4
SenderCostRecoveryCode SenderCostRecoveryCode 6
SenderGLAccount SenderGLAccount 5
ServiceContract ServiceContract 6
ServiceContractItem ServiceContractItem 6
ServiceContractType ServiceContractType 6
ServiceDocument ServiceDocument 10
ServiceDocumentItem ServiceDocumentItem 9
ServiceDocumentType ServiceDocumentType 10
ServicesRenderedDate ServicesRenderedDate 7
SettlementReferenceDate SettlementReferenceDate 5
ShipToParty ShipToParty 9
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy 3
SoldProduct Product,SoldProduct 10
SoldProductGroup SoldProductGroup 9
SourceLogicalSystem SourceLogicalSystem 9
SourceReferenceDocSubitem SourceReferenceDocSubitem 9
SourceReferenceDocument SourceReferenceDocument 10
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt 9
SourceReferenceDocumentItem SourceReferenceDocumentItem 9
SourceReferenceDocumentType SourceReferenceDocumentType 9
SpecialGLCode SpecialGLCode 9
SponsoredClass SponsoredClass 4
SponsoredProgram SponsoredProgram 6
SuperiorOrder SuperiorOrder 3
TaxCode TaxCode 8
TaxCountry TaxCountry 5
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 7
TotalPriceVarcInGlobalCrcy TotalPriceVarcInGlobalCrcy 5
TransactionCurrency DocumentCurrency,TransactionCurrency 24
TransactionSubitem TransactionSubitem 6
TransactionTypeDetermination TransactionTypeDetermination 9
ValuationArea ValuationArea 9
ValuationFixedQuantity ValuationFixedQuantity 6
ValuationQuantity InventoryQty,MatlStkChangeQtyInBaseUnit,ValuationQuantity 10
ValueDate ValueDate 6
VarianceOriginGLAccount VarianceOriginGLAccount 4
VarianceOriginGroup VarianceOriginGroup 1
WBSElement WBSElement 3
WBSElementInternalID ObjectInternalID,WBSElementInternalID 18
WorkItem PartnerWorkItem,WorkItem 9
WorkPackage WorkPackage 6

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.

-- Raw Data of G/L Account Line Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTLINEITEMRAWDATA (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ASSETDEPRECIATIONAREA,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    CUSTOMER,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FIXEDASSET,
    FUNCTIONALAREA,
    GLACCOUNT,
    LEDGERFISCALYEAR,
    LEDGERGLLINEITEM,
    MASTERFIXEDASSET,
    ORDERID,
    ORDERITEM,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PROJECTINTERNALID,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTTYPE,
    SOURCELEDGER,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    WORKCENTERINTERNALID,
    _ACCOUNTASSIGNMENTTYPE,
    _ACCOUNTINGDOCUMENTCATEGORY,
    _ACCOUNTINGDOCUMENTTYPE,
    _ACCRUALITEMTYPE,
    _ACCRUALOBJECT,
    _ACCRUALOBJECTTYPE,
    _ACCRUALSUBOBJECT,
    _ADDITIONALQUANTITY1UNIT,
    _ADDITIONALQUANTITY2UNIT,
    _ADDITIONALQUANTITY3UNIT,
    _ALTERNATIVEGLACCOUNT,
    _ASSEMBLY,
    _ASSETTRANSACTIONTYPE,
    _BALANCETRANSACTIONCURRENCY,
    _BASEUNIT,
    _BILLABLECONTROL,
    _BILLINGDOCUMENTTYPE,
    _BILLTOPARTY,
    _BUDGETPERIOD,
    _BUSINESSAREA,
    _BUSINESSPROCESS,
    _BUSINESSTRANSACTIONCATEGORY,
    _BUSINESSTRANSACTIONTYPE,
    _CALENDARDATE,
    _CASHLEDGERACCOUNT,
    _CASHLEDGERCOMPANYCODE,
    _CHARTOFACCOUNTS,
    _CLEARINGJOURNALENTRY,
    _CLEARINGJRNLENTRYFISCALYEAR,
    _CNSLDTNFINANCIALSTATEMENTITEM,
    _CNSLDTNSUBITEM,
    _CNSLDTNSUBITEMCATEGORY,
    _COMPANY,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONDITIONCONTRACT,
    _CONSOLIDATIONCHARTOFACCOUNTS,
    _CONSOLIDATIONUNIT,
    _CONTROLLINGAREA,
    _CONTROLLINGOBJECTCLASS,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTCTRACTIVITYTYPE,
    _COSTORIGINGROUP,
    _COSTSOURCEUNIT,
    _COUNTRYCHARTOFACCOUNTS,
    _CREDITRISKCLASS,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _DEBITCREDITCODE,
    _DISTRIBUTIONCHANNEL,
    _ELIMINATIONPROFITCENTER,
    _EQUIPMENT,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FINANCIALTRANSACTIONTYPE,
    _FINVALUATIONOBJECTTYPE,
    _FISCALCALENDARDATE,
    _FISCALPERIODFORVARIANT,
    _FISCALYEAR,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FIXEDASSET,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _FUNCTIONALAREA,
    _FUNCTIONALCURRENCY,
    _FUND,
    _FUNDEDPROGRAM,
    _FUNDSCENTER,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTYPE,
    _GLOBALCURRENCY,
    _GRANT,
    _GROUPFIXEDASSET,
    _GROUPMASTERFIXEDASSET,
    _INVENTORYSPCLSTKSALESDOCITM,
    _INVENTORYSPCLSTKSALESDOCUMENT,
    _INVENTORYSPCLSTOCKVALNTYPE,
    _INVENTORYSPECIALSTOCKSUPPLIER,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYVALUATIONTYPE,
    _INVTRYSPCLSTOCKWBSELMNTBASIC,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEARFORVARIANT,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCEORDER,
    _MAINTENANCEORDEROPERATION,
    _MAINTENANCEORDERSUBOPERATION,
    _MASTERFIXEDASSET,
    _MOVEMENTCATEGORY,
    _OFFSETTINGACCOUNT,
    _OFFSETTINGACCOUNTTYPE,
    _OFFSETTINGCHARTOFACCOUNTS,
    _OPERATINGCONCERN,
    _ORDER,
    _ORDERCATEGORY,
    _ORIGINCOSTCENTER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _ORIGINPRODUCT,
    _ORIGINPROFITCENTER,
    _ORIGINSENDEROBJECT,
    _PARTNERBUDGETPERIOD,
    _PARTNERBUSINESSAREA,
    _PARTNERBUSINESSPROCESS,
    _PARTNERCOMPANY,
    _PARTNERCOMPANYCODE,
    _PARTNERCONSOLIDATIONUNIT,
    _PARTNERCONTROLLINGOBJECTCLASS,
    _PARTNERCOSTCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PARTNERFIXEDASSET,
    _PARTNERFUNCTIONALAREA,
    _PARTNERFUND,
    _PARTNERGRANT,
    _PARTNERMASTERFIXEDASSET,
    _PARTNERORDER,
    _PARTNERORDERCATEGORY,
    _PARTNERPROFITCENTER,
    _PARTNERPROJECTBASICDATA,
    _PARTNERSALESDOCUMENT,
    _PARTNERSALESDOCUMENTITEM,
    _PARTNERSEGMENT,
    _PARTNERSERVICEDOCUMENT,
    _PARTNERSERVICEDOCUMENTITEM,
    _PARTNERSERVICEDOCUMENTTYPE,
    _PARTNERWBSELEMENTBASICDATA,
    _PLANT,
    _POSTINGKEY,
    _PREDECESSORREFERENCEDOCTYPE,
    _PRODUCT,
    _PRODUCTGROUP_2,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _PROVIDERCONTRACT,
    _PROVIDERCONTRACTITEM,
    _PUBSECBUDGETACCOUNT,
    _PUBSECBUDGETACCOUNTCOCODE,
    _PUBSECBUDGETCNSMPNAMTTYPE,
    _PUBSECBUDGETCNSMPNDATE,
    _PUBSECBUDGETCNSMPNFSCLPERIOD,
    _PUBSECBUDGETCNSMPNFSCLYEAR,
    _PUBSECBUDGETCNSMPNTYPE,
    _REFERENCEDOCUMENTTYPE,
    _REFERENCEQUANTITYUNIT,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SEMTAGGLACCOUNT,
    _SERVICECONTRACT,
    _SERVICECONTRACTITEM,
    _SERVICECONTRACTTYPE,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTITEM,
    _SERVICEDOCUMENTTYPE,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP_2,
    _SPECIALGLCODE,
    _SPONSOREDCLASS,
    _SPONSOREDPROGRAM,
    _SUBLEDGERACCLINEITEMTYPE,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    _TAXCODE,
    _TAXCOUNTRY,
    _TIMESHEETOVERTIMECAT,
    _TRANSACTIONCURRENCY,
    _VALUATIONAREA,
    _WBSELEMENTBASICDATA,
    _WORKCENTER,
    _WORKPACKAGE,
    _WORKPACKAGEWORKITEM,
    ACCOUNTASSIGNMENT,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGNOTIFICATIONUUID,
    ACCRUALITEMTYPE,
    ACCRUALOBJECT,
    ACCRUALOBJECTLOGICALSYSTEM,
    ACCRUALOBJECTTYPE,
    ACCRUALREFERENCEOBJECT,
    ACCRUALSUBOBJECT,
    ACCRUALVALUEDATE,
    ADDITIONALQUANTITY1,
    ADDITIONALQUANTITY1UNIT,
    ADDITIONALQUANTITY2,
    ADDITIONALQUANTITY2UNIT,
    ADDITIONALQUANTITY3,
    ADDITIONALQUANTITY3UNIT,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINGRANTCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSEMBLY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCLASS,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BILLABLECONTROL,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUDGETPERIOD,
    BUSINESSPROCESS,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CASHLEDGERACCOUNT,
    CASHLEDGERCOMPANYCODE,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    CNSLDTNFINANCIALSTATEMENTITEM,
    CNSLDTNSUBITEM,
    CNSLDTNSUBITEMCATEGORY,
    COMMITMENTITEM,
    COMPANY,
    COMPANYCODECURRENCY,
    CONDITIONCONTRACT,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONUNIT,
    CONTROLLINGBUSTRANSACTYPE,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGDOCUMENTITEM,
    CONTROLLINGOBJECTCLASS,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLLINGOBJECTDEBITTYPE,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTESTIMATE,
    COSTOBJECT,
    COSTORIGINGROUP,
    COSTSOURCEUNIT,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONDATE,
    CREATIONDATETIME,
    CREDITRISKCLASS,
    CUSTOMERGROUP,
    CUSTOMERSERVICENOTIFICATION,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    CUTBACKACCOUNT,
    CUTBACKCOSTOBJECT,
    CUTBACKRUN,
    DEBITCREDITCODE,
    DEPRECIATIONFISCALPERIOD,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    ELIMINATIONPROFITCENTER,
    EQUIPMENT,
    EXCHANGERATEDATE,
    FINANCIALCLOSINGSTEP,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALTRANSACTIONTYPE,
    FINANCIALVALUATIONOBJECT,
    FINANCIALVALUATIONOBJECTTYPE,
    FINANCIALVALUATIONSUBOBJECT,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINCOCODECRCY,
    FIXEDAMOUNTINGLOBALCRCY,
    FIXEDAMOUNTINTRANSCRCY,
    FIXEDPRICEVARCINGLOBALCRCY,
    FIXEDQUANTITY,
    FOLLOWONDOCUMENTTYPE,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALCURRENCY,
    FUNCTIONALLOCATION,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GENERALLEDGERAGINGINCREMENT,
    GENERALLEDGERAGINGSCOPE,
    GLACCOUNTTYPE,
    GLBUSINESSTRANSACTIONTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    GRANTCURRENCY,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    GRPVALNFIXEDAMTINGLOBCRCY,
    GRPVALNFIXEDPRCVARCINGLOBCRCY,
    GRPVALNTOTPRCVARCINGLOBCRCY,
    GTEEMBUDGETVALIDITYNUMBER,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INCMPLTSUMMABLEVALNFXDQTY,
    INCMPLTSUMMABLEVALNQTY,
    INCMPLTSUMMABLEVALNQTYUNT,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    INVENTORYSPCLSTOCKWBSELEMENT,
    INVENTORYSPECIALSTOCKSUPPLIER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    INVENTORYVALUATIONTYPE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    INVTRYSPCLSTOCKWBSELMNTINTID,
    ISCOMMITMENT,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    ISSETTLED,
    ISSETTLEMENT,
    ISSUPPLIERSTOCKVALUATION,
    ITEMISSPLIT,
    JOINTVENTURE,
    JOINTVENTUREACCOUNTINGACTIVITY,
    JOINTVENTUREBILLINGDATE,
    JOINTVENTUREBILLINGTYPE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREEQUITYTYPE,
    JOINTVENTUREOPERATIONALDATE,
    JOINTVENTUREPARTNER,
    JOINTVENTUREPRODUCTIONDATE,
    JOURNALENTRYITEMCATEGORY,
    JRNLENTRALTVFYCONSECUTIVEID,
    JRNLENTRYITEMMIGRATIONSOURCE,
    JRNLENTRYITEMOBSOLETEREASON,
    JRNLPERIODENDCLOSINGRUNLOGUUID,
    LASTCHANGEDATETIME,
    LINEITEMISCOMPLETED,
    LOGICALSYSTEM,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERISPLANNED,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    MATERIALLEDGERCATEGORY,
    MATERIALLEDGERPROCESSTYPE,
    MATLSTKCHANGEQTYINBASEUNIT,
    NETDUEDATE,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGCHARTOFACCOUNTS,
    OFFSETTINGLEDGERGLLINEITEM,
    OPERATINGCONCERN,
    ORDERCATEGORY,
    ORDEROPERATION,
    ORDERSUBOPERATION,
    ORGANIZATIONALCHANGE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINCTRLGDEBITCREDITCODE,
    ORIGINOBJECTTYPE,
    ORIGINORDER,
    ORIGINORDEROPERATION,
    ORIGINPRODUCT,
    ORIGINPROFITCENTER,
    ORIGINSENDEROBJECT,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERBUDGETPERIOD,
    PARTNERBUSINESSAREA,
    PARTNERBUSINESSPROCESS,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCONTROLLINGOBJECTCLASS,
    PARTNERCOSTOBJECT,
    PARTNEREQUITYGROUP,
    PARTNERFIXEDASSET,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERGRANT,
    PARTNERMASTERFIXEDASSET,
    PARTNERORDER,
    PARTNERORDERCATEGORY,
    PARTNERORDERITEM,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTINTERNALID,
    PARTNERPROJECTNETWORK,
    PARTNERPROJECTNETWORKACTIVITY,
    PARTNERSALESDOCUMENT,
    PARTNERSALESDOCUMENTITEM,
    PARTNERSEGMENT,
    PARTNERSERVICEDOCUMENT,
    PARTNERSERVICEDOCUMENTITEM,
    PARTNERSERVICEDOCUMENTTYPE,
    PARTNERSETTLEMENTREFERENCEDATE,
    PARTNERVENTURE,
    PARTNERWBSELEMENT,
    PARTNERWBSELEMENTINTERNALID,
    PERFORMANCEOBLIGATION,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PERSONNELNUMBER,
    POSTINGKEY,
    PRDCSSRJOURNALENTRYCOMPANYCODE,
    PRDCSSRJOURNALENTRYFISCALYEAR,
    PREDECESSORJOURNALENTRY,
    PREDECESSORJOURNALENTRYITEM,
    PREDECESSORREFERENCEDOCCNTXT,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCTYPE,
    PREDECESSORREFERENCEDOCUMENT,
    PRFTCTRVALNFXDAMTINGLOBCRCY,
    PRFTCTRVALNFXDPRCVARCINGLBCRCY,
    PRFTCTRVALNTOTPRCVARCINGLBCRCY,
    PRODUCTGROUP,
    PRODUCTPRICECONTROL,
    PROJECT,
    PROJECTNETWORK,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNFSCLPERIOD,
    PUBSECBUDGETCNSMPNFSCLYEAR,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITY,
    QUANTITYISINCOMPLETE,
    REALESTATEBUILDING,
    REALESTATECONTRACT,
    REALESTATEPARTNERBUILDING,
    REALESTATEPARTNERCONTRACT,
    REALESTATEPARTNERPROPERTY,
    REALESTATEPROPERTY,
    REBUSINESSENTITY,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEPURCHASEORDERCATEGORY,
    REFERENCEQUANTITY,
    REFERENCEQUANTITYUNIT,
    RELATEDNETWORKACTIVITY,
    REPARTNERBUSINESSENTITY,
    REPARTNERRENTALOBJECT,
    REPARTNERSERVICECHARGEKEY,
    REPARTNERSETTLEMENTUNITID,
    RERENTALOBJECT,
    RESERVICECHARGEKEY,
    RESETTLEMENTUNITID,
    REVENUEACCOUNTINGCONTRACT,
    REVERSALREFERENCEDOCUMENT,
    REVERSALREFERENCEDOCUMENTCNTXT,
    REVERSALTRANSACTIONSUBITEM,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORGANIZATION,
    SEGMENT,
    SENDERACCOUNTASSIGNMENT,
    SENDERACCOUNTASSIGNMENTTYPE,
    SENDERCOMPANYCODE,
    SENDERCOSTRECOVERYCODE,
    SENDERGLACCOUNT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SETTLEMENTREFERENCEDATE,
    SHIPTOPARTY,
    SLSPRICEAMOUNTINCOCODECRCY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SPECIALGLCODE,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUPERIORORDER,
    TAXCODE,
    TAXCOUNTRY,
    TIMESHEETOVERTIMECATEGORY,
    TOTALPRICEVARCINGLOBALCRCY,
    TRANSACTIONCURRENCY,
    TRANSACTIONSUBITEM,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    VALUATIONFIXEDQUANTITY,
    VALUATIONQUANTITY,
    VALUEDATE,
    VARIANCEORIGINGLACCOUNT,
    VARIANCEORIGINGROUP,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ASSETDEPRECIATIONAREA, BUSINESSAREA, COMPANYCODE, CONTROLLINGAREA, CONTROLLINGOBJECT, CUSTOMER, FINANCIALACCOUNTTYPE, FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD, FIXEDASSET, FUNCTIONALAREA, GLACCOUNT, LEDGERFISCALYEAR, LEDGERGLLINEITEM, MASTERFIXEDASSET, ORDERID, ORDERITEM, PARTNERCOSTCENTER, PARTNERCOSTCTRACTIVITYTYPE, PLANT, POSTINGDATE, PRODUCT, PROFITCENTER, PROJECTINTERNALID, REFERENCEDOCUMENT, REFERENCEDOCUMENTCONTEXT, REFERENCEDOCUMENTITEM, REFERENCEDOCUMENTTYPE, SOURCELEDGER, SUBLEDGERACCTLINEITEMTYPE, SUPPLIER, WORKCENTERINTERNALID)
);