I_JVALINEITEMCUBE

CDS View

JVA Line Item - Cube

I_JVALINEITEMCUBE is a CDS View in S/4HANA. JVA Line Item - Cube. It contains 650 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
C_JVAInceptionToDateDetObjPg view from CONSUMPTION JVA Inception To Date Detail Object Page
C_JVAOperatorNetCostDetObjPg view from CONSUMPTION Operator Net Cost Detail Object Page
C_JVATotalCostDetailObjectPage view from CONSUMPTION Operator Net Cost Detail Object Page
C_JVAVentureGrossCostDetObjPg view from CONSUMPTION Venture Gross Cost Detail Object Page
C_JVAVentureWrkgCptlDetObjPg view from CONSUMPTION Object Page for Venture Working Capital
C_JVAYearToDateDetObjPg view from CONSUMPTION JVA Year To Date Detail Object Page
I_GrossBillByVntrC view from COMPOSITE Gross Bill By Venture - Cube
I_GrossPartNetByCostCtrC view from COMPOSITE Gross Partner Net By Cost Center
I_JntVntrGLAcctLineItemData view from COMPOSITE JVA GL Account Line Item - Cube
I_JntVntrRmngCutbackAmt view inner COMPOSITE JV Remaining Cutback Amount
I_JVACalculatedITDPerdData view inner COMPOSITE JVA Calculated ITD Period Data - Cube
I_JVACalculatedYTDPerdData view inner COMPOSITE JVA Calculated YearToDate Period - Cube
I_JVAJntInterestBillingCube view from COMPOSITE JVA Joint Interest Billing - Cube
I_JVAJntInterestBillingCube2 view_entity union COMPOSITE JVA Joint Interest Billing 2 - Cube
I_JVAJntInterestBillingCube2 view_entity from COMPOSITE JVA Joint Interest Billing 2 - Cube
I_JVALineItemEnhancedCube view_entity from COMPOSITE JVA Line Item Enhanced - Cube
I_JVAPartnerBillingCube view from COMPOSITE Joint Venture Partner Billing

