I_JournalEntryOperationalView
Operational View on Journal Entry Item
I_JournalEntryOperationalView (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.
Accounting and Financial Close
I_JournalEntryOperationalView is a Composite CDS View (Cube) that provides data about "Operational View on Journal Entry Item" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 592 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 7 associations to related views. Part of development package FINS_FIS_FICO.
SAP API Hub
| Category | Composite |
|---|---|
| State | C1 |
| Line of Business | Accounting and Financial Close |
| Application Component | FI-GL-IS-2CL |
| Capabilities | Data Provider for Analytical Queries,Data Source for Defining CDS Entities,Data Source in SQL Select |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Not Released |
| Package | Accounting and Financial Close for SAP S/4HANA Cloud Public Edition |
| Description | <p>This CDS view provides access to all details of a journal entry item (database table ACDOCA) joined to the details of the corresponding operational accounting document item (database table BSEG) and to the details of the corresponding journal entry header (database table BKPF) including the most important business entity, such as G/L account, cost center or profit center. The most important attributes of business entities are included, such as G/L account, cost center, profit center, segment, accounting document type, accounting document category, financial account type, document date, posting date, clearing data, account assignment data, amounts in different currencies, and also payment data.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul><li><p>What are the details of a journal entry header?</p></li> <li><p>Which journal entry items are posted during the year?</p></li> <li><p>What is the company code currency of the journal entry?</p></li> <li><p>Which journal entries are created by a certain user?</p></li> <li><p>What postings have accumulated on a company code, a cost center or other objects during the year?</p></li> <li><p>What is the amount in company code currency of the journal entry items?</p></li> </ul> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_JournalEntryItem | I_JournalEntryItem | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ProjectByExternalID | _ProjectExternalID | $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID |
| [0..1] | I_ProjectByExternalID | _PartnerProjectExternalID | $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID |
| [0..1] | I_WBSElementByExternalID | _WBSElementExternalID | $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID |
| [0..1] | I_WBSElementByExternalID | _PartnerWBSElementExternalID | $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID |
| [0..1] | I_WBSElementByExternalID | _InvtrySpclStockWBSElmntExtID | $projection.InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID |
| [0..1] | I_PersonWorkAgreement_1 | _PersonWorkAgreement_1 | $projection.PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement |
| [0..1] | I_OperationalAcctgDocItem | _OperationalAcctgDocItem | $projection.CompanyCode = _OperationalAcctgDocItem.CompanyCode and $projection.FiscalYear = _OperationalAcctgDocItem.FiscalYear and $projection.AccountingDocument = _OperationalAcctgDocItem.AccountingDocument and $projection.AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.entityBuffer.definitionAllowed | false | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| EndUserText.label | Operational View on Journal Entry Item | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | LedgerGLLineItem | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| Analytics.dataCategory | #CUBE | view | |
| Analytics.technicalName | IFIJRNLENTOPV | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| AccessControl.auditFilter | #ENABLED | view | |
| Environment.sql.passValueForClient | true | view |
Fields (592)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SourceLedger | I_JournalEntryItem | SourceLedger | Source Ledger |
| KEY | CompanyCode | I_JournalEntryItem | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | I_JournalEntryItem | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | I_JournalEntryItem | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | I_JournalEntryItem | LedgerGLLineItem | General Ledger Journal Entry Line Item |
| KEY | Ledger | I_JournalEntryItem | Ledger | Ledger in General Ledger Accounting |
| FiscalYearVariant | I_JournalEntryItem | FiscalYearVariant | Fiscal Year Variant | |
| ChartOfAccounts | I_JournalEntryItem | ChartOfAccounts | Chart of Accounts | |
| ControllingArea | I_JournalEntryItem | ControllingArea | Controlling Area | |
| AccountingDocumentCreationDate | Accounting Document Entry Date | |||
| CreationTime | Creation Time | |||
| LastChangeDate | Last Change Date | |||
| JournalEntryLastChangeDateTime | Journal Entry Last Change Date Time | |||
| ExchangeRateDate | Exchange Rate Date | |||
| TransactionCode | Transaction Code | |||
| IntercompanyTransaction | Intercompany Transaction Number | |||
| DocumentReferenceID | Document Reference ID | |||
| RecurringAccountingDocument | Recurring Journal Entry | |||
| ReverseDocument | Reverse Document | |||
| ReverseDocumentFiscalYear | Reverse Document Fiscal Year | |||
| AccountingDocumentHeaderText | Document Header Text | |||
| AbsoluteExchangeRate | Absolute Exchange Rate | |||
| ExchangeRate | Exchange Rate | |||
| ExchRateIsIndirectQuotation | Exchange Rate Is Indirect Quotation | |||
| EffectiveExchangeRate | Effective Exchange Rate | |||
| BatchInputSession | Batch Input Session | |||
| OriginalReferenceDocument | Object key | |||
| ReversalIsPlanned | Indicator: Reversal Is Planned for Document | |||
| PlannedReversalDate | Planned Date for the Reversal Posting | |||
| TaxIsCalculatedAutomatically | Tax Is Automatically Calculated | |||
| TaxBaseAmountIsNetAmount | Tax Base Amount is Net Amount | |||
| SourceCompanyCode | Source Company Code | |||
| TaxAbsoluteExchangeRate | Absolute Tax Exchange Rate | |||
| TaxExchangeRate | Tax Exchange Rate | |||
| TaxExchRateIsIndirectQuotation | Tax Exchange Rate Is Indirect Quotation | |||
| TaxEffectiveExchangeRate | Effective Tax Exchange Rate | |||
| ReversalReason | Reason for Reversal or Inverse Posting | |||
| Branch | Branch | |||
| Reference1InDocumentHeader | Internal ID of Reference Key 1 in Document Header | |||
| Reference2InDocumentHeader | Internal ID of Reference Key 2 in Document Header | |||
| InvoiceReceiptDate | Invoice Receipt Date | |||
| LedgerGroup | Ledger Group | |||
| AlternativeReferenceDocument | Alternative Reference Document | |||
| TaxReportingDate | Tax Reporting Date | |||
| AccountingDocumentClass | Accounting Document Class | |||
| ExchangeRateType | Exchange Rate Type | |||
| SenderLogicalSystem | Sender Logical System | |||
| SenderCompanyCode | Company Code in Sender System | |||
| SenderAccountingDocument | Sender Journal Entry | |||
| SenderFiscalYear | Fiscal Year in Sender System | |||
| LatePaymentReason | Late Payment Reason | |||
| SalesDocumentCondition | Sales Document Condition | |||
| LedgerFiscalYear | I_JournalEntryItem | LedgerFiscalYear | Fiscal Year of Ledger | |
| GLRecordType | I_JournalEntryItem | GLRecordType | Record Type | |
| FinancialTransactionType | I_JournalEntryItem | FinancialTransactionType | Financial Transaction Type | |
| BusinessTransactionType | I_JournalEntryItem | BusinessTransactionType | Business Transaction Type | |
| ReferenceDocumentType | I_JournalEntryItem | ReferenceDocumentType | Reference Document Type | |
| LogicalSystem | I_JournalEntryItem | LogicalSystem | Logical System | |
| ReferenceDocumentContext | I_JournalEntryItem | ReferenceDocumentContext | Reference Document Context | |
| ReferenceDocument | I_JournalEntryItem | ReferenceDocument | Reference Doc. Number | |
| ReferenceDocumentItem | I_JournalEntryItem | ReferenceDocumentItem | Reference Document Item | |
| ReferenceDocumentItemGroup | I_JournalEntryItem | ReferenceDocumentItemGroup | Reference Document Item Group | |
| IsReversal | I_JournalEntryItem | IsReversal | Indicator: Item is Reversing Another Item | |
| IsReversed | I_JournalEntryItem | IsReversed | Indicator: Item is Reversed | |
| ReversalReferenceDocumentCntxt | I_JournalEntryItem | ReversalReferenceDocumentCntxt | Reversal Reference Document Context | |
| ReversalReferenceDocument | I_JournalEntryItem | ReversalReferenceDocument | Reversal Reference Document | |
| IsSettlement | I_JournalEntryItem | IsSettlement | Indicator: Item is Settling or Transferring Another Item | |
| IsSettled | I_JournalEntryItem | IsSettled | Indicator: Line Item is Settled or Transferred | |
| PredecessorReferenceDocType | I_JournalEntryItem | PredecessorReferenceDocType | Predecessor Reference Document Type | |
| PredecessorReferenceDocCntxt | I_JournalEntryItem | PredecessorReferenceDocCntxt | Predecessor Reference Document Context | |
| PredecessorReferenceDocument | I_JournalEntryItem | PredecessorReferenceDocument | Predecessor Reference Document | |
| PredecessorReferenceDocItem | I_JournalEntryItem | PredecessorReferenceDocItem | Predecessor Reference Document Item | |
| SourceReferenceDocumentType | I_JournalEntryItem | SourceReferenceDocumentType | Source Reference Document Type | |
| SourceLogicalSystem | I_JournalEntryItem | SourceLogicalSystem | Source Logical System | |
| SourceReferenceDocumentCntxt | I_JournalEntryItem | SourceReferenceDocumentCntxt | Source Reference Document Context | |
| SourceReferenceDocument | I_JournalEntryItem | SourceReferenceDocument | Source Reference Document | |
| SourceReferenceDocumentItem | I_JournalEntryItem | SourceReferenceDocumentItem | Source Reference Document Item | |
| SourceReferenceDocSubitem | I_JournalEntryItem | SourceReferenceDocSubitem | Source Reference Document Subitem | |
| IsCommitment | I_JournalEntryItem | IsCommitment | Indicator: Is Commitment | |
| GLAccount | I_JournalEntryItem | GLAccount | General Ledger | |
| CostCenter | I_JournalEntryItem | CostCenter | Cost Center | |
| ProfitCenter | I_JournalEntryItem | ProfitCenter | Profit Center | |
| FunctionalArea | I_JournalEntryItem | FunctionalArea | Sendr Fctl Area | |
| BusinessArea | I_JournalEntryItem | BusinessArea | Business Area | |
| Segment | I_JournalEntryItem | Segment | Segment for Segmental Reporting | |
| PartnerCostCenter | I_JournalEntryItem | PartnerCostCenter | Partner Cost Center | |
| PartnerProfitCenter | I_JournalEntryItem | PartnerProfitCenter | Partner Profit Center | |
| PartnerFunctionalArea | I_JournalEntryItem | PartnerFunctionalArea | Partner Functional Area | |
| PartnerBusinessArea | I_JournalEntryItem | PartnerBusinessArea | Partner Business Area | |
| PartnerCompany | I_JournalEntryItem | PartnerCompany | Company ID of Trading Partner | |
| PartnerSegment | I_JournalEntryItem | PartnerSegment | Partner Segment for Segmental Reporting | |
| BalanceTransactionCurrency | I_JournalEntryItem | BalanceTransactionCurrency | Balance Transaction Currency | |
| AmountInBalanceTransacCrcy | I_JournalEntryItem | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | |
| TransactionCurrency | I_JournalEntryItem | TransactionCurrency | Transaction Currency | |
| AmountInTransactionCurrency | I_JournalEntryItem | AmountInTransactionCurrency | Amount in Transaction Currency | |
| CompanyCodeCurrency | I_JournalEntryItem | CompanyCodeCurrency | Company Code Currency | |
| AmountInCompanyCodeCurrency | I_JournalEntryItem | AmountInCompanyCodeCurrency | Amount in Company Code Currency | |
| GlobalCurrency | I_JournalEntryItem | GlobalCurrency | GM Billing Element: Global Currency | |
| AmountInGlobalCurrency | I_JournalEntryItem | AmountInGlobalCurrency | Amount in Global Currency | |
| FixedAmountInGlobalCrcy | I_JournalEntryItem | FixedAmountInGlobalCrcy | Fixed Amount in Global Currency | |
| GrpValnFixedAmtInGlobCrcy | I_JournalEntryItem | GrpValnFixedAmtInGlobCrcy | Group Valuation Fixed Amount in Global Currency | |
| PrftCtrValnFxdAmtInGlobCrcy | I_JournalEntryItem | PrftCtrValnFxdAmtInGlobCrcy | Profit Center Valuation Fixed Amount in Global Currency | |
| TotalPriceVarcInGlobalCrcy | I_JournalEntryItem | TotalPriceVarcInGlobalCrcy | Total Price Variance in Global Currency | |
| GrpValnTotPrcVarcInGlobCrcy | I_JournalEntryItem | GrpValnTotPrcVarcInGlobCrcy | Group Valuation Total Price Variance in Global Currency | |
| PrftCtrValnTotPrcVarcInGlbCrcy | I_JournalEntryItem | PrftCtrValnTotPrcVarcInGlbCrcy | Profit Center Valuation Total Price Variance in Global Cur. | |
| FixedPriceVarcInGlobalCrcy | I_JournalEntryItem | FixedPriceVarcInGlobalCrcy | Fixed Price Variance in Global Currency | |
| GrpValnFixedPrcVarcInGlobCrcy | I_JournalEntryItem | GrpValnFixedPrcVarcInGlobCrcy | Group Valuation Fixed Price Variance in Global Currency | |
| PrftCtrValnFxdPrcVarcInGlbCrcy | I_JournalEntryItem | PrftCtrValnFxdPrcVarcInGlbCrcy | Profit Center Valuation Fixed Price Variance in Global Cur. | |
| FreeDefinedCurrency1 | I_JournalEntryItem | FreeDefinedCurrency1 | Freely Defined Currency 1 | |
| AmountInFreeDefinedCurrency1 | I_JournalEntryItem | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| FreeDefinedCurrency2 | I_JournalEntryItem | FreeDefinedCurrency2 | Freely Defined Currency 2 | |
| AmountInFreeDefinedCurrency2 | I_JournalEntryItem | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | |
| FreeDefinedCurrency3 | I_JournalEntryItem | FreeDefinedCurrency3 | Freely Defined Currency 3 | |
| AmountInFreeDefinedCurrency3 | I_JournalEntryItem | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | |
| FreeDefinedCurrency4 | I_JournalEntryItem | FreeDefinedCurrency4 | Freely Defined Currency 4 | |
| AmountInFreeDefinedCurrency4 | I_JournalEntryItem | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | |
| FreeDefinedCurrency5 | I_JournalEntryItem | FreeDefinedCurrency5 | Freely Defined Currency 5 | |
| AmountInFreeDefinedCurrency5 | I_JournalEntryItem | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | |
| FreeDefinedCurrency6 | I_JournalEntryItem | FreeDefinedCurrency6 | Freely Defined Currency 6 | |
| AmountInFreeDefinedCurrency6 | I_JournalEntryItem | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | |
| FreeDefinedCurrency7 | I_JournalEntryItem | FreeDefinedCurrency7 | Freely Defined Currency 7 | |
| AmountInFreeDefinedCurrency7 | I_JournalEntryItem | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | |
| FreeDefinedCurrency8 | I_JournalEntryItem | FreeDefinedCurrency8 | Freely Defined Currency 8 | |
| AmountInFreeDefinedCurrency8 | I_JournalEntryItem | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | |
| ControllingObjectCurrency | I_JournalEntryItem | ControllingObjectCurrency | CO Object Currency | |
| AmountInObjectCurrency | I_JournalEntryItem | AmountInObjectCurrency | Amount in Object Currency | |
| BaseUnit | I_JournalEntryItem | BaseUnit | Base Unit of Measure | |
| Quantity | I_JournalEntryItem | Quantity | Quantity | |
| FixedQuantity | I_JournalEntryItem | FixedQuantity | Fixed Quantity | |
| CostSourceUnit | I_JournalEntryItem | CostSourceUnit | Cost Source Unit | |
| ValuationQuantity | I_JournalEntryItem | ValuationQuantity | Valuation Quantity | |
| ValuationFixedQuantity | I_JournalEntryItem | ValuationFixedQuantity | Valuation Fixed Quantity | |
| AdditionalQuantity1Unit | I_JournalEntryItem | AdditionalQuantity1Unit | Additional Quantity 1 Unit | |
| AdditionalQuantity1 | I_JournalEntryItem | AdditionalQuantity1 | Additional Quantity 1 | |
| AdditionalQuantity2Unit | I_JournalEntryItem | AdditionalQuantity2Unit | Additional Quantity 2 Unit | |
| AdditionalQuantity2 | I_JournalEntryItem | AdditionalQuantity2 | Additional Quantity 2 | |
| AdditionalQuantity3Unit | I_JournalEntryItem | AdditionalQuantity3Unit | Additional Quantity 3 Unit | |
| AdditionalQuantity3 | I_JournalEntryItem | AdditionalQuantity3 | Additional Quantity 3 | |
| DebitCreditCode | I_JournalEntryItem | DebitCreditCode | Single-Character Flag | |
| FiscalPeriod | I_JournalEntryItem | FiscalPeriod | Fiscal Period | |
| FiscalYearPeriod | I_JournalEntryItem | FiscalYearPeriod | Fiscal Year Period | |
| PostingDate | I_JournalEntryItem | PostingDate | Posting Date for GR | |
| DocumentDate | I_JournalEntryItem | DocumentDate | Journal Entry Date | |
| AccountingDocumentType | I_JournalEntryItem | AccountingDocumentType | Journal Entry Type | |
| AccountingDocumentItem | I_JournalEntryItem | AccountingDocumentItem | Journal Entry Posting View Item | |
| AssignmentReference | I_JournalEntryItem | AssignmentReference | Assignment Reference | |
| AccountingDocumentCategory | I_JournalEntryItem | AccountingDocumentCategory | Journal Entry Category | |
| PostingKey | I_JournalEntryItem | PostingKey | Posting Key | |
| TransactionTypeDetermination | I_JournalEntryItem | TransactionTypeDetermination | Transaction Key | |
| SubLedgerAcctLineItemType | I_JournalEntryItem | SubLedgerAcctLineItemType | Subledger-Specific Line Item Type | |
| AccountingDocCreatedByUser | I_JournalEntryItem | AccountingDocCreatedByUser | User which created overhead document | |
| LastChangeDateTime | I_JournalEntryItem | LastChangeDateTime | Last Change Date Time | |
| CreationDateTime | Date time of creation of Journal Entry Item | |||
| EliminationProfitCenter | I_JournalEntryItem | EliminationProfitCenter | Elimination Profit Center | |
| OriginObjectType | I_JournalEntryItem | OriginObjectType | Type of Origin Object | |
| GLAccountType | I_JournalEntryItem | GLAccountType | Type of a General Ledger Account | |
| AlternativeGLAccount | I_JournalEntryItem | AlternativeGLAccount | Alternative G/L Account Number In Company Code | |
| CountryChartOfAccounts | I_JournalEntryItem | CountryChartOfAccounts | Alternative Chart of Accounts for Country/Region | |
| InvoiceReference | I_JournalEntryItem | InvoiceReference | Invoice Reference | |
| InvoiceReferenceFiscalYear | I_JournalEntryItem | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | |
| FollowOnDocumentType | I_JournalEntryItem | FollowOnDocumentType | Follow-On Document Type | |
| InvoiceItemReference | I_JournalEntryItem | InvoiceItemReference | Invoice Item Reference | |
| ReferencePurchaseOrderCategory | ReferencePurchaseOrderCategory | Category of Reference Purchase Order | ||
| PurchasingDocument | I_JournalEntryItem | PurchasingDocument | Purchasing Document | |
| PurchasingDocumentItem | I_JournalEntryItem | PurchasingDocumentItem | Purchasing Document Item | |
| AccountAssignmentNumber | I_JournalEntryItem | AccountAssignmentNumber | Account Assignment Number | |
| DocumentItemText | I_JournalEntryItem | DocumentItemText | Item Text | |
| SalesDocument | I_JournalEntryItem | SalesDocument | Sales Document | |
| SalesDocumentItem | I_JournalEntryItem | SalesDocumentItem | Sales Document Item | |
| SalesOrder | I_JournalEntryItem | SalesOrder | SD Document | |
| SalesOrderItem | I_JournalEntryItem | SalesOrderItem | Sales Order Item | |
| Product | I_JournalEntryItem | Product | Product Sold | |
| Material | I_JournalEntryItem | Material | Material Number | |
| Plant | I_JournalEntryItem | Plant | Valuation Area | |
| Supplier | I_JournalEntryItem | Supplier | Supplier | |
| Customer | I_JournalEntryItem | Customer | Customer Number | |
| ServicesRenderedDate | I_JournalEntryItem | ServicesRenderedDate | Date on which services are rendered | |
| FinancialAccountType | I_JournalEntryItem | FinancialAccountType | Fin. Account Type | |
| SpecialGLCode | I_JournalEntryItem | SpecialGLCode | Special G/L Indicator | |
| TaxCode | I_JournalEntryItem | TaxCode | Tax on Sales/Purchases Code | |
| HouseBank | I_JournalEntryItem | HouseBank | House Bank Key | |
| HouseBankAccount | I_JournalEntryItem | HouseBankAccount | House Bank Account | |
| IsOpenItemManaged | I_JournalEntryItem | IsOpenItemManaged | Managed on an Open Item Basis | |
| ClearingDate | I_JournalEntryItem | ClearingDate | Clearing Date | |
| ClearingJournalEntryFiscalYear | I_JournalEntryItem | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | |
| ClearingDocFiscalYear | I_JournalEntryItem | ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry (Deprecated) | |
| ClearingJournalEntry | I_JournalEntryItem | ClearingJournalEntry | Clearing Journal Entry | |
| ClearingAccountingDocument | I_JournalEntryItem | ClearingAccountingDocument | Clearing Journal Entry (Deprecated) | |
| AssetDepreciationArea | I_JournalEntryItem | AssetDepreciationArea | Asset Depreciation Area (Real or Derived) | |
| ServiceDocumentType | I_JournalEntryItem | ServiceDocumentType | Service Document Type | |
| ServiceDocument | I_JournalEntryItem | ServiceDocument | Service Document ID | |
| ServiceDocumentItem | I_JournalEntryItem | ServiceDocumentItem | Service Document Item ID | |
| MasterFixedAsset | I_JournalEntryItem | MasterFixedAsset | Fixed Asset (Main Asset Number) | |
| FixedAsset | I_JournalEntryItem | FixedAsset | Asset Subnumber | |
| AssetValueDate | I_JournalEntryItem | AssetValueDate | Asset Value Date | |
| AssetTransactionType | I_JournalEntryItem | AssetTransactionType | Asset Transaction Type | |
| AssetAcctTransClassfctn | I_JournalEntryItem | AssetAcctTransClassfctn | Transaction Type Category | |
| DepreciationFiscalPeriod | I_JournalEntryItem | DepreciationFiscalPeriod | Fiscal Period of Depreciation | |
| GroupMasterFixedAsset | I_JournalEntryItem | GroupMasterFixedAsset | Group Asset | |
| GroupFixedAsset | I_JournalEntryItem | GroupFixedAsset | Group Asset Subnumber | |
| CostEstimate | I_JournalEntryItem | CostEstimate | Cost EstimateNo | |
| InventorySpecialStockValnType | I_JournalEntryItem | InventorySpecialStockValnType | Inventory Special Stock Valuation Type (Deprecated) | |
| InvtrySpecialStockValnType_2 | I_JournalEntryItem | InvtrySpecialStockValnType_2 | Inventory Special Stock Valuation Type | |
| InventorySpecialStockType | I_JournalEntryItem | InventorySpecialStockType | Inventory Special Stock Type | |
| InventorySpclStkSalesDocument | I_JournalEntryItem | InventorySpclStkSalesDocument | Inventory Special Stock Sales Document | |
| InventorySpclStkSalesDocItm | I_JournalEntryItem | InventorySpclStkSalesDocItm | Inventory Special Stock Sales Document Item | |
| InvtrySpclStockWBSElmntIntID | I_JournalEntryItem | InvtrySpclStockWBSElmntIntID | Inventory Special Stock WBS Element Internal ID | |
| InventorySpclStockWBSElement | I_JournalEntryItem | InventorySpclStockWBSElement | Inventory Special Stock WBS Element | |
| InvtrySpclStockWBSElmntExtID | Inventory Special Stock WBS Element External ID | |||
| InventorySpecialStockSupplier | I_JournalEntryItem | InventorySpecialStockSupplier | Supplier of Inventory Special Stock | |
| InventoryValuationType | I_JournalEntryItem | InventoryValuationType | Inventory Valuation Type | |
| ValuationArea | I_JournalEntryItem | ValuationArea | Valuation Area | |
| SenderGLAccount | I_JournalEntryItem | SenderGLAccount | Sender G/L Account | |
| SenderAccountAssignment | I_JournalEntryItem | SenderAccountAssignment | Sender Account Assignment | |
| SenderAccountAssignmentType | I_JournalEntryItem | SenderAccountAssignmentType | Account Assignment Type in Sender System | |
| ControllingObject | I_JournalEntryItem | ControllingObject | Controlling Object | |
| CostOriginGroup | I_JournalEntryItem | CostOriginGroup | Origin Group as Subdivision of Cost Element | |
| OriginSenderObject | I_JournalEntryItem | OriginSenderObject | Origin Sender Object | |
| ControllingDebitCreditCode | I_JournalEntryItem | ControllingDebitCreditCode | Controlling Debit Credit Code | |
| ControllingObjectDebitType | I_JournalEntryItem | ControllingObjectDebitType | Controlling Object Debit Type | |
| QuantityIsIncomplete | I_JournalEntryItem | QuantityIsIncomplete | Indicator: Quantity is Incomplete | |
| OffsettingChartOfAccounts | I_JournalEntryItem | OffsettingChartOfAccounts | Offsetting Chart of Accounts | |
| OffsettingAccount | I_JournalEntryItem | OffsettingAccount | Offsetting Account | |
| OffsettingAccountType | I_JournalEntryItem | OffsettingAccountType | Offsetting Account Type | |
| LineItemIsCompleted | I_JournalEntryItem | LineItemIsCompleted | Indicator: Line Item is Completed | |
| PersonnelNumber | I_JournalEntryItem | PersonnelNumber | Personnel Number | |
| ControllingObjectClass | I_JournalEntryItem | ControllingObjectClass | Controlling Object Class | |
| PartnerCompanyCode | I_JournalEntryItem | PartnerCompanyCode | Partner Company Code | |
| PartnerControllingObjectClass | I_JournalEntryItem | PartnerControllingObjectClass | Partner Controlling Object Class | |
| OriginCostCenter | I_JournalEntryItem | OriginCostCenter | Origin Cost Center | |
| OriginCostCtrActivityType | I_JournalEntryItem | OriginCostCtrActivityType | Origin Cost Center Activity Type | |
| AccountAssignment | I_JournalEntryItem | AccountAssignment | Sender Acct Assgmt | |
| AccountAssignmentType | I_JournalEntryItem | AccountAssignmentType | Account Assignment Type | |
| CostCtrActivityType | I_JournalEntryItem | CostCtrActivityType | Activity Type | |
| OrderID | I_JournalEntryItem | OrderID | Order ID | |
| OrderCategory | I_JournalEntryItem | OrderCategory | Order Category | |
| WBSElement | I_JournalEntryItem | WBSElement | WBS Internal ID | |
| WBSElementInternalID | I_JournalEntryItem | WBSElementInternalID | WBS Element Internal ID | |
| WBSElementExternalID | WBS Element External ID | |||
| WorkPackage | I_JournalEntryItem | WorkPackage | Plan Item | |
| Project | I_JournalEntryItem | Project | WBS Element | |
| ProjectInternalID | I_JournalEntryItem | ProjectInternalID | Project Internal ID | |
| ProjectExternalID | Project External ID | |||
| OperatingConcern | I_JournalEntryItem | OperatingConcern | Operating concern | |
| ProjectNetwork | I_JournalEntryItem | ProjectNetwork | Network Number for Account Assignment | |
| RelatedNetworkActivity | I_JournalEntryItem | RelatedNetworkActivity | Related Network Activity | |
| BusinessProcess | I_JournalEntryItem | BusinessProcess | Business Process | |
| CostObject | I_JournalEntryItem | CostObject | Cost Object | |
| CostAnalysisResource | I_JournalEntryItem | CostAnalysisResource | Cost Analysis Resource | |
| CustomerServiceNotification | I_JournalEntryItem | CustomerServiceNotification | Customer Service Notification | |
| PartnerAccountAssignment | I_JournalEntryItem | PartnerAccountAssignment | Partner Account Assignment | |
| PartnerAccountAssignmentType | I_JournalEntryItem | PartnerAccountAssignmentType | Partner Account Assignment Type | |
| PartnerCostCtrActivityType | I_JournalEntryItem | PartnerCostCtrActivityType | Partner Cost Center Activity Type | |
| PartnerOrder | I_JournalEntryItem | PartnerOrder | Partner Order (Deprecated) | |
| PartnerOrder_2 | I_JournalEntryItem | PartnerOrder_2 | Partner Order | |
| PartnerOrderCategory | I_JournalEntryItem | PartnerOrderCategory | Partner Order Category | |
| PartnerWBSElement | I_JournalEntryItem | PartnerWBSElement | Partner WBS Element | |
| PartnerWBSElementInternalID | I_JournalEntryItem | PartnerWBSElementInternalID | Partner WBS Element Internal ID | |
| PartnerWBSElementExternalID | Partner WBS Element External ID | |||
| PartnerProject | I_JournalEntryItem | PartnerProject | Partner Project | |
| PartnerProjectInternalID | I_JournalEntryItem | PartnerProjectInternalID | Partner Project Internal ID | |
| PartnerProjectExternalID | Partner Project External ID | |||
| PartnerSalesDocument | I_JournalEntryItem | PartnerSalesDocument | Partner Sales Document | |
| PartnerSalesDocumentItem | I_JournalEntryItem | PartnerSalesDocumentItem | Partner Sales Document Item | |
| PartnerProjectNetwork | I_JournalEntryItem | PartnerProjectNetwork | Partner Project Network | |
| PartnerProjectNetworkActivity | I_JournalEntryItem | PartnerProjectNetworkActivity | Partner Project Network Activity | |
| PartnerBusinessProcess | I_JournalEntryItem | PartnerBusinessProcess | Partner Business Process | |
| PartnerCostObject | I_JournalEntryItem | PartnerCostObject | Partner Cost Object | |
| WorkItem | I_JournalEntryItem | WorkItem | Work Item ID | |
| BillingDocumentType | I_JournalEntryItem | BillingDocumentType | Billing Type | |
| SalesOrganization | I_JournalEntryItem | SalesOrganization | Sales Organization | |
| DistributionChannel | I_JournalEntryItem | DistributionChannel | Distribution Channel | |
| OrganizationDivision | I_JournalEntryItem | OrganizationDivision | Org. Division | |
| SoldProduct | I_JournalEntryItem | SoldProduct | Product Sold | |
| SoldMaterial | I_JournalEntryItem | SoldMaterial | Sold Material | |
| ProductGroup | I_JournalEntryItem | ProductGroup | Product Group for Maintenance Orders | |
| MaterialGroup | I_JournalEntryItem | MaterialGroup | Product Sold Group (Deprecated) | |
| SoldProductGroup | I_JournalEntryItem | SoldProductGroup | Product Sold Group | |
| CustomerGroup | I_JournalEntryItem | CustomerGroup | Customer Group | |
| CustomerSupplierCountry | I_JournalEntryItem | CustomerSupplierCountry | Customer or Supplier Country/Region | |
| CustomerSupplierIndustry | I_JournalEntryItem | CustomerSupplierIndustry | Customer Supplier Industry | |
| SalesDistrict | I_JournalEntryItem | SalesDistrict | Sales District | |
| BillToParty | I_JournalEntryItem | BillToParty | Inv. Recipient | |
| ShipToParty | I_JournalEntryItem | ShipToParty | Ship-To Party (obsolete) | |
| CustomerSupplierCorporateGroup | I_JournalEntryItem | CustomerSupplierCorporateGroup | Customer Supplier Corporate Group | |
| FinancialManagementArea | I_JournalEntryItem | FinancialManagementArea | Financial Management Area | |
| Fund | I_JournalEntryItem | Fund | Sender Fund | |
| GrantID | I_JournalEntryItem | GrantID | Sender Grant | |
| BudgetPeriod | I_JournalEntryItem | BudgetPeriod | Budget Period | |
| PartnerFund | I_JournalEntryItem | PartnerFund | Receiver Fund | |
| PartnerGrant | I_JournalEntryItem | PartnerGrant | Receiver Grant | |
| PartnerBudgetPeriod | I_JournalEntryItem | PartnerBudgetPeriod | FM: Partner Budget Period | |
| FundsCenter | I_JournalEntryItem | FundsCenter | Funds Management Center | |
| FundedProgram | I_JournalEntryItem | FundedProgram | Funded Program | |
| JointVenture | I_JournalEntryItem | JointVenture | Joint venture | |
| JointVentureEquityGroup | I_JournalEntryItem | JointVentureEquityGroup | Joint Venture Equity Group | |
| JointVentureCostRecoveryCode | I_JournalEntryItem | JointVentureCostRecoveryCode | Joint Venture Cost Recovery Code | |
| JointVentureEquityType | I_JournalEntryItem | JointVentureEquityType | Joint Venture Equity Type | |
| SettlementReferenceDate | I_JournalEntryItem | SettlementReferenceDate | Settlement Reference Date | |
| NetDueDate | I_JournalEntryItem | NetDueDate | Net Due Date | |
| DebitAmountInCoCodeCrcy | I_JournalEntryItem | DebitAmountInCoCodeCrcy | Debit Amount in Company Code Currency | |
| CreditAmountInCoCodeCrcy | I_JournalEntryItem | CreditAmountInCoCodeCrcy | Credit Amount in Company Code Currency | |
| DebitAmountInTransCrcy | I_JournalEntryItem | DebitAmountInTransCrcy | Debit Amount in Transaction Currency | |
| CreditAmountInTransCrcy | I_JournalEntryItem | CreditAmountInTransCrcy | Credit Amount in Transaction Currency | |
| DebitAmountInBalanceTransCrcy | I_JournalEntryItem | DebitAmountInBalanceTransCrcy | Debit Amount in Balance Transaction Currency | |
| CreditAmountInBalanceTransCrcy | I_JournalEntryItem | CreditAmountInBalanceTransCrcy | Credit Amount in Balance Transaction Currency | |
| DebitAmountInGlobalCrcy | I_JournalEntryItem | DebitAmountInGlobalCrcy | Debit Amount in Global Currency | |
| CreditAmountInGlobalCrcy | I_JournalEntryItem | CreditAmountInGlobalCrcy | Credit Amount in Global Currency | |
| DebitAmountInFreeDefinedCrcy1 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy1 | Debit Amount in Free Defined Currency 1 | |
| CreditAmountInFreeDefinedCrcy1 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy1 | Credit Amount in Free Defined Currency 1 | |
| DebitAmountInFreeDefinedCrcy2 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy2 | Debit Amount in Free Defined Currency 2 | |
| CreditAmountInFreeDefinedCrcy2 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy2 | Credit Amount in Free Defined Currency 2 | |
| DebitAmountInFreeDefinedCrcy3 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy3 | Debit Amount in Free Defined Currency 3 | |
| CreditAmountInFreeDefinedCrcy3 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy3 | Credit Amount in Free Defined Currency 3 | |
| DebitAmountInFreeDefinedCrcy4 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy4 | Debit Amount in Free Defined Currency 4 | |
| CreditAmountInFreeDefinedCrcy4 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy4 | Credit Amount in Free Defined Currency 4 | |
| DebitAmountInFreeDefinedCrcy5 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy5 | Debit Amount in Free Defined Currency 5 | |
| CreditAmountInFreeDefinedCrcy5 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy5 | Credit Amount in Free Defined Currency 5 | |
| DebitAmountInFreeDefinedCrcy6 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy6 | Debit Amount in Free Defined Currency 6 | |
| CreditAmountInFreeDefinedCrcy6 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy6 | Credit Amount in Free Defined Currency 6 | |
| DebitAmountInFreeDefinedCrcy7 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy7 | Debit Amount in Free Defined Currency 7 | |
| CreditAmountInFreeDefinedCrcy7 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy7 | Credit Amount in Free Defined Currency 7 | |
| DebitAmountInFreeDefinedCrcy8 | I_JournalEntryItem | DebitAmountInFreeDefinedCrcy8 | Debit Amount in Free Defined Currency 8 | |
| CreditAmountInFreeDefinedCrcy8 | I_JournalEntryItem | CreditAmountInFreeDefinedCrcy8 | Credit Amount in Free Defined Currency 8 | |
| IsStatisticalOrder | I_JournalEntryItem | IsStatisticalOrder | Indicator: Internal Order is Statistical Account Assignment | |
| IsStatisticalCostCenter | I_JournalEntryItem | IsStatisticalCostCenter | Indicator: Cost Center is Statistical Account Assignment | |
| IsStatisticalSalesDocument | I_JournalEntryItem | IsStatisticalSalesDocument | Sales Document is statistical | |
| WBSIsStatisticalWBSElement | I_JournalEntryItem | WBSIsStatisticalWBSElement | Indicator: WBS Element is Statistical Account Assignment | |
| ClearingCreationDate | _OperationalAcctgDocItem | ClearingCreationDate | Clearing Creation Date | |
| SpecialGLTransactionType | _OperationalAcctgDocItem | SpecialGLTransactionType | Special G/L Transaction Type | |
| WithholdingTaxCode | _OperationalAcctgDocItem | WithholdingTaxCode | Withholding Tax Code | |
| TaxType | _OperationalAcctgDocItem | TaxType | Tax Type | |
| ValueDate | _OperationalAcctgDocItem | ValueDate | Value Date | |
| CorporateGroupAccount | _OperationalAcctgDocItem | CorporateGroupAccount | Corporate Group Account | |
| PlanningLevel | _OperationalAcctgDocItem | PlanningLevel | Planning Level | |
| BillingDocument | _OperationalAcctgDocItem | BillingDocument | Billing Document | |
| ScheduleLine | _OperationalAcctgDocItem | ScheduleLine | Schedule Line | |
| IsSalesRelated | _OperationalAcctgDocItem | IsSalesRelated | Is Sales Related | |
| LineItemDisplayIsEnabled | _OperationalAcctgDocItem | LineItemDisplayIsEnabled | Indicator: Can Line Items Be Displayed by Account? | |
| IsNotCashDiscountLiable | _OperationalAcctgDocItem | IsNotCashDiscountLiable | Is Not Cash Discount Liable | |
| IsAutomaticallyCreated | _OperationalAcctgDocItem | IsAutomaticallyCreated | Is Automatically Created | |
| IsUsedInPaymentTransaction | _OperationalAcctgDocItem | IsUsedInPaymentTransaction | Is Used In Payment Transaction | |
| OperationalGLAccount | _OperationalAcctgDocItem | OperationalGLAccount | Operational General Ledger Account | |
| BranchAccount | _OperationalAcctgDocItem | BranchAccount | Branch Account No. | |
| IsBalanceSheetAccount | _OperationalAcctgDocItem | IsBalanceSheetAccount | Is Balance Sheet Account | |
| ProfitLossAccountType | _OperationalAcctgDocItem | ProfitLossAccountType | Profit Loss Account Type | |
| SpecialGLAccountAssignment | _OperationalAcctgDocItem | SpecialGLAccountAssignment | Assignment Number for Special G/L Accounts | |
| DueCalculationBaseDate | _OperationalAcctgDocItem | DueCalculationBaseDate | Due Calculation Base Date | |
| PaymentTerms | _OperationalAcctgDocItem | PaymentTerms | Terms of Payment Key | |
| PaymentMethod | _OperationalAcctgDocItem | PaymentMethod | Payment Method | |
| PaymentBlockingReason | _OperationalAcctgDocItem | PaymentBlockingReason | Payment Blocking Reason | |
| FixedCashDiscount | _OperationalAcctgDocItem | FixedCashDiscount | Fixed Cash Discount | |
| TaxDistributionCode1 | _OperationalAcctgDocItem | TaxDistributionCode1 | Tax Code 1 for Distribution | |
| TaxDistributionCode2 | _OperationalAcctgDocItem | TaxDistributionCode2 | Tax Code 2 for Distribution | |
| TaxDistributionCode3 | _OperationalAcctgDocItem | TaxDistributionCode3 | Tax Code 3 for Distribution | |
| StateCentralBankPaymentReason | _OperationalAcctgDocItem | StateCentralBankPaymentReason | State Central Bank Indicator | |
| SupplyingCountry | _OperationalAcctgDocItem | SupplyingCountry | Supplying Country/Region | |
| InvoiceList | _OperationalAcctgDocItem | InvoiceList | Invoice List | |
| BillOfExchangeUsage | _OperationalAcctgDocItem | BillOfExchangeUsage | Bill of Exchange Usage Type | |
| DunningKey | _OperationalAcctgDocItem | DunningKey | Dunning Key | |
| LastDunningDate | _OperationalAcctgDocItem | LastDunningDate | Date of Last Dunning Notice | |
| DunningLevel | _OperationalAcctgDocItem | DunningLevel | Dunning Level | |
| DunningArea | _OperationalAcctgDocItem | DunningArea | Dunning Area | |
| WithholdingTaxCertificate | _OperationalAcctgDocItem | WithholdingTaxCertificate | Withholding Tax Certificate | |
| IsCompletelyDelivered | _OperationalAcctgDocItem | IsCompletelyDelivered | Is completely delivered | |
| VATRegistration | _OperationalAcctgDocItem | VATRegistration | VAT Registration No. | |
| DelivOfGoodsDestCountry | _OperationalAcctgDocItem | DelivOfGoodsDestCountry | Country/Region of Destination for Delivery of Goods | |
| PaymentDifferenceReason | _OperationalAcctgDocItem | PaymentDifferenceReason | Payment Difference Reason | |
| TreasuryContractType | _OperationalAcctgDocItem | TreasuryContractType | Treasury Contract Type | |
| AssetContract | _OperationalAcctgDocItem | AssetContract | Asset Contract | |
| CashFlowType | _OperationalAcctgDocItem | CashFlowType | Flow Type | |
| TaxJurisdiction | _OperationalAcctgDocItem | TaxJurisdiction | Tax Jurisdiction | |
| REInternalFinNumber | _OperationalAcctgDocItem | REInternalFinNumber | Internal Key of Real Estate Object (FI) | |
| RealEstateObject | _OperationalAcctgDocItem | RealEstateObject | Internal Key for Real Estate Object | |
| CommitmentItem | _OperationalAcctgDocItem | CommitmentItem | Commitment item | |
| CommitmentItemShortID | _OperationalAcctgDocItem | CommitmentItemShortID | Commitment Item Short ID | |
| OrderInternalBillOfOperations | _OperationalAcctgDocItem | OrderInternalBillOfOperations | Order Internal Bill of Operations ID | |
| OrderIntBillOfOperationsItem | _OperationalAcctgDocItem | OrderIntBillOfOperationsItem | Order Internal Bill of Operations Item | |
| IsEUTriangularDeal | _OperationalAcctgDocItem | IsEUTriangularDeal | Is EU Triangular Deal | |
| CompanyCodeCurrencyDetnMethod | _OperationalAcctgDocItem | CompanyCodeCurrencyDetnMethod | Company Code Currency Determination Method | |
| ClearingIsReversed | _OperationalAcctgDocItem | ClearingIsReversed | Clearing Is Reversed | |
| PaymentMethodSupplement | _OperationalAcctgDocItem | PaymentMethodSupplement | Payment Method Supplement | |
| Reference1IDByBusinessPartner | _OperationalAcctgDocItem | Reference1IDByBusinessPartner | ID of Reference 1 by Business Partner | |
| Reference2IDByBusinessPartner | _OperationalAcctgDocItem | Reference2IDByBusinessPartner | ID of Reference 2 by Business Partner | |
| IsNegativePosting | _OperationalAcctgDocItem | IsNegativePosting | Is Negative Posting | |
| PaymentCardItem | _OperationalAcctgDocItem | PaymentCardItem | Payment Card Item | |
| PaymentCardPaymentSettlement | _OperationalAcctgDocItem | PaymentCardPaymentSettlement | Payment Card Payment Settlement | |
| CreditControlArea | _OperationalAcctgDocItem | CreditControlArea | Credit Control Area | |
| Reference3IDByBusinessPartner | _OperationalAcctgDocItem | Reference3IDByBusinessPartner | ID of Reference 3 by Business Partner | |
| DataExchangeInstruction1 | _OperationalAcctgDocItem | DataExchangeInstruction1 | Data Exchange Instruction 1 | |
| DataExchangeInstruction2 | _OperationalAcctgDocItem | DataExchangeInstruction2 | Data Exchange Instruction 2 | |
| DataExchangeInstruction3 | _OperationalAcctgDocItem | DataExchangeInstruction3 | Data Exchange Instruction 3 | |
| DataExchangeInstruction4 | _OperationalAcctgDocItem | DataExchangeInstruction4 | Data Exchange Instruction 4 | |
| Region | _OperationalAcctgDocItem | Region | Region (State, Province, County) | |
| HasPaymentOrder | _OperationalAcctgDocItem | HasPaymentOrder | Indicator: Payment Order Exists for this Item | |
| PaymentReference | _OperationalAcctgDocItem | PaymentReference | Payment Reference | |
| TaxDeterminationDate | _OperationalAcctgDocItem | TaxDeterminationDate | Date for Determination of Tax Rates | |
| BusinessPlace | _OperationalAcctgDocItem | BusinessPlace | Business place | |
| TaxSection | _OperationalAcctgDocItem | TaxSection | Tax Section | |
| AccountsReceivableIsPledged | _OperationalAcctgDocItem | AccountsReceivableIsPledged | Accounts Receivable Is Pledged | |
| AcctsReceivablePledgingCode | _OperationalAcctgDocItem | AcctsReceivablePledgingCode | Accounts Receivable Pledging Code | |
| CustomerIsInExecution | _OperationalAcctgDocItem | CustomerIsInExecution | Customer Is In Execution | |
| CostElement | _OperationalAcctgDocItem | CostElement | Cost Element | |
| PaymentServiceProvider | _OperationalAcctgDocItem | PaymentServiceProvider | Payment Service Provider | |
| PaymentRefByPaytSrvcProvider | _OperationalAcctgDocItem | PaymentRefByPaytSrvcProvider | Payment Reference by Payment Service Provider | |
| SEPAMandate | _OperationalAcctgDocItem | SEPAMandate | Unique Reference to Mandate for each Payee | |
| ReferenceDocumentLogicalSystem | _OperationalAcctgDocItem | ReferenceDocumentLogicalSystem | Logical System of Reference Document | |
| AccountingDocumentItemRef | _OperationalAcctgDocItem | AccountingDocumentItemRef | Journal Entry Line Item Reference | |
| CashDiscount1DueDate | _OperationalAcctgDocItem | CashDiscount1DueDate | Due Date for Cash Discount 1 | |
| CashDiscount2DueDate | _OperationalAcctgDocItem | CashDiscount2DueDate | Cash Discount 2 Due Date | |
| BranchCode | _OperationalAcctgDocItem | BranchCode | Branch Code | |
| PaymentCurrency | _OperationalAcctgDocItem | PaymentCurrency | Currency for Automatic Payment | |
| CreditControlAreaCurrency | _OperationalAcctgDocItem | CreditControlAreaCurrency | Credit Control Area Currency | |
| GoodsMovementEntryUnit | _OperationalAcctgDocItem | GoodsMovementEntryUnit | Unit of Entry | |
| PurchasingDocumentPriceUnit | _OperationalAcctgDocItem | PurchasingDocumentPriceUnit | Purchasing Document Price Unit | |
| MaterialPriceUnitQty | _OperationalAcctgDocItem | MaterialPriceUnitQty | Material Price Unit Quantity | |
| IN_GSTPartner | _OperationalAcctgDocItem | IN_GSTPartner | GST Partner | |
| IN_GSTPlaceOfSupply | _OperationalAcctgDocItem | IN_GSTPlaceOfSupply | Place of Supply | |
| IN_HSNOrSACCode | _OperationalAcctgDocItem | IN_HSNOrSACCode | HSN or SAC Code | |
| _JournalEntry | I_JournalEntryItem | _JournalEntry | ||
| _CompanyCode | I_JournalEntryItem | _CompanyCode | ||
| _FiscalYear | I_JournalEntryItem | _FiscalYear | ||
| _FiscalPeriod | I_JournalEntryItem | _FiscalPeriod | ||
| _LedgerFiscalYear | I_JournalEntryItem | _LedgerFiscalYear | ||
| _FiscalYearVariant | I_JournalEntryItem | _FiscalYearVariant | ||
| _ControllingArea | I_JournalEntryItem | _ControllingArea | ||
| _BalanceTransactionCurrency | I_JournalEntryItem | _BalanceTransactionCurrency | ||
| _TransactionCurrency | I_JournalEntryItem | _TransactionCurrency | ||
| _CompanyCodeCurrency | I_JournalEntryItem | _CompanyCodeCurrency | ||
| _GlobalCurrency | I_JournalEntryItem | _GlobalCurrency | ||
| _FreeDefinedCurrency1 | I_JournalEntryItem | _FreeDefinedCurrency1 | ||
| _FreeDefinedCurrency2 | I_JournalEntryItem | _FreeDefinedCurrency2 | ||
| _FreeDefinedCurrency3 | I_JournalEntryItem | _FreeDefinedCurrency3 | ||
| _FreeDefinedCurrency4 | I_JournalEntryItem | _FreeDefinedCurrency4 | ||
| _FreeDefinedCurrency5 | I_JournalEntryItem | _FreeDefinedCurrency5 | ||
| _FreeDefinedCurrency6 | I_JournalEntryItem | _FreeDefinedCurrency6 | ||
| _FreeDefinedCurrency7 | I_JournalEntryItem | _FreeDefinedCurrency7 | ||
| _FreeDefinedCurrency8 | I_JournalEntryItem | _FreeDefinedCurrency8 | ||
| _BaseUnit | I_JournalEntryItem | _BaseUnit | ||
| _CostSourceUnit | I_JournalEntryItem | _CostSourceUnit | ||
| _AdditionalQuantity1Unit | I_JournalEntryItem | _AdditionalQuantity1Unit | ||
| _AdditionalQuantity2Unit | I_JournalEntryItem | _AdditionalQuantity2Unit | ||
| _AdditionalQuantity3Unit | I_JournalEntryItem | _AdditionalQuantity3Unit | ||
| _Segment | I_JournalEntryItem | _Segment | ||
| _ProfitCenter | I_JournalEntryItem | _ProfitCenter | ||
| _CurrentProfitCenter | I_JournalEntryItem | _CurrentProfitCenter | ||
| _CostCenter | I_JournalEntryItem | _CostCenter | ||
| _CurrentCostCenter | I_JournalEntryItem | _CurrentCostCenter | ||
| _CostAnalysisResource | I_JournalEntryItem | _CostAnalysisResource | ||
| _WBSElementBasicData | I_JournalEntryItem | _WBSElementBasicData | ||
| _WBSElementInternalID | I_JournalEntryItem | _WBSElementInternalID | ||
| _WBSElement | I_JournalEntryItem | _WBSElement | ||
| _WBSElementExternalID | _WBSElementExternalID | |||
| _ProjectBasicData | I_JournalEntryItem | _ProjectBasicData | ||
| _Project | I_JournalEntryItem | _Project | ||
| _ProjectExternalID | _ProjectExternalID | |||
| _BusinessArea | I_JournalEntryItem | _BusinessArea | ||
| _FunctionalArea | I_JournalEntryItem | _FunctionalArea | ||
| _GLAccountInChartOfAccounts | I_JournalEntryItem | _GLAccountInChartOfAccounts | ||
| _GLAccountInCompanyCode | I_JournalEntryItem | _GLAccountInCompanyCode | ||
| _ChartOfAccounts | I_JournalEntryItem | _ChartOfAccounts | ||
| _AccountingDocumentType | I_JournalEntryItem | _AccountingDocumentType | ||
| _FinancialAccountType | I_JournalEntryItem | _FinancialAccountType | ||
| _DebitCreditCode | I_JournalEntryItem | _DebitCreditCode | ||
| _Product | I_JournalEntryItem | _Product | ||
| _Material | I_JournalEntryItem | _Material | ||
| _Plant | I_JournalEntryItem | _Plant | ||
| _OffsettingAccountType | I_JournalEntryItem | _OffsettingAccountType | ||
| _OffsettingChartOfAccounts | I_JournalEntryItem | _OffsettingChartOfAccounts | ||
| _OffsettingAccount | I_JournalEntryItem | _OffsettingAccount | ||
| _OffsettingAccountWithBP | I_JournalEntryItem | _OffsettingAccountWithBP | ||
| _WorkPackageWorkItem | I_JournalEntryItem | _WorkPackageWorkItem | ||
| _WorkPackage | I_JournalEntryItem | _WorkPackage | ||
| _Ledger | I_JournalEntryItem | _Ledger | ||
| _SourceLedger | I_JournalEntryItem | _SourceLedger | ||
| _Customer | I_JournalEntryItem | _Customer | ||
| _CustomerGroup | I_JournalEntryItem | _CustomerGroup | ||
| _Supplier | I_JournalEntryItem | _Supplier | ||
| _ProductGroup_2 | I_JournalEntryItem | _ProductGroup_2 | ||
| _SoldProductGroup_2 | I_JournalEntryItem | _SoldProductGroup_2 | ||
| _MaterialGroup | I_JournalEntryItem | _MaterialGroup | ||
| _SoldProductGroup | I_JournalEntryItem | _SoldProductGroup | ||
| _SalesDocument | I_JournalEntryItem | _SalesDocument | ||
| _SalesDocumentItem | I_JournalEntryItem | _SalesDocumentItem | ||
| _SalesOrder | I_JournalEntryItem | _SalesOrder | ||
| _SalesOrderItem | I_JournalEntryItem | _SalesOrderItem | ||
| _InternalOrder | I_JournalEntryItem | _InternalOrder | ||
| _Order | I_JournalEntryItem | _Order | ||
| _PersonWorkAgreement_1 | _PersonWorkAgreement_1 | |||
| _Employment | I_JournalEntryItem | _Employment | ||
| _FinancialTransactionType | I_JournalEntryItem | _FinancialTransactionType | ||
| _BusinessTransactionType | I_JournalEntryItem | _BusinessTransactionType | ||
| _ReferenceDocumentType | I_JournalEntryItem | _ReferenceDocumentType | ||
| _PredecessorReferenceDocType | I_JournalEntryItem | _PredecessorReferenceDocType | ||
| _PartnerCostCenter | I_JournalEntryItem | _PartnerCostCenter | ||
| _PartnerProfitCenter | I_JournalEntryItem | _PartnerProfitCenter | ||
| _PartnerBusinessArea | I_JournalEntryItem | _PartnerBusinessArea | ||
| _PartnerFunctionalArea | I_JournalEntryItem | _PartnerFunctionalArea | ||
| _PartnerCompanyCode | I_JournalEntryItem | _PartnerCompanyCode | ||
| _PartnerSegment | I_JournalEntryItem | _PartnerSegment | ||
| _AccountingDocumentCategory | I_JournalEntryItem | _AccountingDocumentCategory | ||
| _PostingKey | I_JournalEntryItem | _PostingKey | ||
| _SubLedgerAccLineItemType | I_JournalEntryItem | _SubLedgerAccLineItemType | ||
| _User | I_JournalEntryItem | _User | ||
| _EliminationProfitCenter | I_JournalEntryItem | _EliminationProfitCenter | ||
| _ControllingObject | I_JournalEntryItem | _ControllingObject | ||
| _GLAccountType | I_JournalEntryItem | _GLAccountType | ||
| _AlternativeGLAccount | I_JournalEntryItem | _AlternativeGLAccount | ||
| _CountryChartOfAccounts | I_JournalEntryItem | _CountryChartOfAccounts | ||
| _PurchasingDocument | I_JournalEntryItem | _PurchasingDocument | ||
| _PurchasingDocumentItem | I_JournalEntryItem | _PurchasingDocumentItem | ||
| _SpecialGLCode | I_JournalEntryItem | _SpecialGLCode | ||
| _TaxCode | I_JournalEntryItem | _TaxCode | ||
| _HouseBank | I_JournalEntryItem | _HouseBank | ||
| _ClearingJrnlEntryFiscalYear | I_JournalEntryItem | _ClearingJrnlEntryFiscalYear | ||
| _ClearingJournalEntry | I_JournalEntryItem | _ClearingJournalEntry | ||
| _ClearingAccountingDocument | I_JournalEntryItem | _ClearingAccountingDocument | ||
| _MasterFixedAsset | I_JournalEntryItem | _MasterFixedAsset | ||
| _GroupFixedAsset | I_JournalEntryItem | _GroupFixedAsset | ||
| _FixedAsset | I_JournalEntryItem | _FixedAsset | ||
| _GroupMasterFixedAsset | I_JournalEntryItem | _GroupMasterFixedAsset | ||
| _InventorySpecialStockValnType | I_JournalEntryItem | _InventorySpecialStockValnType | ||
| _InventorySpclStockValnType | I_JournalEntryItem | _InventorySpclStockValnType | ||
| _InventorySpecialStockType | I_JournalEntryItem | _InventorySpecialStockType | ||
| _InventorySpclStkSalesDocument | I_JournalEntryItem | _InventorySpclStkSalesDocument | ||
| _InventorySpclStkSalesDocItm | I_JournalEntryItem | _InventorySpclStkSalesDocItm | ||
| _InvtrySpclStkWBSElmntBscData | I_JournalEntryItem | _InvtrySpclStkWBSElmntBscData | ||
| _InvtrySpclStockWBSElmntIntID | I_JournalEntryItem | _InvtrySpclStockWBSElmntIntID | ||
| _InventorySpclStockWBSElement | I_JournalEntryItem | _InventorySpclStockWBSElement | ||
| _InvtrySpclStockWBSElmntExtID | _InvtrySpclStockWBSElmntExtID | |||
| _InventorySpecialStockSupplier | I_JournalEntryItem | _InventorySpecialStockSupplier | ||
| _InventoryValuationType | I_JournalEntryItem | _InventoryValuationType | ||
| _OriginSenderObject | I_JournalEntryItem | _OriginSenderObject | ||
| _ControllingObjectClass | I_JournalEntryItem | _ControllingObjectClass | ||
| _PartnerControllingObjectClass | I_JournalEntryItem | _PartnerControllingObjectClass | ||
| _OriginCostCenter | I_JournalEntryItem | _OriginCostCenter | ||
| _CostCtrActivityType | I_JournalEntryItem | _CostCtrActivityType | ||
| _OriginCostCtrActivityType | I_JournalEntryItem | _OriginCostCtrActivityType | ||
| _OrderCategory | I_JournalEntryItem | _OrderCategory | ||
| _BusinessProcess | I_JournalEntryItem | _BusinessProcess | ||
| _PartnerCostCtrActivityType | I_JournalEntryItem | _PartnerCostCtrActivityType | ||
| _PartnerOrder | I_JournalEntryItem | _PartnerOrder | ||
| _PartnerOrder_2 | I_JournalEntryItem | _PartnerOrder_2 | ||
| _PartnerOrderCategory | I_JournalEntryItem | _PartnerOrderCategory | ||
| _PartnerWBSElementBasicData | I_JournalEntryItem | _PartnerWBSElementBasicData | ||
| _PartnerWBSElement | I_JournalEntryItem | _PartnerWBSElement | ||
| _PartnerWBSElementExternalID | _PartnerWBSElementExternalID | |||
| _PartnerProjectBasicData | I_JournalEntryItem | _PartnerProjectBasicData | ||
| _PartnerProject | I_JournalEntryItem | _PartnerProject | ||
| _PartnerProjectExternalID | _PartnerProjectExternalID | |||
| _PartnerSalesDocument | I_JournalEntryItem | _PartnerSalesDocument | ||
| _PartnerSalesDocumentItem | I_JournalEntryItem | _PartnerSalesDocumentItem | ||
| _PartnerBusinessProcess | I_JournalEntryItem | _PartnerBusinessProcess | ||
| _BillingDocumentType | I_JournalEntryItem | _BillingDocumentType | ||
| _SalesOrganization | I_JournalEntryItem | _SalesOrganization | ||
| _DistributionChannel | I_JournalEntryItem | _DistributionChannel | ||
| _SoldProduct | I_JournalEntryItem | _SoldProduct | ||
| _SoldMaterial | I_JournalEntryItem | _SoldMaterial | ||
| _Fund | I_JournalEntryItem | _Fund | ||
| _PartnerFund | I_JournalEntryItem | _PartnerFund | ||
| _FundsCenter | I_JournalEntryItem | _FundsCenter | ||
| _MovementCategory | I_JournalEntryItem | _MovementCategory | ||
| _AssetTransactionType | I_JournalEntryItem | _AssetTransactionType | ||
| _BudgetPeriod | I_JournalEntryItem | _BudgetPeriod | ||
| _CostOriginGroup | I_JournalEntryItem | _CostOriginGroup | ||
| _FinancialManagementArea | I_JournalEntryItem | _FinancialManagementArea | ||
| _HouseBankAccount | I_JournalEntryItem | _HouseBankAccount | ||
| _LogicalSystem | I_JournalEntryItem | _LogicalSystem | ||
| _OperatingConcern | I_JournalEntryItem | _OperatingConcern | ||
| _PartnerCompany | I_JournalEntryItem | _PartnerCompany | ||
| _ProjectNetwork | I_JournalEntryItem | _ProjectNetwork | ||
| _PurReqValuationArea | I_JournalEntryItem | _PurReqValuationArea | ||
| _OperationalAcctgDocItem | _OperationalAcctgDocItem | |||
| _PaymentCurrency | _OperationalAcctgDocItem | _PaymentCurrency | ||
| _CreditControlAreaCurrency | _OperationalAcctgDocItem | _CreditControlAreaCurrency | ||
| _GoodsMovementEntryUnit | _OperationalAcctgDocItem | _GoodsMovementEntryUnit | ||
| _PurchasingDocumentPriceUnit | _OperationalAcctgDocItem | _PurchasingDocumentPriceUnit | ||
| _SupplyingCountry | _OperationalAcctgDocItem | _SupplyingCountry | ||
| _TaxType | _OperationalAcctgDocItem | _TaxType | ||
| _ServiceDocumentType | I_JournalEntryItem | _ServiceDocumentType | ||
| _ServiceDocument | I_JournalEntryItem | _ServiceDocument | ||
| _ServiceDocumentItem | I_JournalEntryItem | _ServiceDocumentItem | ||
| _Grant | I_JournalEntryItem | _Grant | ||
| _PartnerGrant | I_JournalEntryItem | _PartnerGrant | ||
| _FiscalYearPeriodForVariant | I_JournalEntryItem | _FiscalYearPeriodForVariant | ||
| GLAccountAuthorizationGroup | I_JournalEntryItem | GLAccountAuthorizationGroup | G/L Account Authorization Group | |
| SupplierBasicAuthorizationGrp | I_JournalEntryItem | SupplierBasicAuthorizationGrp | Supplier Basic Authorization Group | |
| CustomerBasicAuthorizationGrp | I_JournalEntryItem | CustomerBasicAuthorizationGrp | Customer Basic Authorization Group | |
| AcctgDocTypeAuthorizationGroup | I_JournalEntryItem | AcctgDocTypeAuthorizationGroup | Accounting Document Type Authorization Group | |
| OrderType | I_JournalEntryItem | OrderType | Order Type | |
| SalesOrderType | I_JournalEntryItem | SalesOrderType | Sales Document Type | |
| AssetClass | I_JournalEntryItem | AssetClass | Asset Class |
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_JournalEntryOperationalView.
-- 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_JournalEntryOperationalView AS
SELECT
I_JournalEntryItem.SourceLedger AS SourceLedger,
I_JournalEntryItem.CompanyCode AS CompanyCode,
I_JournalEntryItem.FiscalYear AS FiscalYear,
I_JournalEntryItem.AccountingDocument AS AccountingDocument,
I_JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
I_JournalEntryItem.Ledger AS Ledger,
I_JournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
I_JournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
I_JournalEntryItem.ControllingArea AS ControllingArea,
I_JournalEntryItem._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
I_JournalEntryItem._JournalEntry.CreationTime AS CreationTime,
I_JournalEntryItem._JournalEntry.LastChangeDate AS LastChangeDate,
I_JournalEntryItem._JournalEntry.JournalEntryLastChangeDateTime AS JournalEntryLastChangeDateTime,
I_JournalEntryItem._JournalEntry.ExchangeRateDate AS ExchangeRateDate,
I_JournalEntryItem._JournalEntry.TransactionCode AS TransactionCode,
I_JournalEntryItem._JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
I_JournalEntryItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
I_JournalEntryItem._JournalEntry.RecurringAccountingDocument AS RecurringAccountingDocument,
I_JournalEntryItem._JournalEntry.ReverseDocument AS ReverseDocument,
I_JournalEntryItem._JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
I_JournalEntryItem._JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
I_JournalEntryItem._JournalEntry.AbsoluteExchangeRate AS AbsoluteExchangeRate,
I_JournalEntryItem._JournalEntry.ExchangeRate AS ExchangeRate,
I_JournalEntryItem._JournalEntry.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
I_JournalEntryItem._JournalEntry.EffectiveExchangeRate AS EffectiveExchangeRate,
I_JournalEntryItem._JournalEntry.BatchInputSession AS BatchInputSession,
I_JournalEntryItem._JournalEntry.OriginalReferenceDocument AS OriginalReferenceDocument,
I_JournalEntryItem._JournalEntry.ReversalIsPlanned AS ReversalIsPlanned,
I_JournalEntryItem._JournalEntry.PlannedReversalDate AS PlannedReversalDate,
I_JournalEntryItem._JournalEntry.TaxIsCalculatedAutomatically AS TaxIsCalculatedAutomatically,
I_JournalEntryItem._JournalEntry.TaxBaseAmountIsNetAmount AS TaxBaseAmountIsNetAmount,
I_JournalEntryItem._JournalEntry.SourceCompanyCode AS SourceCompanyCode,
I_JournalEntryItem._JournalEntry.TaxAbsoluteExchangeRate AS TaxAbsoluteExchangeRate,
I_JournalEntryItem._JournalEntry.TaxExchangeRate AS TaxExchangeRate,
I_JournalEntryItem._JournalEntry.TaxExchRateIsIndirectQuotation AS TaxExchRateIsIndirectQuotation,
I_JournalEntryItem._JournalEntry.TaxEffectiveExchangeRate AS TaxEffectiveExchangeRate,
I_JournalEntryItem._JournalEntry.ReversalReason AS ReversalReason,
I_JournalEntryItem._JournalEntry.Branch AS Branch,
I_JournalEntryItem._JournalEntry.Reference1InDocumentHeader AS Reference1InDocumentHeader,
I_JournalEntryItem._JournalEntry.Reference2InDocumentHeader AS Reference2InDocumentHeader,
I_JournalEntryItem._JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
I_JournalEntryItem._JournalEntry.LedgerGroup AS LedgerGroup,
I_JournalEntryItem._JournalEntry.AlternativeReferenceDocument AS AlternativeReferenceDocument,
I_JournalEntryItem._JournalEntry.TaxReportingDate AS TaxReportingDate,
I_JournalEntryItem._JournalEntry.AccountingDocumentClass AS AccountingDocumentClass,
I_JournalEntryItem._JournalEntry.ExchangeRateType AS ExchangeRateType,
I_JournalEntryItem._JournalEntry.SenderLogicalSystem AS SenderLogicalSystem,
I_JournalEntryItem._JournalEntry.SenderCompanyCode AS SenderCompanyCode,
I_JournalEntryItem._JournalEntry.SenderAccountingDocument AS SenderAccountingDocument,
I_JournalEntryItem._JournalEntry.SenderFiscalYear AS SenderFiscalYear,
I_JournalEntryItem._JournalEntry.LatePaymentReason AS LatePaymentReason,
I_JournalEntryItem._JournalEntry.SalesDocumentCondition AS SalesDocumentCondition,
I_JournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
I_JournalEntryItem.GLRecordType AS GLRecordType,
I_JournalEntryItem.FinancialTransactionType AS FinancialTransactionType,
I_JournalEntryItem.BusinessTransactionType AS BusinessTransactionType,
I_JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
I_JournalEntryItem.LogicalSystem AS LogicalSystem,
I_JournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
I_JournalEntryItem.ReferenceDocument AS ReferenceDocument,
I_JournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem,
I_JournalEntryItem.ReferenceDocumentItemGroup AS ReferenceDocumentItemGroup,
I_JournalEntryItem.IsReversal AS IsReversal,
I_JournalEntryItem.IsReversed AS IsReversed,
I_JournalEntryItem.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
I_JournalEntryItem.ReversalReferenceDocument AS ReversalReferenceDocument,
I_JournalEntryItem.IsSettlement AS IsSettlement,
I_JournalEntryItem.IsSettled AS IsSettled,
I_JournalEntryItem.PredecessorReferenceDocType AS PredecessorReferenceDocType,
I_JournalEntryItem.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
I_JournalEntryItem.PredecessorReferenceDocument AS PredecessorReferenceDocument,
I_JournalEntryItem.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
I_JournalEntryItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
I_JournalEntryItem.SourceLogicalSystem AS SourceLogicalSystem,
I_JournalEntryItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
I_JournalEntryItem.SourceReferenceDocument AS SourceReferenceDocument,
I_JournalEntryItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
I_JournalEntryItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
I_JournalEntryItem.IsCommitment AS IsCommitment,
I_JournalEntryItem.GLAccount AS GLAccount,
I_JournalEntryItem.CostCenter AS CostCenter,
I_JournalEntryItem.ProfitCenter AS ProfitCenter,
I_JournalEntryItem.FunctionalArea AS FunctionalArea,
I_JournalEntryItem.BusinessArea AS BusinessArea,
I_JournalEntryItem.Segment AS Segment,
I_JournalEntryItem.PartnerCostCenter AS PartnerCostCenter,
I_JournalEntryItem.PartnerProfitCenter AS PartnerProfitCenter,
I_JournalEntryItem.PartnerFunctionalArea AS PartnerFunctionalArea,
I_JournalEntryItem.PartnerBusinessArea AS PartnerBusinessArea,
I_JournalEntryItem.PartnerCompany AS PartnerCompany,
I_JournalEntryItem.PartnerSegment AS PartnerSegment,
I_JournalEntryItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
I_JournalEntryItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
I_JournalEntryItem.TransactionCurrency AS TransactionCurrency,
I_JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
I_JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
I_JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
I_JournalEntryItem.GlobalCurrency AS GlobalCurrency,
I_JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
I_JournalEntryItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
I_JournalEntryItem.GrpValnFixedAmtInGlobCrcy AS GrpValnFixedAmtInGlobCrcy,
I_JournalEntryItem.PrftCtrValnFxdAmtInGlobCrcy AS PrftCtrValnFxdAmtInGlobCrcy,
I_JournalEntryItem.TotalPriceVarcInGlobalCrcy AS TotalPriceVarcInGlobalCrcy,
I_JournalEntryItem.GrpValnTotPrcVarcInGlobCrcy AS GrpValnTotPrcVarcInGlobCrcy,
I_JournalEntryItem.PrftCtrValnTotPrcVarcInGlbCrcy AS PrftCtrValnTotPrcVarcInGlbCrcy,
I_JournalEntryItem.FixedPriceVarcInGlobalCrcy AS FixedPriceVarcInGlobalCrcy,
I_JournalEntryItem.GrpValnFixedPrcVarcInGlobCrcy AS GrpValnFixedPrcVarcInGlobCrcy,
I_JournalEntryItem.PrftCtrValnFxdPrcVarcInGlbCrcy AS PrftCtrValnFxdPrcVarcInGlbCrcy,
I_JournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
I_JournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
I_JournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
I_JournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
I_JournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
I_JournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
I_JournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
I_JournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
I_JournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
I_JournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
I_JournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
I_JournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
I_JournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
I_JournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
I_JournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
I_JournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
I_JournalEntryItem.ControllingObjectCurrency AS ControllingObjectCurrency,
I_JournalEntryItem.AmountInObjectCurrency AS AmountInObjectCurrency,
I_JournalEntryItem.BaseUnit AS BaseUnit,
I_JournalEntryItem.Quantity AS Quantity,
I_JournalEntryItem.FixedQuantity AS FixedQuantity,
I_JournalEntryItem.CostSourceUnit AS CostSourceUnit,
I_JournalEntryItem.ValuationQuantity AS ValuationQuantity,
I_JournalEntryItem.ValuationFixedQuantity AS ValuationFixedQuantity,
I_JournalEntryItem.AdditionalQuantity1Unit AS AdditionalQuantity1Unit,
I_JournalEntryItem.AdditionalQuantity1 AS AdditionalQuantity1,
I_JournalEntryItem.AdditionalQuantity2Unit AS AdditionalQuantity2Unit,
I_JournalEntryItem.AdditionalQuantity2 AS AdditionalQuantity2,
I_JournalEntryItem.AdditionalQuantity3Unit AS AdditionalQuantity3Unit,
I_JournalEntryItem.AdditionalQuantity3 AS AdditionalQuantity3,
I_JournalEntryItem.DebitCreditCode AS DebitCreditCode,
I_JournalEntryItem.FiscalPeriod AS FiscalPeriod,
I_JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
I_JournalEntryItem.PostingDate AS PostingDate,
I_JournalEntryItem.DocumentDate AS DocumentDate,
I_JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
I_JournalEntryItem.AccountingDocumentItem AS AccountingDocumentItem,
I_JournalEntryItem.AssignmentReference AS AssignmentReference,
I_JournalEntryItem.AccountingDocumentCategory AS AccountingDocumentCategory,
I_JournalEntryItem.PostingKey AS PostingKey,
I_JournalEntryItem.TransactionTypeDetermination AS TransactionTypeDetermination,
I_JournalEntryItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
I_JournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
I_JournalEntryItem.LastChangeDateTime AS LastChangeDateTime,
cast( I_JournalEntryItem.CreationDateTime as fis_creation_timestamp preserving type ) AS CreationDateTime,
I_JournalEntryItem.EliminationProfitCenter AS EliminationProfitCenter,
I_JournalEntryItem.OriginObjectType AS OriginObjectType,
I_JournalEntryItem.GLAccountType AS GLAccountType,
I_JournalEntryItem.AlternativeGLAccount AS AlternativeGLAccount,
I_JournalEntryItem.CountryChartOfAccounts AS CountryChartOfAccounts,
I_JournalEntryItem.InvoiceReference AS InvoiceReference,
I_JournalEntryItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
I_JournalEntryItem.FollowOnDocumentType AS FollowOnDocumentType,
I_JournalEntryItem.InvoiceItemReference AS InvoiceItemReference,
ReferencePurchaseOrderCategory,
I_JournalEntryItem.PurchasingDocument AS PurchasingDocument,
I_JournalEntryItem.PurchasingDocumentItem AS PurchasingDocumentItem,
I_JournalEntryItem.AccountAssignmentNumber AS AccountAssignmentNumber,
I_JournalEntryItem.DocumentItemText AS DocumentItemText,
I_JournalEntryItem.SalesDocument AS SalesDocument,
I_JournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
I_JournalEntryItem.SalesOrder AS SalesOrder,
I_JournalEntryItem.SalesOrderItem AS SalesOrderItem,
I_JournalEntryItem.Product AS Product,
I_JournalEntryItem.Material AS Material,
I_JournalEntryItem.Plant AS Plant,
I_JournalEntryItem.Supplier AS Supplier,
I_JournalEntryItem.Customer AS Customer,
I_JournalEntryItem.ServicesRenderedDate AS ServicesRenderedDate,
I_JournalEntryItem.FinancialAccountType AS FinancialAccountType,
I_JournalEntryItem.SpecialGLCode AS SpecialGLCode,
I_JournalEntryItem.TaxCode AS TaxCode,
I_JournalEntryItem.HouseBank AS HouseBank,
I_JournalEntryItem.HouseBankAccount AS HouseBankAccount,
I_JournalEntryItem.IsOpenItemManaged AS IsOpenItemManaged,
I_JournalEntryItem.ClearingDate AS ClearingDate,
I_JournalEntryItem.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
I_JournalEntryItem.ClearingDocFiscalYear AS ClearingDocFiscalYear,
I_JournalEntryItem.ClearingJournalEntry AS ClearingJournalEntry,
I_JournalEntryItem.ClearingAccountingDocument AS ClearingAccountingDocument,
I_JournalEntryItem.AssetDepreciationArea AS AssetDepreciationArea,
I_JournalEntryItem.ServiceDocumentType AS ServiceDocumentType,
I_JournalEntryItem.ServiceDocument AS ServiceDocument,
I_JournalEntryItem.ServiceDocumentItem AS ServiceDocumentItem,
I_JournalEntryItem.MasterFixedAsset AS MasterFixedAsset,
I_JournalEntryItem.FixedAsset AS FixedAsset,
I_JournalEntryItem.AssetValueDate AS AssetValueDate,
I_JournalEntryItem.AssetTransactionType AS AssetTransactionType,
I_JournalEntryItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
I_JournalEntryItem.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
I_JournalEntryItem.GroupMasterFixedAsset AS GroupMasterFixedAsset,
I_JournalEntryItem.GroupFixedAsset AS GroupFixedAsset,
I_JournalEntryItem.CostEstimate AS CostEstimate,
I_JournalEntryItem.InventorySpecialStockValnType AS InventorySpecialStockValnType,
I_JournalEntryItem.InvtrySpecialStockValnType_2 AS InvtrySpecialStockValnType_2,
I_JournalEntryItem.InventorySpecialStockType AS InventorySpecialStockType,
I_JournalEntryItem.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
I_JournalEntryItem.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
I_JournalEntryItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
I_JournalEntryItem.InventorySpclStockWBSElement AS InventorySpclStockWBSElement,
cast( I_JournalEntryItem._InvtrySpclStockWBSElmntBD.WBSElementExternalID as fis_invspstock_wbsext_no_conv preserving type ) AS InvtrySpclStockWBSElmntExtID,
I_JournalEntryItem.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
I_JournalEntryItem.InventoryValuationType AS InventoryValuationType,
I_JournalEntryItem.ValuationArea AS ValuationArea,
I_JournalEntryItem.SenderGLAccount AS SenderGLAccount,
I_JournalEntryItem.SenderAccountAssignment AS SenderAccountAssignment,
I_JournalEntryItem.SenderAccountAssignmentType AS SenderAccountAssignmentType,
I_JournalEntryItem.ControllingObject AS ControllingObject,
I_JournalEntryItem.CostOriginGroup AS CostOriginGroup,
I_JournalEntryItem.OriginSenderObject AS OriginSenderObject,
I_JournalEntryItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
I_JournalEntryItem.ControllingObjectDebitType AS ControllingObjectDebitType,
I_JournalEntryItem.QuantityIsIncomplete AS QuantityIsIncomplete,
I_JournalEntryItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
I_JournalEntryItem.OffsettingAccount AS OffsettingAccount,
I_JournalEntryItem.OffsettingAccountType AS OffsettingAccountType,
I_JournalEntryItem.LineItemIsCompleted AS LineItemIsCompleted,
I_JournalEntryItem.PersonnelNumber AS PersonnelNumber,
I_JournalEntryItem.ControllingObjectClass AS ControllingObjectClass,
I_JournalEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
I_JournalEntryItem.PartnerControllingObjectClass AS PartnerControllingObjectClass,
I_JournalEntryItem.OriginCostCenter AS OriginCostCenter,
I_JournalEntryItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
I_JournalEntryItem.AccountAssignment AS AccountAssignment,
I_JournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
I_JournalEntryItem.CostCtrActivityType AS CostCtrActivityType,
I_JournalEntryItem.OrderID AS OrderID,
I_JournalEntryItem.OrderCategory AS OrderCategory,
I_JournalEntryItem.WBSElement AS WBSElement,
I_JournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
cast( I_JournalEntryItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
I_JournalEntryItem.WorkPackage AS WorkPackage,
I_JournalEntryItem.Project AS Project,
I_JournalEntryItem.ProjectInternalID AS ProjectInternalID,
cast( I_JournalEntryItem._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
I_JournalEntryItem.OperatingConcern AS OperatingConcern,
I_JournalEntryItem.ProjectNetwork AS ProjectNetwork,
I_JournalEntryItem.RelatedNetworkActivity AS RelatedNetworkActivity,
I_JournalEntryItem.BusinessProcess AS BusinessProcess,
I_JournalEntryItem.CostObject AS CostObject,
I_JournalEntryItem.CostAnalysisResource AS CostAnalysisResource,
I_JournalEntryItem.CustomerServiceNotification AS CustomerServiceNotification,
I_JournalEntryItem.PartnerAccountAssignment AS PartnerAccountAssignment,
I_JournalEntryItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
I_JournalEntryItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
I_JournalEntryItem.PartnerOrder AS PartnerOrder,
I_JournalEntryItem.PartnerOrder_2 AS PartnerOrder_2,
I_JournalEntryItem.PartnerOrderCategory AS PartnerOrderCategory,
I_JournalEntryItem.PartnerWBSElement AS PartnerWBSElement,
I_JournalEntryItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
cast( I_JournalEntryItem._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv preserving type ) AS PartnerWBSElementExternalID,
I_JournalEntryItem.PartnerProject AS PartnerProject,
I_JournalEntryItem.PartnerProjectInternalID AS PartnerProjectInternalID,
cast( I_JournalEntryItem._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv preserving type ) AS PartnerProjectExternalID,
I_JournalEntryItem.PartnerSalesDocument AS PartnerSalesDocument,
I_JournalEntryItem.PartnerSalesDocumentItem AS PartnerSalesDocumentItem,
I_JournalEntryItem.PartnerProjectNetwork AS PartnerProjectNetwork,
I_JournalEntryItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
I_JournalEntryItem.PartnerBusinessProcess AS PartnerBusinessProcess,
I_JournalEntryItem.PartnerCostObject AS PartnerCostObject,
I_JournalEntryItem.WorkItem AS WorkItem,
I_JournalEntryItem.BillingDocumentType AS BillingDocumentType,
I_JournalEntryItem.SalesOrganization AS SalesOrganization,
I_JournalEntryItem.DistributionChannel AS DistributionChannel,
I_JournalEntryItem.OrganizationDivision AS OrganizationDivision,
I_JournalEntryItem.SoldProduct AS SoldProduct,
I_JournalEntryItem.SoldMaterial AS SoldMaterial,
I_JournalEntryItem.ProductGroup AS ProductGroup,
I_JournalEntryItem.MaterialGroup AS MaterialGroup,
I_JournalEntryItem.SoldProductGroup AS SoldProductGroup,
I_JournalEntryItem.CustomerGroup AS CustomerGroup,
I_JournalEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
I_JournalEntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
I_JournalEntryItem.SalesDistrict AS SalesDistrict,
I_JournalEntryItem.BillToParty AS BillToParty,
I_JournalEntryItem.ShipToParty AS ShipToParty,
I_JournalEntryItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
I_JournalEntryItem.FinancialManagementArea AS FinancialManagementArea,
I_JournalEntryItem.Fund AS Fund,
I_JournalEntryItem.GrantID AS GrantID,
I_JournalEntryItem.BudgetPeriod AS BudgetPeriod,
I_JournalEntryItem.PartnerFund AS PartnerFund,
I_JournalEntryItem.PartnerGrant AS PartnerGrant,
I_JournalEntryItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
I_JournalEntryItem.FundsCenter AS FundsCenter,
I_JournalEntryItem.FundedProgram AS FundedProgram,
I_JournalEntryItem.JointVenture AS JointVenture,
I_JournalEntryItem.JointVentureEquityGroup AS JointVentureEquityGroup,
I_JournalEntryItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
I_JournalEntryItem.JointVentureEquityType AS JointVentureEquityType,
I_JournalEntryItem.SettlementReferenceDate AS SettlementReferenceDate,
I_JournalEntryItem.NetDueDate AS NetDueDate,
I_JournalEntryItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
I_JournalEntryItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
I_JournalEntryItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
I_JournalEntryItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
I_JournalEntryItem.DebitAmountInBalanceTransCrcy AS DebitAmountInBalanceTransCrcy,
I_JournalEntryItem.CreditAmountInBalanceTransCrcy AS CreditAmountInBalanceTransCrcy,
I_JournalEntryItem.DebitAmountInGlobalCrcy AS DebitAmountInGlobalCrcy,
I_JournalEntryItem.CreditAmountInGlobalCrcy AS CreditAmountInGlobalCrcy,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy1 AS DebitAmountInFreeDefinedCrcy1,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy1 AS CreditAmountInFreeDefinedCrcy1,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy2 AS DebitAmountInFreeDefinedCrcy2,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy2 AS CreditAmountInFreeDefinedCrcy2,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy3 AS DebitAmountInFreeDefinedCrcy3,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy3 AS CreditAmountInFreeDefinedCrcy3,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy4 AS DebitAmountInFreeDefinedCrcy4,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy4 AS CreditAmountInFreeDefinedCrcy4,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy5 AS DebitAmountInFreeDefinedCrcy5,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy5 AS CreditAmountInFreeDefinedCrcy5,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy6 AS DebitAmountInFreeDefinedCrcy6,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy6 AS CreditAmountInFreeDefinedCrcy6,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy7 AS DebitAmountInFreeDefinedCrcy7,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy7 AS CreditAmountInFreeDefinedCrcy7,
I_JournalEntryItem.DebitAmountInFreeDefinedCrcy8 AS DebitAmountInFreeDefinedCrcy8,
I_JournalEntryItem.CreditAmountInFreeDefinedCrcy8 AS CreditAmountInFreeDefinedCrcy8,
I_JournalEntryItem.IsStatisticalOrder AS IsStatisticalOrder,
I_JournalEntryItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
I_JournalEntryItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
I_JournalEntryItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
_OperationalAcctgDocItem.ClearingCreationDate AS ClearingCreationDate,
_OperationalAcctgDocItem.SpecialGLTransactionType AS SpecialGLTransactionType,
_OperationalAcctgDocItem.WithholdingTaxCode AS WithholdingTaxCode,
_OperationalAcctgDocItem.TaxType AS TaxType,
_OperationalAcctgDocItem.ValueDate AS ValueDate,
_OperationalAcctgDocItem.CorporateGroupAccount AS CorporateGroupAccount,
_OperationalAcctgDocItem.PlanningLevel AS PlanningLevel,
_OperationalAcctgDocItem.BillingDocument AS BillingDocument,
_OperationalAcctgDocItem.ScheduleLine AS ScheduleLine,
_OperationalAcctgDocItem.IsSalesRelated AS IsSalesRelated,
_OperationalAcctgDocItem.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
_OperationalAcctgDocItem.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
_OperationalAcctgDocItem.IsAutomaticallyCreated AS IsAutomaticallyCreated,
_OperationalAcctgDocItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
_OperationalAcctgDocItem.OperationalGLAccount AS OperationalGLAccount,
_OperationalAcctgDocItem.BranchAccount AS BranchAccount,
_OperationalAcctgDocItem.IsBalanceSheetAccount AS IsBalanceSheetAccount,
_OperationalAcctgDocItem.ProfitLossAccountType AS ProfitLossAccountType,
_OperationalAcctgDocItem.SpecialGLAccountAssignment AS SpecialGLAccountAssignment,
_OperationalAcctgDocItem.DueCalculationBaseDate AS DueCalculationBaseDate,
_OperationalAcctgDocItem.PaymentTerms AS PaymentTerms,
_OperationalAcctgDocItem.PaymentMethod AS PaymentMethod,
_OperationalAcctgDocItem.PaymentBlockingReason AS PaymentBlockingReason,
_OperationalAcctgDocItem.FixedCashDiscount AS FixedCashDiscount,
_OperationalAcctgDocItem.TaxDistributionCode1 AS TaxDistributionCode1,
_OperationalAcctgDocItem.TaxDistributionCode2 AS TaxDistributionCode2,
_OperationalAcctgDocItem.TaxDistributionCode3 AS TaxDistributionCode3,
_OperationalAcctgDocItem.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
_OperationalAcctgDocItem.SupplyingCountry AS SupplyingCountry,
_OperationalAcctgDocItem.InvoiceList AS InvoiceList,
_OperationalAcctgDocItem.BillOfExchangeUsage AS BillOfExchangeUsage,
_OperationalAcctgDocItem.DunningKey AS DunningKey,
_OperationalAcctgDocItem.LastDunningDate AS LastDunningDate,
_OperationalAcctgDocItem.DunningLevel AS DunningLevel,
_OperationalAcctgDocItem.DunningArea AS DunningArea,
_OperationalAcctgDocItem.WithholdingTaxCertificate AS WithholdingTaxCertificate,
_OperationalAcctgDocItem.IsCompletelyDelivered AS IsCompletelyDelivered,
_OperationalAcctgDocItem.VATRegistration AS VATRegistration,
_OperationalAcctgDocItem.DelivOfGoodsDestCountry AS DelivOfGoodsDestCountry,
_OperationalAcctgDocItem.PaymentDifferenceReason AS PaymentDifferenceReason,
_OperationalAcctgDocItem.TreasuryContractType AS TreasuryContractType,
_OperationalAcctgDocItem.AssetContract AS AssetContract,
_OperationalAcctgDocItem.CashFlowType AS CashFlowType,
_OperationalAcctgDocItem.TaxJurisdiction AS TaxJurisdiction,
_OperationalAcctgDocItem.REInternalFinNumber AS REInternalFinNumber,
_OperationalAcctgDocItem.RealEstateObject AS RealEstateObject,
_OperationalAcctgDocItem.CommitmentItem AS CommitmentItem,
_OperationalAcctgDocItem.CommitmentItemShortID AS CommitmentItemShortID,
_OperationalAcctgDocItem.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
_OperationalAcctgDocItem.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
_OperationalAcctgDocItem.IsEUTriangularDeal AS IsEUTriangularDeal,
_OperationalAcctgDocItem.CompanyCodeCurrencyDetnMethod AS CompanyCodeCurrencyDetnMethod,
_OperationalAcctgDocItem.ClearingIsReversed AS ClearingIsReversed,
_OperationalAcctgDocItem.PaymentMethodSupplement AS PaymentMethodSupplement,
_OperationalAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
_OperationalAcctgDocItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
_OperationalAcctgDocItem.IsNegativePosting AS IsNegativePosting,
_OperationalAcctgDocItem.PaymentCardItem AS PaymentCardItem,
_OperationalAcctgDocItem.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
_OperationalAcctgDocItem.CreditControlArea AS CreditControlArea,
_OperationalAcctgDocItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
_OperationalAcctgDocItem.DataExchangeInstruction1 AS DataExchangeInstruction1,
_OperationalAcctgDocItem.DataExchangeInstruction2 AS DataExchangeInstruction2,
_OperationalAcctgDocItem.DataExchangeInstruction3 AS DataExchangeInstruction3,
_OperationalAcctgDocItem.DataExchangeInstruction4 AS DataExchangeInstruction4,
_OperationalAcctgDocItem.Region AS Region,
_OperationalAcctgDocItem.HasPaymentOrder AS HasPaymentOrder,
_OperationalAcctgDocItem.PaymentReference AS PaymentReference,
_OperationalAcctgDocItem.TaxDeterminationDate AS TaxDeterminationDate,
_OperationalAcctgDocItem.BusinessPlace AS BusinessPlace,
_OperationalAcctgDocItem.TaxSection AS TaxSection,
_OperationalAcctgDocItem.AccountsReceivableIsPledged AS AccountsReceivableIsPledged,
_OperationalAcctgDocItem.AcctsReceivablePledgingCode AS AcctsReceivablePledgingCode,
_OperationalAcctgDocItem.CustomerIsInExecution AS CustomerIsInExecution,
_OperationalAcctgDocItem.CostElement AS CostElement,
_OperationalAcctgDocItem.PaymentServiceProvider AS PaymentServiceProvider,
_OperationalAcctgDocItem.PaymentRefByPaytSrvcProvider AS PaymentRefByPaytSrvcProvider,
_OperationalAcctgDocItem.SEPAMandate AS SEPAMandate,
_OperationalAcctgDocItem.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
_OperationalAcctgDocItem.AccountingDocumentItemRef AS AccountingDocumentItemRef,
_OperationalAcctgDocItem.CashDiscount1DueDate AS CashDiscount1DueDate,
_OperationalAcctgDocItem.CashDiscount2DueDate AS CashDiscount2DueDate,
_OperationalAcctgDocItem.BranchCode AS BranchCode,
_OperationalAcctgDocItem.PaymentCurrency AS PaymentCurrency,
_OperationalAcctgDocItem.CreditControlAreaCurrency AS CreditControlAreaCurrency,
_OperationalAcctgDocItem.GoodsMovementEntryUnit AS GoodsMovementEntryUnit,
_OperationalAcctgDocItem.PurchasingDocumentPriceUnit AS PurchasingDocumentPriceUnit,
_OperationalAcctgDocItem.MaterialPriceUnitQty AS MaterialPriceUnitQty,
_OperationalAcctgDocItem.IN_GSTPartner AS IN_GSTPartner,
_OperationalAcctgDocItem.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
_OperationalAcctgDocItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
I_JournalEntryItem._JournalEntry AS _JournalEntry,
I_JournalEntryItem._CompanyCode AS _CompanyCode,
I_JournalEntryItem._FiscalYear AS _FiscalYear,
I_JournalEntryItem._FiscalPeriod AS _FiscalPeriod,
I_JournalEntryItem._LedgerFiscalYear AS _LedgerFiscalYear,
I_JournalEntryItem._FiscalYearVariant AS _FiscalYearVariant,
I_JournalEntryItem._ControllingArea AS _ControllingArea,
I_JournalEntryItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
I_JournalEntryItem._TransactionCurrency AS _TransactionCurrency,
I_JournalEntryItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
I_JournalEntryItem._GlobalCurrency AS _GlobalCurrency,
I_JournalEntryItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
I_JournalEntryItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
I_JournalEntryItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
I_JournalEntryItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
I_JournalEntryItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
I_JournalEntryItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
I_JournalEntryItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
I_JournalEntryItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8,
I_JournalEntryItem._BaseUnit AS _BaseUnit,
I_JournalEntryItem._CostSourceUnit AS _CostSourceUnit,
I_JournalEntryItem._AdditionalQuantity1Unit AS _AdditionalQuantity1Unit,
I_JournalEntryItem._AdditionalQuantity2Unit AS _AdditionalQuantity2Unit,
I_JournalEntryItem._AdditionalQuantity3Unit AS _AdditionalQuantity3Unit,
I_JournalEntryItem._Segment AS _Segment,
I_JournalEntryItem._ProfitCenter AS _ProfitCenter,
I_JournalEntryItem._CurrentProfitCenter AS _CurrentProfitCenter,
I_JournalEntryItem._CostCenter AS _CostCenter,
I_JournalEntryItem._CurrentCostCenter AS _CurrentCostCenter,
I_JournalEntryItem._CostAnalysisResource AS _CostAnalysisResource,
I_JournalEntryItem._WBSElementBasicData AS _WBSElementBasicData,
I_JournalEntryItem._WBSElementInternalID AS _WBSElementInternalID,
I_JournalEntryItem._WBSElement AS _WBSElement,
I_JournalEntryItem._ProjectBasicData AS _ProjectBasicData,
I_JournalEntryItem._Project AS _Project,
I_JournalEntryItem._BusinessArea AS _BusinessArea,
I_JournalEntryItem._FunctionalArea AS _FunctionalArea,
I_JournalEntryItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
I_JournalEntryItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
I_JournalEntryItem._ChartOfAccounts AS _ChartOfAccounts,
I_JournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
I_JournalEntryItem._FinancialAccountType AS _FinancialAccountType,
I_JournalEntryItem._DebitCreditCode AS _DebitCreditCode,
I_JournalEntryItem._Product AS _Product,
I_JournalEntryItem._Material AS _Material,
I_JournalEntryItem._Plant AS _Plant,
I_JournalEntryItem._OffsettingAccountType AS _OffsettingAccountType,
I_JournalEntryItem._OffsettingChartOfAccounts AS _OffsettingChartOfAccounts,
I_JournalEntryItem._OffsettingAccount AS _OffsettingAccount,
I_JournalEntryItem._OffsettingAccountWithBP AS _OffsettingAccountWithBP,
I_JournalEntryItem._WorkPackageWorkItem AS _WorkPackageWorkItem,
I_JournalEntryItem._WorkPackage AS _WorkPackage,
I_JournalEntryItem._Ledger AS _Ledger,
I_JournalEntryItem._SourceLedger AS _SourceLedger,
I_JournalEntryItem._Customer AS _Customer,
I_JournalEntryItem._CustomerGroup AS _CustomerGroup,
I_JournalEntryItem._Supplier AS _Supplier,
I_JournalEntryItem._ProductGroup_2 AS _ProductGroup_2,
I_JournalEntryItem._SoldProductGroup_2 AS _SoldProductGroup_2,
I_JournalEntryItem._MaterialGroup AS _MaterialGroup,
I_JournalEntryItem._SoldProductGroup AS _SoldProductGroup,
I_JournalEntryItem._SalesDocument AS _SalesDocument,
I_JournalEntryItem._SalesDocumentItem AS _SalesDocumentItem,
I_JournalEntryItem._SalesOrder AS _SalesOrder,
I_JournalEntryItem._SalesOrderItem AS _SalesOrderItem,
I_JournalEntryItem._InternalOrder AS _InternalOrder,
I_JournalEntryItem._Order AS _Order,
I_JournalEntryItem._Employment AS _Employment,
I_JournalEntryItem._FinancialTransactionType AS _FinancialTransactionType,
I_JournalEntryItem._BusinessTransactionType AS _BusinessTransactionType,
I_JournalEntryItem._ReferenceDocumentType AS _ReferenceDocumentType,
I_JournalEntryItem._PredecessorReferenceDocType AS _PredecessorReferenceDocType,
I_JournalEntryItem._PartnerCostCenter AS _PartnerCostCenter,
I_JournalEntryItem._PartnerProfitCenter AS _PartnerProfitCenter,
I_JournalEntryItem._PartnerBusinessArea AS _PartnerBusinessArea,
I_JournalEntryItem._PartnerFunctionalArea AS _PartnerFunctionalArea,
I_JournalEntryItem._PartnerCompanyCode AS _PartnerCompanyCode,
I_JournalEntryItem._PartnerSegment AS _PartnerSegment,
I_JournalEntryItem._AccountingDocumentCategory AS _AccountingDocumentCategory,
I_JournalEntryItem._PostingKey AS _PostingKey,
I_JournalEntryItem._SubLedgerAccLineItemType AS _SubLedgerAccLineItemType,
I_JournalEntryItem._User AS _User,
I_JournalEntryItem._EliminationProfitCenter AS _EliminationProfitCenter,
I_JournalEntryItem._ControllingObject AS _ControllingObject,
I_JournalEntryItem._GLAccountType AS _GLAccountType,
I_JournalEntryItem._AlternativeGLAccount AS _AlternativeGLAccount,
I_JournalEntryItem._CountryChartOfAccounts AS _CountryChartOfAccounts,
I_JournalEntryItem._PurchasingDocument AS _PurchasingDocument,
I_JournalEntryItem._PurchasingDocumentItem AS _PurchasingDocumentItem,
I_JournalEntryItem._SpecialGLCode AS _SpecialGLCode,
I_JournalEntryItem._TaxCode AS _TaxCode,
I_JournalEntryItem._HouseBank AS _HouseBank,
I_JournalEntryItem._ClearingJrnlEntryFiscalYear AS _ClearingJrnlEntryFiscalYear,
I_JournalEntryItem._ClearingJournalEntry AS _ClearingJournalEntry,
I_JournalEntryItem._ClearingAccountingDocument AS _ClearingAccountingDocument,
I_JournalEntryItem._MasterFixedAsset AS _MasterFixedAsset,
I_JournalEntryItem._GroupFixedAsset AS _GroupFixedAsset,
I_JournalEntryItem._FixedAsset AS _FixedAsset,
I_JournalEntryItem._GroupMasterFixedAsset AS _GroupMasterFixedAsset,
I_JournalEntryItem._InventorySpecialStockValnType AS _InventorySpecialStockValnType,
I_JournalEntryItem._InventorySpclStockValnType AS _InventorySpclStockValnType,
I_JournalEntryItem._InventorySpecialStockType AS _InventorySpecialStockType,
I_JournalEntryItem._InventorySpclStkSalesDocument AS _InventorySpclStkSalesDocument,
I_JournalEntryItem._InventorySpclStkSalesDocItm AS _InventorySpclStkSalesDocItm,
I_JournalEntryItem._InvtrySpclStkWBSElmntBscData AS _InvtrySpclStkWBSElmntBscData,
I_JournalEntryItem._InvtrySpclStockWBSElmntIntID AS _InvtrySpclStockWBSElmntIntID,
I_JournalEntryItem._InventorySpclStockWBSElement AS _InventorySpclStockWBSElement,
I_JournalEntryItem._InventorySpecialStockSupplier AS _InventorySpecialStockSupplier,
I_JournalEntryItem._InventoryValuationType AS _InventoryValuationType,
I_JournalEntryItem._OriginSenderObject AS _OriginSenderObject,
I_JournalEntryItem._ControllingObjectClass AS _ControllingObjectClass,
I_JournalEntryItem._PartnerControllingObjectClass AS _PartnerControllingObjectClass,
I_JournalEntryItem._OriginCostCenter AS _OriginCostCenter,
I_JournalEntryItem._CostCtrActivityType AS _CostCtrActivityType,
I_JournalEntryItem._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
I_JournalEntryItem._OrderCategory AS _OrderCategory,
I_JournalEntryItem._BusinessProcess AS _BusinessProcess,
I_JournalEntryItem._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
I_JournalEntryItem._PartnerOrder AS _PartnerOrder,
I_JournalEntryItem._PartnerOrder_2 AS _PartnerOrder_2,
I_JournalEntryItem._PartnerOrderCategory AS _PartnerOrderCategory,
I_JournalEntryItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
I_JournalEntryItem._PartnerWBSElement AS _PartnerWBSElement,
I_JournalEntryItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
I_JournalEntryItem._PartnerProject AS _PartnerProject,
I_JournalEntryItem._PartnerSalesDocument AS _PartnerSalesDocument,
I_JournalEntryItem._PartnerSalesDocumentItem AS _PartnerSalesDocumentItem,
I_JournalEntryItem._PartnerBusinessProcess AS _PartnerBusinessProcess,
I_JournalEntryItem._BillingDocumentType AS _BillingDocumentType,
I_JournalEntryItem._SalesOrganization AS _SalesOrganization,
I_JournalEntryItem._DistributionChannel AS _DistributionChannel,
I_JournalEntryItem._SoldProduct AS _SoldProduct,
I_JournalEntryItem._SoldMaterial AS _SoldMaterial,
I_JournalEntryItem._Fund AS _Fund,
I_JournalEntryItem._PartnerFund AS _PartnerFund,
I_JournalEntryItem._FundsCenter AS _FundsCenter,
I_JournalEntryItem._MovementCategory AS _MovementCategory,
I_JournalEntryItem._AssetTransactionType AS _AssetTransactionType,
I_JournalEntryItem._BudgetPeriod AS _BudgetPeriod,
I_JournalEntryItem._CostOriginGroup AS _CostOriginGroup,
I_JournalEntryItem._FinancialManagementArea AS _FinancialManagementArea,
I_JournalEntryItem._HouseBankAccount AS _HouseBankAccount,
I_JournalEntryItem._LogicalSystem AS _LogicalSystem,
I_JournalEntryItem._OperatingConcern AS _OperatingConcern,
I_JournalEntryItem._PartnerCompany AS _PartnerCompany,
I_JournalEntryItem._ProjectNetwork AS _ProjectNetwork,
I_JournalEntryItem._PurReqValuationArea AS _PurReqValuationArea,
_OperationalAcctgDocItem._PaymentCurrency AS _PaymentCurrency,
_OperationalAcctgDocItem._CreditControlAreaCurrency AS _CreditControlAreaCurrency,
_OperationalAcctgDocItem._GoodsMovementEntryUnit AS _GoodsMovementEntryUnit,
_OperationalAcctgDocItem._PurchasingDocumentPriceUnit AS _PurchasingDocumentPriceUnit,
_OperationalAcctgDocItem._SupplyingCountry AS _SupplyingCountry,
_OperationalAcctgDocItem._TaxType AS _TaxType,
I_JournalEntryItem._ServiceDocumentType AS _ServiceDocumentType,
I_JournalEntryItem._ServiceDocument AS _ServiceDocument,
I_JournalEntryItem._ServiceDocumentItem AS _ServiceDocumentItem,
I_JournalEntryItem._Grant AS _Grant,
I_JournalEntryItem._PartnerGrant AS _PartnerGrant,
I_JournalEntryItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
I_JournalEntryItem.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
I_JournalEntryItem.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
I_JournalEntryItem.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
I_JournalEntryItem.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
I_JournalEntryItem.OrderType AS OrderType,
I_JournalEntryItem.SalesOrderType AS SalesOrderType,
I_JournalEntryItem.AssetClass AS AssetClass
FROM I_JournalEntryItem
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _InvtrySpclStockWBSElmntExtID ON InvtrySpclStockWBSElmntExtID = _InvtrySpclStockWBSElmntExtID.WBSElementExternalID -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement_1 ON PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement -- association [0..1]
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON CompanyCode = _OperationalAcctgDocItem.CompanyCode AND FiscalYear = _OperationalAcctgDocItem.FiscalYear AND AccountingDocument = _OperationalAcctgDocItem.AccountingDocument AND AccountingDocumentItem = _OperationalAcctgDocItem.AccountingDocumentItem -- association [0..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