I_JournalEntryItemItemizationC

DDL: I_JOURNALENTRYITEMITEMIZATIONC Type: view_entity COMPOSITE

Journal Entry Item and aged Journal Entry Item - Cube

I_JournalEntryItemItemizationC is a Composite CDS View (Cube) that provides data about "Journal Entry Item and aged Journal Entry Item - Cube" in SAP S/4HANA. It reads from 1 data source (P_Acdoca_Acdocd_Union) and exposes 245 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_Acdoca_Acdocd_Union P_Acdoca_Acdocd_Union from

Associations (2)

CardinalityTargetAliasCondition
[1..1] E_JournalEntryItem _Extension_acdoca $projection.SourceLedger = _Extension_acdoca.SourceLedger and $projection.CompanyCode = _Extension_acdoca.CompanyCode and $projection.FiscalYear = _Extension_acdoca.FiscalYear and $projection.AccountingDocument = _Extension_acdoca.AccountingDocument and $projection.LedgerGLLineItem = _Extension_acdoca.LedgerGLLineItem
[1..1] E_JournalEntryItemItemization _Extension_acdocd $projection.SourceLedger = _Extension_acdocd.SourceLedger and $projection.CompanyCode = _Extension_acdocd.CompanyCode and $projection.FiscalYear = _Extension_acdocd.FiscalYear and $projection.AccountingDocument = _Extension_acdocd.AccountingDocument and $projection.LedgerGLLineItem = _Extension_acdocd.LedgerGLLineItem

Annotations (13)