Fields (650)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 13
KEY CompanyCode CompanyCode 15
KEY FiscalYear FiscalYear 13
KEY JointVenture JointVenture 15
KEY JointVentureEquityGroup JointVentureEquityGroup 14
KEY Ledger Ledger 15
KEY LedgerGLLineItem LedgerGLLineItem 13
_AccountAssignmentType _AccountAssignmentType 1
_AccountingDocHeader _AccountingDocHeader 1
_AccountingDocumentCategory _AccountingDocumentCategory 1
_AccountingDocumentType _AccountingDocumentType 2
_AccrualItemType _AccrualItemType 1
_AccrualObject _AccrualObject 1
_AccrualObjectType _AccrualObjectType 1
_AccrualSubobject _AccrualSubobject 1
_AdditionalQuantity1Unit _AdditionalQuantity1Unit 1
_AdditionalQuantity2Unit _AdditionalQuantity2Unit 1
_AdditionalQuantity3Unit _AdditionalQuantity3Unit 1
_AlternativeGLAccount _AlternativeGLAccount 1
_Assembly _Assembly 1
_AssetTransactionType _AssetTransactionType 2
_BalanceTransactionCurrency _BalanceTransactionCurrency 9
_BaseUnit _BaseUnit 2
_BillableControl _BillableControl 1
_BillingDocumentType _BillingDocumentType 1
_BillToParty _BillToParty 1
_BudgetPeriod _BudgetPeriod 1
_BusinessArea _BusinessArea 2
_BusinessProcess _BusinessProcess 1
_BusinessTransactionCategory _BusinessTransactionCategory 1
_BusinessTransactionType _BusinessTransactionType 1
_CalendarDate _CalendarDate 1
_CashLedgerAccount _CashLedgerAccount 1
_CashLedgerCompanyCode _CashLedgerCompanyCode 1
_ChartOfAccounts _ChartOfAccounts 5
_ClearingJournalEntry _ClearingJournalEntry 1
_ClearingJrnlEntryFiscalYear _ClearingJrnlEntryFiscalYear 1
_CnsldtnFinancialStatementItem _CnsldtnFinancialStatementItem 1
_CnsldtnSubitem _CnsldtnSubitem 1
_CnsldtnSubitemCategory _CnsldtnSubitemCategory 1
_Company _Company 1
_CompanyCode _CompanyCode 13
_CompanyCodeCurrency _CompanyCodeCurrency 13
_CompanyCodeText _CompanyCodeText 3
_ConditionContract _ConditionContract 1
_ConsolidationChartOfAccounts _ConsolidationChartOfAccounts 1
_ConsolidationUnit _ConsolidationUnit 1
_ControllingArea _ControllingArea 4
_ControllingAreaText _ControllingAreaText 3
_ControllingDebitCreditCode _ControllingDebitCreditCode 1
_ControllingObjectClass _ControllingObjectClass 1
_CorporateGroupAccount _CorporateGroupAccount 1
_CorporateGroupChartOfAccounts _CorporateGroupChartOfAccounts 1
_CostAnalysisResource _CostAnalysisResource 1
_CostCenter _CostCenter 4
_CostCenterText _CostCenterText 3
_CostCtrActivityType _CostCtrActivityType 1
_CostOriginGroup _CostOriginGroup 1
_CostSourceUnit _CostSourceUnit 1
_CountryChartOfAccounts _CountryChartOfAccounts 1
_CreditRiskClass _CreditRiskClass 1
_CurrentCostCenter _CurrentCostCenter 2
_CurrentProfitCenter _CurrentProfitCenter 2
_Customer _Customer 3
_CustomerCompany _CustomerCompany 1
_CustomerGroup _CustomerGroup 1
_CustomerSupplierCountry _CustomerSupplierCountry 1
_DebitCreditCode _DebitCreditCode 2
_DistributionChannel _DistributionChannel 2
_EliminationProfitCenter _EliminationProfitCenter 1
_Equipment _Equipment 1
_FinancialAccountType _FinancialAccountType 1
_FinancialManagementArea _FinancialManagementArea 1
_FinancialTransactionType _FinancialTransactionType 1
_FinValuationObjectType _FinValuationObjectType 1
_FiscalCalendarDate _FiscalCalendarDate 1
_FiscalPeriodCompanyCode _FiscalPeriod,_FiscalPeriodCompanyCode 3
_FiscalPeriodForVariant _FiscalPeriodForVariant 9
_FiscalPeriodLedger _FiscalPeriodLedger 3
_FiscalYear _FiscalYear 11
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant 2
_FiscalYearVariant _FiscalYearVariant 11
_FixedAsset _FixedAsset 2
_FreeDefinedCurrency1 _FreeDefinedCurrency1 13
_FreeDefinedCurrency2 _FreeDefinedCurrency2 13
_FreeDefinedCurrency3 _FreeDefinedCurrency3 13
_FreeDefinedCurrency4 _FreeDefinedCurrency4 13
_FreeDefinedCurrency5 _FreeDefinedCurrency5 13
_FreeDefinedCurrency6 _FreeDefinedCurrency6 13
_FreeDefinedCurrency7 _FreeDefinedCurrency7 13
_FreeDefinedCurrency8 _FreeDefinedCurrency8 13
_FunctionalArea _FunctionalArea 1
_FunctionalCurrency _FunctionalCurrency 3
_FunctionalLocation _FunctionalLocation 1
_Fund _Fund 1
_FundedProgram _FundedProgram 1
_FundsCenter _FundsCenter 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 5
_GLAccountInCompanyCode _GLAccountInCompanyCode 2
_GLAccountText _GLAccountText 1
_GLAccountTxt _GLAccountTxt 3
_GLAccountType _GLAccountType 3
_GlobalCurrency _GlobalCurrency 13
_Grant _Grant 1
_GroupFixedAsset _GroupFixedAsset 1
_GroupMasterFixedAsset _GroupMasterFixedAsset 1
_HouseBank _HouseBank 1
_HouseBankAccount _HouseBankAccount 1
_IncmpltSummableValnQtyUnt _IncmpltSummableValnQtyUnt 1
_InternalOrder _InternalOrder 1
_InventorySpclStkSalesDocItm _InventorySpclStkSalesDocItm 1
_InventorySpclStkSalesDocument _InventorySpclStkSalesDocument 1
_InventorySpecialStockSupplier _InventorySpecialStockSupplier 1
_InventorySpecialStockType _InventorySpecialStockType 1
_InventorySpecialStockValnType _InventorySpecialStockValnType 1
_InventoryValuationType _InventoryValuationType 1
_InvtrySpclStkWBSElmntBscData _InvtrySpclStkWBSElmntBscData 1
_InvtrySpclStockWBSElmntBasic _InvtrySpclStockWBSElmntBasic 1
_InvtrySpclStockWBSElmntExtID _InvtrySpclStockWBSElmntExtID 1
_InvtrySpclStockWBSElmntInfo _InvtrySpclStockWBSElmntInfo 1
_JntOpgAgrmt _JntOpgAgrmt 1
_JntOpgAgrmtText _JntOpgAgrmtText 1
_JntVntrBusinessPartner _JntVntrBusinessPartner 3
_JntVntrEquityGrp _JntVntrEquityGrp 5
_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster 3
_JntVntrRecoveryInd _JntVntrRecoveryInd 5
_JntVntrRecoveryIndText _JntVntrRecoveryIndText 3
_JointVentureDesc _JointVentureDesc 3
_JointVentureMasterFld _JointVentureMasterFld 11
_JointVentureOrderData _JointVentureOrderData 1
_JointVenturePayrollType _JointVenturePayrollType 2
_JournalEntry _JournalEntry 11
_JrnlEntryItemObsoleteRsn _JrnlEntryItemObsoleteRsn 1
_JVAGlobalCompanyParameter _JVAGlobalCompanyParameter 1
_JVALedger _JVALedger 1
_Ledger _Ledger 11
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant 11
_LogicalSystem _LogicalSystem 1
_MaintenanceActivityType _MaintenanceActivityType 1
_MaintenanceOrder _MaintenanceOrder 1
_MaintenanceOrderOperation _MaintenanceOrderOperation 1
_MaintenanceOrderSubOperation _MaintenanceOrderSubOperation 1
_MaintOrdPlngDegreeCode _MaintOrdPlngDegreeCode 1
_MasterFixedAsset _MasterFixedAsset 2
_MovementCategory _MovementCategory 1
_OffsettingAccount _OffsettingAccount 1
_OffsettingAccountType _OffsettingAccountType 1
_OffsettingAccountWithBP _OffsettingAccountWithBP 1
_OffsettingChartOfAccounts _OffsettingChartOfAccounts 1
_OperatingConcern _OperatingConcern 1
_Order _Order 4
_OrderBasic _OrderBasic 1
_OrderCategory _OrderCategory 1
_OriginCostCenter _OriginCostCenter 1
_OriginCostCtrActivityType _OriginCostCtrActivityType 1
_OriginCtrlgDebitCreditCode _OriginCtrlgDebitCreditCode 1
_OriginOrder _OriginOrder 1
_OriginProduct _OriginProduct 1
_OriginProfitCenter _OriginProfitCenter 1
_OriginSenderObject _OriginSenderObject 1
_PartnerBudgetPeriod _PartnerBudgetPeriod 1
_PartnerBusinessArea _PartnerBusinessArea 1
_PartnerBusinessProcess _PartnerBusinessProcess 1
_PartnerCompany _PartnerCompany 1
_PartnerCompanyCode _PartnerCompanyCode 1
_PartnerConsolidationUnit _PartnerConsolidationUnit 1
_PartnerControllingObjectClass _PartnerControllingObjectClass 1
_PartnerCostCenter _PartnerCostCenter 1
_PartnerCostCtrActivityType _PartnerCostCtrActivityType 1
_PartnerFixedAsset _PartnerFixedAsset 1
_PartnerFunctionalArea _PartnerFunctionalArea 1
_PartnerFund _PartnerFund 1
_PartnerGrant _PartnerGrant 1
_PartnerMasterFixedAsset _PartnerMasterFixedAsset 1
_PartnerOrder _PartnerOrder 1
_PartnerOrderCategory _PartnerOrderCategory 1
_PartnerOrderText _PartnerOrderText 1
_PartnerProfitCenter _PartnerProfitCenter 1
_PartnerProjectBasicData _PartnerProjectBasicData 1
_PartnerProjectExternalID _PartnerProjectExternalID 1
_PartnerProjectExternalIDText _PartnerProjectExternalIDText 1
_PartnerSalesDocument _PartnerSalesDocument 1
_PartnerSalesDocumentItem _PartnerSalesDocumentItem 1
_PartnerSegment _PartnerSegment 1
_PartnerServiceDocument _PartnerServiceDocument 1
_PartnerServiceDocumentItem _PartnerServiceDocumentItem 1
_PartnerServiceDocumentType _PartnerServiceDocumentType 1
_PartnerWBSElementBasicData _PartnerWBSElementBasicData 1
_PartnerWBSElementExternalID _PartnerWBSElementExternalID 1
_PartnerWBSExternalIDText _PartnerWBSExternalIDText 1
_PersonWorkAgreement_1 _PersonWorkAgreement_1 1
_Plant _Plant 1
_PMNotificationPriority _PMNotificationPriority 1
_PMNotificationPriorityType _PMNotificationPriorityType 1
_PostingKey _PostingKey 1
_PredecessorReferenceDocType _PredecessorReferenceDocType 1
_Product _Product 1
_ProductGroup_2 _ProductGroup_2 1
_ProfitCenter _ProfitCenter 2
_ProjectBasicData _ProjectBasicData 1
_ProjectExternalID _ProjectExternalID 1
_ProjectExternalIDText _ProjectExternalIDText 1
_ProjectNetwork _ProjectNetwork 3
_ProjectNetworkText _ProjectNetworkText 1
_ProviderContract _ProviderContract 1
_ProviderContractItem _ProviderContractItem 1
_PubSecBudgetAccount _PubSecBudgetAccount 1
_PubSecBudgetAccountCoCode _PubSecBudgetAccountCoCode 1
_PubSecBudgetCnsmpnAmtType _PubSecBudgetCnsmpnAmtType 1
_PubSecBudgetCnsmpnDate _PubSecBudgetCnsmpnDate 1
_PubSecBudgetCnsmpnFsclPeriod _PubSecBudgetCnsmpnFsclPeriod 1
_PubSecBudgetCnsmpnFsclYear _PubSecBudgetCnsmpnFsclYear 1
_PubSecBudgetCnsmpnType _PubSecBudgetCnsmpnType 1
_PurchasingDocument _PurchasingDocument 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
_PurReqValuationArea _PurReqValuationArea 1
_ReferenceDocumentType _ReferenceDocumentType 1
_ReferenceQuantityUnit _ReferenceQuantityUnit 1
_SalesDistrict _SalesDistrict 1
_SalesDocument _SalesDocument 2
_SalesDocumentItem _SalesDocumentItem 1
_SalesOrganization _SalesOrganization 1
_Segment _Segment 1
_SemTagGLAccount _SemTagGLAccount 1
_ServiceContract _ServiceContract 1
_ServiceContractItem _ServiceContractItem 1
_ServiceContractType _ServiceContractType 1
_ServiceDocument _ServiceDocument 2
_ServiceDocumentItem _ServiceDocumentItem 1
_ServiceDocumentType _ServiceDocumentType 1
_ShipToParty _ShipToParty 1
_SoldProduct _SoldProduct 1
_SoldProductGroup_2 _SoldProductGroup_2 1
_SourceLedger _SourceLedger 1
_SpecialGLCode _SpecialGLCode 1
_SponsoredClass _SponsoredClass 1
_SponsoredProgram _SponsoredProgram 1
_SubLedgerAccLineItemType _SubLedgerAccLineItemType 1
_SuperiorOrder _SuperiorOrder 1
_Supplier _Supplier 2
_SupplierCompany _SupplierCompany 1
_TaxCode _TaxCode 1
_TaxCountry _TaxCountry 1
_TimeSheetOvertimeCat _TimeSheetOvertimeCat 1
_TransactionCurrency _TransactionCurrency 11
_User _User 1
_ValuationArea _ValuationArea 1
_WBSElementBasicData _WBSElementBasicData 4
_WBSElementExternalID _WBSElementExternalID 4
_WBSElementExternalIDText _WBSElementExternalIDText 3
_WBSElementInternalID _WBSElementInternalID 3
_WBSElementInternalIDText _WBSElementInternalIDText 3
_WorkCenter _WorkCenter 1
_WorkPackage _WorkPackage 1
_WorkPackageWorkItem _WorkPackageWorkItem 1
AccountAssignment AccountAssignment 1
AccountAssignmentNumber AccountAssignmentNumber 1
AccountAssignmentType AccountAssignmentType 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 4
AccrualItemType AccrualItemType 1
AccrualObject AccrualObject 1
AccrualObjectLogicalSystem AccrualObjectLogicalSystem 1
AccrualObjectType AccrualObjectType 1
AccrualReferenceObject AccrualReferenceObject 1
AccrualSubobject AccrualSubobject 1
AccrualValueDate AccrualValueDate 1
AdditionalQuantity1 AdditionalQuantity1 1
AdditionalQuantity1Unit AdditionalQuantity1Unit 1
AdditionalQuantity2 AdditionalQuantity2 1
AdditionalQuantity2Unit AdditionalQuantity2Unit 1
AdditionalQuantity3 AdditionalQuantity3 1
AdditionalQuantity3Unit AdditionalQuantity3Unit 1
AlternativeGLAccount AlternativeGLAccount 1
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy,ITDAmtInBlTCrcy,OperatorNetCostInBalTransCrcy,VntrGrossCostInBalTransCrcy,VntrWrkgCptlAmtInBalTransCrcy,YearToDateAmountInBalTransCrcy 7
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency,ITDAmtInCCrcy,OperatorNetCostInCoCodeCrcy,VntrGrossCostInCoCodeCrcy,VntrWrkgCptlAmtInCCrcy,YearToDateAmountInCoCodeCrcy 9
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1,ITDAmtInFDCrcy1,OperatorNetCostInFDCrcy1,VntrGrossCostInFDCrcy1,VntrWrkgCptlAmountInFDCrcy1,YearToDateAmountInFDCrcy1 9
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2,ITDAmtInFDCrcy2,OperatorNetCostInFDCrcy2,VntrGrossCostInFDCrcy2,VntrWrkgCptlAmountInFDCrcy2,YearToDateAmountInFDCrcy2 9
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3,ITDAmtInFDCrcy3,OperatorNetCostInFDCrcy3,VntrGrossCostInFDCrcy3,VntrWrkgCptlAmountInFDCrcy3,YearToDateAmountInFDCrcy3 9
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4,ITDAmtInFDCrcy4,OperatorNetCostInFDCrcy4,VntrGrossCostInFDCrcy4,VntrWrkgCptlAmountInFDCrcy4,YearToDateAmountInFDCrcy4 9
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5,ITDAmtInFDCrcy5,OperatorNetCostInFDCrcy5,VntrGrossCostInFDCrcy5,VntrWrkgCptlAmountInFDCrcy5,YearToDateAmountInFDCrcy5 9
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6,ITDAmtInFDCrcy6,OperatorNetCostInFDCrcy6,VntrGrossCostInFDCrcy6,VntrWrkgCptlAmountInFDCrcy6,YearToDateAmountInFDCrcy6 9
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7,ITDAmtInFDCrcy7,OperatorNetCostInFDCrcy7,VntrGrossCostInFDCrcy7,VntrWrkgCptlAmountInFDCrcy7,YearToDateAmountInFDCrcy7 9
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8,ITDAmtInFDCrcy8,OperatorNetCostInFDCrcy8,VntrGrossCostInFDCrcy8,VntrWrkgCptlAmountInFDCrcy8,YearToDateAmountInFDCrcy8 9
AmountInFunctionalCurrency AmountInFunctionalCurrency 3
AmountInGlobalCurrency AmountInGlobalCurrency,ITDAmtInGCrcy,OperatorNetCostInGCrcy,VntrGrossCostsInGCrcy,VntrWrkgCptlAmountInGCrcy,YearToDateAmountInGlobalCrcy 9
AmountInGrantCurrency AmountInGrantCurrency 1
AmountInJVAFundingCurrency AmountInJVAFundingCurrency 1
AmountInObjectCurrency AmountInObjectCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency,ITDAmtInTC,OperatorNetCostInTransCrcy,VntrGrossCostInTransCrcy,VntrWrkgCptlAmountInTransCrcy,YrToDteAmtInTransacCrcy 9
Assembly Assembly 1
AssetAcctTransClassfctn AssetAcctTransClassfctn 1
AssetClass AssetClass 4
AssetDepreciationArea AssetDepreciationArea 1
AssetTransactionType AssetTransactionType 6
AssetValueDate AssetValueDate 1
AssignmentReference AssignmentReference 1
BalanceTransactionCurrency BalanceTransactionCurrency 10
BaseUnit BaseUnit 4
BillableControl BillableControl 1
BillingDocumentType BillingDocumentType 1
BillToParty BillToParty 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 4
BusinessProcess BusinessProcess 1
BusinessSolutionOrder BusinessSolutionOrder 1
BusinessSolutionOrderItem BusinessSolutionOrderItem 1
BusinessTransactionCategory BusinessTransactionCategory 1
BusinessTransactionType BusinessTransactionType 1
CashLedgerAccount CashLedgerAccount 1
CashLedgerCompanyCode CashLedgerCompanyCode 1
ChartOfAccounts ChartOfAccounts 7
ClearingDate ClearingDate 1
ClearingJournalEntry ClearingJournalEntry 1
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear 1
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 1
CnsldtnSubitem CnsldtnSubitem 1
CnsldtnSubitemCategory CnsldtnSubitemCategory 1
CommitmentItem CommitmentItem 1
Company Company 1
CompanyCodeCurrency CompanyCodeCurrency 15
ConditionContract ConditionContract 1
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
ConsolidationUnit ConsolidationUnit 1
ControllingArea ControllingArea 6
ControllingBusTransacType ControllingBusTransacType 1
ControllingDebitCreditCode ControllingDebitCreditCode 1
ControllingDocumentItem ControllingDocumentItem 1
ControllingObject ControllingObject 1
ControllingObjectClass ControllingObjectClass 1
ControllingObjectCurrency ControllingObjectCurrency 1
ControllingObjectDebitType ControllingObjectDebitType 1
CorporateGroupAccount CorporateGroupAccount 1
CorporateGroupChartOfAccounts CorporateGroupChartOfAccounts 1
CostAnalysisResource CostAnalysisResource 1
CostCenter CostCenter 6
CostCtrActivityType CostCtrActivityType 1
CostEstimate CostEstimate 1
CostObject CostObject 1
CostOriginGroup CostOriginGroup 1
CostSourceUnit CostSourceUnit 1
CountryChartOfAccounts CountryChartOfAccounts 1
CreationDate CreationDate 1
CreationDateTime CreationDateTime 1
CreditRiskClass CreditRiskClass 1
Customer Customer 6
CustomerGroup CustomerGroup 1
CustomerServiceNotification CustomerServiceNotification 1
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 1
CustomerSupplierCountry CustomerSupplierCountry 1
CustomerSupplierIndustry CustomerSupplierIndustry 1
CutbackAccount CutbackAccount 1
CutbackCostObject CutbackCostObject 2
CutbackRun CutbackRun 2
DebitCreditCode DebitCreditCode 4
DepreciationFiscalPeriod DepreciationFiscalPeriod 1
DistributionChannel DistributionChannel 4
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
EarmarkedFundsDocument EarmarkedFundsDocument 1
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 1
EliminationProfitCenter EliminationProfitCenter 1
EmployeeFullName EmployeeFullName 1
Equipment Equipment 1
ExchangeRateDate ExchangeRateDate 1
FinancialAccountType FinancialAccountType 4
FinancialClosingStep FinancialClosingStep 1
FinancialDataSource FinancialDataSource 1
FinancialManagementArea FinancialManagementArea 1
FinancialServicesBranch FinancialServicesBranch 1
FinancialServicesProductGroup FinancialServicesProductGroup 1
FinancialTransactionType FinancialTransactionType 1
FinancialValuationObject FinancialValuationObject 1
FinancialValuationObjectType FinancialValuationObjectType 1
FinancialValuationSubobject FinancialValuationSubobject 1
FiscalPeriod FiscalPeriod 13
FiscalYearPeriod FiscalYearPeriod 2
FiscalYearVariant FiscalYearVariant 13
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy 1
FixedAsset FixedAsset 6
FixedPriceVarcInGlobalCrcy FixedPriceVarcInGlobalCrcy 1
FixedQuantity FixedQuantity 1
FollowOnDocumentType FollowOnDocumentType 1
FreeDefinedCurrency1 FreeDefinedCurrency1 14
FreeDefinedCurrency2 FreeDefinedCurrency2 14
FreeDefinedCurrency3 FreeDefinedCurrency3 14
FreeDefinedCurrency4 FreeDefinedCurrency4 14
FreeDefinedCurrency5 FreeDefinedCurrency5 14
FreeDefinedCurrency6 FreeDefinedCurrency6 14
FreeDefinedCurrency7 FreeDefinedCurrency7 14
FreeDefinedCurrency8 FreeDefinedCurrency8 14
FunctionalArea FunctionalArea 4
FunctionalCurrency FunctionalCurrency 3
FunctionalLocation FunctionalLocation 1
Fund Fund 1
FundedProgram FundedProgram 1
FundsCenter FundsCenter 1
GeneralLedgerAgingIncrement GeneralLedgerAgingIncrement 1
GeneralLedgerAgingScope GeneralLedgerAgingScope 1
GLAccount GLAccount 6
GLAccountType GLAccountType 6
GLBusinessTransactionType GLBusinessTransactionType 1
GlobalCurrency GlobalCurrency 14
GLRecordType GLRecordType 4
GrantCurrency GrantCurrency 1
GrantID GrantID 1
GroupFixedAsset GroupFixedAsset 1
GroupMasterFixedAsset GroupMasterFixedAsset 1
GrpValnFixedAmtInGlobCrcy GrpValnFixedAmtInGlobCrcy 1
GrpValnFixedPrcVarcInGlobCrcy GrpValnFixedPrcVarcInGlobCrcy 1
GrpValnTotPrcVarcInGlobCrcy GrpValnTotPrcVarcInGlobCrcy 1
GteeMBudgetValidityNumber GteeMBudgetValidityNumber 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
IncmpltSummableValnFxdQty IncmpltSummableValnFxdQty 1
IncmpltSummableValnQty IncmpltSummableValnQty 1
IncmpltSummableValnQtyUnt IncmpltSummableValnQtyUnt 1
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm 1
InventorySpclStkSalesDocument InventorySpclStkSalesDocument 1
InventorySpecialStockSupplier InventorySpecialStockSupplier 1
InventorySpecialStockType InventorySpecialStockType 1
InventorySpecialStockValnType InventorySpecialStockValnType 1
InventoryValuationType InventoryValuationType 1
InvoiceItemReference InvoiceItemReference 1
InvoiceReference InvoiceReference 1
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID 1
IsBalanceSheetAccount IsBalanceSheetAccount 1
IsCommitment IsCommitment 1
IsOpenItemManaged IsOpenItemManaged 1
IsReversal IsReversal 1
IsReversed IsReversed 1
IsSettled IsSettled 1
IsSettlement IsSettlement 1
IsStatisticalCostCenter IsStatisticalCostCenter 1
IsStatisticalOrder IsStatisticalOrder 1
IsStatisticalSalesDocument IsStatisticalSalesDocument 1
IsSupplierStockValuation IsSupplierStockValuation 1
ItemIsSplit ItemIsSplit 1
JntOpgAgrmt JntOpgAgrmt 1
JntVntrRcvryCodeIsBillable JntVntrRcvryCodeIsBillable 8
JntVntrRcvryCodeIsRlvtToBillg JntVntrRcvryCodeIsRlvtToBillg 1
JointVentureAccountingActivity JointVentureAccountingActivity 9
JointVentureBillingDate JointVentureBillingDate 1
JointVentureBillingType JointVentureBillingType 11
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 7
JointVentureEquityType JointVentureEquityType 11
JointVentureOperationalDate JointVentureOperationalDate 1
JointVenturePartner BusinessPartner,JointVenturePartner 4
JointVentureProductionDate JointVentureProductionDate 1
JournalEntryIsSecondaryEntry JournalEntryIsSecondaryEntry 1
JournalEntryItemCategory JournalEntryItemCategory 1
JrnlEntrAltvFYConsecutiveID JrnlEntrAltvFYConsecutiveID 1
JrnlEntryItemMigrationSource JrnlEntryItemMigrationSource 1
JrnlEntryItemObsoleteReason JrnlEntryItemObsoleteReason 1
JrnlPeriodEndClosingRunLogUUID JrnlPeriodEndClosingRunLogUUID 1
JVAFundingCurrency JVAFundingCurrency1 1
LastChangeDateTime LastChangeDateTime 1
LedgerFiscalYear LedgerFiscalYear 15
LineItemIsCompleted LineItemIsCompleted 1
LogicalSystem LogicalSystem 1
MaintenanceActivityType MaintenanceActivityType 1
MaintenanceOrderIsPlanned MaintenanceOrderIsPlanned 1
MaintenanceOrderPlanningCode MaintenanceOrderPlanningCode 1
MaintPriority MaintPriority 1
MaintPriorityType MaintPriorityType 1
MasterFixedAsset MasterFixedAsset 6
MaterialLedgerCategory MaterialLedgerCategory 1
MaterialLedgerProcessType MaterialLedgerProcessType 1
NetDueDate NetDueDate 1
OffsettingAccount OffsettingAccount 1
OffsettingAccountType OffsettingAccountType 1
OffsettingChartOfAccounts OffsettingChartOfAccounts 1
OperatingConcern OperatingConcern 1
OrderCategory OrderCategory 1
OrderID OrderID 6
OrderItem OrderItem 1
OrderOperation OrderOperation 1
OrderSuboperation OrderSuboperation 1
OrganizationalChange OrganizationalChange 1
OrganizationDivision OrganizationDivision 4
OriginCostCenter OriginCostCenter 1
OriginCostCtrActivityType OriginCostCtrActivityType 1
OriginCtrlgDebitCreditCode OriginCtrlgDebitCreditCode 1
OriginObjectType OriginObjectType 1
OriginOrder OriginOrder 1
OriginOrderOperation OriginOrderOperation 1
OriginProduct OriginProduct 1
OriginProfitCenter OriginProfitCenter 1
OriginSenderObject OriginSenderObject 1
PartnerAccountAssignment PartnerAccountAssignment 1
PartnerAccountAssignmentType PartnerAccountAssignmentType 1
PartnerBudgetPeriod PartnerBudgetPeriod 1
PartnerBusinessArea PartnerBusinessArea 1
PartnerBusinessProcess PartnerBusinessProcess 1
PartnerCompany PartnerCompany 1
PartnerCompanyCode PartnerCompanyCode 1
PartnerConsolidationUnit PartnerConsolidationUnit 1
PartnerControllingObjectClass PartnerControllingObjectClass 1
PartnerCostCenter PartnerCostCenter 1
PartnerCostCtrActivityType PartnerCostCtrActivityType 1
PartnerCostObject PartnerCostObject 1
PartnerEquityGroup PartnerEquityGroup 1
PartnerFixedAsset PartnerFixedAsset 1
PartnerFunctionalArea PartnerFunctionalArea 1
PartnerFund PartnerFund 1
PartnerGrant PartnerGrant 1
PartnerMasterFixedAsset PartnerMasterFixedAsset 1
PartnerOrder PartnerOrder 1
PartnerOrderCategory PartnerOrderCategory 1
PartnerOrderItem PartnerOrderItem 1
PartnerProfitCenter PartnerProfitCenter 1
PartnerProject PartnerProject 1
PartnerProjectInternalID PartnerProjectInternalID 1
PartnerProjectNetwork PartnerProjectNetwork 1
PartnerProjectNetworkActivity PartnerProjectNetworkActivity 1
PartnerSalesDocument PartnerSalesDocument 1
PartnerSalesDocumentItem PartnerSalesDocumentItem 1
PartnerSegment PartnerSegment 1
PartnerServiceDocument PartnerServiceDocument 1
PartnerServiceDocumentItem PartnerServiceDocumentItem 1
PartnerServiceDocumentType PartnerServiceDocumentType 1
PartnerSettlementReferenceDate PartnerSettlementReferenceDate 1
PartnerVenture PartnerVenture 1
PartnerWBSElement PartnerWBSElement 1
PartnerWBSElementInternalID PartnerWBSElementInternalID 1
PerformanceObligation PerformanceObligation 1
PerformancePeriodEndDate PerformancePeriodEndDate 1
PerformancePeriodStartDate PerformancePeriodStartDate 1
PersonnelNumber PersonnelNumber 1
Plant Plant 4
PostingDate PostingDate 6
PostingKey PostingKey 1
PrdcssrJournalEntryCompanyCode PrdcssrJournalEntryCompanyCode 1
PrdcssrJournalEntryFiscalYear PrdcssrJournalEntryFiscalYear 1
PredecessorJournalEntry PredecessorJournalEntry 1
PredecessorJournalEntryItem PredecessorJournalEntryItem 1
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt 1
PredecessorReferenceDocItem PredecessorReferenceDocItem 1
PredecessorReferenceDocType PredecessorReferenceDocType 1
PredecessorReferenceDocument PredecessorReferenceDocument 1
PrftCtrValnFxdAmtInGlobCrcy PrftCtrValnFxdAmtInGlobCrcy 1
PrftCtrValnFxdPrcVarcInGlbCrcy PrftCtrValnFxdPrcVarcInGlbCrcy 1
PrftCtrValnTotPrcVarcInGlbCrcy PrftCtrValnTotPrcVarcInGlbCrcy 1
Product Product 1
ProductGroup ProductGroup 1
ProductPriceControl ProductPriceControl 1
ProfitCenter ProfitCenter 6
ProjectInternalID ProjectInternalID 1
ProjectNetwork ProjectNetwork 5
ProviderContract ProviderContract 1
ProviderContractItem ProviderContractItem 1
PubSecBudgetAccount PubSecBudgetAccount 1
PubSecBudgetAccountCoCode PubSecBudgetAccountCoCode 1
PubSecBudgetCnsmpnAmtType PubSecBudgetCnsmpnAmtType 1
PubSecBudgetCnsmpnDate PubSecBudgetCnsmpnDate 1
PubSecBudgetCnsmpnFsclPeriod PubSecBudgetCnsmpnFsclPeriod 1
PubSecBudgetCnsmpnFsclYear PubSecBudgetCnsmpnFsclYear 1
PubSecBudgetCnsmpnType PubSecBudgetCnsmpnType 1
PubSecBudgetIsRelevant PubSecBudgetIsRelevant 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
Quantity Quantity 4
QuantityIsIncomplete QuantityIsIncomplete 1
RealEstateBuilding RealEstateBuilding 1
RealEstateContract RealEstateContract 1
RealEstatePartnerBuilding RealEstatePartnerBuilding 1
RealEstatePartnerContract RealEstatePartnerContract 1
RealEstatePartnerProperty RealEstatePartnerProperty 1
RealEstateProperty RealEstateProperty 1
REBusinessEntity REBusinessEntity 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentItem ReferenceDocumentItem 1
ReferenceDocumentItemGroup ReferenceDocumentItemGroup 1
ReferenceDocumentType ReferenceDocumentType 1
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory 1
ReferenceQuantity ReferenceQuantity 1
ReferenceQuantityUnit ReferenceQuantityUnit 1
RelatedNetworkActivity RelatedNetworkActivity 2
REPartnerBusinessEntity REPartnerBusinessEntity 1
REPartnerRentalObject REPartnerRentalObject 1
REPartnerServiceChargeKey REPartnerServiceChargeKey 1
REPartnerSettlementUnitID REPartnerSettlementUnitID 1
RERentalObject RERentalObject 1
REServiceChargeKey REServiceChargeKey 1
RESettlementUnitID RESettlementUnitID 1
RevenueAccountingContract RevenueAccountingContract 1
ReversalReferenceDocument ReversalReferenceDocument 1
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt 1
ReversalTransactionSubitem ReversalTransactionSubitem 1
SalesDistrict SalesDistrict 1
SalesDocument SalesDocument 4
SalesDocumentItem SalesDocumentItem 1
SalesOrganization SalesOrganization 4
Segment Segment 4
SenderAccountAssignment SenderAccountAssignment 1
SenderAccountAssignmentType SenderAccountAssignmentType 1
SenderCompanyCode SenderCompanyCode 1
SenderCostRecoveryCode SenderCostRecoveryCode 1
SenderGLAccount SenderGLAccount 1
ServiceContract ServiceContract 1
ServiceContractItem ServiceContractItem 1
ServiceContractType ServiceContractType 1
ServiceDocument ServiceDocument 4
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 4
ServicesRenderedDate ServicesRenderedDate 1
SettlementReferenceDate SettlementReferenceDate 1
ShipToParty ShipToParty 1
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy 1
SoldProduct SoldProduct 1
SoldProductGroup SoldProductGroup 1
SourceLedger SourceLedger 1
SourceLogicalSystem SourceLogicalSystem 1
SourceReferenceDocSubitem SourceReferenceDocSubitem 1
SourceReferenceDocument SourceReferenceDocument 1
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt 1
SourceReferenceDocumentItem SourceReferenceDocumentItem 1
SourceReferenceDocumentType SourceReferenceDocumentType 1
SpecialGLCode SpecialGLCode 1
SponsoredClass SponsoredClass 1
SponsoredProgram SponsoredProgram 1
StstclAccountAssignmentType1 StstclAccountAssignmentType1 1
StstclAccountAssignmentType2 StstclAccountAssignmentType2 1
StstclAccountAssignmentType3 StstclAccountAssignmentType3 1
SubLedgerAcctLineItemType SubLedgerAcctLineItemType 1
SuperiorOrder SuperiorOrder 2
Supplier Supplier 4
TaxCode TaxCode 1
TaxCountry TaxCountry 1
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 1
TotalPriceVarcInGlobalCrcy TotalPriceVarcInGlobalCrcy 1
TransactionCurrency TransactionCurrency 13
TransactionSubitem TransactionSubitem 1
TransactionTypeDetermination TransactionTypeDetermination 1
ValuationArea ValuationArea 4
ValuationFixedQuantity ValuationFixedQuantity 1
ValuationQuantity ValuationQuantity 1
ValueDate ValueDate 1
VarianceOriginGLAccount VarianceOriginGLAccount 1
VarianceOriginGroup VarianceOriginGroup 1
WBSElementExternalID WBSElementExternalID 5
WBSElementInternalID WBSElementInternalID 6
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement 1
WorkCenterInternalID WorkCenterInternalID 1
WorkItem WorkItem 1
WorkPackage WorkPackage 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.

