I_ActualPlanJournalEntryItem
Actual Plan for Journal Entry Item
I_ActualPlanJournalEntryItem (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_ActualPlanJournalEntryItem is a Basic CDS View (Cube) that provides data about "Actual Plan for Journal Entry Item" in SAP S/4HANA. It reads from 1 data source (P_ActualPlanJrnlEntryItm) and exposes 461 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 46 associations to related views. Part of development package FINS_FIS_FICO.
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 actual and planned journal entry items. It integrates various financial and controlling data elements, allowing for detailed analysis and reporting on financial transactions, including actual versus planned amounts, across multiple dimensions such as company code, ledger, fiscal year, and more. This CDS view provides the data to answer the following business questions: What are the actual and planned amounts for journal entries across different currencies and units of measure? How do actual amounts compare to planned amounts for specific fiscal periods and years? What are the differences between actual and planned amounts in various currencies? How are financial transactions distributed across different organizational units such as company codes, profit centers, and cost centers? What are the detailed account assignments for general ledger accounts, including business areas, projects, and cost centers? How do financial transactions relate to specific business transactions, document types, and account types? What are the details of financial transactions related to sales, purchasing, and service documents? How are financial transactions linked to specific assets, orders, and maintenance activities? What are the implications of financial transactions for public sector budgeting and sponsored programs? How do financial transactions impact joint venture accounting and accrual objects? 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 The corresponding restriction types must be set to read access. For a list of restriction types please see Authorizations in Analytics for Universal Journal . These restriction types are maintained in the Maintain Business Roles app.
Structure
Measures and Dimension The documentation includes all relevant dimensions and their associations with interface views for most dimensions. It contains measures such as the amount field for available currencies, along with debit and credit amounts for all available currencies. Needed Fields Key SourceLedger Key Ledger Key CompanyCode Key FiscalYear Key AccountingDocument Key FinancialPlanningReqTransSqnc Key FinancialPlanningDataPacket Key ActualPlanJournalEntryItem LedgerGLLineItem FinancialPlanningEntryItem Filter Fields Ledger CompanyCode LedgerFiscalYear PlanningCategory ActualPlanCode With the field ActualPlanCode you can differ between actual data and plan data. In planning it is possible to have more planning categories. With the field PlanningCategory you can filter on one or many categories. More Important Fields ChartOfAccounts GLAccount ControllingArea CostCenter ProfitCenter FiscalYearVariant FiscalYearPeriod FiscalQuarter FiscalPeriod CompanyCodeCurrency AmountInCompanyCodeCurrency (or any other amount in this view) – Measure More Fields Segment WBSElementInternalID WBSElementExternalID ProjectInternalID ProjectExternalID
This CDS view is designed to provide a comprehensive analytical cube for actual and planned journal entry items. It integrates various financial and controlling data elements, allowing for detailed analysis and reporting on financial transactions, including actual versus planned amounts, across multiple dimensions such as company code, ledger, fiscal year, and more. This CDS view provides the data to answer the following business questions: What are the actual and planned amounts for journal entries across different currencies and units of measure? How do actual amounts compare to planned amounts for specific fiscal periods and years? What are the differences between actual and planned amounts in various currencies? How are financial transactions distributed across different organizational units such as company codes, profit centers, and cost centers? What are the detailed account assignments for general ledger accounts, including business areas, projects, and cost centers? How do financial transactions relate to specific business transactions, document types, and account types? What are the details of financial transactions related to sales, purchasing, and service documents? How are financial transactions linked to specific assets, orders, and maintenance activities? What are the implications of financial transactions for public sector budgeting and sponsored programs? How do financial transactions impact joint venture accounting and accrual objects? 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 The corresponding restriction types must be set to read access. For a list of restriction types please see Authorizations in Analytics for Universal Journal . These restriction types are maintained in the Maintain Business Roles app.
Structure
Measures and Dimension The documentation includes all relevant dimensions and their associations with interface views for most dimensions. It contains measures such as the amount field for available currencies, along with debit and credit amounts for all available currencies. Needed Fields Key SourceLedger Key Ledger Key CompanyCode Key FiscalYear Key AccountingDocument Key FinancialPlanningReqTransSqnc Key FinancialPlanningDataPacket Key ActualPlanJournalEntryItem LedgerGLLineItem FinancialPlanningEntryItem Filter Fields Ledger CompanyCode LedgerFiscalYear PlanningCategory ActualPlanCode With the field ActualPlanCode you can differ between actual data and plan data. In planning it is possible to have more planning categories. With the field PlanningCategory you can filter on one or many categories. More Important Fields ChartOfAccounts GLAccount ControllingArea CostCenter ProfitCenter FiscalYearVariant FiscalYearPeriod FiscalQuarter FiscalPeriod CompanyCodeCurrency AmountInCompanyCodeCurrency (or any other amount in this view) – Measure More Fields Segment WBSElementInternalID WBSElementExternalID ProjectInternalID ProjectExternalID
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 in SQL Select,Data Source for Defining CDS Entities |
| Extensible (Key User) | Yes |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Released |
| Package | Accounting and Financial Close for SAP S/4HANA Cloud Public Edition |
| Description | <p>This CDS view is designed to provide a comprehensive analytical cube for actual and planned journal entry items. It integrates various financial and controlling data elements, allowing for detailed analysis and reporting on financial transactions, including actual versus planned amounts, across multiple dimensions such as company code, ledger, fiscal year, and more.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the actual and planned amounts for journal entries across different currencies and units of measure?</p></li> <li><p>How do actual amounts compare to planned amounts for specific fiscal periods and years?</p></li> <li><p>What are the differences between actual and planned amounts in various currencies?</p></li> <li><p>How are financial transactions distributed across different organizational units such as company codes, profit centers, and cost centers?</p></li> <li><p>What are the detailed account assignments for general ledger accounts, including business areas, projects, and cost centers?</p></li> <li><p>How do financial transactions relate to specific business transactions, document types, and account types?</p></li> <li><p>What are the details of financial transactions related to sales, purchasing, and service documents?</p></li> <li><p>How are financial transactions linked to specific assets, orders, and maintenance activities?</p></li> <li><p>What are the implications of financial transactions for public sector budgeting and sponsored programs?</p></li> <li><p>How do financial transactions impact joint venture accounting and accrual objects?</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 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 |
|---|---|---|
| P_ActualPlanJrnlEntryItm | ActualPlanJournalEntryItem | from |
Associations (46)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_FiscalYearForVariant | _LedgerFiscalYearForVariant | $projection.LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear and $projection.FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant |
| [0..1] | I_FiscalPeriodForVariant | _FiscalPeriodForVariant | $projection.LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear and $projection.FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod and $projection.FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant |
| [0..1] | I_FiscalYearPeriodForVariant | _FiscalYearPeriodForVariant | $projection.FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod and $projection.FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant association[0..1] to I_CalendarDate as _CalendarDate on $projection.PostingDate = _CalendarDate.CalendarDate association[0..1] to I_FiscalCalendarDate as _FiscalCalendarDate on $projection.PostingDate = _FiscalCalendarDate.CalendarDate and $projection.FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant association[0..1] to I_BusinessArea as _BusinessArea on $projection.BusinessArea = _BusinessArea.BusinessArea association[0..*] to I_ProfitCenter as _ProfitCenter on $projection.ControllingArea = _ProfitCenter.ControllingArea and $projection.ProfitCenter = _ProfitCenter.ProfitCenter association[0..1] to I_ProfitCenter as _CurrentProfitCenter on $projection.ControllingArea = _CurrentProfitCenter.ControllingArea and $projection.ProfitCenter = _CurrentProfitCenter.ProfitCenter and _CurrentProfitCenter.ValidityStartDate <= $session.system_date and _CurrentProfitCenter.ValidityEndDate >= $session.system_date association[0..*] to I_CostCenter as _CostCenter on $projection.ControllingArea = _CostCenter.ControllingArea and $projection.CostCenter = _CostCenter.CostCenter association[0..1] to I_CostCenter as _CurrentCostCenter on $projection.ControllingArea = _CurrentCostCenter.ControllingArea and $projection.CostCenter = _CurrentCostCenter.CostCenter and _CurrentCostCenter.ValidityStartDate <= $session.system_date and _CurrentCostCenter.ValidityEndDate >= $session.system_date association[0..1] to I_Project as _Project on $projection.Project = _Project.Project |
| [0..1] | I_ProjectByExternalID | _ProjectExternalID | $projection.ProjectExternalID = _ProjectExternalID.ProjectExternalID |
| [0..1] | I_ProjectByExternalID | _ProjectExternalIDText | $projection.ProjectExternalID = _ProjectExternalIDText.ProjectExternalID |
| [0..1] | I_ProjectByExternalID | _PartnerProjectExternalID | $projection.PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID |
| [0..1] | I_ProjectByExternalID | _PartnerProjctExtrnalIDText | $projection.PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID association[0..1] to I_WBSElement as _WBSElement on $projection.WBSElement = _WBSElement.WBSElement association[0..1] to I_WBSElementByExternalID as _WBSElementExternalID on $projection.WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID association[0..1] to I_WBSElementByExternalID as _PartnerWBSElementExternalID on $projection.PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID association[0..1] to I_WBSElementByExternalID as _PartnerWBSElemntExtrnalIDText on $projection.PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID association[0..1] to I_FunctionalArea as _FunctionalArea on $projection.FunctionalArea = _FunctionalArea.FunctionalArea association[0..1] to I_Segment as _Segment on $projection.Segment = _Segment.Segment association[0..*] to I_CostCenterActivityType as _CostCtrActivityType on $projection.ControllingArea = _CostCtrActivityType.ControllingArea and $projection.CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType association[0..*] to I_CostAnalysisResource as _CostAnalysisResource on $projection.ControllingArea = _CostAnalysisResource.ControllingArea and $projection.CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource association[0..1] to I_InternalOrder as _InternalOrder on $projection.OrderID = _InternalOrder.InternalOrder association[0..1] to I_Order as _Order on $projection.OrderID = _Order.OrderID association[0..1] to I_WorkPackageWorkItem as _WorkPackageWorkItem on $projection.WorkItem = _WorkPackageWorkItem.WorkItem and $projection.WorkPackage = _WorkPackageWorkItem.WorkPackage association[0..1] to I_WorkPackage as _WorkPackage on $projection.WorkPackage = _WorkPackage.WorkPackage association[0..1] to I_CompanyCode as _PartnerCompanyCode on $projection.PartnerCompanyCode = _PartnerCompanyCode.CompanyCode association[0..1] to I_BusinessArea as _PartnerBusinessArea on $projection.PartnerBusinessArea = _PartnerBusinessArea.BusinessArea association[0..*] to I_ProfitCenter as _PartnerProfitCenter on $projection.ControllingArea = _PartnerProfitCenter.ControllingArea and $projection.PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter association[0..*] to I_CostCenter as _PartnerCostCenter on $projection.ControllingArea = _PartnerCostCenter.ControllingArea and $projection.PartnerCostCenter = _PartnerCostCenter.CostCenter association[0..1] to I_Project as _PartnerProject on $projection.PartnerProject = _PartnerProject.Project association[0..1] to I_WBSElement as _PartnerWBSElement on $projection.PartnerWBSElement = _PartnerWBSElement.WBSElement association[0..1] to I_FunctionalArea as _PartnerFunctionalArea on $projection.PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea association[0..1] to I_Segment as _PartnerSegment on $projection.PartnerSegment = _PartnerSegment.Segment association[0..*] to I_CostCenterActivityType as _PartnerCostCtrActivityType on $projection.ControllingArea = _PartnerCostCtrActivityType.ControllingArea and $projection.PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType association[0..1] to I_InternalOrder as _PartnerOrder on $projection.PartnerOrder = _PartnerOrder.InternalOrder association[0..1] to I_Order as _PartnerOrder_2 on $projection.PartnerOrder_2 = _PartnerOrder_2.OrderID association[0..1] to I_OrderCategory as _PartnerOrderCategory on $projection.PartnerOrderCategory = _PartnerOrderCategory.OrderCategory association[0..1] to I_Partnercompany as _PartnerCompany on $projection.PartnerCompany = _PartnerCompany.PartnerCompany association[1] to I_FiscalYearVariant as _FiscalYearVariant on $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant association[0..1] to I_ControllingDebitCreditCode as _ControllingDebitCreditCode on $projection.ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode association[0..1] to I_Employment as _Employment on $projection.PersonnelNumber = _Employment.EmploymentInternalID association[0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement_1 on $projection.PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement association[0..1] to I_BusinessTransactionCategory as _BusinessTransactionCategory on $projection.BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory association[0..1] to I_BusinessTransactionType as _BusinessTransactionType on $projection.BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType association[0..1] to I_AccountingDocumentType as _AccountingDocumentType on $projection.AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType association[0..1] to I_FinancialAccountType as _FinancialAccountType on $projection.FinancialAccountType = _FinancialAccountType.FinancialAccountType association[0..1] to I_DebitCreditCode as _DebitCreditCode on $projection.DebitCreditCode = _DebitCreditCode.DebitCreditCode association[0..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant association[0..1] to I_Material as _Material on $projection.Material = _Material.Material association[0..1] to I_Product as _Product on $projection.Product = _Product.Product association[0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer association[0..1] to I_CustomerCompany as _CustomerCompany on $projection.Customer = _CustomerCompany.Customer and $projection.CompanyCode = _CustomerCompany.CompanyCode association[0..1] to I_SalesOrder as _SalesOrder on $projection.SalesOrder = _SalesOrder.SalesOrder association[0..1] to I_SalesOrderItem as _SalesOrderItem on $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem association[0..1] to I_SalesDocument as _SalesDocument on $projection.SalesDocument = _SalesDocument.SalesDocument association[0..1] to I_SalesDocumentItem as _SalesDocumentItem on $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem |
| [0..1] | I_ServiceDocumentType | _ServiceDocumentType | $projection.ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType |
| [0..1] | I_SrvcDocByDocumentType | _ServiceDocument | $projection.ServiceDocumentType = _ServiceDocument.ServiceDocumentType and $projection.ServiceDocument = _ServiceDocument.ServiceDocument |
| [0..1] | I_SrvcDocItemByDocumentType | _ServiceDocumentItem | $projection.ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType and $projection.ServiceDocument = _ServiceDocumentItem.ServiceDocument and $projection.ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem |
| [0..1] | I_ServiceDocumentType | _ServiceContractType | $projection.ServiceContractType = _ServiceContractType.ServiceDocumentType |
| [0..1] | I_SrvcDocByDocumentType | _ServiceContract | $projection.ServiceContractType = _ServiceContract.ServiceDocumentType and $projection.ServiceContract = _ServiceContract.ServiceDocument |
| [0..1] | I_SrvcDocItemByDocumentType | _ServiceContractItem | $projection.ServiceContractType = _ServiceContractItem.ServiceDocumentType and $projection.ServiceContract = _ServiceContractItem.ServiceDocument and $projection.ServiceContractItem = _ServiceContractItem.ServiceDocumentItem association[0..1] to I_BillingDocumentType as _BillingDocumentType on $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType association[0..1] to I_SalesOrganization as _SalesOrganization on $projection.SalesOrganization = _SalesOrganization.SalesOrganization association[0..1] to I_DistributionChannel as _DistributionChannel on $projection.DistributionChannel = _DistributionChannel.DistributionChannel association[0..1] to I_Division as _Division on $projection.Division = _Division.Division association[0..1] to I_Division as _OrganizationDivision on $projection.OrganizationDivision = _OrganizationDivision.Division association[0..1] to I_Material as _SoldMaterial on $projection.SoldMaterial = _SoldMaterial.Material association[0..1] to I_Product as _SoldProduct on $projection.SoldProduct = _SoldProduct.Product association[0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup = _MaterialGroup.MaterialGroup association[0..1] to I_ProductGroup as _ProductGroup on $projection.ProductGroup = _ProductGroup.MaterialGroup association[0..1] to I_ProductGroup_2 as _ProductGroup_2 on $projection.ProductGroup = _ProductGroup_2.ProductGroup association[0..1] to I_ProductGroup as _SoldProductGroup on $projection.SoldProductGroup = _SoldProductGroup.MaterialGroup association[0..1] to I_ProductGroup_2 as _SoldProductGroup_2 on $projection.SoldProductGroup = _SoldProductGroup_2.ProductGroup association[0..1] to I_CustomerGroup as _CustomerGroup on $projection.CustomerGroup = _CustomerGroup.CustomerGroup association[0..1] to I_Country as _CustomerSupplierCountry on $projection.CustomerSupplierCountry = _CustomerSupplierCountry.Country association[0..*] to I_SupplierIndustryText as _CustomerSupplierIndustryText on $projection.CustomerSupplierIndustry = _CustomerSupplierIndustryText.SupplierIndustry association[0..1] to I_SalesDistrict as _SalesDistrict on $projection.SalesDistrict = _SalesDistrict.SalesDistrict association[0..1] to I_Customer as _BillToParty on $projection.BillToParty = _BillToParty.Customer association[0..1] to I_Customer as _ShipToParty on $projection.ShipToParty = _ShipToParty.Customer association[0..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency association[1] to I_Currency as _CompanyCodeCurrency on $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency association[0..1] to I_Currency as _GlobalCurrency on $projection.GlobalCurrency = _GlobalCurrency.Currency association[0..1] to I_Currency as _FunctionalCurrency on $projection.FunctionalCurrency = _FunctionalCurrency.Currency association[0..1] to I_Currency as _FreeDefinedCurrency1 on $projection.FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency association[0..1] to I_Currency as _FreeDefinedCurrency2 on $projection.FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency association[0..1] to I_Currency as _FreeDefinedCurrency3 on $projection.FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency association[0..1] to I_Currency as _FreeDefinedCurrency4 on $projection.FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency association[0..1] to I_Currency as _FreeDefinedCurrency5 on $projection.FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency association[0..1] to I_Currency as _FreeDefinedCurrency6 on $projection.FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency association[0..1] to I_Currency as _FreeDefinedCurrency7 on $projection.FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency association[0..1] to I_Currency as _FreeDefinedCurrency8 on $projection.FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency association[0..1] to I_Currency as _ControllingObjectCurrency on $projection.ControllingObjectCurrency = _ControllingObjectCurrency.Currency association[0..1] to I_UnitOfMeasure as _BaseUnit on $projection.BaseUnit = _BaseUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _CostSourceUnit on $projection.CostSourceUnit = _CostSourceUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _ReferenceQuantityUnit on $projection.ReferenceQuantityUnit = _ReferenceQuantityUnit.UnitOfMeasure association[0..1] to I_PlanningCategory as _PlanningCategory on $projection.PlanningCategory = _PlanningCategory.PlanningCategory association[0..*] to I_CostCenter as _OriginCostCenter on $projection.ControllingArea = _OriginCostCenter.ControllingArea and $projection.OriginCostCenter = _OriginCostCenter.CostCenter association[0..*] to I_ProfitCenter as _OriginProfitCenter on $projection.ControllingArea = _OriginProfitCenter.ControllingArea and $projection.OriginProfitCenter = _OriginProfitCenter.ProfitCenter association[0..*] to I_CostCenterActivityType as _OriginCostCtrActivityType on $projection.ControllingArea = _OriginCostCtrActivityType.ControllingArea and $projection.OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType association[0..1] to I_WorkCenter as _WorkCenter on $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and _WorkCenter.WorkCenterTypeCode = 'A' |
| [0..1] | I_BillableControl | _BillableControl | $projection.BillableControl = _BillableControl.BillableControl |
| [0..1] | I_Supplier | _Supplier | $projection.Supplier = _Supplier.Supplier |
| [0..1] | I_SupplierCompany | _SupplierCompany | $projection.Supplier = _SupplierCompany.Supplier and $projection.CompanyCode = _SupplierCompany.CompanyCode |
| [0..*] | I_SemTagGLAccount | _SemTagGLAccount | $projection.GLAccount = _SemTagGLAccount.GLAccount and $projection.ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts |
| [0..1] | I_CompanyCode | _CashLedgerCompanyCode | $projection.CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode |
| [0..1] | I_GLAccountInCompanyCode | _CashLedgerAccount | $projection.CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode and $projection.CashLedgerAccount = _CashLedgerAccount.GLAccount |
| [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 | _PartnerFund | $projection.FinancialManagementArea = _PartnerFund.FinancialManagementArea and $projection.PartnerFund = _PartnerFund.Fund |
| [0..1] | I_Grant | _PartnerGrant | $projection.PartnerGrant = _PartnerGrant.GrantID |
| [0..1] | I_BudgetPeriod | _PartnerBudgetPeriod | $projection.PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod |
| [0..1] | I_CompanyCode | _PubSecBudgetAccountCoCode | $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode |
| [0..1] | I_PubSecBudgetAccount | _PubSecBudgetAccount | $projection.PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode and $projection.PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount |
| [0..1] | I_FiscCalendarDateForCompCode | _PubSecBudgetCnsmpnDate | $projection.PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate and $projection.PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode |
| [0..1] | I_FiscalYearPeriodForCmpnyCode | _PubSecBudgetCnsmpnFsclPeriod | $projection.PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclPeriod.CompanyCode and $projection.PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclPeriod.FiscalYear and $projection.PubSecBudgetCnsmpnFsclPeriod = _PubSecBudgetCnsmpnFsclPeriod.FiscalPeriod |
| [0..1] | I_FiscalYearForCompanyCode | _PubSecBudgetCnsmpnFsclYear | $projection.PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclYear.CompanyCode and $projection.PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclYear.FiscalYear |
| [0..1] | I_PubSecBdgtCnsmpnType | _PubSecBudgetCnsmpnType | $projection.PubSecBudgetCnsmpnType = _PubSecBudgetCnsmpnType.PubSecBudgetCnsmpnType |
| [0..1] | I_PubSecBdgtCnsmpnAmtType | _PubSecBudgetCnsmpnAmtType | $projection.PubSecBudgetCnsmpnAmtType = _PubSecBudgetCnsmpnAmtType.PubSecBudgetCnsmpnAmtType |
| [0..1] | I_SponsoredClassCore | _SponsoredClass | $projection.SponsoredClass = _SponsoredClass.SponsoredClass |
| [0..1] | I_SponsoredProgramCore | _SponsoredProgram | $projection.SponsoredProgram = _SponsoredProgram.SponsoredProgram |
| [0..1] | I_BudgetProcess | _BudgetProcess | $projection.BudgetProcess = _BudgetProcess.BudgetProcess |
| [0..1] | I_BudgetingType | _BudgetingType | $projection.BudgetingType = _BudgetingType.BudgetingType |
| [0..1] | I_MasterFixedAsset | _MasterFixedAsset | $projection.CompanyCode = _MasterFixedAsset.CompanyCode and $projection.MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset |
| [0..1] | I_FixedAsset | _FixedAsset | $projection.CompanyCode = _FixedAsset.CompanyCode and $projection.MasterFixedAsset = _FixedAsset.MasterFixedAsset and $projection.FixedAsset = _FixedAsset.FixedAsset |
| [0..1] | I_SubLedgerAccLineItemType | _SubLedgerAccLineItemType | $projection.SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType |
| [0..1] | I_MaintenanceOrder | _MaintenanceOrder | $projection.OrderID = _MaintenanceOrder.MaintenanceOrder |
| [0..1] | I_MaintenanceOrderOperation | _MaintenanceOrderOperation | $projection.OrderID = _MaintenanceOrderOperation.MaintenanceOrder and $projection.OrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation |
| [0..1] | I_MaintenanceOrderSubOperation | _MaintenanceOrderSubOperation | $projection.OrderID = _MaintenanceOrderSubOperation.MaintenanceOrder and $projection.OrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation and $projection.OrderSuboperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation |
| [0..1] | I_MaintOrdPlngDegreeCode | _MaintOrdPlngDegreeCode | $projection.MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode |
| [0..1] | I_PMNotificationPriorityType | _PMNotificationPriorityType | $projection.MaintPriorityType = _PMNotificationPriorityType.MaintPriorityType |
| [0..1] | I_PMNotificationPriority | _PMNotificationPriority | $projection.MaintPriority = _PMNotificationPriority.MaintPriority and $projection.MaintPriorityType = _PMNotificationPriority.MaintPriorityType |
| [0..1] | I_LogisticsOrder | _SuperiorOrder | $projection.SuperiorOrder = _SuperiorOrder.OrderID |
| [0..1] | I_AccountAssignmentType | _AccountAssignmentType | $projection.AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.entityBuffer.definitionAllowed | false | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| Analytics.dataCategory | #CUBE | view | |
| Analytics.technicalName | IFIACTPLNJEI | view | |
| EndUserText.label | Actual Plan for Journal Entry Item | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | true | view | |
| VDM.viewType | #BASIC | view | |
| AccessControl.auditFilter | #ENABLED | view | |
| Environment.sql.passValueForClient | true | view |
Fields (461)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SourceLedger | P_ActualPlanJrnlEntryItm | SourceLedger | Source Ledger |
| KEY | Ledger | P_ActualPlanJrnlEntryItm | Ledger | Ledger in General Ledger Accounting |
| KEY | CompanyCode | P_ActualPlanJrnlEntryItm | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | P_ActualPlanJrnlEntryItm | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | P_ActualPlanJrnlEntryItm | AccountingDocument | Journal Entry |
| KEY | FinancialPlanningReqTransSqnc | P_ActualPlanJrnlEntryItm | FinancialPlanningReqTransSqnc | Financial Planning Request Transaction Sequence Number |
| KEY | FinancialPlanningDataPacket | P_ActualPlanJrnlEntryItm | FinancialPlanningDataPacket | Financial Planning Data Packet Number |
| KEY | ActualPlanJournalEntryItem | P_ActualPlanJrnlEntryItm | ActualPlanJournalEntryItem | Actual Plan Journal Entry Item |
| LedgerGLLineItem | P_ActualPlanJrnlEntryItm | LedgerGLLineItem | General Ledger Journal Entry Line Item | |
| FinancialPlanningEntryItem | P_ActualPlanJrnlEntryItm | FinancialPlanningEntryItem | Financial Planning Entry Item | |
| LedgerFiscalYear | P_ActualPlanJrnlEntryItm | LedgerFiscalYear | Fiscal Year of Ledger | |
| ControllingArea | P_ActualPlanJrnlEntryItm | ControllingArea | Controlling Area | |
| GLAccount | P_ActualPlanJrnlEntryItm | GLAccount | General Ledger | |
| ChartOfAccounts | P_ActualPlanJrnlEntryItm | ChartOfAccounts | Chart of Accounts | |
| ActualPlanCode | P_ActualPlanJrnlEntryItm | ActualPlanCode | Actual Plan Code | |
| BusinessArea | P_ActualPlanJrnlEntryItm | BusinessArea | Business Area | |
| ProfitCenter | P_ActualPlanJrnlEntryItm | ProfitCenter | Profit Center | |
| CostCenter | P_ActualPlanJrnlEntryItm | CostCenter | Cost Center | |
| Project | P_ActualPlanJrnlEntryItm | Project | WBS Element | |
| ProjectInternalID | P_ActualPlanJrnlEntryItm | ProjectInternalID | Project Internal ID | |
| ProjectExternalID | Project External ID | |||
| PartnerProjectInternalID | P_ActualPlanJrnlEntryItm | PartnerProjectInternalID | Partner Project Internal ID | |
| PartnerProjectExternalID | Partner Project External ID | |||
| WBSElement | P_ActualPlanJrnlEntryItm | WBSElement | WBS Internal ID | |
| WBSElementInternalID | P_ActualPlanJrnlEntryItm | WBSElementInternalID | WBS Element Internal ID | |
| WBSElementExternalID | WBS Element External ID | |||
| PartnerWBSElementInternalID | P_ActualPlanJrnlEntryItm | PartnerWBSElementInternalID | Partner WBS Element Internal ID | |
| PartnerWBSElementExternalID | Partner WBS Element External ID | |||
| FunctionalArea | P_ActualPlanJrnlEntryItm | FunctionalArea | Sendr Fctl Area | |
| Segment | P_ActualPlanJrnlEntryItm | Segment | Segment for Segmental Reporting | |
| CostCtrActivityType | P_ActualPlanJrnlEntryItm | CostCtrActivityType | Activity Type | |
| CostAnalysisResource | P_ActualPlanJrnlEntryItm | CostAnalysisResource | Cost Analysis Resource | |
| OrderID | P_ActualPlanJrnlEntryItm | OrderID | Order ID | |
| OrderCategory | P_ActualPlanJrnlEntryItm | OrderCategory | Order Category | |
| WorkPackage | P_ActualPlanJrnlEntryItm | WorkPackage | Plan Item | |
| WorkItem | P_ActualPlanJrnlEntryItm | WorkItem | Work Item ID | |
| PartnerAccountAssignmentType | P_ActualPlanJrnlEntryItm | PartnerAccountAssignmentType | Partner Account Assignment Type | |
| TimeSheetOvertimeCategory | P_ActualPlanJrnlEntryItm | TimeSheetOvertimeCategory | Overtime Category | |
| PartnerCompanyCode | P_ActualPlanJrnlEntryItm | PartnerCompanyCode | Partner Company Code | |
| PartnerBusinessArea | P_ActualPlanJrnlEntryItm | PartnerBusinessArea | Partner Business Area | |
| PartnerProfitCenter | P_ActualPlanJrnlEntryItm | PartnerProfitCenter | Partner Profit Center | |
| PartnerCostCenter | P_ActualPlanJrnlEntryItm | PartnerCostCenter | Partner Cost Center | |
| PartnerProject | P_ActualPlanJrnlEntryItm | PartnerProject | Partner Project | |
| PartnerWBSElement | P_ActualPlanJrnlEntryItm | PartnerWBSElement | Partner WBS Element | |
| PartnerFunctionalArea | P_ActualPlanJrnlEntryItm | PartnerFunctionalArea | Partner Functional Area | |
| PartnerSegment | P_ActualPlanJrnlEntryItm | PartnerSegment | Partner Segment for Segmental Reporting | |
| PartnerCostCtrActivityType | P_ActualPlanJrnlEntryItm | PartnerCostCtrActivityType | Partner Cost Center Activity Type | |
| PartnerOrder | P_ActualPlanJrnlEntryItm | PartnerOrder | Partner Order (Deprecated) | |
| PartnerOrder_2 | P_ActualPlanJrnlEntryItm | PartnerOrder_2 | Partner Order | |
| PartnerOrderCategory | P_ActualPlanJrnlEntryItm | PartnerOrderCategory | Partner Order Category | |
| PartnerSalesDocument | P_ActualPlanJrnlEntryItm | PartnerSalesDocument | Partner Sales Document | |
| PartnerProjectNetwork | P_ActualPlanJrnlEntryItm | PartnerProjectNetwork | Partner Project Network | |
| PartnerProjectNetworkActivity | P_ActualPlanJrnlEntryItm | PartnerProjectNetworkActivity | Partner Project Network Activity | |
| PartnerBusinessProcess | P_ActualPlanJrnlEntryItm | PartnerBusinessProcess | Partner Business Process | |
| PartnerCostObject | P_ActualPlanJrnlEntryItm | PartnerCostObject | Partner Cost Object | |
| PartnerCompany | P_ActualPlanJrnlEntryItm | PartnerCompany | Company ID of Trading Partner | |
| OriginProfitCenter | P_ActualPlanJrnlEntryItm | OriginProfitCenter | Origin Profit Center | |
| OriginCostCenter | P_ActualPlanJrnlEntryItm | OriginCostCenter | Origin Cost Center | |
| OriginCostCtrActivityType | P_ActualPlanJrnlEntryItm | OriginCostCtrActivityType | Origin Cost Center Activity Type | |
| ReferenceDocumentType | P_ActualPlanJrnlEntryItm | ReferenceDocumentType | Reference Document Type | |
| ReferenceDocumentContext | P_ActualPlanJrnlEntryItm | ReferenceDocumentContext | Reference Document Context | |
| ReferenceDocument | P_ActualPlanJrnlEntryItm | ReferenceDocument | Reference Doc. Number | |
| ReferenceDocumentItem | P_ActualPlanJrnlEntryItm | ReferenceDocumentItem | Reference Document Item | |
| BusinessTransactionCategory | P_ActualPlanJrnlEntryItm | BusinessTransactionCategory | Business Transaction Category | |
| BusinessTransactionType | P_ActualPlanJrnlEntryItm | BusinessTransactionType | Business Transaction Type | |
| FinancialTransactionType | P_ActualPlanJrnlEntryItm | FinancialTransactionType | Financial Transaction Type | |
| AccountingDocumentType | P_ActualPlanJrnlEntryItm | AccountingDocumentType | Journal Entry Type | |
| FinancialAccountType | P_ActualPlanJrnlEntryItm | FinancialAccountType | Fin. Account Type | |
| DebitCreditCode | P_ActualPlanJrnlEntryItm | DebitCreditCode | Single-Character Flag | |
| AssignmentReference | P_ActualPlanJrnlEntryItm | AssignmentReference | Assignment Reference | |
| PostingDate | P_ActualPlanJrnlEntryItm | PostingDate | Posting Date for GR | |
| DocumentDate | P_ActualPlanJrnlEntryItm | DocumentDate | Journal Entry Date | |
| FiscalPeriod | P_ActualPlanJrnlEntryItm | FiscalPeriod | Fiscal Period | |
| FiscalYearPeriod | P_ActualPlanJrnlEntryItm | FiscalYearPeriod | Fiscal Year Period | |
| FiscalYearVariant | P_ActualPlanJrnlEntryItm | FiscalYearVariant | Fiscal Year Variant | |
| AccountingDocCreatedByUser | P_ActualPlanJrnlEntryItm | AccountingDocCreatedByUser | User which created overhead document | |
| CreationDate | P_ActualPlanJrnlEntryItm | CreationDate | Creation Date | |
| PlanningCategory | P_ActualPlanJrnlEntryItm | PlanningCategory | Plan Category | |
| ServicesRenderedDate | P_ActualPlanJrnlEntryItm | ServicesRenderedDate | Date on which services are rendered | |
| ControllingDebitCreditCode | P_ActualPlanJrnlEntryItm | ControllingDebitCreditCode | Controlling Debit Credit Code | |
| AccountAssignmentType | P_ActualPlanJrnlEntryItm | AccountAssignmentType | Account Assignment Type | |
| PersonnelNumber | P_ActualPlanJrnlEntryItm | PersonnelNumber | Personnel Number | |
| BillableControl | P_ActualPlanJrnlEntryItm | BillableControl | Billable Control | |
| ValuationArea | P_ActualPlanJrnlEntryItm | ValuationArea | Valuation Area | |
| ControllingObject | P_ActualPlanJrnlEntryItm | ControllingObject | Controlling Object | |
| CostOriginGroup | P_ActualPlanJrnlEntryItm | CostOriginGroup | Origin Group as Subdivision of Cost Element | |
| ControllingObjectClass | P_ActualPlanJrnlEntryItm | ControllingObjectClass | Controlling Object Class | |
| BusinessSolutionOrder | P_ActualPlanJrnlEntryItm | BusinessSolutionOrder | Solution Order | |
| BusinessSolutionOrderItem | P_ActualPlanJrnlEntryItm | BusinessSolutionOrderItem | Solution Order Item | |
| ProviderContract | P_ActualPlanJrnlEntryItm | ProviderContract | Provider Contract | |
| ProviderContractItem | P_ActualPlanJrnlEntryItm | ProviderContractItem | Provider Contract Item | |
| DocumentItemText | P_ActualPlanJrnlEntryItm | DocumentItemText | Item Text | |
| Plant | P_ActualPlanJrnlEntryItm | Plant | Valuation Area | |
| Material | P_ActualPlanJrnlEntryItm | Material | Material Number | |
| Product | P_ActualPlanJrnlEntryItm | Product | Product Sold | |
| Customer | P_ActualPlanJrnlEntryItm | Customer | Customer Number | |
| Supplier | P_ActualPlanJrnlEntryItm | Supplier | Supplier | |
| PurchasingDocument | P_ActualPlanJrnlEntryItm | PurchasingDocument | Purchasing Document | |
| PurchasingDocumentItem | P_ActualPlanJrnlEntryItm | PurchasingDocumentItem | Purchasing Document Item | |
| AccountAssignmentNumber | P_ActualPlanJrnlEntryItm | AccountAssignmentNumber | Account Assignment Number | |
| OffsettingAccount | P_ActualPlanJrnlEntryItm | OffsettingAccount | Offsetting Account | |
| OffsettingAccountType | P_ActualPlanJrnlEntryItm | OffsettingAccountType | Offsetting Account Type | |
| OffsettingChartOfAccounts | P_ActualPlanJrnlEntryItm | OffsettingChartOfAccounts | Offsetting Chart of Accounts | |
| SalesOrder | P_ActualPlanJrnlEntryItm | SalesOrder | SD Document | |
| SalesOrderItem | P_ActualPlanJrnlEntryItm | SalesOrderItem | Sales Order Item | |
| SalesDocument | P_ActualPlanJrnlEntryItm | SalesDocument | Sales Document | |
| SalesDocumentItem | P_ActualPlanJrnlEntryItm | SalesDocumentItem | Sales Document Item | |
| ServiceDocumentType | P_ActualPlanJrnlEntryItm | ServiceDocumentType | Service Document Type | |
| ServiceDocument | P_ActualPlanJrnlEntryItm | ServiceDocument | Service Document ID | |
| ServiceDocumentItem | P_ActualPlanJrnlEntryItm | ServiceDocumentItem | Service Document Item ID | |
| ServiceContractType | P_ActualPlanJrnlEntryItm | ServiceContractType | Service Contract Type | |
| ServiceContract | P_ActualPlanJrnlEntryItm | ServiceContract | Service Contract ID | |
| ServiceContractItem | P_ActualPlanJrnlEntryItm | ServiceContractItem | Service Contract Item ID | |
| ProjectNetwork | P_ActualPlanJrnlEntryItm | ProjectNetwork | Network Number for Account Assignment | |
| BillingDocumentType | P_ActualPlanJrnlEntryItm | BillingDocumentType | Billing Type | |
| SalesOrganization | P_ActualPlanJrnlEntryItm | SalesOrganization | Sales Organization | |
| DistributionChannel | P_ActualPlanJrnlEntryItm | DistributionChannel | Distribution Channel | |
| Division | P_ActualPlanJrnlEntryItm | Division | Internal Division ID | |
| OrganizationDivision | P_ActualPlanJrnlEntryItm | OrganizationDivision | Organization Division | |
| SoldMaterial | P_ActualPlanJrnlEntryItm | SoldMaterial | Sold Material | |
| SoldProduct | P_ActualPlanJrnlEntryItm | SoldProduct | Product Sold | |
| MaterialGroup | P_ActualPlanJrnlEntryItm | MaterialGroup | Product Sold Group (Deprecated) | |
| ProductGroup | P_ActualPlanJrnlEntryItm | ProductGroup | Product Group for Maintenance Orders | |
| SoldProductGroup | P_ActualPlanJrnlEntryItm | SoldProductGroup | Product Sold Group | |
| CustomerGroup | P_ActualPlanJrnlEntryItm | CustomerGroup | Customer Group | |
| CustomerSupplierCountry | P_ActualPlanJrnlEntryItm | CustomerSupplierCountry | Customer or Supplier Country/Region | |
| CustomerSupplierIndustry | P_ActualPlanJrnlEntryItm | CustomerSupplierIndustry | Customer Supplier Industry | |
| SalesDistrict | P_ActualPlanJrnlEntryItm | SalesDistrict | Sales District | |
| BillToParty | P_ActualPlanJrnlEntryItm | BillToParty | Inv. Recipient | |
| ShipToParty | P_ActualPlanJrnlEntryItm | ShipToParty | Ship-To Party (obsolete) | |
| CustomerSupplierCorporateGroup | P_ActualPlanJrnlEntryItm | CustomerSupplierCorporateGroup | Customer Supplier Corporate Group | |
| IsStatisticalOrder | P_ActualPlanJrnlEntryItm | IsStatisticalOrder | Indicator: Internal Order is Statistical Account Assignment | |
| IsStatisticalCostCenter | P_ActualPlanJrnlEntryItm | IsStatisticalCostCenter | Indicator: Cost Center is Statistical Account Assignment | |
| IsStatisticalSalesDocument | P_ActualPlanJrnlEntryItm | IsStatisticalSalesDocument | Sales Document is statistical | |
| WBSIsStatisticalWBSElement | P_ActualPlanJrnlEntryItm | WBSIsStatisticalWBSElement | Indicator: WBS Element is Statistical Account Assignment | |
| WorkCenterInternalID | P_ActualPlanJrnlEntryItm | WorkCenterInternalID | Object ID of the resource | |
| OrderOperation | P_ActualPlanJrnlEntryItm | OrderOperation | Operation or Phase | |
| OrderItem | P_ActualPlanJrnlEntryItm | OrderItem | Number of Order Item | |
| PartnerOrderItem | P_ActualPlanJrnlEntryItm | PartnerOrderItem | Partner Order Item Number | |
| OrderSuboperation | P_ActualPlanJrnlEntryItm | OrderSuboperation | Order Suboperation | |
| Equipment | P_ActualPlanJrnlEntryItm | Equipment | Equipment Number | |
| FunctionalLocation | P_ActualPlanJrnlEntryItm | FunctionalLocation | Functional Location | |
| Assembly | P_ActualPlanJrnlEntryItm | Assembly | Pegged Reqmt | |
| MaintenanceActivityType | P_ActualPlanJrnlEntryItm | MaintenanceActivityType | Maintenance activity type | |
| MaintenanceOrderPlanningCode | P_ActualPlanJrnlEntryItm | MaintenanceOrderPlanningCode | Maintenance order planning indicator | |
| MaintPriorityType | P_ActualPlanJrnlEntryItm | MaintPriorityType | Priority Type | |
| MaintPriority | P_ActualPlanJrnlEntryItm | MaintPriority | Priority | |
| SuperiorOrder | P_ActualPlanJrnlEntryItm | SuperiorOrder | Number of Superior Order | |
| SourceReferenceDocumentType | P_ActualPlanJrnlEntryItm | SourceReferenceDocumentType | Source Reference Document Type | |
| SourceLogicalSystem | P_ActualPlanJrnlEntryItm | SourceLogicalSystem | Source Logical System | |
| SourceReferenceDocumentCntxt | P_ActualPlanJrnlEntryItm | SourceReferenceDocumentCntxt | Source Reference Document Context | |
| SourceReferenceDocument | P_ActualPlanJrnlEntryItm | SourceReferenceDocument | Source Reference Document | |
| SourceReferenceDocumentItem | P_ActualPlanJrnlEntryItm | SourceReferenceDocumentItem | Source Reference Document Item | |
| SourceReferenceDocSubitem | P_ActualPlanJrnlEntryItm | SourceReferenceDocSubitem | Source Reference Document Subitem | |
| IsCommitment | P_ActualPlanJrnlEntryItm | IsCommitment | Indicator: Is Commitment | |
| CashLedgerCompanyCode | P_ActualPlanJrnlEntryItm | CashLedgerCompanyCode | Cash Origin Company Code | |
| CashLedgerAccount | P_ActualPlanJrnlEntryItm | CashLedgerAccount | Cash Origin Account | |
| FinancialManagementArea | P_ActualPlanJrnlEntryItm | FinancialManagementArea | Financial Management Area | |
| FundsCenter | P_ActualPlanJrnlEntryItm | FundsCenter | Funds Management Center | |
| FundedProgram | P_ActualPlanJrnlEntryItm | FundedProgram | Funded Program | |
| Fund | P_ActualPlanJrnlEntryItm | Fund | Sender Fund | |
| GrantID | P_ActualPlanJrnlEntryItm | GrantID | Sender Grant | |
| BudgetPeriod | P_ActualPlanJrnlEntryItm | BudgetPeriod | Budget Period | |
| PartnerFund | P_ActualPlanJrnlEntryItm | PartnerFund | Receiver Fund | |
| PartnerGrant | P_ActualPlanJrnlEntryItm | PartnerGrant | Receiver Grant | |
| PartnerBudgetPeriod | P_ActualPlanJrnlEntryItm | PartnerBudgetPeriod | FM: Partner Budget Period | |
| PubSecBudgetAccount | P_ActualPlanJrnlEntryItm | PubSecBudgetAccount | Budget Account | |
| PubSecBudgetAccountCoCode | P_ActualPlanJrnlEntryItm | PubSecBudgetAccountCoCode | Company Code for Budget Account | |
| PubSecBudgetCnsmpnDate | P_ActualPlanJrnlEntryItm | PubSecBudgetCnsmpnDate | Budget Consumption Date | |
| PubSecBudgetCnsmpnFsclPeriod | P_ActualPlanJrnlEntryItm | PubSecBudgetCnsmpnFsclPeriod | CC Fiscal Period for Budget Consumption Date | |
| PubSecBudgetCnsmpnFsclYear | P_ActualPlanJrnlEntryItm | PubSecBudgetCnsmpnFsclYear | CC Fiscal Year for Budget Consumption Date | |
| PubSecBudgetIsRelevant | P_ActualPlanJrnlEntryItm | PubSecBudgetIsRelevant | Budget-Relevant Indicator | |
| PubSecBudgetCnsmpnType | P_ActualPlanJrnlEntryItm | PubSecBudgetCnsmpnType | Budget Consumption Type | |
| PubSecBudgetCnsmpnAmtType | P_ActualPlanJrnlEntryItm | PubSecBudgetCnsmpnAmtType | Budget Consumption Amount Type | |
| SponsoredProgram | P_ActualPlanJrnlEntryItm | SponsoredProgram | Sponsored Program | |
| SponsoredClass | P_ActualPlanJrnlEntryItm | SponsoredClass | Sponsored Class | |
| GteeMBudgetValidityNumber | P_ActualPlanJrnlEntryItm | GteeMBudgetValidityNumber | Budget Validity Number | |
| BudgetProcess | P_ActualPlanJrnlEntryItm | BudgetProcess | Budget Process Type | |
| BudgetingType | P_ActualPlanJrnlEntryItm | BudgetingType | Budget Type (Subcategory) | |
| BudgetDocWorkFlowStatus | P_ActualPlanJrnlEntryItm | BudgetDocWorkFlowStatus | Workflow Status for a Budget Document | |
| SubLedgerAcctLineItemType | P_ActualPlanJrnlEntryItm | SubLedgerAcctLineItemType | Subledger-Specific Line Item Type | |
| AssetDepreciationArea | P_ActualPlanJrnlEntryItm | AssetDepreciationArea | Asset Depreciation Area (Real or Derived) | |
| MasterFixedAsset | P_ActualPlanJrnlEntryItm | MasterFixedAsset | Fixed Asset (Main Asset Number) | |
| FixedAsset | P_ActualPlanJrnlEntryItm | FixedAsset | Asset Subnumber | |
| AssetAcctTransClassfctn | P_ActualPlanJrnlEntryItm | AssetAcctTransClassfctn | Transaction Type Category | |
| AssetClass | P_ActualPlanJrnlEntryItm | AssetClass | Asset Class | |
| JointVenture | P_ActualPlanJrnlEntryItm | JointVenture | Joint venture | |
| JointVentureEquityGroup | P_ActualPlanJrnlEntryItm | JointVentureEquityGroup | Joint Venture Equity Group | |
| JointVentureCostRecoveryCode | P_ActualPlanJrnlEntryItm | JointVentureCostRecoveryCode | Joint Venture Cost Recovery Code | |
| JointVentureProductionDate | P_ActualPlanJrnlEntryItm | JointVentureProductionDate | Joint Venture Production Date | |
| JointVentureAccountingActivity | P_ActualPlanJrnlEntryItm | JointVentureAccountingActivity | Joint Venture Accounting Activity | |
| AccrualObjectType | P_ActualPlanJrnlEntryItm | AccrualObjectType | Type of the Accrual Object | |
| AccrualObjectLogicalSystem | P_ActualPlanJrnlEntryItm | AccrualObjectLogicalSystem | Logical System of the Accrual Object | |
| AccrualObject | P_ActualPlanJrnlEntryItm | AccrualObject | External Reference of Accrual Object | |
| AccrualSubobject | P_ActualPlanJrnlEntryItm | AccrualSubobject | External Reference of Accrual Subobject | |
| AccrualItemType | P_ActualPlanJrnlEntryItm | AccrualItemType | Type of the Item of the Accrual Subobject | |
| AccrualReferenceObject | P_ActualPlanJrnlEntryItm | AccrualReferenceObject | Accrual Reference Object | |
| AccrualValueDate | P_ActualPlanJrnlEntryItm | AccrualValueDate | Accrual Value Date | |
| Reservation | P_ActualPlanJrnlEntryItm | Reservation | Number of reservation/dependent requirements | |
| ReservationItem | P_ActualPlanJrnlEntryItm | ReservationItem | Item Number of Reservation | |
| ReservationType | P_ActualPlanJrnlEntryItm | ReservationType | Type of Reservation | |
| MMServicePackage | P_ActualPlanJrnlEntryItm | MMServicePackage | Service Package | |
| MMServicePackageLine | P_ActualPlanJrnlEntryItm | MMServicePackageLine | Service Package Item | |
| REBusinessEntity | P_ActualPlanJrnlEntryItm | REBusinessEntity | RE Business Entity | |
| RealEstateBuilding | P_ActualPlanJrnlEntryItm | RealEstateBuilding | Real Estate Building | |
| RealEstateProperty | P_ActualPlanJrnlEntryItm | RealEstateProperty | Real Estate Property | |
| RERentalObject | P_ActualPlanJrnlEntryItm | RERentalObject | RE Rental Object | |
| RealEstateContract | P_ActualPlanJrnlEntryItm | RealEstateContract | Real Estate Contract Number | |
| REServiceChargeKey | P_ActualPlanJrnlEntryItm | REServiceChargeKey | RE Service Charge Key | |
| RESettlementUnitID | P_ActualPlanJrnlEntryItm | RESettlementUnitID | RE Settlement Unit | |
| SettlementReferenceDate | P_ActualPlanJrnlEntryItm | SettlementReferenceDate | Settlement Reference Date | |
| TransactionCurrency | P_ActualPlanJrnlEntryItm | TransactionCurrency | Transaction Currency | |
| CompanyCodeCurrency | P_ActualPlanJrnlEntryItm | CompanyCodeCurrency | Company Code Currency | |
| GlobalCurrency | P_ActualPlanJrnlEntryItm | GlobalCurrency | GM Billing Element: Global Currency | |
| FunctionalCurrency | P_ActualPlanJrnlEntryItm | FunctionalCurrency | Functional Currency | |
| FreeDefinedCurrency1 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency1 | Freely Defined Currency 1 | |
| FreeDefinedCurrency2 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency2 | Freely Defined Currency 2 | |
| FreeDefinedCurrency3 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency3 | Freely Defined Currency 3 | |
| FreeDefinedCurrency4 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency4 | Freely Defined Currency 4 | |
| FreeDefinedCurrency5 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency5 | Freely Defined Currency 5 | |
| FreeDefinedCurrency6 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency6 | Freely Defined Currency 6 | |
| FreeDefinedCurrency7 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency7 | Freely Defined Currency 7 | |
| FreeDefinedCurrency8 | P_ActualPlanJrnlEntryItm | FreeDefinedCurrency8 | Freely Defined Currency 8 | |
| ControllingObjectCurrency | P_ActualPlanJrnlEntryItm | ControllingObjectCurrency | CO Object Currency | |
| CostSourceUnit | P_ActualPlanJrnlEntryItm | CostSourceUnit | Cost Source Unit | |
| AmountInTransactionCurrency | P_ActualPlanJrnlEntryItm | AmountInTransactionCurrency | Amount in Transaction Currency | |
| AmountInCompanyCodeCurrency | P_ActualPlanJrnlEntryItm | AmountInCompanyCodeCurrency | Amount in Company Code Currency | |
| AmountInGlobalCurrency | P_ActualPlanJrnlEntryItm | AmountInGlobalCurrency | Amount in Global Currency | |
| AmountInFunctionalCurrency | P_ActualPlanJrnlEntryItm | AmountInFunctionalCurrency | Amount in Functional Currency | |
| AmountInFreeDefinedCurrency1 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| AmountInFreeDefinedCurrency2 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | |
| AmountInFreeDefinedCurrency3 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | |
| AmountInFreeDefinedCurrency4 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | |
| AmountInFreeDefinedCurrency5 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | |
| AmountInFreeDefinedCurrency6 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | |
| AmountInFreeDefinedCurrency7 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | |
| AmountInFreeDefinedCurrency8 | P_ActualPlanJrnlEntryItm | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | |
| AmountInObjectCurrency | P_ActualPlanJrnlEntryItm | AmountInObjectCurrency | Amount in Object Currency | |
| FixedAmountInGlobalCrcy | P_ActualPlanJrnlEntryItm | FixedAmountInGlobalCrcy | Fixed Amount in Global Currency | |
| FixedAmountInCoCodeCrcy | P_ActualPlanJrnlEntryItm | FixedAmountInCoCodeCrcy | Fixed Amount in Company Currency | |
| FixedAmountInTransCrcy | P_ActualPlanJrnlEntryItm | FixedAmountInTransCrcy | Fixed Amount in Transaction Currency | |
| ValuationQuantity | P_ActualPlanJrnlEntryItm | ValuationQuantity | Valuation Quantity | |
| ValuationFixedQuantity | P_ActualPlanJrnlEntryItm | ValuationFixedQuantity | Valuation Fixed Quantity | |
| FixedQuantity | P_ActualPlanJrnlEntryItm | FixedQuantity | Fixed Quantity | |
| BaseUnit | P_ActualPlanJrnlEntryItm | BaseUnit | Base Unit of Measure | |
| Quantity | P_ActualPlanJrnlEntryItm | Quantity | Quantity | |
| ReferenceQuantityUnit | P_ActualPlanJrnlEntryItm | ReferenceQuantityUnit | Unit of Measure for Reference Quantity | |
| ReferenceQuantity | P_ActualPlanJrnlEntryItm | ReferenceQuantity | Comm Refer Quantity | |
| ActualAmountInTransactionCrcy | P_ActualPlanJrnlEntryItm | ActualAmountInTransactionCrcy | Actual Amount in Transaction Currency | |
| ActualAmountInCompanyCodeCrcy | P_ActualPlanJrnlEntryItm | ActualAmountInCompanyCodeCrcy | Actual Amount in Company Code Currency | |
| ActualAmountInGlobalCurrency | P_ActualPlanJrnlEntryItm | ActualAmountInGlobalCurrency | Actual Amount in Global Currency | |
| ActualAmountInFreeDfndCrcy1 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy1 | Actual Amount in Freely Defined Currency 1 | |
| ActualAmountInFreeDfndCrcy2 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy2 | Actual Amount in Freely Defined Currency 2 | |
| ActualAmountInFreeDfndCrcy3 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy3 | Actual Amount in Freely Defined Currency 3 | |
| ActualAmountInFreeDfndCrcy4 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy4 | Actual Amount in Freely Defined Currency 4 | |
| ActualAmountInFreeDfndCrcy5 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy5 | Actual Amount in Freely Defined Currency 5 | |
| ActualAmountInFreeDfndCrcy6 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy6 | Actual Amount in Freely Defined Currency 6 | |
| ActualAmountInFreeDfndCrcy7 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy7 | Actual Amount in Freely Defined Currency 7 | |
| ActualAmountInFreeDfndCrcy8 | P_ActualPlanJrnlEntryItm | ActualAmountInFreeDfndCrcy8 | Actual Amount in Freely Defined Currency 8 | |
| ActualAmountInObjectCurrency | P_ActualPlanJrnlEntryItm | ActualAmountInObjectCurrency | Actual Amount in Object Currency | |
| ActualValuationQuantity | P_ActualPlanJrnlEntryItm | ActualValuationQuantity | Actual Valuation Quantity | |
| ActualReferenceQuantity | P_ActualPlanJrnlEntryItm | ActualReferenceQuantity | Actual Reference Quantity | |
| ActualQuantityInBaseUnit | P_ActualPlanJrnlEntryItm | ActualQuantityInBaseUnit | Actual Quantity in Base Unit | |
| PlanAmountInTransactionCrcy | P_ActualPlanJrnlEntryItm | PlanAmountInTransactionCrcy | Plan Amount in Transaction Currency | |
| PlanAmountInCompanyCodeCrcy | P_ActualPlanJrnlEntryItm | PlanAmountInCompanyCodeCrcy | Plan Amount in Company Code Currency | |
| PlanAmountInGlobalCurrency | P_ActualPlanJrnlEntryItm | PlanAmountInGlobalCurrency | Plan Amount in Global Currency | |
| PlanAmountInFreeDefinedCrcy1 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy1 | Plan Amount in Freely Defined Currency 1 | |
| PlanAmountInFreeDefinedCrcy2 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy2 | Plan Amount in Freely Defined Currency 2 | |
| PlanAmountInFreeDefinedCrcy3 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy3 | Plan Amount in Freely Defined Currency 3 | |
| PlanAmountInFreeDefinedCrcy4 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy4 | Plan Amount in Freely Defined Currency 4 | |
| PlanAmountInFreeDefinedCrcy5 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy5 | Plan Amount in Freely Defined Currency 5 | |
| PlanAmountInFreeDefinedCrcy6 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy6 | Plan Amount in Freely Defined Currency 6 | |
| PlanAmountInFreeDefinedCrcy7 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy7 | Plan Amount in Freely Defined Currency 7 | |
| PlanAmountInFreeDefinedCrcy8 | P_ActualPlanJrnlEntryItm | PlanAmountInFreeDefinedCrcy8 | Plan Amount in Freely Defined Currency 8 | |
| PlanAmountInObjectCurrency | P_ActualPlanJrnlEntryItm | PlanAmountInObjectCurrency | Plan Amount in Object Currency | |
| PlanValuationQuantity | P_ActualPlanJrnlEntryItm | PlanValuationQuantity | Plan Valuation Quantity | |
| PlanReferenceQuantity | P_ActualPlanJrnlEntryItm | PlanReferenceQuantity | Plan Reference Quantity | |
| PlanPriceInGlobalCurrency | P_ActualPlanJrnlEntryItm | PlanPriceInGlobalCurrency | Price in Global Currency | |
| PlanPriceInCompanyCodeCurrency | P_ActualPlanJrnlEntryItm | PlanPriceInCompanyCodeCurrency | Price in Company Code Currency | |
| PlanPriceInTransactionCurrency | P_ActualPlanJrnlEntryItm | PlanPriceInTransactionCurrency | Price in Transaction Currency | |
| ActlPlnDiffAmtInTransCrcy | Actual plan difference in transaction currency | |||
| ActlPlnDiffAmtInCoCodeCrcy | Actual plan difference in company code currency | |||
| ActlPlnDiffAmtInGlobalCrcy | Actual plan difference in global currency | |||
| ActlPlnDiffAmtInFreeDfndCrcy1 | Actual plan difference in freely defined currency 1 | |||
| ActlPlnDiffAmtInFreeDfndCrcy2 | Actual plan difference in freely defined currency 2 | |||
| ActlPlnDiffAmtInFreeDfndCrcy3 | Actual plan difference in freely defined currency 3 | |||
| ActlPlnDiffAmtInFreeDfndCrcy4 | Actual plan difference in freely defined currency 4 | |||
| ActlPlnDiffAmtInFreeDfndCrcy5 | Actual plan difference in freely defined currency 5 | |||
| ActlPlnDiffAmtInFreeDfndCrcy6 | Actual plan difference in freely defined currency 6 | |||
| ActlPlnDiffAmtInFreeDfndCrcy7 | Actual plan difference in freely defined currency 7 | |||
| ActlPlnDiffAmtInFreeDfndCrcy8 | Actual plan difference in freely defined currency 8 | |||
| ActlPlnDiffAmtInObjectCrcy | Actual plan difference in object currency | |||
| ActlPanDiffValuationQuantity | Actual Plan Difference Valuation Quantity | |||
| ActlPlanDiffReferenceQuantity | Actual Plan Difference Reference Quantity | |||
| _SourceLedger | _SourceLedger | |||
| _JournalEntry | _JournalEntry | |||
| _ControllingArea | _ControllingArea | |||
| _Ledger | _Ledger | |||
| _CompanyCode | _CompanyCode | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _LedgerFiscalYear | _LedgerFiscalYear | |||
| _LedgerFiscalYearForVariant | _LedgerFiscalYearForVariant | |||
| _FiscalYear | _FiscalYear | |||
| _FiscalPeriod | _FiscalPeriod | |||
| _FiscalPeriodForVariant | _FiscalPeriodForVariant | |||
| _FiscalYearPeriod | _FiscalYearPeriod | |||
| _FiscalYearPeriodForVariant | _FiscalYearPeriodForVariant | |||
| _CalendarDate | _CalendarDate | |||
| _FiscalCalendarDate | _FiscalCalendarDate | |||
| _BusinessArea | _BusinessArea | |||
| _ProfitCenter | _ProfitCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _CostCenter | _CostCenter | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _AccountAssignmentType | _AccountAssignmentType | |||
| _Project | _Project | |||
| _ProjectBasicData | P_ActualPlanJrnlEntryItm | _ProjectBasicData | ||
| _ProjectExternalID | _ProjectExternalID | |||
| _ProjectExternalIDText | _ProjectExternalIDText | |||
| _PartnerProjectBasicData | P_ActualPlanJrnlEntryItm | _PartnerProjectBasicData | ||
| _PartnerProjectExternalID | _PartnerProjectExternalID | |||
| _PartnerProjctExtrnalIDText | _PartnerProjctExtrnalIDText | |||
| _WBSElement | _WBSElement | |||
| _WBSElementBasicData | P_ActualPlanJrnlEntryItm | _WBSElementBasicData | ||
| _WBSElementExternalID | _WBSElementExternalID | |||
| _PartnerWBSElementBasicData | P_ActualPlanJrnlEntryItm | _PartnerWBSElementBasicData | ||
| _PartnerWBSElementExternalID | _PartnerWBSElementExternalID | |||
| _PartnerWBSElemntExtrnalIDText | _PartnerWBSElemntExtrnalIDText | |||
| _FunctionalArea | _FunctionalArea | |||
| _Segment | _Segment | |||
| _CostCtrActivityType | _CostCtrActivityType | |||
| _CostAnalysisResource | _CostAnalysisResource | |||
| _InternalOrder | _InternalOrder | |||
| _Order | _Order | |||
| _WorkPackageWorkItem | _WorkPackageWorkItem | |||
| _WorkPackage | _WorkPackage | |||
| _PartnerCompanyCode | _PartnerCompanyCode | |||
| _PartnerBusinessArea | _PartnerBusinessArea | |||
| _PartnerProfitCenter | _PartnerProfitCenter | |||
| _PartnerCostCenter | _PartnerCostCenter | |||
| _PartnerProject | _PartnerProject | |||
| _PartnerWBSElement | _PartnerWBSElement | |||
| _PartnerFunctionalArea | _PartnerFunctionalArea | |||
| _PartnerSegment | _PartnerSegment | |||
| _PartnerCostCtrActivityType | _PartnerCostCtrActivityType | |||
| _PartnerOrder | _PartnerOrder | |||
| _PartnerOrder_2 | _PartnerOrder_2 | |||
| _PartnerOrderCategory | _PartnerOrderCategory | |||
| _PartnerCompany | _PartnerCompany | |||
| _OriginProfitCenter | _OriginProfitCenter | |||
| _OriginCostCenter | _OriginCostCenter | |||
| _OriginCostCtrActivityType | _OriginCostCtrActivityType | |||
| _FiscalYearVariant | _FiscalYearVariant | |||
| _ControllingDebitCreditCode | _ControllingDebitCreditCode | |||
| _Employment | _Employment | |||
| _PersonWorkAgreement_1 | _PersonWorkAgreement_1 | |||
| _BusinessTransactionCategory | _BusinessTransactionCategory | |||
| _BusinessTransactionType | _BusinessTransactionType | |||
| _FinancialTransactionType | P_ActualPlanJrnlEntryItm | _FinancialTransactionType | ||
| _AccountingDocumentType | _AccountingDocumentType | |||
| _FinancialAccountType | _FinancialAccountType | |||
| _DebitCreditCode | _DebitCreditCode | |||
| _Plant | _Plant | |||
| _Material | _Material | |||
| _Product | _Product | |||
| _Customer | _Customer | |||
| _CustomerCompany | _CustomerCompany | |||
| _Supplier | _Supplier | |||
| _SupplierCompany | _SupplierCompany | |||
| _SalesOrder | _SalesOrder | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _SalesDocument | _SalesDocument | |||
| _SalesDocumentItem | _SalesDocumentItem | |||
| _ServiceDocumentType | _ServiceDocumentType | |||
| _ServiceDocument | _ServiceDocument | |||
| _ServiceDocumentItem | _ServiceDocumentItem | |||
| _ServiceContract | _ServiceContract | |||
| _ServiceContractItem | _ServiceContractItem | |||
| _ServiceContractType | _ServiceContractType | |||
| _BillingDocumentType | _BillingDocumentType | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _Division | _Division | |||
| _OrganizationDivision | _OrganizationDivision | |||
| _SoldMaterial | _SoldMaterial | |||
| _SoldProduct | _SoldProduct | |||
| _MaterialGroup | _MaterialGroup | |||
| _ProductGroup | _ProductGroup | |||
| _ProductGroup_2 | _ProductGroup_2 | |||
| _SoldProductGroup | _SoldProductGroup | |||
| _SoldProductGroup_2 | _SoldProductGroup_2 | |||
| _CustomerGroup | _CustomerGroup | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _CompanyCodeCurrency | _CompanyCodeCurrency | |||
| _GlobalCurrency | _GlobalCurrency | |||
| _FunctionalCurrency | _FunctionalCurrency | |||
| _FreeDefinedCurrency1 | _FreeDefinedCurrency1 | |||
| _FreeDefinedCurrency2 | _FreeDefinedCurrency2 | |||
| _FreeDefinedCurrency3 | _FreeDefinedCurrency3 | |||
| _FreeDefinedCurrency4 | _FreeDefinedCurrency4 | |||
| _FreeDefinedCurrency5 | _FreeDefinedCurrency5 | |||
| _FreeDefinedCurrency6 | _FreeDefinedCurrency6 | |||
| _FreeDefinedCurrency7 | _FreeDefinedCurrency7 | |||
| _FreeDefinedCurrency8 | _FreeDefinedCurrency8 | |||
| _ControllingObjectCurrency | _ControllingObjectCurrency | |||
| _BaseUnit | _BaseUnit | |||
| _CostSourceUnit | _CostSourceUnit | |||
| _ReferenceQuantityUnit | _ReferenceQuantityUnit | |||
| _CustomerSupplierCountry | _CustomerSupplierCountry | |||
| _CustomerSupplierIndustryText | _CustomerSupplierIndustryText | |||
| _SalesDistrict | _SalesDistrict | |||
| _BillToParty | _BillToParty | |||
| _ShipToParty | _ShipToParty | |||
| _WorkCenter | _WorkCenter | |||
| _PlanningCategory | _PlanningCategory | |||
| _BillableControl | _BillableControl | |||
| _SemTagGLAccount | _SemTagGLAccount | |||
| _FinancialManagementArea | P_ActualPlanJrnlEntryItm | _FinancialManagementArea | ||
| _Fund | P_ActualPlanJrnlEntryItm | _Fund | ||
| _Grant | P_ActualPlanJrnlEntryItm | _Grant | ||
| _BudgetPeriod | P_ActualPlanJrnlEntryItm | _BudgetPeriod | ||
| _CashLedgerCompanyCode | _CashLedgerCompanyCode | |||
| _CashLedgerAccount | _CashLedgerAccount | |||
| _FundsCenter | _FundsCenter | |||
| _FundedProgram | _FundedProgram | |||
| _PartnerFund | _PartnerFund | |||
| _PartnerGrant | _PartnerGrant | |||
| _PartnerBudgetPeriod | _PartnerBudgetPeriod | |||
| _PubSecBudgetAccountCoCode | _PubSecBudgetAccountCoCode | |||
| _PubSecBudgetAccount | _PubSecBudgetAccount | |||
| _PubSecBudgetCnsmpnDate | _PubSecBudgetCnsmpnDate | |||
| _PubSecBudgetCnsmpnFsclPeriod | _PubSecBudgetCnsmpnFsclPeriod | |||
| _PubSecBudgetCnsmpnFsclYear | _PubSecBudgetCnsmpnFsclYear | |||
| _PubSecBudgetCnsmpnType | _PubSecBudgetCnsmpnType | |||
| _PubSecBudgetCnsmpnAmtType | _PubSecBudgetCnsmpnAmtType | |||
| _SponsoredProgram | _SponsoredProgram | |||
| _SponsoredClass | _SponsoredClass | |||
| _BudgetProcess | _BudgetProcess | |||
| _BudgetingType | _BudgetingType | |||
| _MasterFixedAsset | _MasterFixedAsset | |||
| _FixedAsset | _FixedAsset | |||
| _SubLedgerAccLineItemType | _SubLedgerAccLineItemType | |||
| _Equipment | P_ActualPlanJrnlEntryItm | _Equipment | ||
| _FunctionalLocation | P_ActualPlanJrnlEntryItm | _FunctionalLocation | ||
| _MaintenanceActivityType | P_ActualPlanJrnlEntryItm | _MaintenanceActivityType | ||
| _MaintOrdPlngDegreeCode | _MaintOrdPlngDegreeCode | |||
| _PMNotificationPriorityType | _PMNotificationPriorityType | |||
| _PMNotificationPriority | _PMNotificationPriority | |||
| _MaintenanceOrder | _MaintenanceOrder | |||
| _MaintenanceOrderOperation | _MaintenanceOrderOperation | |||
| _MaintenanceOrderSubOperation | _MaintenanceOrderSubOperation | |||
| _Assembly | P_ActualPlanJrnlEntryItm | _Assembly | ||
| _SuperiorOrder | _SuperiorOrder | |||
| GLAccountAuthorizationGroup | P_ActualPlanJrnlEntryItm | GLAccountAuthorizationGroup | Authorization Group | |
| SupplierBasicAuthorizationGrp | P_ActualPlanJrnlEntryItm | SupplierBasicAuthorizationGrp | Authorization Group | |
| CustomerBasicAuthorizationGrp | P_ActualPlanJrnlEntryItm | CustomerBasicAuthorizationGrp | Authorization Group | |
| AcctgDocTypeAuthorizationGroup | P_ActualPlanJrnlEntryItm | AcctgDocTypeAuthorizationGroup | Authorization Group | |
| OrderType | P_ActualPlanJrnlEntryItm | OrderType | Order Type | |
| SalesOrderType | P_ActualPlanJrnlEntryItm | SalesOrderType | Sales Document Type |
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_ActualPlanJournalEntryItem.
-- 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_ActualPlanJournalEntryItem AS
SELECT
ActualPlanJournalEntryItem.SourceLedger AS SourceLedger,
ActualPlanJournalEntryItem.Ledger AS Ledger,
ActualPlanJournalEntryItem.CompanyCode AS CompanyCode,
ActualPlanJournalEntryItem.FiscalYear AS FiscalYear,
ActualPlanJournalEntryItem.AccountingDocument AS AccountingDocument,
ActualPlanJournalEntryItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
ActualPlanJournalEntryItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
ActualPlanJournalEntryItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
ActualPlanJournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
ActualPlanJournalEntryItem.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
ActualPlanJournalEntryItem.LedgerFiscalYear AS LedgerFiscalYear,
ActualPlanJournalEntryItem.ControllingArea AS ControllingArea,
ActualPlanJournalEntryItem.GLAccount AS GLAccount,
ActualPlanJournalEntryItem.ChartOfAccounts AS ChartOfAccounts,
ActualPlanJournalEntryItem.ActualPlanCode AS ActualPlanCode,
ActualPlanJournalEntryItem.BusinessArea AS BusinessArea,
ActualPlanJournalEntryItem.ProfitCenter AS ProfitCenter,
ActualPlanJournalEntryItem.CostCenter AS CostCenter,
ActualPlanJournalEntryItem.Project AS Project,
ActualPlanJournalEntryItem.ProjectInternalID AS ProjectInternalID,
cast( ActualPlanJournalEntryItem._ProjectBasicData.ProjectExternalID as fis_projectext_no_conv ) AS ProjectExternalID,
ActualPlanJournalEntryItem.PartnerProjectInternalID AS PartnerProjectInternalID,
cast( ActualPlanJournalEntryItem._PartnerProjectBasicData.ProjectExternalID as fis_part_projectext_no_conv ) AS PartnerProjectExternalID,
ActualPlanJournalEntryItem.WBSElement AS WBSElement,
ActualPlanJournalEntryItem.WBSElementInternalID AS WBSElementInternalID,
cast( ActualPlanJournalEntryItem._WBSElementBasicData.WBSElementExternalID as fis_wbsext_no_conv ) AS WBSElementExternalID,
ActualPlanJournalEntryItem.PartnerWBSElementInternalID AS PartnerWBSElementInternalID,
cast( ActualPlanJournalEntryItem._PartnerWBSElementBasicData.WBSElementExternalID as fis_partner_wbsext_no_conv ) AS PartnerWBSElementExternalID,
ActualPlanJournalEntryItem.FunctionalArea AS FunctionalArea,
ActualPlanJournalEntryItem.Segment AS Segment,
ActualPlanJournalEntryItem.CostCtrActivityType AS CostCtrActivityType,
ActualPlanJournalEntryItem.CostAnalysisResource AS CostAnalysisResource,
ActualPlanJournalEntryItem.OrderID AS OrderID,
ActualPlanJournalEntryItem.OrderCategory AS OrderCategory,
ActualPlanJournalEntryItem.WorkPackage AS WorkPackage,
ActualPlanJournalEntryItem.WorkItem AS WorkItem,
ActualPlanJournalEntryItem.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
ActualPlanJournalEntryItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
ActualPlanJournalEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
ActualPlanJournalEntryItem.PartnerBusinessArea AS PartnerBusinessArea,
ActualPlanJournalEntryItem.PartnerProfitCenter AS PartnerProfitCenter,
ActualPlanJournalEntryItem.PartnerCostCenter AS PartnerCostCenter,
ActualPlanJournalEntryItem.PartnerProject AS PartnerProject,
ActualPlanJournalEntryItem.PartnerWBSElement AS PartnerWBSElement,
ActualPlanJournalEntryItem.PartnerFunctionalArea AS PartnerFunctionalArea,
ActualPlanJournalEntryItem.PartnerSegment AS PartnerSegment,
ActualPlanJournalEntryItem.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
ActualPlanJournalEntryItem.PartnerOrder AS PartnerOrder,
ActualPlanJournalEntryItem.PartnerOrder_2 AS PartnerOrder_2,
ActualPlanJournalEntryItem.PartnerOrderCategory AS PartnerOrderCategory,
ActualPlanJournalEntryItem.PartnerSalesDocument AS PartnerSalesDocument,
ActualPlanJournalEntryItem.PartnerProjectNetwork AS PartnerProjectNetwork,
ActualPlanJournalEntryItem.PartnerProjectNetworkActivity AS PartnerProjectNetworkActivity,
ActualPlanJournalEntryItem.PartnerBusinessProcess AS PartnerBusinessProcess,
ActualPlanJournalEntryItem.PartnerCostObject AS PartnerCostObject,
ActualPlanJournalEntryItem.PartnerCompany AS PartnerCompany,
ActualPlanJournalEntryItem.OriginProfitCenter AS OriginProfitCenter,
ActualPlanJournalEntryItem.OriginCostCenter AS OriginCostCenter,
ActualPlanJournalEntryItem.OriginCostCtrActivityType AS OriginCostCtrActivityType,
ActualPlanJournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
ActualPlanJournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
ActualPlanJournalEntryItem.ReferenceDocument AS ReferenceDocument,
ActualPlanJournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem,
ActualPlanJournalEntryItem.BusinessTransactionCategory AS BusinessTransactionCategory,
ActualPlanJournalEntryItem.BusinessTransactionType AS BusinessTransactionType,
ActualPlanJournalEntryItem.FinancialTransactionType AS FinancialTransactionType,
ActualPlanJournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
ActualPlanJournalEntryItem.FinancialAccountType AS FinancialAccountType,
ActualPlanJournalEntryItem.DebitCreditCode AS DebitCreditCode,
ActualPlanJournalEntryItem.AssignmentReference AS AssignmentReference,
ActualPlanJournalEntryItem.PostingDate AS PostingDate,
ActualPlanJournalEntryItem.DocumentDate AS DocumentDate,
ActualPlanJournalEntryItem.FiscalPeriod AS FiscalPeriod,
ActualPlanJournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
ActualPlanJournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
ActualPlanJournalEntryItem.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
ActualPlanJournalEntryItem.CreationDate AS CreationDate,
ActualPlanJournalEntryItem.PlanningCategory AS PlanningCategory,
ActualPlanJournalEntryItem.ServicesRenderedDate AS ServicesRenderedDate,
ActualPlanJournalEntryItem.ControllingDebitCreditCode AS ControllingDebitCreditCode,
ActualPlanJournalEntryItem.AccountAssignmentType AS AccountAssignmentType,
ActualPlanJournalEntryItem.PersonnelNumber AS PersonnelNumber,
ActualPlanJournalEntryItem.BillableControl AS BillableControl,
ActualPlanJournalEntryItem.ValuationArea AS ValuationArea,
ActualPlanJournalEntryItem.ControllingObject AS ControllingObject,
ActualPlanJournalEntryItem.CostOriginGroup AS CostOriginGroup,
ActualPlanJournalEntryItem.ControllingObjectClass AS ControllingObjectClass,
ActualPlanJournalEntryItem.BusinessSolutionOrder AS BusinessSolutionOrder,
ActualPlanJournalEntryItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
ActualPlanJournalEntryItem.ProviderContract AS ProviderContract,
ActualPlanJournalEntryItem.ProviderContractItem AS ProviderContractItem,
ActualPlanJournalEntryItem.DocumentItemText AS DocumentItemText,
ActualPlanJournalEntryItem.Plant AS Plant,
ActualPlanJournalEntryItem.Material AS Material,
ActualPlanJournalEntryItem.Product AS Product,
ActualPlanJournalEntryItem.Customer AS Customer,
ActualPlanJournalEntryItem.Supplier AS Supplier,
ActualPlanJournalEntryItem.PurchasingDocument AS PurchasingDocument,
ActualPlanJournalEntryItem.PurchasingDocumentItem AS PurchasingDocumentItem,
ActualPlanJournalEntryItem.AccountAssignmentNumber AS AccountAssignmentNumber,
ActualPlanJournalEntryItem.OffsettingAccount AS OffsettingAccount,
ActualPlanJournalEntryItem.OffsettingAccountType AS OffsettingAccountType,
ActualPlanJournalEntryItem.OffsettingChartOfAccounts AS OffsettingChartOfAccounts,
ActualPlanJournalEntryItem.SalesOrder AS SalesOrder,
ActualPlanJournalEntryItem.SalesOrderItem AS SalesOrderItem,
ActualPlanJournalEntryItem.SalesDocument AS SalesDocument,
ActualPlanJournalEntryItem.SalesDocumentItem AS SalesDocumentItem,
ActualPlanJournalEntryItem.ServiceDocumentType AS ServiceDocumentType,
ActualPlanJournalEntryItem.ServiceDocument AS ServiceDocument,
ActualPlanJournalEntryItem.ServiceDocumentItem AS ServiceDocumentItem,
ActualPlanJournalEntryItem.ServiceContractType AS ServiceContractType,
ActualPlanJournalEntryItem.ServiceContract AS ServiceContract,
ActualPlanJournalEntryItem.ServiceContractItem AS ServiceContractItem,
ActualPlanJournalEntryItem.ProjectNetwork AS ProjectNetwork,
ActualPlanJournalEntryItem.BillingDocumentType AS BillingDocumentType,
ActualPlanJournalEntryItem.SalesOrganization AS SalesOrganization,
ActualPlanJournalEntryItem.DistributionChannel AS DistributionChannel,
ActualPlanJournalEntryItem.Division AS Division,
ActualPlanJournalEntryItem.OrganizationDivision AS OrganizationDivision,
ActualPlanJournalEntryItem.SoldMaterial AS SoldMaterial,
ActualPlanJournalEntryItem.SoldProduct AS SoldProduct,
ActualPlanJournalEntryItem.MaterialGroup AS MaterialGroup,
ActualPlanJournalEntryItem.ProductGroup AS ProductGroup,
ActualPlanJournalEntryItem.SoldProductGroup AS SoldProductGroup,
ActualPlanJournalEntryItem.CustomerGroup AS CustomerGroup,
ActualPlanJournalEntryItem.CustomerSupplierCountry AS CustomerSupplierCountry,
ActualPlanJournalEntryItem.CustomerSupplierIndustry AS CustomerSupplierIndustry,
ActualPlanJournalEntryItem.SalesDistrict AS SalesDistrict,
ActualPlanJournalEntryItem.BillToParty AS BillToParty,
ActualPlanJournalEntryItem.ShipToParty AS ShipToParty,
ActualPlanJournalEntryItem.CustomerSupplierCorporateGroup AS CustomerSupplierCorporateGroup,
ActualPlanJournalEntryItem.IsStatisticalOrder AS IsStatisticalOrder,
ActualPlanJournalEntryItem.IsStatisticalCostCenter AS IsStatisticalCostCenter,
ActualPlanJournalEntryItem.IsStatisticalSalesDocument AS IsStatisticalSalesDocument,
ActualPlanJournalEntryItem.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
ActualPlanJournalEntryItem.WorkCenterInternalID AS WorkCenterInternalID,
ActualPlanJournalEntryItem.OrderOperation AS OrderOperation,
ActualPlanJournalEntryItem.OrderItem AS OrderItem,
ActualPlanJournalEntryItem.PartnerOrderItem AS PartnerOrderItem,
ActualPlanJournalEntryItem.OrderSuboperation AS OrderSuboperation,
ActualPlanJournalEntryItem.Equipment AS Equipment,
ActualPlanJournalEntryItem.FunctionalLocation AS FunctionalLocation,
ActualPlanJournalEntryItem.Assembly AS Assembly,
ActualPlanJournalEntryItem.MaintenanceActivityType AS MaintenanceActivityType,
ActualPlanJournalEntryItem.MaintenanceOrderPlanningCode AS MaintenanceOrderPlanningCode,
ActualPlanJournalEntryItem.MaintPriorityType AS MaintPriorityType,
ActualPlanJournalEntryItem.MaintPriority AS MaintPriority,
ActualPlanJournalEntryItem.SuperiorOrder AS SuperiorOrder,
ActualPlanJournalEntryItem.SourceReferenceDocumentType AS SourceReferenceDocumentType,
ActualPlanJournalEntryItem.SourceLogicalSystem AS SourceLogicalSystem,
ActualPlanJournalEntryItem.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
ActualPlanJournalEntryItem.SourceReferenceDocument AS SourceReferenceDocument,
ActualPlanJournalEntryItem.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
ActualPlanJournalEntryItem.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
ActualPlanJournalEntryItem.IsCommitment AS IsCommitment,
ActualPlanJournalEntryItem.CashLedgerCompanyCode AS CashLedgerCompanyCode,
ActualPlanJournalEntryItem.CashLedgerAccount AS CashLedgerAccount,
ActualPlanJournalEntryItem.FinancialManagementArea AS FinancialManagementArea,
ActualPlanJournalEntryItem.FundsCenter AS FundsCenter,
ActualPlanJournalEntryItem.FundedProgram AS FundedProgram,
ActualPlanJournalEntryItem.Fund AS Fund,
ActualPlanJournalEntryItem.GrantID AS GrantID,
ActualPlanJournalEntryItem.BudgetPeriod AS BudgetPeriod,
ActualPlanJournalEntryItem.PartnerFund AS PartnerFund,
ActualPlanJournalEntryItem.PartnerGrant AS PartnerGrant,
ActualPlanJournalEntryItem.PartnerBudgetPeriod AS PartnerBudgetPeriod,
ActualPlanJournalEntryItem.PubSecBudgetAccount AS PubSecBudgetAccount,
ActualPlanJournalEntryItem.PubSecBudgetAccountCoCode AS PubSecBudgetAccountCoCode,
ActualPlanJournalEntryItem.PubSecBudgetCnsmpnDate AS PubSecBudgetCnsmpnDate,
ActualPlanJournalEntryItem.PubSecBudgetCnsmpnFsclPeriod AS PubSecBudgetCnsmpnFsclPeriod,
ActualPlanJournalEntryItem.PubSecBudgetCnsmpnFsclYear AS PubSecBudgetCnsmpnFsclYear,
ActualPlanJournalEntryItem.PubSecBudgetIsRelevant AS PubSecBudgetIsRelevant,
ActualPlanJournalEntryItem.PubSecBudgetCnsmpnType AS PubSecBudgetCnsmpnType,
ActualPlanJournalEntryItem.PubSecBudgetCnsmpnAmtType AS PubSecBudgetCnsmpnAmtType,
ActualPlanJournalEntryItem.SponsoredProgram AS SponsoredProgram,
ActualPlanJournalEntryItem.SponsoredClass AS SponsoredClass,
ActualPlanJournalEntryItem.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
ActualPlanJournalEntryItem.BudgetProcess AS BudgetProcess,
ActualPlanJournalEntryItem.BudgetingType AS BudgetingType,
ActualPlanJournalEntryItem.BudgetDocWorkFlowStatus AS BudgetDocWorkFlowStatus,
ActualPlanJournalEntryItem.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
ActualPlanJournalEntryItem.AssetDepreciationArea AS AssetDepreciationArea,
ActualPlanJournalEntryItem.MasterFixedAsset AS MasterFixedAsset,
ActualPlanJournalEntryItem.FixedAsset AS FixedAsset,
ActualPlanJournalEntryItem.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
ActualPlanJournalEntryItem.AssetClass AS AssetClass,
ActualPlanJournalEntryItem.JointVenture AS JointVenture,
ActualPlanJournalEntryItem.JointVentureEquityGroup AS JointVentureEquityGroup,
ActualPlanJournalEntryItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
ActualPlanJournalEntryItem.JointVentureProductionDate AS JointVentureProductionDate,
ActualPlanJournalEntryItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
ActualPlanJournalEntryItem.AccrualObjectType AS AccrualObjectType,
ActualPlanJournalEntryItem.AccrualObjectLogicalSystem AS AccrualObjectLogicalSystem,
ActualPlanJournalEntryItem.AccrualObject AS AccrualObject,
ActualPlanJournalEntryItem.AccrualSubobject AS AccrualSubobject,
ActualPlanJournalEntryItem.AccrualItemType AS AccrualItemType,
ActualPlanJournalEntryItem.AccrualReferenceObject AS AccrualReferenceObject,
ActualPlanJournalEntryItem.AccrualValueDate AS AccrualValueDate,
ActualPlanJournalEntryItem.Reservation AS Reservation,
ActualPlanJournalEntryItem.ReservationItem AS ReservationItem,
ActualPlanJournalEntryItem.ReservationType AS ReservationType,
ActualPlanJournalEntryItem.MMServicePackage AS MMServicePackage,
ActualPlanJournalEntryItem.MMServicePackageLine AS MMServicePackageLine,
ActualPlanJournalEntryItem.REBusinessEntity AS REBusinessEntity,
ActualPlanJournalEntryItem.RealEstateBuilding AS RealEstateBuilding,
ActualPlanJournalEntryItem.RealEstateProperty AS RealEstateProperty,
ActualPlanJournalEntryItem.RERentalObject AS RERentalObject,
ActualPlanJournalEntryItem.RealEstateContract AS RealEstateContract,
ActualPlanJournalEntryItem.REServiceChargeKey AS REServiceChargeKey,
ActualPlanJournalEntryItem.RESettlementUnitID AS RESettlementUnitID,
ActualPlanJournalEntryItem.SettlementReferenceDate AS SettlementReferenceDate,
ActualPlanJournalEntryItem.TransactionCurrency AS TransactionCurrency,
ActualPlanJournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
ActualPlanJournalEntryItem.GlobalCurrency AS GlobalCurrency,
ActualPlanJournalEntryItem.FunctionalCurrency AS FunctionalCurrency,
ActualPlanJournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
ActualPlanJournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
ActualPlanJournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
ActualPlanJournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
ActualPlanJournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
ActualPlanJournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
ActualPlanJournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
ActualPlanJournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
ActualPlanJournalEntryItem.ControllingObjectCurrency AS ControllingObjectCurrency,
ActualPlanJournalEntryItem.CostSourceUnit AS CostSourceUnit,
ActualPlanJournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
ActualPlanJournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
ActualPlanJournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
ActualPlanJournalEntryItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
ActualPlanJournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
ActualPlanJournalEntryItem.AmountInObjectCurrency AS AmountInObjectCurrency,
ActualPlanJournalEntryItem.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
ActualPlanJournalEntryItem.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
ActualPlanJournalEntryItem.FixedAmountInTransCrcy AS FixedAmountInTransCrcy,
ActualPlanJournalEntryItem.ValuationQuantity AS ValuationQuantity,
ActualPlanJournalEntryItem.ValuationFixedQuantity AS ValuationFixedQuantity,
ActualPlanJournalEntryItem.FixedQuantity AS FixedQuantity,
ActualPlanJournalEntryItem.BaseUnit AS BaseUnit,
ActualPlanJournalEntryItem.Quantity AS Quantity,
ActualPlanJournalEntryItem.ReferenceQuantityUnit AS ReferenceQuantityUnit,
ActualPlanJournalEntryItem.ReferenceQuantity AS ReferenceQuantity,
ActualPlanJournalEntryItem.ActualAmountInTransactionCrcy AS ActualAmountInTransactionCrcy,
ActualPlanJournalEntryItem.ActualAmountInCompanyCodeCrcy AS ActualAmountInCompanyCodeCrcy,
ActualPlanJournalEntryItem.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy1 AS ActualAmountInFreeDfndCrcy1,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy2 AS ActualAmountInFreeDfndCrcy2,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy3 AS ActualAmountInFreeDfndCrcy3,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy4 AS ActualAmountInFreeDfndCrcy4,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy5 AS ActualAmountInFreeDfndCrcy5,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy6 AS ActualAmountInFreeDfndCrcy6,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy7 AS ActualAmountInFreeDfndCrcy7,
ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy8 AS ActualAmountInFreeDfndCrcy8,
ActualPlanJournalEntryItem.ActualAmountInObjectCurrency AS ActualAmountInObjectCurrency,
ActualPlanJournalEntryItem.ActualValuationQuantity AS ActualValuationQuantity,
ActualPlanJournalEntryItem.ActualReferenceQuantity AS ActualReferenceQuantity,
ActualPlanJournalEntryItem.ActualQuantityInBaseUnit AS ActualQuantityInBaseUnit,
ActualPlanJournalEntryItem.PlanAmountInTransactionCrcy AS PlanAmountInTransactionCrcy,
ActualPlanJournalEntryItem.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
ActualPlanJournalEntryItem.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy1 AS PlanAmountInFreeDefinedCrcy1,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy2 AS PlanAmountInFreeDefinedCrcy2,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy3 AS PlanAmountInFreeDefinedCrcy3,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy4 AS PlanAmountInFreeDefinedCrcy4,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy5 AS PlanAmountInFreeDefinedCrcy5,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy6 AS PlanAmountInFreeDefinedCrcy6,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy7 AS PlanAmountInFreeDefinedCrcy7,
ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy8 AS PlanAmountInFreeDefinedCrcy8,
ActualPlanJournalEntryItem.PlanAmountInObjectCurrency AS PlanAmountInObjectCurrency,
ActualPlanJournalEntryItem.PlanValuationQuantity AS PlanValuationQuantity,
ActualPlanJournalEntryItem.PlanReferenceQuantity AS PlanReferenceQuantity,
ActualPlanJournalEntryItem.PlanPriceInGlobalCurrency AS PlanPriceInGlobalCurrency,
ActualPlanJournalEntryItem.PlanPriceInCompanyCodeCurrency AS PlanPriceInCompanyCodeCurrency,
ActualPlanJournalEntryItem.PlanPriceInTransactionCurrency AS PlanPriceInTransactionCurrency,
cast(ActualPlanJournalEntryItem.ActualAmountInTransactionCrcy - ActualPlanJournalEntryItem.PlanAmountInTransactionCrcy as fis_actl_pln_diff_wsl) AS ActlPlnDiffAmtInTransCrcy,
cast(ActualPlanJournalEntryItem.ActualAmountInCompanyCodeCrcy - ActualPlanJournalEntryItem.PlanAmountInCompanyCodeCrcy as fis_actl_pln_diff_hsl) AS ActlPlnDiffAmtInCoCodeCrcy,
cast(ActualPlanJournalEntryItem.ActualAmountInGlobalCurrency - ActualPlanJournalEntryItem.PlanAmountInGlobalCurrency as fis_actl_pln_diff_ksl) AS ActlPlnDiffAmtInGlobalCrcy,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy1 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy1 as fis_actl_pln_diff_osl) AS ActlPlnDiffAmtInFreeDfndCrcy1,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy2 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy2 as fis_actl_pln_diff_vsl) AS ActlPlnDiffAmtInFreeDfndCrcy2,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy3 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy3 as fis_actl_pln_diff_bsl) AS ActlPlnDiffAmtInFreeDfndCrcy3,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy4 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy4 as fis_actl_pln_diff_csl) AS ActlPlnDiffAmtInFreeDfndCrcy4,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy5 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy5 as fis_actl_pln_diff_dsl) AS ActlPlnDiffAmtInFreeDfndCrcy5,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy6 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy6 as fis_actl_pln_diff_esl) AS ActlPlnDiffAmtInFreeDfndCrcy6,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy7 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy7 as fis_actl_pln_diff_fsl) AS ActlPlnDiffAmtInFreeDfndCrcy7,
cast(ActualPlanJournalEntryItem.ActualAmountInFreeDfndCrcy8 - ActualPlanJournalEntryItem.PlanAmountInFreeDefinedCrcy8 as fis_actl_pln_diff_gsl) AS ActlPlnDiffAmtInFreeDfndCrcy8,
cast(ActualPlanJournalEntryItem.ActualAmountInObjectCurrency - ActualPlanJournalEntryItem.PlanAmountInObjectCurrency as fis_actl_pln_diff_co_osl) AS ActlPlnDiffAmtInObjectCrcy,
cast(ActualPlanJournalEntryItem.ActualValuationQuantity - ActualPlanJournalEntryItem.PlanValuationQuantity as fis_val_quan_actl_plan_diff) AS ActlPanDiffValuationQuantity,
cast(ActualPlanJournalEntryItem.ActualValuationQuantity - ActualPlanJournalEntryItem.PlanValuationQuantity as fis_ref_quan_actl_plan_diff) AS ActlPlanDiffReferenceQuantity,
ActualPlanJournalEntryItem._ProjectBasicData AS _ProjectBasicData,
ActualPlanJournalEntryItem._PartnerProjectBasicData AS _PartnerProjectBasicData,
ActualPlanJournalEntryItem._WBSElementBasicData AS _WBSElementBasicData,
ActualPlanJournalEntryItem._PartnerWBSElementBasicData AS _PartnerWBSElementBasicData,
ActualPlanJournalEntryItem._FinancialTransactionType AS _FinancialTransactionType,
ActualPlanJournalEntryItem._FinancialManagementArea AS _FinancialManagementArea,
ActualPlanJournalEntryItem._Fund AS _Fund,
ActualPlanJournalEntryItem._Grant AS _Grant,
ActualPlanJournalEntryItem._BudgetPeriod AS _BudgetPeriod,
ActualPlanJournalEntryItem._Equipment AS _Equipment,
ActualPlanJournalEntryItem._FunctionalLocation AS _FunctionalLocation,
ActualPlanJournalEntryItem._MaintenanceActivityType AS _MaintenanceActivityType,
ActualPlanJournalEntryItem._Assembly AS _Assembly,
ActualPlanJournalEntryItem.GLAccountAuthorizationGroup AS GLAccountAuthorizationGroup,
ActualPlanJournalEntryItem.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
ActualPlanJournalEntryItem.CustomerBasicAuthorizationGrp AS CustomerBasicAuthorizationGrp,
ActualPlanJournalEntryItem.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
ActualPlanJournalEntryItem.OrderType AS OrderType,
ActualPlanJournalEntryItem.SalesOrderType AS SalesOrderType
FROM P_ActualPlanJrnlEntryItm AS ActualPlanJournalEntryItem
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriodForVariant ON LedgerFiscalYear = _FiscalPeriodForVariant.FiscalYear AND FiscalPeriod = _FiscalPeriodForVariant.FiscalPeriod AND FiscalYearVariant = _FiscalPeriodForVariant.FiscalYearVariant -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant ON FiscalYearPeriod = _FiscalYearPeriodForVariant.FiscalYearPeriod AND FiscalYearVariant = _FiscalYearPeriodForVariant.FiscalYearVariant association[0..1] to I_CalendarDate as _CalendarDate on PostingDate = _CalendarDate.CalendarDate association[0..1] to I_FiscalCalendarDate as _FiscalCalendarDate on PostingDate = _FiscalCalendarDate.CalendarDate AND FiscalYearVariant = _FiscalCalendarDate.FiscalYearVariant association[0..1] to I_BusinessArea as _BusinessArea on BusinessArea = _BusinessArea.BusinessArea association[0..*] to I_ProfitCenter as _ProfitCenter on ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter association[0..1] to I_ProfitCenter as _CurrentProfitCenter on ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date association[0..*] to I_CostCenter as _CostCenter on ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter association[0..1] to I_CostCenter as _CurrentCostCenter on ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date association[0..1] to I_Project as _Project on Project = _Project.Project -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjctExtrnalIDText ON PartnerProjectExternalID = _PartnerProjctExtrnalIDText.ProjectExternalID association[0..1] to I_WBSElement as _WBSElement on WBSElement = _WBSElement.WBSElement association[0..1] to I_WBSElementByExternalID as _WBSElementExternalID on WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID association[0..1] to I_WBSElementByExternalID as _PartnerWBSElementExternalID on PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID association[0..1] to I_WBSElementByExternalID as _PartnerWBSElemntExtrnalIDText on PartnerWBSElementExternalID = _PartnerWBSElemntExtrnalIDText.WBSElementExternalID association[0..1] to I_FunctionalArea as _FunctionalArea on FunctionalArea = _FunctionalArea.FunctionalArea association[0..1] to I_Segment as _Segment on Segment = _Segment.Segment association[0..*] to I_CostCenterActivityType as _CostCtrActivityType on ControllingArea = _CostCtrActivityType.ControllingArea AND CostCtrActivityType = _CostCtrActivityType.CostCtrActivityType association[0..*] to I_CostAnalysisResource as _CostAnalysisResource on ControllingArea = _CostAnalysisResource.ControllingArea AND CostAnalysisResource = _CostAnalysisResource.CostAnalysisResource association[0..1] to I_InternalOrder as _InternalOrder on OrderID = _InternalOrder.InternalOrder association[0..1] to I_Order as _Order on OrderID = _Order.OrderID association[0..1] to I_WorkPackageWorkItem as _WorkPackageWorkItem on WorkItem = _WorkPackageWorkItem.WorkItem AND WorkPackage = _WorkPackageWorkItem.WorkPackage association[0..1] to I_WorkPackage as _WorkPackage on WorkPackage = _WorkPackage.WorkPackage association[0..1] to I_CompanyCode as _PartnerCompanyCode on PartnerCompanyCode = _PartnerCompanyCode.CompanyCode association[0..1] to I_BusinessArea as _PartnerBusinessArea on PartnerBusinessArea = _PartnerBusinessArea.BusinessArea association[0..*] to I_ProfitCenter as _PartnerProfitCenter on ControllingArea = _PartnerProfitCenter.ControllingArea AND PartnerProfitCenter = _PartnerProfitCenter.ProfitCenter association[0..*] to I_CostCenter as _PartnerCostCenter on ControllingArea = _PartnerCostCenter.ControllingArea AND PartnerCostCenter = _PartnerCostCenter.CostCenter association[0..1] to I_Project as _PartnerProject on PartnerProject = _PartnerProject.Project association[0..1] to I_WBSElement as _PartnerWBSElement on PartnerWBSElement = _PartnerWBSElement.WBSElement association[0..1] to I_FunctionalArea as _PartnerFunctionalArea on PartnerFunctionalArea = _PartnerFunctionalArea.FunctionalArea association[0..1] to I_Segment as _PartnerSegment on PartnerSegment = _PartnerSegment.Segment association[0..*] to I_CostCenterActivityType as _PartnerCostCtrActivityType on ControllingArea = _PartnerCostCtrActivityType.ControllingArea AND PartnerCostCtrActivityType = _PartnerCostCtrActivityType.CostCtrActivityType association[0..1] to I_InternalOrder as _PartnerOrder on PartnerOrder = _PartnerOrder.InternalOrder association[0..1] to I_Order as _PartnerOrder_2 on PartnerOrder_2 = _PartnerOrder_2.OrderID association[0..1] to I_OrderCategory as _PartnerOrderCategory on PartnerOrderCategory = _PartnerOrderCategory.OrderCategory association[0..1] to I_Partnercompany as _PartnerCompany on PartnerCompany = _PartnerCompany.PartnerCompany association[1] to I_FiscalYearVariant as _FiscalYearVariant on FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant association[0..1] to I_ControllingDebitCreditCode as _ControllingDebitCreditCode on ControllingDebitCreditCode = _ControllingDebitCreditCode.ControllingDebitCreditCode association[0..1] to I_Employment as _Employment on PersonnelNumber = _Employment.EmploymentInternalID association[0..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement_1 on PersonnelNumber = _PersonWorkAgreement_1.PersonWorkAgreement association[0..1] to I_BusinessTransactionCategory as _BusinessTransactionCategory on BusinessTransactionCategory = _BusinessTransactionCategory.BusinessTransactionCategory association[0..1] to I_BusinessTransactionType as _BusinessTransactionType on BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType association[0..1] to I_AccountingDocumentType as _AccountingDocumentType on AccountingDocumentType = _AccountingDocumentType.AccountingDocumentType association[0..1] to I_FinancialAccountType as _FinancialAccountType on FinancialAccountType = _FinancialAccountType.FinancialAccountType association[0..1] to I_DebitCreditCode as _DebitCreditCode on DebitCreditCode = _DebitCreditCode.DebitCreditCode association[0..1] to I_Plant as _Plant on Plant = _Plant.Plant association[0..1] to I_Material as _Material on Material = _Material.Material association[0..1] to I_Product as _Product on Product = _Product.Product association[0..1] to I_Customer as _Customer on Customer = _Customer.Customer association[0..1] to I_CustomerCompany as _CustomerCompany on Customer = _CustomerCompany.Customer AND CompanyCode = _CustomerCompany.CompanyCode association[0..1] to I_SalesOrder as _SalesOrder on SalesOrder = _SalesOrder.SalesOrder association[0..1] to I_SalesOrderItem as _SalesOrderItem on SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem association[0..1] to I_SalesDocument as _SalesDocument on SalesDocument = _SalesDocument.SalesDocument association[0..1] to I_SalesDocumentItem as _SalesDocumentItem on SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceDocumentItem ON ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceContractType ON ServiceContractType = _ServiceContractType.ServiceDocumentType -- association [0..1]
LEFT OUTER JOIN I_SrvcDocByDocumentType AS _ServiceContract ON ServiceContractType = _ServiceContract.ServiceDocumentType AND ServiceContract = _ServiceContract.ServiceDocument -- association [0..1]
LEFT OUTER JOIN I_SrvcDocItemByDocumentType AS _ServiceContractItem ON ServiceContractType = _ServiceContractItem.ServiceDocumentType AND ServiceContract = _ServiceContractItem.ServiceDocument AND ServiceContractItem = _ServiceContractItem.ServiceDocumentItem association[0..1] to I_BillingDocumentType as _BillingDocumentType on BillingDocumentType = _BillingDocumentType.BillingDocumentType association[0..1] to I_SalesOrganization as _SalesOrganization on SalesOrganization = _SalesOrganization.SalesOrganization association[0..1] to I_DistributionChannel as _DistributionChannel on DistributionChannel = _DistributionChannel.DistributionChannel association[0..1] to I_Division as _Division on Division = _Division.Division association[0..1] to I_Division as _OrganizationDivision on OrganizationDivision = _OrganizationDivision.Division association[0..1] to I_Material as _SoldMaterial on SoldMaterial = _SoldMaterial.Material association[0..1] to I_Product as _SoldProduct on SoldProduct = _SoldProduct.Product association[0..1] to I_MaterialGroup as _MaterialGroup on MaterialGroup = _MaterialGroup.MaterialGroup association[0..1] to I_ProductGroup as _ProductGroup on ProductGroup = _ProductGroup.MaterialGroup association[0..1] to I_ProductGroup_2 as _ProductGroup_2 on ProductGroup = _ProductGroup_2.ProductGroup association[0..1] to I_ProductGroup as _SoldProductGroup on SoldProductGroup = _SoldProductGroup.MaterialGroup association[0..1] to I_ProductGroup_2 as _SoldProductGroup_2 on SoldProductGroup = _SoldProductGroup_2.ProductGroup association[0..1] to I_CustomerGroup as _CustomerGroup on CustomerGroup = _CustomerGroup.CustomerGroup association[0..1] to I_Country as _CustomerSupplierCountry on CustomerSupplierCountry = _CustomerSupplierCountry.Country association[0..*] to I_SupplierIndustryText as _CustomerSupplierIndustryText on CustomerSupplierIndustry = _CustomerSupplierIndustryText.SupplierIndustry association[0..1] to I_SalesDistrict as _SalesDistrict on SalesDistrict = _SalesDistrict.SalesDistrict association[0..1] to I_Customer as _BillToParty on BillToParty = _BillToParty.Customer association[0..1] to I_Customer as _ShipToParty on ShipToParty = _ShipToParty.Customer association[0..1] to I_Currency as _TransactionCurrency on TransactionCurrency = _TransactionCurrency.Currency association[1] to I_Currency as _CompanyCodeCurrency on CompanyCodeCurrency = _CompanyCodeCurrency.Currency association[0..1] to I_Currency as _GlobalCurrency on GlobalCurrency = _GlobalCurrency.Currency association[0..1] to I_Currency as _FunctionalCurrency on FunctionalCurrency = _FunctionalCurrency.Currency association[0..1] to I_Currency as _FreeDefinedCurrency1 on FreeDefinedCurrency1 = _FreeDefinedCurrency1.Currency association[0..1] to I_Currency as _FreeDefinedCurrency2 on FreeDefinedCurrency2 = _FreeDefinedCurrency2.Currency association[0..1] to I_Currency as _FreeDefinedCurrency3 on FreeDefinedCurrency3 = _FreeDefinedCurrency3.Currency association[0..1] to I_Currency as _FreeDefinedCurrency4 on FreeDefinedCurrency4 = _FreeDefinedCurrency4.Currency association[0..1] to I_Currency as _FreeDefinedCurrency5 on FreeDefinedCurrency5 = _FreeDefinedCurrency5.Currency association[0..1] to I_Currency as _FreeDefinedCurrency6 on FreeDefinedCurrency6 = _FreeDefinedCurrency6.Currency association[0..1] to I_Currency as _FreeDefinedCurrency7 on FreeDefinedCurrency7 = _FreeDefinedCurrency7.Currency association[0..1] to I_Currency as _FreeDefinedCurrency8 on FreeDefinedCurrency8 = _FreeDefinedCurrency8.Currency association[0..1] to I_Currency as _ControllingObjectCurrency on ControllingObjectCurrency = _ControllingObjectCurrency.Currency association[0..1] to I_UnitOfMeasure as _BaseUnit on BaseUnit = _BaseUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _CostSourceUnit on CostSourceUnit = _CostSourceUnit.UnitOfMeasure association[0..1] to I_UnitOfMeasure as _ReferenceQuantityUnit on ReferenceQuantityUnit = _ReferenceQuantityUnit.UnitOfMeasure association[0..1] to I_PlanningCategory as _PlanningCategory on PlanningCategory = _PlanningCategory.PlanningCategory association[0..*] to I_CostCenter as _OriginCostCenter on ControllingArea = _OriginCostCenter.ControllingArea AND OriginCostCenter = _OriginCostCenter.CostCenter association[0..*] to I_ProfitCenter as _OriginProfitCenter on ControllingArea = _OriginProfitCenter.ControllingArea AND OriginProfitCenter = _OriginProfitCenter.ProfitCenter association[0..*] to I_CostCenterActivityType as _OriginCostCtrActivityType on ControllingArea = _OriginCostCtrActivityType.ControllingArea AND OriginCostCtrActivityType = _OriginCostCtrActivityType.CostCtrActivityType association[0..1] to I_WorkCenter as _WorkCenter on WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A' -- association [0..1]
LEFT OUTER JOIN I_BillableControl AS _BillableControl ON BillableControl = _BillableControl.BillableControl -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _SupplierCompany ON Supplier = _SupplierCompany.Supplier AND CompanyCode = _SupplierCompany.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_SemTagGLAccount AS _SemTagGLAccount ON GLAccount = _SemTagGLAccount.GLAccount AND ChartOfAccounts = _SemTagGLAccount.ChartOfAccounts -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CashLedgerCompanyCode ON CashLedgerCompanyCode = _CashLedgerCompanyCode.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _CashLedgerAccount ON CashLedgerCompanyCode = _CashLedgerAccount.CompanyCode AND CashLedgerAccount = _CashLedgerAccount.GLAccount -- 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 _PartnerFund ON FinancialManagementArea = _PartnerFund.FinancialManagementArea AND PartnerFund = _PartnerFund.Fund -- association [0..1]
LEFT OUTER JOIN I_Grant AS _PartnerGrant ON PartnerGrant = _PartnerGrant.GrantID -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _PartnerBudgetPeriod ON PartnerBudgetPeriod = _PartnerBudgetPeriod.BudgetPeriod -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _PubSecBudgetAccountCoCode ON PubSecBudgetAccountCoCode = _PubSecBudgetAccountCoCode.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_PubSecBudgetAccount AS _PubSecBudgetAccount ON PubSecBudgetAccountCoCode = _PubSecBudgetAccount.PubSecBudgetAccountCoCode AND PubSecBudgetAccount = _PubSecBudgetAccount.PubSecBudgetAccount -- association [0..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _PubSecBudgetCnsmpnDate ON PubSecBudgetCnsmpnDate = _PubSecBudgetCnsmpnDate.CalendarDate AND PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnDate.CompanyCode -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _PubSecBudgetCnsmpnFsclPeriod ON PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclPeriod.CompanyCode AND PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclPeriod.FiscalYear AND PubSecBudgetCnsmpnFsclPeriod = _PubSecBudgetCnsmpnFsclPeriod.FiscalPeriod -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _PubSecBudgetCnsmpnFsclYear ON PubSecBudgetAccountCoCode = _PubSecBudgetCnsmpnFsclYear.CompanyCode AND PubSecBudgetCnsmpnFsclYear = _PubSecBudgetCnsmpnFsclYear.FiscalYear -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnType AS _PubSecBudgetCnsmpnType ON PubSecBudgetCnsmpnType = _PubSecBudgetCnsmpnType.PubSecBudgetCnsmpnType -- association [0..1]
LEFT OUTER JOIN I_PubSecBdgtCnsmpnAmtType AS _PubSecBudgetCnsmpnAmtType ON PubSecBudgetCnsmpnAmtType = _PubSecBudgetCnsmpnAmtType.PubSecBudgetCnsmpnAmtType -- association [0..1]
LEFT OUTER JOIN I_SponsoredClassCore AS _SponsoredClass ON SponsoredClass = _SponsoredClass.SponsoredClass -- association [0..1]
LEFT OUTER JOIN I_SponsoredProgramCore AS _SponsoredProgram ON SponsoredProgram = _SponsoredProgram.SponsoredProgram -- association [0..1]
LEFT OUTER JOIN I_BudgetProcess AS _BudgetProcess ON BudgetProcess = _BudgetProcess.BudgetProcess -- association [0..1]
LEFT OUTER JOIN I_BudgetingType AS _BudgetingType ON BudgetingType = _BudgetingType.BudgetingType -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON OrderID = _MaintenanceOrder.MaintenanceOrder -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderOperation AS _MaintenanceOrderOperation ON OrderID = _MaintenanceOrderOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderOperation.MaintenanceOrderOperation -- association [0..1]
LEFT OUTER JOIN I_MaintenanceOrderSubOperation AS _MaintenanceOrderSubOperation ON OrderID = _MaintenanceOrderSubOperation.MaintenanceOrder AND OrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation AND OrderSuboperation = _MaintenanceOrderSubOperation.MaintenanceOrderSubOperation -- association [0..1]
LEFT OUTER JOIN I_MaintOrdPlngDegreeCode AS _MaintOrdPlngDegreeCode ON MaintenanceOrderPlanningCode = _MaintOrdPlngDegreeCode.MaintenanceOrderPlanningCode -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriorityType AS _PMNotificationPriorityType ON MaintPriorityType = _PMNotificationPriorityType.MaintPriorityType -- association [0..1]
LEFT OUTER JOIN I_PMNotificationPriority AS _PMNotificationPriority ON MaintPriority = _PMNotificationPriority.MaintPriority AND MaintPriorityType = _PMNotificationPriority.MaintPriorityType -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _SuperiorOrder ON SuperiorOrder = _SuperiorOrder.OrderID -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentType AS _AccountAssignmentType ON AccountAssignmentType = _AccountAssignmentType.AccountAssignmentType -- 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