NameValueLevelField
Analytics.technicalName IFIJOURNALENTITITMZNC view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Journal Entry Item and aged Journal Entry Item - Cube view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (245)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger Ledger Ledger
LedgerFiscalYear LedgerFiscalYear
GLRecordType GLRecordType Record Type
JrnlEntrAltvFYConsecutiveID JrnlEntrAltvFYConsecutiveID
ChartOfAccounts ChartOfAccounts Node Class
ControllingArea ControllingArea Controlling Area
FinancialTransactionType FinancialTransactionType Transact. Type
GLBusinessTransactionType GLBusinessTransactionType Transact. Type
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
BusinessTransactionType BusinessTransactionType Bus.transaction
FinancialClosingStep FinancialClosingStep Closing Step
ControllingBusTransacType ControllingBusTransacType CO Bus. Transaction
ReferenceDocumentType ReferenceDocumentType Reference Document Type
LogicalSystem LogicalSystem Logical System
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentItemGroup ReferenceDocumentItemGroup Reference Document Item Group
TransactionSubitem TransactionSubitem Sub Transaction
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReversalReferenceDocumentCntxt ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
ReversalTransactionSubitem ReversalTransactionSubitem Reversal Sub Trans
IsSettlement IsSettlement Is Settling
IsSettled IsSettled Is Settled
PredecessorReferenceDocType PredecessorReferenceDocType Predecessor Reference Document Type
PredecessorReferenceDocCntxt PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocument PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem PredecessorReferenceDocItem Prec. Ref. Doc. Item
PrdcssrJournalEntryCompanyCode PrdcssrJournalEntryCompanyCode Predecessor Journal Entry Company Code
PrdcssrJournalEntryFiscalYear PrdcssrJournalEntryFiscalYear Predecessor Journal Entry Fiscal Year
PredecessorJournalEntry PredecessorJournalEntry Predecessor Journal Entry
PredecessorJournalEntryItem PredecessorJournalEntryItem Predecessor Journal Entry Item
SourceReferenceDocumentType SourceReferenceDocumentType Ref. procedure
SourceLogicalSystem SourceLogicalSystem
SourceReferenceDocumentCntxt SourceReferenceDocumentCntxt
SourceReferenceDocument SourceReferenceDocument Reference Doc.
SourceReferenceDocumentItem SourceReferenceDocumentItem Ref. Doc. Item
SourceReferenceDocSubitem SourceReferenceDocSubitem
IsCommitment IsCommitment
JrnlEntryItemObsoleteReason JrnlEntryItemObsoleteReason
JrnlPeriodEndClosingRunLogUUID JrnlPeriodEndClosingRunLogUUID Closing Run UUID
OrganizationalChange OrganizationalChange Organizational Change
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
Segment Segment Segment number
PartnerCostCenter PartnerCostCenter Sender Cost Ctr
PartnerProfitCenter PartnerProfitCenter Profit Center
PartnerFunctionalArea PartnerFunctionalArea Rec. Fntcl Area
PartnerBusinessArea PartnerBusinessArea Trdg Part.BA
PartnerCompany PartnerCompany Trading Partner
PartnerSegment PartnerSegment Partner Segment
BalanceTransactionCurrency BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
FunctionalCurrency FunctionalCurrency Functional Currency
AmountInFunctionalCurrency AmountInFunctionalCurrency Amount in Functional Currency
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy
GrpValnFixedAmtInGlobCrcy GrpValnFixedAmtInGlobCrcy
PrftCtrValnFxdAmtInGlobCrcy PrftCtrValnFxdAmtInGlobCrcy
TotalPriceVarcInGlobalCrcy TotalPriceVarcInGlobalCrcy
GrpValnTotPrcVarcInGlobCrcy GrpValnTotPrcVarcInGlobCrcy
PrftCtrValnTotPrcVarcInGlbCrcy PrftCtrValnTotPrcVarcInGlbCrcy
FixedPriceVarcInGlobalCrcy FixedPriceVarcInGlobalCrcy
GrpValnFixedPrcVarcInGlobCrcy GrpValnFixedPrcVarcInGlobCrcy
PrftCtrValnFxdPrcVarcInGlbCrcy PrftCtrValnFxdPrcVarcInGlbCrcy
FixedAmountInCoCodeCrcy FixedAmountInCoCodeCrcy
FixedAmountInTransCrcy FixedAmountInTransCrcy
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency AmountInObjectCurrency Amount in Obj Crcy
GrantCurrency GrantCurrency Grant Currency
AmountInGrantCurrency AmountInGrantCurrency
BaseUnit BaseUnit Unit of Measure
Quantity Quantity Value
FixedQuantity FixedQuantity Fixed Quantity
CostSourceUnit CostSourceUnit
ValuationQuantity ValuationQuantity
ValuationFixedQuantity ValuationFixedQuantity
ReferenceQuantityUnit ReferenceQuantityUnit
ReferenceQuantity ReferenceQuantity Comm Refer Quantity
AdditionalQuantity1Unit AdditionalQuantity1Unit Add Unit Meas 1
AdditionalQuantity1 AdditionalQuantity1
AdditionalQuantity2Unit AdditionalQuantity2Unit Add Unit Meas 2
AdditionalQuantity2 AdditionalQuantity2
AdditionalQuantity3Unit AdditionalQuantity3Unit Add Unit Meas 3
AdditionalQuantity3 AdditionalQuantity3
DebitCreditCode DebitCreditCode Single-Character Flag
FiscalPeriod FiscalPeriod Tax period
FiscalYearVariant FiscalYearVariant FY Variant
FiscalYearPeriod FiscalYearPeriod Period/Year
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocumentType Journal Entry Type
AccountingDocumentItem AccountingDocumentItem Posting View Item
AssignmentReference AssignmentReference Assignment Reference
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
JournalEntryItemCategory JournalEntryItemCategory
PostingKey PostingKey Posting Key
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
SubLedgerAcctLineItemType SubLedgerAcctLineItemType SLALineItemType
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime LastChangeDateTime Timestamp
CreationDateTime CreationDateTime Timestamp
CreationDate Time Stamp
CreationDate CreationDate Time Stamp
EliminationProfitCenter EliminationProfitCenter
OriginObjectType OriginObjectType Origin
GLAccountType GLAccountType G/L Account Type
AlternativeGLAccount AlternativeGLAccount Group Account
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
ItemIsSplit ItemIsSplit
ConsolidationUnit ConsolidationUnit Consolidation Unit
PartnerConsolidationUnit PartnerConsolidationUnit Partner Unit
Company Company Owner
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem
CnsldtnSubitemCategory CnsldtnSubitemCategory
CnsldtnSubitem CnsldtnSubitem
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
FollowOnDocumentType FollowOnDocumentType Follow-On Document Type
InvoiceItemReference InvoiceItemReference Item
ReferencePurchaseOrderCategory ReferencePurchaseOrderCategory
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
DocumentItemText DocumentItemText Text
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
Product Product Product Sold
Plant Plant Valuation Area
Supplier Supplier Supplier
Customer Customer Sold-to Party
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
ConditionContract ConditionContract Condition Contract
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
TaxCode TaxCode Tax Code
TaxCountry TaxCountry Tax Ctry/Reg.
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
IsOpenItemManaged IsOpenItemManaged Open Item Management
ClearingDate ClearingDate Clearing Date
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingJournalEntry ClearingJournalEntry Clrng doc.
ValueDate ValueDate Value Date
GeneralLedgerAgingScope GeneralLedgerAgingScope Aging
GeneralLedgerAgingIncrement GeneralLedgerAgingIncrement Increment
AssetDepreciationArea AssetDepreciationArea Deprec. Area
MasterFixedAsset MasterFixedAsset Fixed Asset
FixedAsset FixedAsset Sub-number
AssetValueDate AssetValueDate Reference date
AssetTransactionType AssetTransactionType Trans.Type
AssetAcctTransClassfctn AssetAcctTransClassfctn Trans.Type Cat.
DepreciationFiscalPeriod DepreciationFiscalPeriod Deprec. Period
GroupMasterFixedAsset GroupMasterFixedAsset
GroupFixedAsset GroupFixedAsset
AssetClass AssetClass Asset Class
PartnerMasterFixedAsset PartnerMasterFixedAsset Partner Asset
PartnerFixedAsset PartnerFixedAsset Partner Sub-No.
CostEstimate CostEstimate Cost EstimateNo
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
InvtrySpecialStockValnType_2 InvtrySpecialStockValnType_2
IsSupplierStockValuation IsSupplierStockValuation
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpclStkSalesDocument InventorySpclStkSalesDocument
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID
InventorySpecialStockSupplier InventorySpecialStockSupplier
InventoryValuationType InventoryValuationType Valuation Type
ValuationArea ValuationArea Valuation Area
MaterialLedgerProcessType MaterialLedgerProcessType
MaterialLedgerCategory MaterialLedgerCategory
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy Sales Price Book Value
ProductPriceControl ProductPriceControl Price control
SenderCompanyCode SenderCompanyCode Sender Company Code
SenderGLAccount SenderGLAccount
SenderAccountAssignment SenderAccountAssignment
SenderAccountAssignmentType SenderAccountAssignmentType
ControllingObject ControllingObject Object number
CostOriginGroup CostOriginGroup Origin Group
OriginSenderObject OriginSenderObject
ControllingDebitCreditCode ControllingDebitCreditCode Dr/Cr ind. CO
ControllingObjectDebitType ControllingObjectDebitType
QuantityIsIncomplete QuantityIsIncomplete
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
OffsettingChartOfAccounts OffsettingChartOfAccounts Offsetting Chart of Accounts
LineItemIsCompleted LineItemIsCompleted Item Completed
PersonnelNumber PersonnelNumber Personnel No.
ControllingObjectClass ControllingObjectClass Object Class
PartnerCompanyCode PartnerCompanyCode Partner Company Code
PartnerControllingObjectClass PartnerControllingObjectClass
OriginCostCenter OriginCostCenter
OriginProfitCenter OriginProfitCenter
OriginCostCtrActivityType OriginCostCtrActivityType
OriginProduct OriginProduct
VarianceOriginGLAccount VarianceOriginGLAccount
AccountAssignment AccountAssignment Sender Acct Assgmt
AccountAssignmentType AccountAssignmentType Sndr AcctAssgmt Type
CostCtrActivityType CostCtrActivityType Activity Type
OrderID OrderID Order ID
OrderCategory OrderCategory Order Category
WBSElementInternalID WBSElementInternalID WBS Internal ID
PartnerWBSElementInternalID PartnerWBSElementInternalID Partner WBS Element Internal ID
ProjectInternalID ProjectInternalID Project Def.
PartnerProjectInternalID PartnerProjectInternalID
OperatingConcern OperatingConcern Operating concern
ProjectNetwork ProjectNetwork Order
RelatedNetworkActivity RelatedNetworkActivity Netwk activity
BusinessProcess BusinessProcess Business Process
CostObject CostObject Cost Object
BillableControl BillableControl Billable Control
CostAnalysisResource CostAnalysisResource
CustomerServiceNotification CustomerServiceNotification

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_JournalEntryItemItemizationC.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_JournalEntryItemItemizationC AS
SELECT
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LedgerFiscalYear,
  GLRecordType,
  JrnlEntrAltvFYConsecutiveID,
  ChartOfAccounts,
  ControllingArea,
  FinancialTransactionType,
  GLBusinessTransactionType,
  BusinessTransactionCategory,
  BusinessTransactionType,
  FinancialClosingStep,
  ControllingBusTransacType,
  ReferenceDocumentType,
  LogicalSystem,
  ReferenceDocumentContext,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocumentItemGroup,
  TransactionSubitem,
  IsReversal,
  IsReversed,
  ReversalReferenceDocumentCntxt,
  ReversalReferenceDocument,
  ReversalTransactionSubitem,
  IsSettlement,
  IsSettled,
  PredecessorReferenceDocType,
  PredecessorReferenceDocCntxt,
  PredecessorReferenceDocument,
  PredecessorReferenceDocItem,
  PrdcssrJournalEntryCompanyCode,
  PrdcssrJournalEntryFiscalYear,
  PredecessorJournalEntry,
  PredecessorJournalEntryItem,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  JrnlEntryItemObsoleteReason,
  JrnlPeriodEndClosingRunLogUUID,
  OrganizationalChange,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  Segment,
  PartnerCostCenter,
  PartnerProfitCenter,
  PartnerFunctionalArea,
  PartnerBusinessArea,
  PartnerCompany,
  PartnerSegment,
  BalanceTransactionCurrency,
  AmountInBalanceTransacCrcy,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  FixedAmountInGlobalCrcy,
  GrpValnFixedAmtInGlobCrcy,
  PrftCtrValnFxdAmtInGlobCrcy,
  TotalPriceVarcInGlobalCrcy,
  GrpValnTotPrcVarcInGlobCrcy,
  PrftCtrValnTotPrcVarcInGlbCrcy,
  FixedPriceVarcInGlobalCrcy,
  GrpValnFixedPrcVarcInGlobCrcy,
  PrftCtrValnFxdPrcVarcInGlbCrcy,
  FixedAmountInCoCodeCrcy,
  FixedAmountInTransCrcy,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  GrantCurrency,
  AmountInGrantCurrency,
  BaseUnit,
  Quantity,
  FixedQuantity,
  CostSourceUnit,
  ValuationQuantity,
  ValuationFixedQuantity,
  ReferenceQuantityUnit,
  ReferenceQuantity,
  AdditionalQuantity1Unit,
  AdditionalQuantity1,
  AdditionalQuantity2Unit,
  AdditionalQuantity2,
  AdditionalQuantity3Unit,
  AdditionalQuantity3,
  DebitCreditCode,
  FiscalPeriod,
  FiscalYearVariant,
  FiscalYearPeriod,
  PostingDate,
  DocumentDate,
  AccountingDocumentType,
  AccountingDocumentItem,
  AssignmentReference,
  AccountingDocumentCategory,
  JournalEntryItemCategory,
  PostingKey,
  TransactionTypeDetermination,
  SubLedgerAcctLineItemType,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  CreationDateTime,
  CreationDate,
  EliminationProfitCenter,
  OriginObjectType,
  GLAccountType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  ItemIsSplit,
  ConsolidationUnit,
  PartnerConsolidationUnit,
  Company,
  ConsolidationChartOfAccounts,
  CnsldtnFinancialStatementItem,
  CnsldtnSubitemCategory,
  CnsldtnSubitem,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  FollowOnDocumentType,
  InvoiceItemReference,
  ReferencePurchaseOrderCategory,
  PurchasingDocument,
  PurchasingDocumentItem,
  AccountAssignmentNumber,
  DocumentItemText,
  SalesDocument,
  SalesDocumentItem,
  Product,
  Plant,
  Supplier,
  Customer,
  ServicesRenderedDate,
  ConditionContract,
  FinancialAccountType,
  SpecialGLCode,
  TaxCode,
  TaxCountry,
  HouseBank,
  HouseBankAccount,
  IsOpenItemManaged,
  ClearingDate,
  ClearingJournalEntryFiscalYear,
  ClearingJournalEntry,
  ValueDate,
  GeneralLedgerAgingScope,
  GeneralLedgerAgingIncrement,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetValueDate,
  AssetTransactionType,
  AssetAcctTransClassfctn,
  DepreciationFiscalPeriod,
  GroupMasterFixedAsset,
  GroupFixedAsset,
  AssetClass,
  PartnerMasterFixedAsset,
  PartnerFixedAsset,
  CostEstimate,
  InventorySpecialStockValnType,
  InvtrySpecialStockValnType_2,
  IsSupplierStockValuation,
  InventorySpecialStockType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  InvtrySpclStockWBSElmntIntID,
  InventorySpecialStockSupplier,
  InventoryValuationType,
  ValuationArea,
  MaterialLedgerProcessType,
  MaterialLedgerCategory,
  SlsPriceAmountInCoCodeCrcy,
  ProductPriceControl,
  SenderCompanyCode,
  SenderGLAccount,
  SenderAccountAssignment,
  SenderAccountAssignmentType,
  ControllingObject,
  CostOriginGroup,
  OriginSenderObject,
  ControllingDebitCreditCode,
  ControllingObjectDebitType,
  QuantityIsIncomplete,
  OffsettingAccount,
  OffsettingAccountType,
  OffsettingChartOfAccounts,
  LineItemIsCompleted,
  PersonnelNumber,
  ControllingObjectClass,
  PartnerCompanyCode,
  PartnerControllingObjectClass,
  OriginCostCenter,
  OriginProfitCenter,
  OriginCostCtrActivityType,
  OriginProduct,
  VarianceOriginGLAccount,
  AccountAssignment,
  AccountAssignmentType,
  CostCtrActivityType,
  OrderID,
  OrderCategory,
  WBSElementInternalID,
  PartnerWBSElementInternalID,
  ProjectInternalID,
  PartnerProjectInternalID,
  OperatingConcern,
  ProjectNetwork,
  RelatedNetworkActivity,
  BusinessProcess,
  CostObject,
  BillableControl,
  CostAnalysisResource,
  CustomerServiceNotification
FROM P_Acdoca_Acdocd_Union
LEFT OUTER JOIN E_JournalEntryItem AS _Extension_acdoca ON SourceLedger = _Extension_acdoca.SourceLedger AND CompanyCode = _Extension_acdoca.CompanyCode AND FiscalYear = _Extension_acdoca.FiscalYear AND AccountingDocument = _Extension_acdoca.AccountingDocument AND LedgerGLLineItem = _Extension_acdoca.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN E_JournalEntryItemItemization AS _Extension_acdocd ON SourceLedger = _Extension_acdocd.SourceLedger AND CompanyCode = _Extension_acdocd.CompanyCode AND FiscalYear = _Extension_acdocd.FiscalYear AND AccountingDocument = _Extension_acdocd.AccountingDocument AND LedgerGLLineItem = _Extension_acdocd.LedgerGLLineItem  -- association [1..1]
;