-- JVA Line Item - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JVALINEITEMCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    JOINTVENTURE,
    JOINTVENTUREEQUITYGROUP,
    LEDGER,
    LEDGERGLLINEITEM,
    _ACCOUNTASSIGNMENTTYPE,
    _ACCOUNTINGDOCHEADER,
    _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,
    _COMPANYCODETEXT,
    _CONDITIONCONTRACT,
    _CONSOLIDATIONCHARTOFACCOUNTS,
    _CONSOLIDATIONUNIT,
    _CONTROLLINGAREA,
    _CONTROLLINGAREATEXT,
    _CONTROLLINGDEBITCREDITCODE,
    _CONTROLLINGOBJECTCLASS,
    _CORPORATEGROUPACCOUNT,
    _CORPORATEGROUPCHARTOFACCOUNTS,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTCENTERTEXT,
    _COSTCTRACTIVITYTYPE,
    _COSTORIGINGROUP,
    _COSTSOURCEUNIT,
    _COUNTRYCHARTOFACCOUNTS,
    _CREDITRISKCLASS,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _DEBITCREDITCODE,
    _DISTRIBUTIONCHANNEL,
    _ELIMINATIONPROFITCENTER,
    _EQUIPMENT,
    _FINANCIALACCOUNTTYPE,
    _FINANCIALMANAGEMENTAREA,
    _FINANCIALTRANSACTIONTYPE,
    _FINVALUATIONOBJECTTYPE,
    _FISCALCALENDARDATE,
    _FISCALPERIODCOMPANYCODE,
    _FISCALPERIODFORVARIANT,
    _FISCALPERIODLEDGER,
    _FISCALYEAR,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FIXEDASSET,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _FUNCTIONALAREA,
    _FUNCTIONALCURRENCY,
    _FUNCTIONALLOCATION,
    _FUND,
    _FUNDEDPROGRAM,
    _FUNDSCENTER,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTEXT,
    _GLACCOUNTTXT,
    _GLACCOUNTTYPE,
    _GLOBALCURRENCY,
    _GRANT,
    _GROUPFIXEDASSET,
    _GROUPMASTERFIXEDASSET,
    _HOUSEBANK,
    _HOUSEBANKACCOUNT,
    _INCMPLTSUMMABLEVALNQTYUNT,
    _INTERNALORDER,
    _INVENTORYSPCLSTKSALESDOCITM,
    _INVENTORYSPCLSTKSALESDOCUMENT,
    _INVENTORYSPECIALSTOCKSUPPLIER,
    _INVENTORYSPECIALSTOCKTYPE,
    _INVENTORYSPECIALSTOCKVALNTYPE,
    _INVENTORYVALUATIONTYPE,
    _INVTRYSPCLSTKWBSELMNTBSCDATA,
    _INVTRYSPCLSTOCKWBSELMNTBASIC,
    _INVTRYSPCLSTOCKWBSELMNTEXTID,
    _INVTRYSPCLSTOCKWBSELMNTINFO,
    _JNTOPGAGRMT,
    _JNTOPGAGRMTTEXT,
    _JNTVNTRBUSINESSPARTNER,
    _JNTVNTREQUITYGRP,
    _JNTVNTREQUITYTYPEMASTER,
    _JNTVNTRRECOVERYIND,
    _JNTVNTRRECOVERYINDTEXT,
    _JOINTVENTUREDESC,
    _JOINTVENTUREMASTERFLD,
    _JOINTVENTUREORDERDATA,
    _JOINTVENTUREPAYROLLTYPE,
    _JOURNALENTRY,
    _JRNLENTRYITEMOBSOLETERSN,
    _JVAGLOBALCOMPANYPARAMETER,
    _JVALEDGER,
    _LEDGER,
    _LEDGERFISCALYEARFORVARIANT,
    _LOGICALSYSTEM,
    _MAINTENANCEACTIVITYTYPE,
    _MAINTENANCEORDER,
    _MAINTENANCEORDEROPERATION,
    _MAINTENANCEORDERSUBOPERATION,
    _MAINTORDPLNGDEGREECODE,
    _MASTERFIXEDASSET,
    _MOVEMENTCATEGORY,
    _OFFSETTINGACCOUNT,
    _OFFSETTINGACCOUNTTYPE,
    _OFFSETTINGACCOUNTWITHBP,
    _OFFSETTINGCHARTOFACCOUNTS,
    _OPERATINGCONCERN,
    _ORDER,
    _ORDERBASIC,
    _ORDERCATEGORY,
    _ORIGINCOSTCENTER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _ORIGINCTRLGDEBITCREDITCODE,
    _ORIGINORDER,
    _ORIGINPRODUCT,
    _ORIGINPROFITCENTER,
    _ORIGINSENDEROBJECT,
    _PARTNERBUDGETPERIOD,
    _PARTNERBUSINESSAREA,
    _PARTNERBUSINESSPROCESS,
    _PARTNERCOMPANY,
    _PARTNERCOMPANYCODE,
    _PARTNERCONSOLIDATIONUNIT,
    _PARTNERCONTROLLINGOBJECTCLASS,
    _PARTNERCOSTCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PARTNERFIXEDASSET,
    _PARTNERFUNCTIONALAREA,
    _PARTNERFUND,
    _PARTNERGRANT,
    _PARTNERMASTERFIXEDASSET,
    _PARTNERORDER,
    _PARTNERORDERCATEGORY,
    _PARTNERORDERTEXT,
    _PARTNERPROFITCENTER,
    _PARTNERPROJECTBASICDATA,
    _PARTNERPROJECTEXTERNALID,
    _PARTNERPROJECTEXTERNALIDTEXT,
    _PARTNERSALESDOCUMENT,
    _PARTNERSALESDOCUMENTITEM,
    _PARTNERSEGMENT,
    _PARTNERSERVICEDOCUMENT,
    _PARTNERSERVICEDOCUMENTITEM,
    _PARTNERSERVICEDOCUMENTTYPE,
    _PARTNERWBSELEMENTBASICDATA,
    _PARTNERWBSELEMENTEXTERNALID,
    _PARTNERWBSEXTERNALIDTEXT,
    _PERSONWORKAGREEMENT_1,
    _PLANT,
    _PMNOTIFICATIONPRIORITY,
    _PMNOTIFICATIONPRIORITYTYPE,
    _POSTINGKEY,
    _PREDECESSORREFERENCEDOCTYPE,
    _PRODUCT,
    _PRODUCTGROUP_2,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _PROJECTEXTERNALID,
    _PROJECTEXTERNALIDTEXT,
    _PROJECTNETWORK,
    _PROJECTNETWORKTEXT,
    _PROVIDERCONTRACT,
    _PROVIDERCONTRACTITEM,
    _PUBSECBUDGETACCOUNT,
    _PUBSECBUDGETACCOUNTCOCODE,
    _PUBSECBUDGETCNSMPNAMTTYPE,
    _PUBSECBUDGETCNSMPNDATE,
    _PUBSECBUDGETCNSMPNFSCLPERIOD,
    _PUBSECBUDGETCNSMPNFSCLYEAR,
    _PUBSECBUDGETCNSMPNTYPE,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _PURREQVALUATIONAREA,
    _REFERENCEDOCUMENTTYPE,
    _REFERENCEQUANTITYUNIT,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SEMTAGGLACCOUNT,
    _SERVICECONTRACT,
    _SERVICECONTRACTITEM,
    _SERVICECONTRACTTYPE,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTITEM,
    _SERVICEDOCUMENTTYPE,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP_2,
    _SOURCELEDGER,
    _SPECIALGLCODE,
    _SPONSOREDCLASS,
    _SPONSOREDPROGRAM,
    _SUBLEDGERACCLINEITEMTYPE,
    _SUPERIORORDER,
    _SUPPLIER,
    _SUPPLIERCOMPANY,
    _TAXCODE,
    _TAXCOUNTRY,
    _TIMESHEETOVERTIMECAT,
    _TRANSACTIONCURRENCY,
    _USER,
    _VALUATIONAREA,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    _WBSELEMENTEXTERNALIDTEXT,
    _WBSELEMENTINTERNALID,
    _WBSELEMENTINTERNALIDTEXT,
    _WORKCENTER,
    _WORKPACKAGE,
    _WORKPACKAGEWORKITEM,
    ACCOUNTASSIGNMENT,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    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,
    AMOUNTINJVAFUNDINGCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSEMBLY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCLASS,
    ASSETDEPRECIATIONAREA,
    ASSETTRANSACTIONTYPE,
    ASSETVALUEDATE,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BILLABLECONTROL,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CASHLEDGERACCOUNT,
    CASHLEDGERCOMPANYCODE,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CLEARINGJOURNALENTRYFISCALYEAR,
    CNSLDTNFINANCIALSTATEMENTITEM,
    CNSLDTNSUBITEM,
    CNSLDTNSUBITEMCATEGORY,
    COMMITMENTITEM,
    COMPANY,
    COMPANYCODECURRENCY,
    CONDITIONCONTRACT,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONUNIT,
    CONTROLLINGAREA,
    CONTROLLINGBUSTRANSACTYPE,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGDOCUMENTITEM,
    CONTROLLINGOBJECT,
    CONTROLLINGOBJECTCLASS,
    CONTROLLINGOBJECTCURRENCY,
    CONTROLLINGOBJECTDEBITTYPE,
    CORPORATEGROUPACCOUNT,
    CORPORATEGROUPCHARTOFACCOUNTS,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTESTIMATE,
    COSTOBJECT,
    COSTORIGINGROUP,
    COSTSOURCEUNIT,
    COUNTRYCHARTOFACCOUNTS,
    CREATIONDATE,
    CREATIONDATETIME,
    CREDITRISKCLASS,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSERVICENOTIFICATION,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    CUTBACKACCOUNT,
    CUTBACKCOSTOBJECT,
    CUTBACKRUN,
    DEBITCREDITCODE,
    DEPRECIATIONFISCALPERIOD,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    ELIMINATIONPROFITCENTER,
    EMPLOYEEFULLNAME,
    EQUIPMENT,
    EXCHANGERATEDATE,
    FINANCIALACCOUNTTYPE,
    FINANCIALCLOSINGSTEP,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALTRANSACTIONTYPE,
    FINANCIALVALUATIONOBJECT,
    FINANCIALVALUATIONOBJECTTYPE,
    FINANCIALVALUATIONSUBOBJECT,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINGLOBALCRCY,
    FIXEDASSET,
    FIXEDPRICEVARCINGLOBALCRCY,
    FIXEDQUANTITY,
    FOLLOWONDOCUMENTTYPE,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    FUNCTIONALLOCATION,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GENERALLEDGERAGINGINCREMENT,
    GENERALLEDGERAGINGSCOPE,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLBUSINESSTRANSACTIONTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    GRANTCURRENCY,
    GRANTID,
    GROUPFIXEDASSET,
    GROUPMASTERFIXEDASSET,
    GRPVALNFIXEDAMTINGLOBCRCY,
    GRPVALNFIXEDPRCVARCINGLOBCRCY,
    GRPVALNTOTPRCVARCINGLOBCRCY,
    GTEEMBUDGETVALIDITYNUMBER,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INCMPLTSUMMABLEVALNFXDQTY,
    INCMPLTSUMMABLEVALNQTY,
    INCMPLTSUMMABLEVALNQTYUNT,
    INVENTORYSPCLSTKSALESDOCITM,
    INVENTORYSPCLSTKSALESDOCUMENT,
    INVENTORYSPECIALSTOCKSUPPLIER,
    INVENTORYSPECIALSTOCKTYPE,
    INVENTORYSPECIALSTOCKVALNTYPE,
    INVENTORYVALUATIONTYPE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    INVTRYSPCLSTOCKWBSELMNTINTID,
    ISBALANCESHEETACCOUNT,
    ISCOMMITMENT,
    ISOPENITEMMANAGED,
    ISREVERSAL,
    ISREVERSED,
    ISSETTLED,
    ISSETTLEMENT,
    ISSTATISTICALCOSTCENTER,
    ISSTATISTICALORDER,
    ISSTATISTICALSALESDOCUMENT,
    ISSUPPLIERSTOCKVALUATION,
    ITEMISSPLIT,
    JNTOPGAGRMT,
    JNTVNTRRCVRYCODEISBILLABLE,
    JNTVNTRRCVRYCODEISRLVTTOBILLG,
    JOINTVENTUREACCOUNTINGACTIVITY,
    JOINTVENTUREBILLINGDATE,
    JOINTVENTUREBILLINGTYPE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYTYPE,
    JOINTVENTUREOPERATIONALDATE,
    JOINTVENTUREPARTNER,
    JOINTVENTUREPRODUCTIONDATE,
    JOURNALENTRYISSECONDARYENTRY,
    JOURNALENTRYITEMCATEGORY,
    JRNLENTRALTVFYCONSECUTIVEID,
    JRNLENTRYITEMMIGRATIONSOURCE,
    JRNLENTRYITEMOBSOLETEREASON,
    JRNLPERIODENDCLOSINGRUNLOGUUID,
    JVAFUNDINGCURRENCY,
    LASTCHANGEDATETIME,
    LEDGERFISCALYEAR,
    LINEITEMISCOMPLETED,
    LOGICALSYSTEM,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERISPLANNED,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MASTERFIXEDASSET,
    MATERIALLEDGERCATEGORY,
    MATERIALLEDGERPROCESSTYPE,
    NETDUEDATE,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGCHARTOFACCOUNTS,
    OPERATINGCONCERN,
    ORDERCATEGORY,
    ORDERID,
    ORDERITEM,
    ORDEROPERATION,
    ORDERSUBOPERATION,
    ORGANIZATIONALCHANGE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINCTRLGDEBITCREDITCODE,
    ORIGINOBJECTTYPE,
    ORIGINORDER,
    ORIGINORDEROPERATION,
    ORIGINPRODUCT,
    ORIGINPROFITCENTER,
    ORIGINSENDEROBJECT,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERBUDGETPERIOD,
    PARTNERBUSINESSAREA,
    PARTNERBUSINESSPROCESS,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCONTROLLINGOBJECTCLASS,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    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,
    PLANT,
    POSTINGDATE,
    POSTINGKEY,
    PRDCSSRJOURNALENTRYCOMPANYCODE,
    PRDCSSRJOURNALENTRYFISCALYEAR,
    PREDECESSORJOURNALENTRY,
    PREDECESSORJOURNALENTRYITEM,
    PREDECESSORREFERENCEDOCCNTXT,
    PREDECESSORREFERENCEDOCITEM,
    PREDECESSORREFERENCEDOCTYPE,
    PREDECESSORREFERENCEDOCUMENT,
    PRFTCTRVALNFXDAMTINGLOBCRCY,
    PRFTCTRVALNFXDPRCVARCINGLBCRCY,
    PRFTCTRVALNTOTPRCVARCINGLBCRCY,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTPRICECONTROL,
    PROFITCENTER,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PUBSECBUDGETACCOUNT,
    PUBSECBUDGETACCOUNTCOCODE,
    PUBSECBUDGETCNSMPNAMTTYPE,
    PUBSECBUDGETCNSMPNDATE,
    PUBSECBUDGETCNSMPNFSCLPERIOD,
    PUBSECBUDGETCNSMPNFSCLYEAR,
    PUBSECBUDGETCNSMPNTYPE,
    PUBSECBUDGETISRELEVANT,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITY,
    QUANTITYISINCOMPLETE,
    REALESTATEBUILDING,
    REALESTATECONTRACT,
    REALESTATEPARTNERBUILDING,
    REALESTATEPARTNERCONTRACT,
    REALESTATEPARTNERPROPERTY,
    REALESTATEPROPERTY,
    REBUSINESSENTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTITEM,
    REFERENCEDOCUMENTITEMGROUP,
    REFERENCEDOCUMENTTYPE,
    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,
    SOURCELEDGER,
    SOURCELOGICALSYSTEM,
    SOURCEREFERENCEDOCSUBITEM,
    SOURCEREFERENCEDOCUMENT,
    SOURCEREFERENCEDOCUMENTCNTXT,
    SOURCEREFERENCEDOCUMENTITEM,
    SOURCEREFERENCEDOCUMENTTYPE,
    SPECIALGLCODE,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    STSTCLACCOUNTASSIGNMENTTYPE1,
    STSTCLACCOUNTASSIGNMENTTYPE2,
    STSTCLACCOUNTASSIGNMENTTYPE3,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPERIORORDER,
    SUPPLIER,
    TAXCODE,
    TAXCOUNTRY,
    TIMESHEETOVERTIMECATEGORY,
    TOTALPRICEVARCINGLOBALCRCY,
    TRANSACTIONCURRENCY,
    TRANSACTIONSUBITEM,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    VALUATIONFIXEDQUANTITY,
    VALUATIONQUANTITY,
    VALUEDATE,
    VARIANCEORIGINGLACCOUNT,
    VARIANCEORIGINGROUP,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WBSISSTATISTICALWBSELEMENT,
    WORKCENTERINTERNALID,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, JOINTVENTURE, JOINTVENTUREEQUITYGROUP, LEDGER, LEDGERGLLINEITEM)
);