I_JournalEntryItemItemizationC
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)
| Source | Alias | Join Type |
|---|---|---|
| P_Acdoca_Acdocd_Union | P_Acdoca_Acdocd_Union | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA