I_OperationalAcctgDocCube
Operational Journal Entry Item - Cube
I_OperationalAcctgDocCube (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Accounting and Financial Close
I_OperationalAcctgDocCube is a Composite CDS View (Cube) that provides data about "Operational Journal Entry Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 480 fields with key fields AccountingDocumentItem, CompanyCode, FiscalYear, AccountingDocument. It has 14 associations to related views.
SAP Help Documentation
| Category | CDS Views for Transaction Data |
|---|---|
| Data Category | Cube |
Purpose
This CDS view is designed to provide a comprehensive analytical cube for operational journal entry items. It aggregates and organizes financial data from various accounting documents, allowing for detailed analysis and reporting. The view includes associations with multiple related entities to enrich the data with additional context, such as business transaction types, financial management areas, and ledger information. This CDS view provides the data to answer the following business questions: What are the detailed financial transactions recorded in the operational accounting documents? How can we analyze financial data across different currencies and units of measure? What is the status of clearing and reconciliation for specific accounting documents? What are the tax implications and calculations associated with specific journal entries? How can we track and report on financial transactions by various dimensions such as company code, cost center, profit center, and segment? How can we assess the impact of financial transactions on cash flow and payment processes? What are the relationships between different financial entities, such as customers, suppliers, and business areas, in the context of journal entries? How can we evaluate the financial performance and position of the organization using aggregated financial data? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Authorization Object Description A_B_ANLKL Asset Postings: Company Code/Asset Class CRMS4_SLSO Sales Organizational Units of Service Transactions F_ACDOCA_C FIN Authorization Context for DCLs BEGRU_BKPF_BED Accounting Document: Account Authorization for Customers BEGRU_BKPF_BEK Accounting Document: Account Authorization for Vendors BEGRU_BKPF_BLA Accounting Document: Authorization for Document Types BEGRU_BKPF_BUK Accounting Document: Authorization for Company Codes BEGRU_BKPF_FKB Accounting Document: Authorization for Functional Area BEGRU_BKPF_KOA Accounting Document: Authorization for Account Types BEGRU_BKPF_ORD Order Category / Order Type for Journal Entries F_CC_HIER Authorization Object for Company Code Hierarchies F_FAGL_SEG General Ledger: Authorization for Segment K_ML_VA CO Material Ledger: Valuation Area K_PCAR_REP EC-PCA: Summary and Line Item Reports K_REPO_CCA CO-CCA: Reporting on Cost Centers/Cost Elements S_BRWS_TIM Time related authority check for generic lists V_VBAK_AAT Sales Document: Authorization for Sales Document Types V_VBAK_VKO Sales Document: Authorization for Sales Areas
Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute CASHDISCOUNT1DAYS Cash Discount Days 1 Measure CASHDISCOUNT2DAYS Cash Discount Days 2 Measure NETPAYMENTDAYS Days Net Measure NUMBEROFITEMS Number of Items Measure CLEARINGITEM Clearing Item Measure CASHDISCOUNT1PERCENT Disc. Percent 1 Measure CASHDISCOUNT2PERCENT Disc. Percent 2 Measure ABSOLUTEEXCHANGERATE Absolute Exchange Rate Measure EFFECTIVEEXCHANGERATE Effective Exch. Rate Measure TAXEFFECTIVEEXCHANGERATE Effective Tax Exchange Rate Measure TAXABSOLUTEEXCHANGERATE Absolute Tax Exchange Rate Measure EXCHANGERATE Exchange Rate Measure TAXABSLTAMTINADDLCURRENCY1 Tax Abs. Amount in Additional Currency 1 Measure TAXABSLTAMTINADDLCURRENCY2 Tax Abs. Amount in Additional Currency 2 Measure ORIGLTXABSLTBASEAMTINADDLCRCY1 Orig. Tax Abs. Base Amt in Add. Crcy 1 Measure ORIGLTXABSLTBASEAMTINADDLCRCY2 Orig. Tax
This CDS view is designed to provide a comprehensive analytical cube for operational journal entry items. It aggregates and organizes financial data from various accounting documents, allowing for detailed analysis and reporting. The view includes associations with multiple related entities to enrich the data with additional context, such as business transaction types, financial management areas, and ledger information. This CDS view provides the data to answer the following business questions: What are the detailed financial transactions recorded in the operational accounting documents? How can we analyze financial data across different currencies and units of measure? What is the status of clearing and reconciliation for specific accounting documents? What are the tax implications and calculations associated with specific journal entries? How can we track and report on financial transactions by various dimensions such as company code, cost center, profit center, and segment? How can we assess the impact of financial transactions on cash flow and payment processes? What are the relationships between different financial entities, such as customers, suppliers, and business areas, in the context of journal entries? How can we evaluate the financial performance and position of the organization using aggregated financial data? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Authorization Object Description A_B_ANLKL Asset Postings: Company Code/Asset Class CRMS4_SLSO Sales Organizational Units of Service Transactions F_ACDOCA_C FIN Authorization Context for DCLs BEGRU_BKPF_BED Accounting Document: Account Authorization for Customers BEGRU_BKPF_BEK Accounting Document: Account Authorization for Vendors BEGRU_BKPF_BLA Accounting Document: Authorization for Document Types BEGRU_BKPF_BUK Accounting Document: Authorization for Company Codes BEGRU_BKPF_FKB Accounting Document: Authorization for Functional Area BEGRU_BKPF_KOA Accounting Document: Authorization for Account Types BEGRU_BKPF_ORD Order Category / Order Type for Journal Entries F_CC_HIER Authorization Object for Company Code Hierarchies F_FAGL_SEG General Ledger: Authorization for Segment K_ML_VA CO Material Ledger: Valuation Area K_PCAR_REP EC-PCA: Summary and Line Item Reports K_REPO_CCA CO-CCA: Reporting on Cost Centers/Cost Elements S_BRWS_TIM Time related authority check for generic lists V_VBAK_AAT Sales Document: Authorization for Sales Document Types V_VBAK_VKO Sales Document: Authorization for Sales Areas
Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute CASHDISCOUNT1DAYS Cash Discount Days 1 Measure CASHDISCOUNT2DAYS Cash Discount Days 2 Measure NETPAYMENTDAYS Days Net Measure NUMBEROFITEMS Number of Items Measure CLEARINGITEM Clearing Item Measure CASHDISCOUNT1PERCENT Disc. Percent 1 Measure CASHDISCOUNT2PERCENT Disc. Percent 2 Measure ABSOLUTEEXCHANGERATE Absolute Exchange Rate Measure EFFECTIVEEXCHANGERATE Effective Exch. Rate Measure TAXEFFECTIVEEXCHANGERATE Effective Tax Exchange Rate Measure TAXABSOLUTEEXCHANGERATE Absolute Tax Exchange Rate Measure EXCHANGERATE Exchange Rate Measure TAXABSLTAMTINADDLCURRENCY1 Tax Abs. Amount in Additional Currency 1 Measure TAXABSLTAMTINADDLCURRENCY2 Tax Abs. Amount in Additional Currency 2 Measure ORIGLTXABSLTBASEAMTINADDLCRCY1 Orig. Tax Abs. Base Amt in Add. Crcy 1 Measure ORIGLTXABSLTBASEAMTINADDLCRCY2 Orig. Tax
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Accounting and Financial Close |
| Application Component | FI-FIO-GL-IS |
| Capabilities | Data Provider for Analytical Queries, Data Source for Defining CDS Entities, Data Source in SQL Select |
| Package | Accounting and Financial Close for SAP S/4HANA Cloud Private Edition |
| Description | <p>This CDS view is designed to provide a comprehensive analytical cube for operational journal entry items. It aggregates and organizes financial data from various accounting documents, allowing for detailed analysis and reporting. The view includes associations with multiple related entities to enrich the data with additional context, such as business transaction types, financial management areas, and ledger information.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the detailed financial transactions recorded in the operational accounting documents?</p></li> <li><p>How can we analyze financial data across different currencies and units of measure?</p></li> <li><p>What is the status of clearing and reconciliation for specific accounting documents?</p></li> <li><p>What are the tax implications and calculations associated with specific journal entries?</p></li> <li><p>How can we track and report on financial transactions by various dimensions such as company code, cost center, profit center, and segment?</p></li> <li><p>How can we assess the impact of financial transactions on cash flow and payment processes?</p></li> <li><p>What are the relationships between different financial entities, such as customers, suppliers, and business areas, in the context of journal entries?</p></li> <li><p>How can we evaluate the financial performance and position of the organization using aggregated financial data?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_OperationalAcctgDocItem | I_OperationalAcctgDocItem | from |
Associations (14)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_BusTransactionTypeText | _BusinessTransactionTypeText | $projection.BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType |
| [0..*] | I_FinancialManagementAreaText | _FinancialManagementAreaText | $projection.FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea |
| [0..*] | I_LedgerText | _LedgerText | $projection.Ledger = _LedgerText.Ledger |
| [0..1] | I_WBSElement | _WBSElement | $projection.WBSElement = _WBSElement.WBSElement |
| [0..1] | I_WBSElement | _WBSElementText | $projection.WBSElement = _WBSElementText.WBSElement |
| [0..1] | I_WBSElementBasicData | _WBSElementBasicData | $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID |
| [0..1] | I_WBSElementBasicData | _WBSElementBasicDataText | $projection.WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID |
| [0..1] | I_WBSElementByExternalID | _WBSElementExternalID | $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID |
| [0..1] | I_WBSElementByExternalID | _WBSElementExternalIDText | $projection.WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID |
| [0..1] | I_AdditionalCurrencyRoles | _AdditionalCurrencyRoles | $projection.CompanyCode = _AdditionalCurrencyRoles.CompanyCode and $projection.LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup and $projection.Ledger = _AdditionalCurrencyRoles.Ledger |
| [0..*] | I_FundsCenter | _FundsCenter | $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.FundsCenter = _FundsCenter.FundsCenter |
| [0..1] | I_FundedProgram | _FundedProgram | $projection.FinancialManagementArea = _FundedProgram.FinancialManagementArea and $projection.FundedProgram = _FundedProgram.FundedProgram |
| [0..1] | I_Fund | _Fund | $projection.FinancialManagementArea = _Fund.FinancialManagementArea and $projection.Fund = _Fund.Fund |
| [0..1] | I_Fund | _PartnerFund | $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea and $projection.PartnerFund = _PartnerFund.Fund |
Annotations (19)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.sqlViewName | IFIOPACCTGDOCCUB | view | |
| EndUserText.label | Operational Journal Entry Item - Cube | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | AccountingDocumentItem | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| Analytics.dataCategory | #CUBE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| ObjectModel.sapObjectNodeType.name | CashFlowPlanningLevel | view |
Fields (480)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | AccountingDocumentItem | AccountingDocumentItem | Journal Entry Posting View Item | |
| CompanyCodeName | Company Code Name | |||
| ChartOfAccounts | ChartOfAccounts | Chart of Accounts | ||
| AccountingDocumentItemType | AccountingDocumentItemType | Identification of the Line Item | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingCreationDate | ClearingCreationDate | Clearing Creation Date | ||
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| ClearingDocFiscalYear | ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry (Deprecated) | ||
| ClearingJournalEntry | ClearingJournalEntry | Clearing Journal Entry | ||
| ClearingAccountingDocument | ClearingAccountingDocument | Clearing Journal Entry (Deprecated) | ||
| PostingKey | PostingKey | Posting Key | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| SpecialGLCode | SpecialGLCode | Special G/L Indicator | ||
| SpecialGLTransactionType | SpecialGLTransactionType | Special G/L Transaction Type | ||
| DebitCreditCode | DebitCreditCode | Single-Character Flag | ||
| BusinessArea | BusinessArea | Business Area | ||
| BusinessAreaName | Business Area Name | |||
| PartnerBusinessArea | PartnerBusinessArea | Partner Business Area | ||
| TaxCode | TaxCode | Tax on Sales/Purchases Code | ||
| WithholdingTaxCode | WithholdingTaxCode | Withholding Tax Code | ||
| TaxType | TaxType | Tax Type | ||
| TransactionTypeDetermination | TransactionTypeDetermination | Transaction Key | ||
| ValueDate | ValueDate | Value Date | ||
| AssignmentReference | AssignmentReference | Assignment Reference | ||
| DocumentItemText | DocumentItemText | Item Text | ||
| PartnerCompany | PartnerCompany | Company ID of Trading Partner | ||
| FinancialTransactionType | FinancialTransactionType | Financial Transaction Type | ||
| CorporateGroupAccount | CorporateGroupAccount | Corporate Group Account | ||
| PlanningLevel | PlanningLevel | Planning Level | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| ControllingAreaName | Controlling Area Name | |||
| CostCenter | CostCenter | Cost Center | ||
| CostCenterName | Cost Center Name | |||
| Project | Project | |||
| ProjectExternalID | Project External ID | |||
| OrderID | OrderID | Order ID | ||
| BillingDocument | BillingDocument | Billing Document | ||
| SalesDocument | SalesDocument | Sales Document | ||
| SalesDocumentItem | SalesDocumentItem | Sales Document Item | ||
| ScheduleLine | ScheduleLine | Schedule Line | ||
| ServiceDocumentType | ServiceDocumentType | Service Document Type | ||
| ServiceDocument | ServiceDocument | Service Document ID | ||
| ServiceDocumentItem | ServiceDocumentItem | Service Document Item ID | ||
| MasterFixedAsset | MasterFixedAsset | Fixed Asset | ||
| FixedAsset | FixedAsset | Asset Subnumber | ||
| AssetTransactionType | AssetTransactionType | Asset Transaction Type | ||
| AssetValueDate | AssetValueDate | Asset Value Date | ||
| PersonnelNumber | PersonnelNumber | Personnel Number | ||
| IsSalesRelated | IsSalesRelated | Is Sales Related | ||
| LineItemDisplayIsEnabled | LineItemDisplayIsEnabled | Indicator: Can Line Items Be Displayed by Account? | ||
| IsOpenItemManaged | IsOpenItemManaged | Managed on an Open Item Basis | ||
| IsNotCashDiscountLiable | IsNotCashDiscountLiable | Is Not Cash Discount Liable | ||
| IsAutomaticallyCreated | IsAutomaticallyCreated | Is Automatically Created | ||
| IsUsedInPaymentTransaction | IsUsedInPaymentTransaction | Is Used In Payment Transaction | ||
| OperationalGLAccount | OperationalGLAccount | Operational General Ledger Account | ||
| GLAccount | GLAccount | General Ledger | ||
| GLAccountName | G/L Account Name | |||
| GLAccountLongName | G/L Account Long Name | |||
| Customer | Customer | Customer Number | ||
| Supplier | Supplier | Supplier | ||
| BranchAccount | BranchAccount | Branch Account No. | ||
| IsBalanceSheetAccount | IsBalanceSheetAccount | Is Balance Sheet Account | ||
| ProfitLossAccountType | ProfitLossAccountType | Profit Loss Account Type | ||
| SpecialGLAccountAssignment | SpecialGLAccountAssignment | Assignment Number for Special G/L Accounts | ||
| DueCalculationBaseDate | DueCalculationBaseDate | Due Calculation Base Date | ||
| PaymentTerms | PaymentTerms | Terms of Payment Key | ||
| CashDiscount1Days | CashDiscount1Days | Days from Baseline Date for Payment | ||
| CashDiscount2Days | CashDiscount2Days | Days from Baseline Date for Payment | ||
| NetPaymentDays | NetPaymentDays | Net Payment Terms Period | ||
| CashDiscount1Percent | CashDiscount1Percent | Cash Discount Percentage 1 | ||
| CashDiscount2Percent | CashDiscount2Percent | Cash Discount Percentage 2 | ||
| PaymentMethod | PaymentMethod | Payment Method | ||
| PaymentBlockingReason | PaymentBlockingReason | Payment Blocking Reason | ||
| FixedCashDiscount | FixedCashDiscount | Fixed Cash Discount | ||
| HouseBank | HouseBank | House Bank Key | ||
| BPBankAccountInternalID | BPBankAccountInternalID | Business Partner Bank Account Internal ID | ||
| TaxDistributionCode1 | TaxDistributionCode1 | Tax Code 1 for Distribution | ||
| TaxDistributionCode2 | TaxDistributionCode2 | Tax Code 2 for Distribution | ||
| TaxDistributionCode3 | TaxDistributionCode3 | Tax Code 3 for Distribution | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | ||
| InvoiceItemReference | InvoiceItemReference | Invoice Item Reference | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | State Central Bank Indicator | ||
| SupplyingCountry | SupplyingCountry | Supplying Country/Region | ||
| InvoiceList | InvoiceList | Invoice List | ||
| BillOfExchangeUsage | BillOfExchangeUsage | Bill of Exchange Usage Type | ||
| DunningKey | DunningKey | Dunning Key | ||
| DunningBlockingReason | DunningBlockingReason | Dunning Blocking Reason | ||
| LastDunningDate | LastDunningDate | Date of Last Dunning Notice | ||
| DunningLevel | DunningLevel | Dunning Level | ||
| DunningArea | DunningArea | Dunning Area | ||
| WithholdingTaxCertificate | WithholdingTaxCertificate | Withholding Tax Certificate | ||
| Material | Material | Material Number | ||
| Product | Product | Product Number | ||
| Plant | Plant | Valuation Area | ||
| PurchasingDocument | PurchasingDocument | Purchasing Document | ||
| PurchasingDocumentItem | PurchasingDocumentItem | Purchasing Document Item | ||
| AccountAssignmentNumber | AccountAssignmentNumber | Sequential Number of Account Assignment | ||
| IsCompletelyDelivered | IsCompletelyDelivered | Is completely delivered | ||
| MaterialPriceControl | MaterialPriceControl | Material Price Control Indicator | ||
| ValuationArea | ValuationArea | Valuation Area | ||
| InventoryValuationType | InventoryValuationType | Valuation Type | ||
| VATRegistration | VATRegistration | VAT Registration No. | ||
| DelivOfGoodsDestCountry | DelivOfGoodsDestCountry | Country/Region of Destination for Delivery of Goods | ||
| PaymentDifferenceReason | PaymentDifferenceReason | Payment Difference Reason | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| ProfitCenterName | Description of Profit Center | |||
| JointVenture | JointVenture | Joint venture | ||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | Recovery Indicator | ||
| JointVentureEquityGroup | JointVentureEquityGroup | Joint Venture Equity Group | ||
| JointVenturePartner | JointVenturePartner | Joint Venture Partner | ||
| TreasuryContractType | TreasuryContractType | Treasury Contract Type | ||
| AssetContract | AssetContract | Asset Contract | ||
| CashFlowType | CashFlowType | Flow Type | ||
| TaxJurisdiction | TaxJurisdiction | Tax Jurisdiction | ||
| REInternalFinNumber | REInternalFinNumber | Internal Key of Real Estate Object (FI) | ||
| RealEstateObject | RealEstateObject | Internal Key for Real Estate Object | ||
| SettlementReferenceDate | SettlementReferenceDate | Reference Date for Settlement | ||
| CommitmentItem | CommitmentItem | Commitment item | ||
| CommitmentItemShortID | CommitmentItemShortID | Commitment Item Short ID | ||
| CostObject | CostObject | Cost Object | ||
| ProjectNetwork | ProjectNetwork | Network Number for Account Assignment | ||
| OrderInternalBillOfOperations | OrderInternalBillOfOperations | Order Internal Bill of Operations ID | ||
| OrderIntBillOfOperationsItem | OrderIntBillOfOperationsItem | Order Internal Bill of Operations Item | ||
| WBSElementInternalID | WBSElementInternalID | WBS Element Internal ID | ||
| WBSElement | WBS Element | |||
| WBSElementExternalID | WBS Element External ID | |||
| ProfitabilitySegment | Deprecated: Profitability Segment | |||
| ProfitabilitySegment_2 | ProfitabilitySegment_2 | Profitability Segment | ||
| JointVentureBillingType | JointVentureBillingType | Joint Venture Billing Type | ||
| JointVentureEquityType | JointVentureEquityType | Joint Venture Equity Type | ||
| IsEUTriangularDeal | IsEUTriangularDeal | Is EU Triangular Deal | ||
| CostOriginGroup | CostOriginGroup | Origin Group as Subdivision of Cost Element | ||
| CompanyCodeCurrencyDetnMethod | CompanyCodeCurrencyDetnMethod | Company Code Currency Determination Method | ||
| ClearingIsReversed | ClearingIsReversed | Clearing Is Reversed | ||
| PaymentMethodSupplement | PaymentMethodSupplement | Payment Method Supplement | ||
| AlternativeGLAccount | AlternativeGLAccount | Alternative G/L Account Number In Company Code | ||
| FundsCenter | FundsCenter | Funds Management Center | ||
| Fund | Fund | Sender Fund | ||
| PartnerProfitCenter | PartnerProfitCenter | Partner Profit Center | ||
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | ID of Reference 1 by Business Partner | ||
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | ID of Reference 2 by Business Partner | ||
| IsNegativePosting | IsNegativePosting | Is Negative Posting | ||
| PaymentCardItem | PaymentCardItem | Payment Card Item | ||
| PaymentCardPaymentSettlement | PaymentCardPaymentSettlement | Payment Card Payment Settlement | ||
| CreditControlArea | CreditControlArea | Credit Control Area | ||
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | ID of Reference 3 by Business Partner | ||
| DataExchangeInstruction1 | DataExchangeInstruction1 | Data Exchange Instruction 1 | ||
| DataExchangeInstruction2 | DataExchangeInstruction2 | Data Exchange Instruction 2 | ||
| DataExchangeInstruction3 | DataExchangeInstruction3 | Data Exchange Instruction 3 | ||
| DataExchangeInstruction4 | DataExchangeInstruction4 | Data Exchange Instruction 4 | ||
| Region | Region | Region (State, Province, County) | ||
| HasPaymentOrder | HasPaymentOrder | Indicator: Payment Order Exists for this Item | ||
| PaymentReference | PaymentReference | Payment Reference | ||
| TaxDeterminationDate | TaxDeterminationDate | Date for Determination of Tax Rates | ||
| ClearingItem | ClearingItem | Clearing Item | ||
| BusinessPlace | BusinessPlace | Business place | ||
| TaxSection | TaxSection | Tax Section | ||
| CostCtrActivityType | CostCtrActivityType | Activity Type | ||
| AccountsReceivableIsPledged | AccountsReceivableIsPledged | Accounts Receivable Is Pledged | ||
| AcctsReceivablePledgingCode | AcctsReceivablePledgingCode | Accounts Receivable Pledging Code | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| GrantID | GrantID | Sender Grant | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| FunctionalAreaName | Functional Area Name | |||
| CustomerIsInExecution | CustomerIsInExecution | Customer Is In Execution | ||
| FundedProgram | FundedProgram | Funded Program | ||
| LedgerGLLineItem | LedgerGLLineItem | General Ledger Journal Entry Line Item | ||
| Segment | Segment | Segment for Segmental Reporting | ||
| SegmentName | Segment Name | |||
| PartnerSegment | PartnerSegment | Partner Segment for Segmental Reporting | ||
| PartnerFunctionalArea | PartnerFunctionalArea | Partner Functional Area | ||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| CostElement | CostElement | Cost Element | ||
| PaymentServiceProvider | PaymentServiceProvider | Payment Service Provider | ||
| PaymentRefByPaytSrvcProvider | PaymentRefByPaytSrvcProvider | Payment Reference by Payment Service Provider | ||
| SEPAMandate | SEPAMandate | Unique Reference to Mandate for each Payee | ||
| AccountingDocumentCategoryName | Journal Entry Category Name | |||
| AccountingDocumentTypeName | Document Type Name | |||
| NetDueDate | NetDueDate | Due Date for Net Payment | ||
| CashDiscount1DueDate | CashDiscount1DueDate | Due Date for Cash Discount 1 | ||
| CashDiscount2DueDate | CashDiscount2DueDate | Cash Discount 2 Due Date | ||
| OffsettingAccount | OffsettingAccount | Offsetting Account | ||
| OffsettingAccountType | OffsettingAccountType | Offsetting Account Type | ||
| OffsettingChartOfAccounts | OffsettingChartOfAccounts | Offsetting Chart of Accounts | ||
| PartnerFund | PartnerFund | Receiver Fund | ||
| PartnerGrant | PartnerGrant | Receiver Grant | ||
| BudgetPeriod | BudgetPeriod | Budget Period | ||
| PartnerBudgetPeriod | PartnerBudgetPeriod | FM: Partner Budget Period | ||
| BranchCode | BranchCode | Branch Code | ||
| JointVentureProductionDate | JointVentureProductionDate | Joint Venture Production Date | ||
| CashLedgerCompanyCode | CashLedgerCompanyCode | Cash Origin Company Code | ||
| CashLedgerAccount | CashLedgerAccount | Cash Origin Account | ||
| PubSecBudgetAccountCoCode | PubSecBudgetAccountCoCode | Company Code for Budget Account | ||
| PubSecBudgetAccount | PubSecBudgetAccount | Budget Account | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Amount in Company Code Currency | ||
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | Signed Tax Amount in Company Code Currency | ||
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | Tax Base Amount in Company Code Currency | ||
| ValuationDiffAmtInCoCodeCrcy | ValuationDiffAmtInCoCodeCrcy | Valuation Difference Amount In Company Code Currency | ||
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | Cash Discount Amount in Company Code Currency | ||
| InvoiceAmtInCoCodeCrcy | InvoiceAmtInCoCodeCrcy | Invoice Amount in Company Code Currency | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| AmountInTransactionCurrency | AmountInTransactionCurrency | Amount in Transaction Currency | ||
| OriginalTaxBaseAmount | OriginalTaxBaseAmount | Original Tax Base Amount in Transaction Currency | ||
| TaxAmount | TaxAmount | Tax Amount in Transaction Currency | ||
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | Tax Base Amount in Transaction Currency | ||
| WithholdingTaxBaseAmount | WithholdingTaxBaseAmount | Withholding Tax Base Amount | ||
| PlannedAmtInTransactionCrcy | PlannedAmtInTransactionCrcy | Planned Amount in Transaction Currency | ||
| CashDiscountBaseAmount | CashDiscountBaseAmount | Cash Discount Base Amount | ||
| CashDiscountAmount | CashDiscountAmount | Cash Discount Amount | ||
| NetPaymentAmount | NetPaymentAmount | Net Payment Amount | ||
| WithholdingTaxAmount | WithholdingTaxAmount | Withholding Tax Amount | ||
| WithholdingTaxExemptionAmt | WithholdingTaxExemptionAmt | Withholding Tax-Exemption Amount | ||
| InvoiceAmountInFrgnCurrency | InvoiceAmountInFrgnCurrency | Invoice Amount in Foreign Currency | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Balance Transaction Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| AdditionalCurrency1 | AdditionalCurrency1 | Additional Currency 1 | ||
| ValuationDiffAmtInAddlCrcy1 | ValuationDiffAmtInAddlCrcy1 | Valuation Difference Amount in Additional Currency 1 | ||
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | Amount in Additional Currency 1 | ||
| AdditionalCurrency2 | AdditionalCurrency2 | Additional Currency 2 | ||
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | Amount in Additional Currency 2 | ||
| ValuationDiffAmtInAddlCrcy2 | ValuationDiffAmtInAddlCrcy2 | Valuation Difference Amount in Additional Currency 2 | ||
| PaymentCurrency | PaymentCurrency | Currency for Automatic Payment | ||
| AmountInPaymentCurrency | AmountInPaymentCurrency | Amount in Payment Currency | ||
| CreditControlAreaCurrency | CreditControlAreaCurrency | Credit Control Area Currency | ||
| HedgedAmount | HedgedAmount | Credit Management: Hedged Amount | ||
| BaseUnit | BaseUnit | Base Unit of Measure | ||
| Quantity | Quantity | Quantity | ||
| GoodsMovementEntryUnit | GoodsMovementEntryUnit | Unit of Entry | ||
| QuantityInEntryUnit | QuantityInEntryUnit | Quantity in Unit of Entry | ||
| PurchasingDocumentPriceUnit | PurchasingDocumentPriceUnit | Purchasing Document Price Unit | ||
| PurchaseOrderQty | PurchaseOrderQty | Purchase Order Quantity | ||
| MaterialPriceUnitQty | MaterialPriceUnitQty | Material Price Unit Quantity | ||
| NumberOfItems | NumberOfItems | Number of Items | ||
| _JournalEntry | _JournalEntry | |||
| _ControllingArea | _ControllingArea | |||
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _Segment | _Segment | |||
| _ProfitCenter | _ProfitCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _CostCenter | _CostCenter | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _Customer | _Customer | |||
| _CustomerCompany | _CustomerCompany | |||
| _Supplier | _Supplier | |||
| _SupplierCompany | _SupplierCompany | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _FinancialAccountType | _FinancialAccountType | |||
| _FunctionalArea | _FunctionalArea | |||
| _BusinessArea | _BusinessArea | |||
| _CompanyCodeCurrency | _CompanyCodeCurrency | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _BalanceTransactionCurrency | _BalanceTransactionCurrency | |||
| _AdditionalCurrency1 | _AdditionalCurrency1 | |||
| _AdditionalCurrency2 | _AdditionalCurrency2 | |||
| _PaymentCurrency | _PaymentCurrency | |||
| _CreditControlAreaCurrency | _CreditControlAreaCurrency | |||
| _Material | _Material | |||
| _Product | _Product | |||
| _Plant | _Plant | |||
| _BaseUnit | _BaseUnit | |||
| _GoodsMovementEntryUnit | _GoodsMovementEntryUnit | |||
| _PurchasingDocumentPriceUnit | _PurchasingDocumentPriceUnit | |||
| _InternalOrder | _InternalOrder | |||
| _Order | _Order | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _WBSElement | _WBSElement | |||
| _WBSElementExternalID | _WBSElementExternalID | |||
| _WBSElementInternalID | _WBSElementInternalID | |||
| _AccountingDocumentCategory | _AccountingDocumentCategory | |||
| _PostingKey | _PostingKey | |||
| _DebitCreditCode | _DebitCreditCode | |||
| _PartnerBusinessArea | _PartnerBusinessArea | |||
| _TaxType | _TaxType | |||
| _PartnerCompany | _PartnerCompany | |||
| _PartnerCompany_2 | _PartnerCompany_2 | |||
| _SupplyingCountry | _SupplyingCountry | |||
| _InventoryValuationType | _InventoryValuationType | |||
| _PaymentDifferenceReason | _PaymentDifferenceReason | |||
| _PartnerSegment | _PartnerSegment | |||
| _SupplierBankDetails | _SupplierBankDetails | |||
| _ClearingJrnlEntryFiscalYear | _ClearingJrnlEntryFiscalYear | |||
| _ClearingJournalEntry | _ClearingJournalEntry | |||
| _ClearingAccountingDocument | _ClearingAccountingDocument | |||
| _SpecialGLCode | _SpecialGLCode | |||
| _TaxCode | _TaxCode | |||
| _FinancialTransactionType | _FinancialTransactionType | |||
| _SalesDocument | _SalesDocument | |||
| _SalesDocumentItem | _SalesDocumentItem | |||
| _SalesDoc | _SalesDoc | |||
| _SalesDocItem | _SalesDocItem | |||
| _ServiceDocumentType | _ServiceDocumentType | |||
| _ServiceDocument | _ServiceDocument | |||
| _ServiceDocumentItem | _ServiceDocumentItem | |||
| _MasterFixedAsset | _MasterFixedAsset | |||
| _FixedAsset | _FixedAsset | |||
| _AssetTransactionType | _AssetTransactionType | |||
| _PersonWorkAgreement_1 | _PersonWorkAgreement_1 | |||
| _Employment | _Employment | |||
| _HouseBank | _HouseBank | |||
| _PurchasingDocument | _PurchasingDocument | |||
| _PurchasingDocumentItem | _PurchasingDocumentItem | |||
| _ValuationArea | _ValuationArea | |||
| _ProjectNetwork | _ProjectNetwork | |||
| _CostOriginGroup | _CostOriginGroup | |||
| _PartnerProfitCenter | _PartnerProfitCenter | |||
| _CostCtrActivityType | _CostCtrActivityType | |||
| _BusinessProcess | _BusinessProcess | |||
| _PartnerFunctionalArea | _PartnerFunctionalArea | |||
| _HouseBankAccount | _HouseBankAccount | |||
| _FiscalPeriod | _FiscalPeriod | |||
| _ReferenceDocumentType | _ReferenceDocumentType | |||
| _OffsettingAccountType | _OffsettingAccountType | |||
| _OffsettingChartOfAccounts | _OffsettingChartOfAccounts | |||
| _OffsettingAccount | _OffsettingAccount | |||
| _OffsettingAccountWithBP | _OffsettingAccountWithBP | |||
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | |||
| _CashLedgerAccount | _CashLedgerAccount | |||
| _FundsCenter | _FundsCenter | |||
| _FundedProgram | _FundedProgram | |||
| _Fund | _Fund | |||
| _Grant | _Grant | |||
| _BudgetPeriod | _BudgetPeriod | |||
| _PartnerFund | _PartnerFund | |||
| _PartnerGrant | _PartnerGrant | |||
| _PartnerBudgetPeriod | _PartnerBudgetPeriod | |||
| _PubSecBudgetAccountCoCode | _PubSecBudgetAccountCoCode | |||
| _PubSecBudgetAccount | _PubSecBudgetAccount | |||
| _AdditionalCurrencyRoles | _AdditionalCurrencyRoles | |||
| GLAccountAuthorizationGroup | GLAccountAuthorizationGroup | Authorization Group | ||
| SupplierBasicAuthorizationGrp | SupplierBasicAuthorizationGrp | Authorization Group | ||
| CustomerBasicAuthorizationGrp | CustomerBasicAuthorizationGrp | Authorization Group | ||
| AcctgDocTypeAuthorizationGroup | AcctgDocTypeAuthorizationGroup | Authorization Group | ||
| OrderType | OrderType | Order Type | ||
| SalesOrderType | SalesOrderType | Sales Document Type | ||
| AssetClass | AssetClass | Asset Class | ||
| _CostCenterText | _CostCenterText | |||
| _FunctionalAreaText | _FunctionalAreaText | |||
| _ProfitCenterText | _ProfitCenterText | |||
| _AccountingDocumentTypeText | _AccountingDocumentTypeText | |||
| _BudgetPeriodText | _BudgetPeriodText | |||
| _BusinessTransactionTypeText | _BusinessTransactionTypeText | |||
| _BusinessAreaText | _BusinessAreaText | |||
| _PartnerBusinessAreaText | _PartnerBusinessAreaText | |||
| _BusinessProcessText | _BusinessProcessText | |||
| _ChartOfAccountsText | _ChartOfAccountsText | |||
| _OffsettingChartOfAccountsText | _OffsettingChartOfAccountsText | |||
| _PartnerCompanyText | _PartnerCompanyText | |||
| _PartnerCompanyText_2 | _PartnerCompanyText_2 | |||
| _ControllingAreaText | _ControllingAreaText | |||
| _CustomerText | _CustomerText | |||
| _FinancialManagementAreaText | _FinancialManagementAreaText | |||
| _FinancialAccountTypeText | _FinancialAccountTypeText | |||
| _OffsettingAccountTypeText | _OffsettingAccountTypeText | |||
| _FixedAssetText | _FixedAssetText | |||
| _HouseBankAccountText | _HouseBankAccountText | |||
| _LedgerText | _LedgerText | |||
| _MasterFixedAssetText | _MasterFixedAssetText | |||
| _MaterialText | _MaterialText | |||
| _ProductText | _ProductText | |||
| _ProjectNetworkText | _ProjectNetworkText | |||
| _PartnerSegmentText | _PartnerSegmentText | |||
| _SegmentText | _SegmentText | |||
| _SupplierText | _SupplierText | |||
| _WBSElementText | _WBSElementText | |||
| _WBSElementInternalIDText | _WBSElementInternalIDText | |||
| _WBSElementExternalIDText | _WBSElementExternalIDText | |||
| _WBSElementBasicDataText | _WBSElementBasicDataText | |||
| KEY | CompanyCode | I_OperationalAcctgDocItem | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | I_OperationalAcctgDocItem | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | I_OperationalAcctgDocItem | AccountingDocument | Journal Entry |
| ReferenceDocumentType | I_OperationalAcctgDocItem | ReferenceDocumentType | Reference Document Type | |
| OriginalReferenceDocument | I_OperationalAcctgDocItem | OriginalReferenceDocument | Original Reference Document | |
| ReferenceDocumentLogicalSystem | I_OperationalAcctgDocItem | ReferenceDocumentLogicalSystem | Logical System of Reference Document | |
| AccountingDocumentItemRef | I_OperationalAcctgDocItem | AccountingDocumentItemRef | Journal Entry Line Item Reference | |
| FiscalPeriod | I_OperationalAcctgDocItem | FiscalPeriod | Fiscal Period | |
| AccountingDocumentCategory | I_OperationalAcctgDocItem | AccountingDocumentCategory | Journal Entry Category | |
| PostingDate | I_OperationalAcctgDocItem | PostingDate | Posting Date for GR | |
| DocumentDate | I_OperationalAcctgDocItem | DocumentDate | Journal Entry Date | |
| AccountingDocumentType | I_OperationalAcctgDocItem | AccountingDocumentType | Journal Entry Type | |
| CompanyCodeCurrency | I_OperationalAcctgDocItem | CompanyCodeCurrency | Company Code Currency | |
| FunctionalCurrency | I_OperationalAcctgDocItem | FunctionalCurrency | Functional Currency | |
| AmountInFunctionalCurrency | I_OperationalAcctgDocItem | AmountInFunctionalCurrency | Amount in Functional Currency | |
| AbsoluteAmountInCoCodeCrcy | I_OperationalAcctgDocItem | AbsoluteAmountInCoCodeCrcy | Absolute Amount in Company Code Currency | |
| AbsoluteAmountInTransacCrcy | I_OperationalAcctgDocItem | AbsoluteAmountInTransacCrcy | Absolute Amount in Transaction Currency | |
| AbsltAmtInAdditionalCurrency1 | I_OperationalAcctgDocItem | AbsltAmtInAdditionalCurrency1 | Absolute Amount in Additional Currency 1 | |
| AbsltAmtInAdditionalCurrency2 | I_OperationalAcctgDocItem | AbsltAmtInAdditionalCurrency2 | Absolute Amount in Additional Currency 2 | |
| AbsltAmtInBalanceTransacCrcy | I_OperationalAcctgDocItem | AbsltAmtInBalanceTransacCrcy | Absolute Amount in Balance Transaction Currency | |
| AbsltAmtInFunctionalCurrency | I_OperationalAcctgDocItem | AbsltAmtInFunctionalCurrency | Absolute Amount in Functional Currency | |
| AbsltAmountInPaymentCurrency | I_OperationalAcctgDocItem | AbsltAmountInPaymentCurrency | Absolute Amount in Payment Currency | |
| HedgedAbsoluteAmount | I_OperationalAcctgDocItem | HedgedAbsoluteAmount | Hedged Absolute Amount | |
| PlannedAbsltAmtInTransCrcy | I_OperationalAcctgDocItem | PlannedAbsltAmtInTransCrcy | Planned Absolute Amount in Transaction Currency | |
| CashDiscAbsltAmtInCoCodeCrcy | I_OperationalAcctgDocItem | CashDiscAbsltAmtInCoCodeCrcy | Absolute Amount of Cash Discount in Company Code Currency | |
| CashDiscountAbsoluteAmount | I_OperationalAcctgDocItem | CashDiscountAbsoluteAmount | Absolute Amount of Cash Discount | |
| CashDiscountAbsoluteBaseAmount | I_OperationalAcctgDocItem | CashDiscountAbsoluteBaseAmount | Absolute Base Amount of Cash Discount | |
| InvoiceAbsltAmtInCoCodeCrcy | I_OperationalAcctgDocItem | InvoiceAbsltAmtInCoCodeCrcy | Absolute Amount of Invoice in Company Code Currency | |
| InvoiceAbsltAmtInFrgnCurrency | I_OperationalAcctgDocItem | InvoiceAbsltAmtInFrgnCurrency | Absolute Amount of Invoice in Foreign Currency | |
| NetPaymentAbsoluteAmount | I_OperationalAcctgDocItem | NetPaymentAbsoluteAmount | Absolute Amount of Net Payment | |
| NonDcblTaxAbsltAmtInCoCodeCrcy | I_OperationalAcctgDocItem | NonDcblTaxAbsltAmtInCoCodeCrcy | Absolute Amount of Non-Deductible Tax in Company Code Crcy | |
| NonDcblTaxAbsltAmtInTransCrcy | I_OperationalAcctgDocItem | NonDcblTaxAbsltAmtInTransCrcy | Absolute Amount of Non-Deductible Tax in Transaction Crcy | |
| TaxAbsltAmountInCoCodeCrcy | I_OperationalAcctgDocItem | TaxAbsltAmountInCoCodeCrcy | Absolute Amount of Tax in Company Code Currency | |
| TaxAbsoluteAmount | I_OperationalAcctgDocItem | TaxAbsoluteAmount | Absolute Amount of Tax in Transaction Currency | |
| TaxAbsltAmtInAddlCurrency1 | I_OperationalAcctgDocItem | TaxAbsltAmtInAddlCurrency1 | Absolute Amount of Tax in Additional Currency 1 | |
| TaxAbsltAmtInAddlCurrency2 | I_OperationalAcctgDocItem | TaxAbsltAmtInAddlCurrency2 | Absolute Amount of Tax in Additional Currency 2 | |
| TaxAbsltBaseAmountInCoCodeCrcy | I_OperationalAcctgDocItem | TaxAbsltBaseAmountInCoCodeCrcy | Absolute Base Amount of Tax in Company Code Currency | |
| TaxAbsltBaseAmountInTransCrcy | I_OperationalAcctgDocItem | TaxAbsltBaseAmountInTransCrcy | Absolute Base Amount of Tax in Transaction Currency | |
| OriglTxAbsltBaseAmountInCCCrcy | I_OperationalAcctgDocItem | OriglTxAbsltBaseAmountInCCCrcy | Absolute Base Amount of Original Tax in CoCode Currency | |
| OriginalTaxAbsoluteBaseAmount | I_OperationalAcctgDocItem | OriginalTaxAbsoluteBaseAmount | Absolute Base Amount of Original Tax | |
| OriglTxAbsltBaseAmtInAddlCrcy1 | I_OperationalAcctgDocItem | OriglTxAbsltBaseAmtInAddlCrcy1 | Absolute Base Amount of Original Tax in Additional Crcy 1 | |
| OriglTxAbsltBaseAmtInAddlCrcy2 | I_OperationalAcctgDocItem | OriglTxAbsltBaseAmtInAddlCrcy2 | Absolute Base Amount of Original Tax in Additional Crcy 2 | |
| TaxBrkdwnAbsltAmt1InCoCodeCrcy | I_OperationalAcctgDocItem | TaxBrkdwnAbsltAmt1InCoCodeCrcy | Absolute Amount of Tax Brkdown in Company Code Currency (1) | |
| TaxBrkdwnAbsltAmt2InCoCodeCrcy | I_OperationalAcctgDocItem | TaxBrkdwnAbsltAmt2InCoCodeCrcy | Absolute Amount of Tax Brkdown in Company Code Currency (2) | |
| TaxBrkdwnAbsltAmt3InCoCodeCrcy | I_OperationalAcctgDocItem | TaxBrkdwnAbsltAmt3InCoCodeCrcy | Absolute Amount of Tax Brkdown in Company Code Currency (3) | |
| TaxBrkdwnAbsltAmt1InTransCrcy | I_OperationalAcctgDocItem | TaxBrkdwnAbsltAmt1InTransCrcy | Absolute Amount of Tax Breakdown in Transaction Currency (1) | |
| TaxBrkdwnAbsltAmt2InTransCrcy | I_OperationalAcctgDocItem | TaxBrkdwnAbsltAmt2InTransCrcy | Absolute Amount of Tax Breakdown in Transaction Currency (2) | |
| TaxBrkdwnAbsltAmt3InTransCrcy | I_OperationalAcctgDocItem | TaxBrkdwnAbsltAmt3InTransCrcy | Absolute Amount of Tax Breakdown in Transaction Currency (3) | |
| WithholdingTaxAbsoluteAmount | I_OperationalAcctgDocItem | WithholdingTaxAbsoluteAmount | Absolute Amount of Withholding Tax | |
| WithholdingTaxAbsoluteBaseAmt | I_OperationalAcctgDocItem | WithholdingTaxAbsoluteBaseAmt | Absolute Base Amount of Withholding Tax | |
| WhldgTaxExemptionAbsltAmount | I_OperationalAcctgDocItem | WhldgTaxExemptionAbsltAmount | Absolute Amount of Withholding Tax Exemption | |
| ValnDiffAbsltAmtInCoCodeCrcy | I_OperationalAcctgDocItem | ValnDiffAbsltAmtInCoCodeCrcy | Absolute Amount of Valuation Difference in CoCode Crcy | |
| ValnDiffAbsltAmtInAddlCrcy1 | I_OperationalAcctgDocItem | ValnDiffAbsltAmtInAddlCrcy1 | Absolute Amount of Valuation Difference in Additional Crcy 1 | |
| ValnDiffAbsltAmtInAddlCrcy2 | I_OperationalAcctgDocItem | ValnDiffAbsltAmtInAddlCrcy2 | Absolute Amount of Valuation Difference in Additional Crcy 2 | |
| UnadjustedDebitCreditCode | I_OperationalAcctgDocItem | UnadjustedDebitCreditCode | Unadjusted Debit/Credit Code | |
| _CompanyCode | I_OperationalAcctgDocItem | _CompanyCode | ||
| _FiscalYear | I_OperationalAcctgDocItem | _FiscalYear | ||
| _AccountingDocumentType | I_OperationalAcctgDocItem | _AccountingDocumentType | ||
| _FunctionalCurrency | I_OperationalAcctgDocItem | _FunctionalCurrency | ||
| CustomerName | _Customer | CustomerName | Name of Customer | |
| AccountingDocumentCreationDate | _JournalEntry | AccountingDocumentCreationDate | Accounting Document Entry Date | |
| CreationTime | _JournalEntry | CreationTime | Time of Change | |
| LastChangeDate | _JournalEntry | LastChangeDate | Last Change Date | |
| ExchangeRateDate | _JournalEntry | ExchangeRateDate | Exchange Rate Date | |
| AccountingDocCreatedByUser | _JournalEntry | AccountingDocCreatedByUser | User which created overhead document | |
| TransactionCode | _JournalEntry | TransactionCode | Transaction Code | |
| IntercompanyTransaction | _JournalEntry | IntercompanyTransaction | Intercompany Transaction Number | |
| DocumentReferenceID | _JournalEntry | DocumentReferenceID | Document Reference ID | |
| RecurringAccountingDocument | _JournalEntry | RecurringAccountingDocument | Recurring Journal Entry | |
| ReverseDocument | _JournalEntry | ReverseDocument | Reverse Document | |
| ReverseDocumentFiscalYear | _JournalEntry | ReverseDocumentFiscalYear | Reverse Document Fiscal Year | |
| AccountingDocumentHeaderText | _JournalEntry | AccountingDocumentHeaderText | Document Header Text | |
| AbsoluteExchangeRate | _JournalEntry | AbsoluteExchangeRate | Absolute Exchange Rate | |
| ExchangeRate | _JournalEntry | ExchangeRate | Exchange rate | |
| ExchRateIsIndirectQuotation | _JournalEntry | ExchRateIsIndirectQuotation | Exchange Rate Is Indirect Quotation | |
| EffectiveExchangeRate | _JournalEntry | EffectiveExchangeRate | Effective Exchange Rate | |
| BusinessTransactionType | _JournalEntry | BusinessTransactionType | Business Transaction Category | |
| BatchInputSession | _JournalEntry | BatchInputSession | Batch Input Session | |
| FinancialManagementArea | _JournalEntry | FinancialManagementArea | Financial Management Area | |
| ReversalIsPlanned | _JournalEntry | ReversalIsPlanned | Indicator: Reversal Is Planned for Document | |
| PlannedReversalDate | _JournalEntry | PlannedReversalDate | Planned Date for the Reversal Posting | |
| TaxIsCalculatedAutomatically | _JournalEntry | TaxIsCalculatedAutomatically | Tax Is Automatically Calculated | |
| TaxBaseAmountIsNetAmount | _JournalEntry | TaxBaseAmountIsNetAmount | Tax Base Amount is Net Amount | |
| SourceCompanyCode | _JournalEntry | SourceCompanyCode | Source Company Code | |
| LogicalSystem | _JournalEntry | LogicalSystem | Logical System | |
| TaxAbsoluteExchangeRate | _JournalEntry | TaxAbsoluteExchangeRate | Absolute Tax Exchange Rate | |
| TaxExchangeRate | _JournalEntry | TaxExchangeRate | Tax Exchange Rate | |
| TaxExchRateIsIndirectQuotation | _JournalEntry | TaxExchRateIsIndirectQuotation | Tax Exchange Rate Is Indirect Quotation | |
| TaxEffectiveExchangeRate | _JournalEntry | TaxEffectiveExchangeRate | Effective Tax Exchange Rate | |
| ReversalReason | _JournalEntry | ReversalReason | Reason for Reversal or Inverse Posting | |
| Branch | _JournalEntry | Branch | Repository branch | |
| Reference1InDocumentHeader | _JournalEntry | Reference1InDocumentHeader | Internal ID of Reference Key 1 in Document Header | |
| Reference2InDocumentHeader | _JournalEntry | Reference2InDocumentHeader | Internal ID of Reference Key 2 in Document Header | |
| InvoiceReceiptDate | _JournalEntry | InvoiceReceiptDate | Invoice Receipt Date | |
| Ledger | _JournalEntry | Ledger | Ledger | |
| LedgerGroup | _JournalEntry | LedgerGroup | Ledger Group | |
| AlternativeReferenceDocument | _JournalEntry | AlternativeReferenceDocument | Alternative Reference Document | |
| TaxReportingDate | _JournalEntry | TaxReportingDate | Tax Reporting Date | |
| AccountingDocumentClass | _JournalEntry | AccountingDocumentClass | Accounting Document Class | |
| ExchangeRateType | _JournalEntry | ExchangeRateType | Exchange Rate Type | |
| LatePaymentReason | _JournalEntry | LatePaymentReason | Late Payment Reason | |
| SalesDocumentCondition | _JournalEntry | SalesDocumentCondition | Sales Document Condition | |
| IsReversal | _JournalEntry | IsReversal | Indicator: Item is Reversing Another Item | |
| IsReversed | _JournalEntry | IsReversed | Indicator: Item is Reversed | |
| _BusinessTransactionType | _JournalEntry | _BusinessTransactionType | ||
| _FinancialManagementArea | _JournalEntry | _FinancialManagementArea | ||
| _LogicalSystem | _JournalEntry | _LogicalSystem | ||
| _Ledger | _JournalEntry | _Ledger | ||
| OffsettingAccountName | _OffsettingAccountWithBP | OffsettingAccountName | Name of Offsetting Account | |
| SupplierName | _Supplier | SupplierName | Name of Supplier |
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_OperationalAcctgDocCube.
-- 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_OperationalAcctgDocCube AS
SELECT
AccountingDocumentItem,
cast( _CompanyCode.CompanyCodeName as fis_butxt preserving type ) AS CompanyCodeName,
ChartOfAccounts,
AccountingDocumentItemType,
ClearingDate,
ClearingCreationDate,
ClearingJournalEntryFiscalYear,
ClearingDocFiscalYear,
ClearingJournalEntry,
ClearingAccountingDocument,
PostingKey,
FinancialAccountType,
SpecialGLCode,
SpecialGLTransactionType,
DebitCreditCode,
BusinessArea,
cast( _BusinessArea._Text[1: Language = $session.system_language].BusinessAreaName as fis_busarea_name preserving type ) AS BusinessAreaName,
PartnerBusinessArea,
TaxCode,
WithholdingTaxCode,
TaxType,
TransactionTypeDetermination,
ValueDate,
AssignmentReference,
DocumentItemText,
PartnerCompany,
FinancialTransactionType,
CorporateGroupAccount,
PlanningLevel,
ControllingArea,
cast( _ControllingArea.ControllingAreaName as fis_bezei preserving type ) AS ControllingAreaName,
CostCenter,
cast( _CostCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].CostCenterName as fis_kostl_name preserving type ) AS CostCenterName,
cast( _WBSElementBasicData._Project.Project as fis_project preserving type ) AS Project,
cast( _WBSElementBasicData._Project.ProjectExternalID as fis_projectext_no_conv preserving type ) AS ProjectExternalID,
OrderID,
BillingDocument,
SalesDocument,
SalesDocumentItem,
ScheduleLine,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
MasterFixedAsset,
FixedAsset,
AssetTransactionType,
AssetValueDate,
PersonnelNumber,
IsSalesRelated,
LineItemDisplayIsEnabled,
IsOpenItemManaged,
IsNotCashDiscountLiable,
IsAutomaticallyCreated,
IsUsedInPaymentTransaction,
OperationalGLAccount,
GLAccount,
cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountName as fis_txt30_skat ) AS GLAccountName,
cast( _GLAccountInChartOfAccounts._Text[1: Language = $session.system_language].GLAccountLongName as fis_txt50_skat preserving type ) AS GLAccountLongName,
Customer,
Supplier,
BranchAccount,
IsBalanceSheetAccount,
ProfitLossAccountType,
SpecialGLAccountAssignment,
DueCalculationBaseDate,
PaymentTerms,
CashDiscount1Days,
CashDiscount2Days,
NetPaymentDays,
CashDiscount1Percent,
CashDiscount2Percent,
PaymentMethod,
PaymentBlockingReason,
FixedCashDiscount,
HouseBank,
BPBankAccountInternalID,
TaxDistributionCode1,
TaxDistributionCode2,
TaxDistributionCode3,
InvoiceReference,
InvoiceReferenceFiscalYear,
InvoiceItemReference,
FollowOnDocumentType,
StateCentralBankPaymentReason,
SupplyingCountry,
InvoiceList,
BillOfExchangeUsage,
DunningKey,
DunningBlockingReason,
LastDunningDate,
DunningLevel,
DunningArea,
WithholdingTaxCertificate,
Material,
Product,
Plant,
PurchasingDocument,
PurchasingDocumentItem,
AccountAssignmentNumber,
IsCompletelyDelivered,
MaterialPriceControl,
ValuationArea,
InventoryValuationType,
VATRegistration,
DelivOfGoodsDestCountry,
PaymentDifferenceReason,
ProfitCenter,
_ProfitCenter[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date]._Text[1: Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
JointVenture,
JointVentureCostRecoveryCode,
JointVentureEquityGroup,
JointVenturePartner,
TreasuryContractType,
AssetContract,
CashFlowType,
TaxJurisdiction,
REInternalFinNumber,
RealEstateObject,
SettlementReferenceDate,
CommitmentItem,
CommitmentItemShortID,
CostObject,
ProjectNetwork,
OrderInternalBillOfOperations,
OrderIntBillOfOperationsItem,
WBSElementInternalID,
cast( _WBSElementBasicData.WBSElement as fis_wbs preserving type ) AS WBSElement,
cast( _WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv preserving type ) AS WBSElementExternalID,
cast( case when ProfitabilitySegment_2 > '9999999999' then '9999999999' else lpad( ProfitabilitySegment_2, 10, '0' ) end as rkeobjnr_numc ) AS ProfitabilitySegment,
ProfitabilitySegment_2,
JointVentureBillingType,
JointVentureEquityType,
IsEUTriangularDeal,
CostOriginGroup,
CompanyCodeCurrencyDetnMethod,
ClearingIsReversed,
PaymentMethodSupplement,
AlternativeGLAccount,
FundsCenter,
Fund,
PartnerProfitCenter,
Reference1IDByBusinessPartner,
Reference2IDByBusinessPartner,
IsNegativePosting,
PaymentCardItem,
PaymentCardPaymentSettlement,
CreditControlArea,
Reference3IDByBusinessPartner,
DataExchangeInstruction1,
DataExchangeInstruction2,
DataExchangeInstruction3,
DataExchangeInstruction4,
Region,
HasPaymentOrder,
PaymentReference,
TaxDeterminationDate,
ClearingItem,
BusinessPlace,
TaxSection,
CostCtrActivityType,
AccountsReceivableIsPledged,
AcctsReceivablePledgingCode,
BusinessProcess,
GrantID,
FunctionalArea,
cast( _FunctionalArea._Text[1: Language = $session.system_language].FunctionalAreaName as fis_funcarea_name ) AS FunctionalAreaName,
CustomerIsInExecution,
FundedProgram,
LedgerGLLineItem,
Segment,
_Segment._Text[1: Language = $session.system_language].SegmentName AS SegmentName,
PartnerSegment,
PartnerFunctionalArea,
HouseBankAccount,
CostElement,
PaymentServiceProvider,
PaymentRefByPaytSrvcProvider,
SEPAMandate,
cast( _AccountingDocumentCategory._Text[1: Language = $session.system_language].AccountingDocumentCategoryName as fis_bstat_name preserving type ) AS AccountingDocumentCategoryName,
_AccountingDocumentType._Text[1: Language = $session.system_language].AccountingDocumentTypeName AS AccountingDocumentTypeName,
NetDueDate,
CashDiscount1DueDate,
CashDiscount2DueDate,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
PartnerFund,
PartnerGrant,
BudgetPeriod,
PartnerBudgetPeriod,
BranchCode,
JointVentureProductionDate,
CashLedgerCompanyCode,
CashLedgerAccount,
PubSecBudgetAccountCoCode,
PubSecBudgetAccount,
AmountInCompanyCodeCurrency,
TaxAmountInCoCodeCrcy,
TaxBaseAmountInCoCodeCrcy,
ValuationDiffAmtInCoCodeCrcy,
CashDiscountAmtInCoCodeCrcy,
InvoiceAmtInCoCodeCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
OriginalTaxBaseAmount,
TaxAmount,
TaxBaseAmountInTransCrcy,
WithholdingTaxBaseAmount,
PlannedAmtInTransactionCrcy,
CashDiscountBaseAmount,
CashDiscountAmount,
NetPaymentAmount,
WithholdingTaxAmount,
WithholdingTaxExemptionAmt,
InvoiceAmountInFrgnCurrency,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
AdditionalCurrency1,
ValuationDiffAmtInAddlCrcy1,
AmountInAdditionalCurrency1,
AdditionalCurrency2,
AmountInAdditionalCurrency2,
ValuationDiffAmtInAddlCrcy2,
PaymentCurrency,
AmountInPaymentCurrency,
CreditControlAreaCurrency,
HedgedAmount,
BaseUnit,
Quantity,
GoodsMovementEntryUnit,
QuantityInEntryUnit,
PurchasingDocumentPriceUnit,
PurchaseOrderQty,
MaterialPriceUnitQty,
NumberOfItems,
GLAccountAuthorizationGroup,
SupplierBasicAuthorizationGrp,
CustomerBasicAuthorizationGrp,
AcctgDocTypeAuthorizationGroup,
OrderType,
SalesOrderType,
AssetClass,
I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
I_OperationalAcctgDocItem.ReferenceDocumentType AS ReferenceDocumentType,
I_OperationalAcctgDocItem.OriginalReferenceDocument AS OriginalReferenceDocument,
I_OperationalAcctgDocItem.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
I_OperationalAcctgDocItem.AccountingDocumentItemRef AS AccountingDocumentItemRef,
I_OperationalAcctgDocItem.FiscalPeriod AS FiscalPeriod,
I_OperationalAcctgDocItem.AccountingDocumentCategory AS AccountingDocumentCategory,
I_OperationalAcctgDocItem.PostingDate AS PostingDate,
I_OperationalAcctgDocItem.DocumentDate AS DocumentDate,
I_OperationalAcctgDocItem.AccountingDocumentType AS AccountingDocumentType,
I_OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
I_OperationalAcctgDocItem.FunctionalCurrency AS FunctionalCurrency,
I_OperationalAcctgDocItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
I_OperationalAcctgDocItem.AbsoluteAmountInCoCodeCrcy AS AbsoluteAmountInCoCodeCrcy,
I_OperationalAcctgDocItem.AbsoluteAmountInTransacCrcy AS AbsoluteAmountInTransacCrcy,
I_OperationalAcctgDocItem.AbsltAmtInAdditionalCurrency1 AS AbsltAmtInAdditionalCurrency1,
I_OperationalAcctgDocItem.AbsltAmtInAdditionalCurrency2 AS AbsltAmtInAdditionalCurrency2,
I_OperationalAcctgDocItem.AbsltAmtInBalanceTransacCrcy AS AbsltAmtInBalanceTransacCrcy,
I_OperationalAcctgDocItem.AbsltAmtInFunctionalCurrency AS AbsltAmtInFunctionalCurrency,
I_OperationalAcctgDocItem.AbsltAmountInPaymentCurrency AS AbsltAmountInPaymentCurrency,
I_OperationalAcctgDocItem.HedgedAbsoluteAmount AS HedgedAbsoluteAmount,
I_OperationalAcctgDocItem.PlannedAbsltAmtInTransCrcy AS PlannedAbsltAmtInTransCrcy,
I_OperationalAcctgDocItem.CashDiscAbsltAmtInCoCodeCrcy AS CashDiscAbsltAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.CashDiscountAbsoluteAmount AS CashDiscountAbsoluteAmount,
I_OperationalAcctgDocItem.CashDiscountAbsoluteBaseAmount AS CashDiscountAbsoluteBaseAmount,
I_OperationalAcctgDocItem.InvoiceAbsltAmtInCoCodeCrcy AS InvoiceAbsltAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.InvoiceAbsltAmtInFrgnCurrency AS InvoiceAbsltAmtInFrgnCurrency,
I_OperationalAcctgDocItem.NetPaymentAbsoluteAmount AS NetPaymentAbsoluteAmount,
I_OperationalAcctgDocItem.NonDcblTaxAbsltAmtInCoCodeCrcy AS NonDcblTaxAbsltAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.NonDcblTaxAbsltAmtInTransCrcy AS NonDcblTaxAbsltAmtInTransCrcy,
I_OperationalAcctgDocItem.TaxAbsltAmountInCoCodeCrcy AS TaxAbsltAmountInCoCodeCrcy,
I_OperationalAcctgDocItem.TaxAbsoluteAmount AS TaxAbsoluteAmount,
I_OperationalAcctgDocItem.TaxAbsltAmtInAddlCurrency1 AS TaxAbsltAmtInAddlCurrency1,
I_OperationalAcctgDocItem.TaxAbsltAmtInAddlCurrency2 AS TaxAbsltAmtInAddlCurrency2,
I_OperationalAcctgDocItem.TaxAbsltBaseAmountInCoCodeCrcy AS TaxAbsltBaseAmountInCoCodeCrcy,
I_OperationalAcctgDocItem.TaxAbsltBaseAmountInTransCrcy AS TaxAbsltBaseAmountInTransCrcy,
I_OperationalAcctgDocItem.OriglTxAbsltBaseAmountInCCCrcy AS OriglTxAbsltBaseAmountInCCCrcy,
I_OperationalAcctgDocItem.OriginalTaxAbsoluteBaseAmount AS OriginalTaxAbsoluteBaseAmount,
I_OperationalAcctgDocItem.OriglTxAbsltBaseAmtInAddlCrcy1 AS OriglTxAbsltBaseAmtInAddlCrcy1,
I_OperationalAcctgDocItem.OriglTxAbsltBaseAmtInAddlCrcy2 AS OriglTxAbsltBaseAmtInAddlCrcy2,
I_OperationalAcctgDocItem.TaxBrkdwnAbsltAmt1InCoCodeCrcy AS TaxBrkdwnAbsltAmt1InCoCodeCrcy,
I_OperationalAcctgDocItem.TaxBrkdwnAbsltAmt2InCoCodeCrcy AS TaxBrkdwnAbsltAmt2InCoCodeCrcy,
I_OperationalAcctgDocItem.TaxBrkdwnAbsltAmt3InCoCodeCrcy AS TaxBrkdwnAbsltAmt3InCoCodeCrcy,
I_OperationalAcctgDocItem.TaxBrkdwnAbsltAmt1InTransCrcy AS TaxBrkdwnAbsltAmt1InTransCrcy,
I_OperationalAcctgDocItem.TaxBrkdwnAbsltAmt2InTransCrcy AS TaxBrkdwnAbsltAmt2InTransCrcy,
I_OperationalAcctgDocItem.TaxBrkdwnAbsltAmt3InTransCrcy AS TaxBrkdwnAbsltAmt3InTransCrcy,
I_OperationalAcctgDocItem.WithholdingTaxAbsoluteAmount AS WithholdingTaxAbsoluteAmount,
I_OperationalAcctgDocItem.WithholdingTaxAbsoluteBaseAmt AS WithholdingTaxAbsoluteBaseAmt,
I_OperationalAcctgDocItem.WhldgTaxExemptionAbsltAmount AS WhldgTaxExemptionAbsltAmount,
I_OperationalAcctgDocItem.ValnDiffAbsltAmtInCoCodeCrcy AS ValnDiffAbsltAmtInCoCodeCrcy,
I_OperationalAcctgDocItem.ValnDiffAbsltAmtInAddlCrcy1 AS ValnDiffAbsltAmtInAddlCrcy1,
I_OperationalAcctgDocItem.ValnDiffAbsltAmtInAddlCrcy2 AS ValnDiffAbsltAmtInAddlCrcy2,
I_OperationalAcctgDocItem.UnadjustedDebitCreditCode AS UnadjustedDebitCreditCode,
I_OperationalAcctgDocItem._CompanyCode AS _CompanyCode,
I_OperationalAcctgDocItem._FiscalYear AS _FiscalYear,
I_OperationalAcctgDocItem._AccountingDocumentType AS _AccountingDocumentType,
I_OperationalAcctgDocItem._FunctionalCurrency AS _FunctionalCurrency,
_Customer.CustomerName AS CustomerName,
_JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
_JournalEntry.CreationTime AS CreationTime,
_JournalEntry.LastChangeDate AS LastChangeDate,
_JournalEntry.ExchangeRateDate AS ExchangeRateDate,
_JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
_JournalEntry.TransactionCode AS TransactionCode,
_JournalEntry.IntercompanyTransaction AS IntercompanyTransaction,
_JournalEntry.DocumentReferenceID AS DocumentReferenceID,
_JournalEntry.RecurringAccountingDocument AS RecurringAccountingDocument,
_JournalEntry.ReverseDocument AS ReverseDocument,
_JournalEntry.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
_JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
_JournalEntry.AbsoluteExchangeRate AS AbsoluteExchangeRate,
_JournalEntry.ExchangeRate AS ExchangeRate,
_JournalEntry.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
_JournalEntry.EffectiveExchangeRate AS EffectiveExchangeRate,
_JournalEntry.BusinessTransactionType AS BusinessTransactionType,
_JournalEntry.BatchInputSession AS BatchInputSession,
_JournalEntry.FinancialManagementArea AS FinancialManagementArea,
_JournalEntry.ReversalIsPlanned AS ReversalIsPlanned,
_JournalEntry.PlannedReversalDate AS PlannedReversalDate,
_JournalEntry.TaxIsCalculatedAutomatically AS TaxIsCalculatedAutomatically,
_JournalEntry.TaxBaseAmountIsNetAmount AS TaxBaseAmountIsNetAmount,
_JournalEntry.SourceCompanyCode AS SourceCompanyCode,
_JournalEntry.LogicalSystem AS LogicalSystem,
_JournalEntry.TaxAbsoluteExchangeRate AS TaxAbsoluteExchangeRate,
_JournalEntry.TaxExchangeRate AS TaxExchangeRate,
_JournalEntry.TaxExchRateIsIndirectQuotation AS TaxExchRateIsIndirectQuotation,
_JournalEntry.TaxEffectiveExchangeRate AS TaxEffectiveExchangeRate,
_JournalEntry.ReversalReason AS ReversalReason,
_JournalEntry.Branch AS Branch,
_JournalEntry.Reference1InDocumentHeader AS Reference1InDocumentHeader,
_JournalEntry.Reference2InDocumentHeader AS Reference2InDocumentHeader,
_JournalEntry.InvoiceReceiptDate AS InvoiceReceiptDate,
_JournalEntry.Ledger AS Ledger,
_JournalEntry.LedgerGroup AS LedgerGroup,
_JournalEntry.AlternativeReferenceDocument AS AlternativeReferenceDocument,
_JournalEntry.TaxReportingDate AS TaxReportingDate,
_JournalEntry.AccountingDocumentClass AS AccountingDocumentClass,
_JournalEntry.ExchangeRateType AS ExchangeRateType,
_JournalEntry.LatePaymentReason AS LatePaymentReason,
_JournalEntry.SalesDocumentCondition AS SalesDocumentCondition,
_JournalEntry.IsReversal AS IsReversal,
_JournalEntry.IsReversed AS IsReversed,
_JournalEntry._BusinessTransactionType AS _BusinessTransactionType,
_JournalEntry._FinancialManagementArea AS _FinancialManagementArea,
_JournalEntry._LogicalSystem AS _LogicalSystem,
_JournalEntry._Ledger AS _Ledger,
_OffsettingAccountWithBP.OffsettingAccountName AS OffsettingAccountName,
_Supplier.SupplierName AS SupplierName
FROM I_OperationalAcctgDocItem
LEFT OUTER JOIN I_BusTransactionTypeText AS _BusinessTransactionTypeText ON BusinessTransactionType = _BusinessTransactionTypeText.BusinessTransactionType -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementAreaText AS _FinancialManagementAreaText ON FinancialManagementArea = _FinancialManagementAreaText.FinancialManagementArea -- association [0..*]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger -- association [0..*]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElement = _WBSElement.WBSElement -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElementText ON WBSElement = _WBSElementText.WBSElement -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicDataText ON WBSElementInternalID = _WBSElementBasicDataText.WBSElementInternalID -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID -- association [0..1]
LEFT OUTER JOIN I_AdditionalCurrencyRoles AS _AdditionalCurrencyRoles ON CompanyCode = _AdditionalCurrencyRoles.CompanyCode AND LedgerGroup = _AdditionalCurrencyRoles.LedgerGroup AND Ledger = _AdditionalCurrencyRoles.Ledger -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter -- association [0..*]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund -- association [0..1]
LEFT OUTER JOIN I_Fund AS _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund -- 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