I_GLAcctLineItemSemTagGLAcct
G/L Line Item with Semantic Tag
I_GLAcctLineItemSemTagGLAcct (Composite)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.
Accounting and Financial Close
I_GLAcctLineItemSemTagGLAcct is a Composite CDS View (Cube) that provides data about "G/L Line Item with Semantic Tag" in SAP S/4HANA. It reads from 1 data source (P_GLAcctLineItemSemTagGLAcct) and exposes 471 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views.
SAP Help Documentation
| Category | CDS Views for Transaction Data |
|---|---|
| Status | Released |
Purpose
This CDS view provides the prerequisites for answering the following business questions: What are the key figure amounts for a specific company code in a certain fiscal year? What is the ratio of margin to revenue? What is my net cash amount in company code currency?
Structure
Measures and attributes Some important measures and attributes are: Ledger in General Ledger Accounting Source Ledger Company Code Fiscal Year Journal Entry Journal Entry Item Financial Statement Version Semantic Tag of a Hierarchy Node Valid-From Date Valid-To Date
This CDS view provides the prerequisites for answering the following business questions: What are the key figure amounts for a specific company code in a certain fiscal year? What is the ratio of margin to revenue? What is my net cash amount in company code currency?
Structure
Measures and attributes Some important measures and attributes are: Ledger in General Ledger Accounting Source Ledger Company Code Fiscal Year Journal Entry Journal Entry Item Financial Statement Version Semantic Tag of a Hierarchy Node Valid-From Date Valid-To Date
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Accounting and Financial Close |
| Application Component | FI-GL-IS |
| Capabilities | Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities |
| Package | Accounting and Financial Close for SAP S/4HANA Cloud Private Edition |
| Description | <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are the key figure amounts for a specific company code in a certain fiscal year?</p></li> <li><p>What is the ratio of margin to revenue?</p></li> <li><p>What is my net cash amount in company code currency?</p></li> </ul> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_GLAcctLineItemSemTagGLAcct | P_GLAcctLineItemSemTagGLAcct | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | E_JournalEntryItem | _Extension | $projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IFIGLLITSTGLACC | view | |
| EndUserText.label | G/L Line Item with Semantic Tag | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| Analytics.dataCategory | #CUBE | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_CUBE | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Analytics.internalName | #LOCAL | view | |
| AbapCatalog.compiler.compareFilter | true | view |
Fields (471)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Ledger | Ledger | Ledger in General Ledger Accounting | |
| KEY | SourceLedger | SourceLedger | Source Ledger | |
| KEY | CompanyCode | CompanyCode | Receiver Company Code | |
| KEY | FiscalYear | FiscalYear | G/L Fiscal Year | |
| KEY | AccountingDocument | AccountingDocument | Journal Entry | |
| KEY | LedgerGLLineItem | LedgerGLLineItem | General Ledger Journal Entry Line Item | |
| KEY | SemanticTag | SemanticTag | Semantic Tag of a Hierarchy Node | |
| KEY | GLAccountHierarchy | GLAccountHierarchy | Financial Statement Version | |
| KEY | ValidityStartDate | ValidityStartDate | Validity Start Date | |
| KEY | ValidityEndDate | ValidityEndDate | Valid To Date | |
| LedgerFiscalYear | LedgerFiscalYear | Fiscal Year of Ledger | ||
| GLRecordType | GLRecordType | Record Type | ||
| ChartOfAccounts | ChartOfAccounts | Chart of Accounts | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| FinancialTransactionType | FinancialTransactionType | Financial Transaction Type | ||
| BusinessTransactionType | BusinessTransactionType | Business Transaction Type | ||
| ReferenceDocumentType | ReferenceDocumentType | Reference Document Type | ||
| LogicalSystem | LogicalSystem | Logical System | ||
| ReferenceDocumentContext | ReferenceDocumentContext | Reference Document Context | ||
| ReferenceDocument | ReferenceDocument | Reference Doc. Number | ||
| ReferenceDocumentItem | ReferenceDocumentItem | Reference Document Item | ||
| ReferenceDocumentItemGroup | ReferenceDocumentItemGroup | Reference Document Item Group | ||
| IsReversal | IsReversal | Indicator: Item is Reversing Another Item | ||
| IsReversed | IsReversed | Indicator: Item is Reversed | ||
| ReversalReferenceDocumentCntxt | ReversalReferenceDocumentCntxt | Reversal Reference Document Context | ||
| ReversalReferenceDocument | ReversalReferenceDocument | Reversal Reference Document | ||
| IsSettlement | IsSettlement | Indicator: Item is Settling or Transferring Another Item | ||
| IsSettled | IsSettled | Indicator: Line Item is Settled or Transferred | ||
| PredecessorReferenceDocType | PredecessorReferenceDocType | Predecessor Reference Document Type | ||
| PredecessorReferenceDocCntxt | PredecessorReferenceDocCntxt | Predecessor Reference Document Context | ||
| PredecessorReferenceDocument | PredecessorReferenceDocument | Predecessor Reference Document | ||
| PredecessorReferenceDocItem | PredecessorReferenceDocItem | Predecessor Reference Document Item | ||
| SourceReferenceDocumentType | SourceReferenceDocumentType | Source Reference Document Type | ||
| SourceLogicalSystem | SourceLogicalSystem | Source Logical System | ||
| SourceReferenceDocumentCntxt | SourceReferenceDocumentCntxt | Source Reference Document Context | ||
| SourceReferenceDocument | SourceReferenceDocument | Source Reference Document | ||
| SourceReferenceDocumentItem | SourceReferenceDocumentItem | Source Reference Document Item | ||
| SourceReferenceDocSubitem | SourceReferenceDocSubitem | Source Reference Document Subitem | ||
| IsCommitment | IsCommitment | Indicator: Is Commitment | ||
| JrnlEntryItemObsoleteReason | JrnlEntryItemObsoleteReason | Journal Entry Item Obsolete Reason | ||
| GLAccount | GLAccount | General Ledger | ||
| CostCenter | CostCenter | Cost Center | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| BusinessArea | BusinessArea | Business Area | ||
| Segment | Segment | Segment for Segmental Reporting | ||
| PartnerCostCenter | PartnerCostCenter | Partner Cost Center | ||
| PartnerProfitCenter | PartnerProfitCenter | Partner Profit Center | ||
| PartnerFunctionalArea | PartnerFunctionalArea | Partner Functional Area | ||
| PartnerBusinessArea | PartnerBusinessArea | Partner Business Area | ||
| PartnerCompany | PartnerCompany | Company ID of Trading Partner | ||
| PartnerSegment | PartnerSegment | Partner Segment for Segmental Reporting | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Balance Transaction Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| AmountInTransactionCurrency | AmountInTransactionCurrency | Amount in Transaction Currency | ||
| CompanyCodeCurrency | CompanyCodeCurrency | Company Code Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Amount in Company Code Currency | ||
| GlobalCurrency | GlobalCurrency | GM Billing Element: Global Currency | ||
| AmountInGlobalCurrency | AmountInGlobalCurrency | Amount in Global Currency | ||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | Freely Defined Currency 1 | ||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | ||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | Freely Defined Currency 2 | ||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | ||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | Freely Defined Currency 3 | ||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | ||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | Freely Defined Currency 4 | ||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | ||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | Freely Defined Currency 5 | ||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | ||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | Freely Defined Currency 6 | ||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | ||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | Freely Defined Currency 7 | ||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | ||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | Freely Defined Currency 8 | ||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | ||
| FixedAmountInGlobalCrcy | FixedAmountInGlobalCrcy | Fixed Amount in Global Currency | ||
| GrpValnFixedAmtInGlobCrcy | GrpValnFixedAmtInGlobCrcy | Group Valuation Fixed Amount in Global Currency | ||
| PrftCtrValnFxdAmtInGlobCrcy | PrftCtrValnFxdAmtInGlobCrcy | Profit Center Valuation Fixed Amount in Global Currency | ||
| TotalPriceVarcInGlobalCrcy | TotalPriceVarcInGlobalCrcy | Total Price Variance in Global Currency | ||
| GrpValnTotPrcVarcInGlobCrcy | GrpValnTotPrcVarcInGlobCrcy | Group Valuation Total Price Variance in Global Currency | ||
| PrftCtrValnTotPrcVarcInGlbCrcy | PrftCtrValnTotPrcVarcInGlbCrcy | Profit Center Valuation Total Price Variance in Global Cur. | ||
| FixedPriceVarcInGlobalCrcy | FixedPriceVarcInGlobalCrcy | Fixed Price Variance in Global Currency | ||
| GrpValnFixedPrcVarcInGlobCrcy | GrpValnFixedPrcVarcInGlobCrcy | Group Valuation Fixed Price Variance in Global Currency | ||
| PrftCtrValnFxdPrcVarcInGlbCrcy | PrftCtrValnFxdPrcVarcInGlbCrcy | Profit Center Valuation Fixed Price Variance in Global Cur. | ||
| ControllingObjectCurrency | ControllingObjectCurrency | CO Object Currency | ||
| AmountInObjectCurrency | AmountInObjectCurrency | Amount in Object Currency | ||
| BaseUnit | BaseUnit | Base Unit of Measure | ||
| Quantity | Quantity | Quantity | ||
| FixedQuantity | FixedQuantity | Fixed Quantity | ||
| CostSourceUnit | CostSourceUnit | Cost Source Unit | ||
| ValuationQuantity | ValuationQuantity | Valuation Quantity | ||
| ValuationFixedQuantity | ValuationFixedQuantity | Valuation Fixed Quantity | ||
| AdditionalQuantity1Unit | AdditionalQuantity1Unit | Additional Quantity 1 Unit | ||
| AdditionalQuantity1 | AdditionalQuantity1 | Additional Quantity 1 | ||
| AdditionalQuantity2Unit | AdditionalQuantity2Unit | Additional Quantity 2 Unit | ||
| AdditionalQuantity2 | AdditionalQuantity2 | Additional Quantity 2 | ||
| AdditionalQuantity3Unit | AdditionalQuantity3Unit | Additional Quantity 3 Unit | ||
| AdditionalQuantity3 | AdditionalQuantity3 | Additional Quantity 3 | ||
| DebitCreditCode | DebitCreditCode | Single-Character Flag | ||
| FiscalPeriod | FiscalPeriod | Fiscal Period | ||
| FiscalYearPeriod | FiscalYearPeriod | Fiscal Year Period | ||
| PostingDate | PostingDate | Posting Date for GR | ||
| DocumentDate | DocumentDate | Journal Entry Date | ||
| AccountingDocumentType | AccountingDocumentType | Journal Entry Type | ||
| AccountingDocumentItem | AccountingDocumentItem | Journal Entry Posting View Item | ||
| AssignmentReference | AssignmentReference | Assignment Reference | ||
| AccountingDocumentCategory | AccountingDocumentCategory | Journal Entry Category | ||
| PostingKey | PostingKey | Posting Key | ||
| TransactionTypeDetermination | TransactionTypeDetermination | Transaction Key | ||
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | Subledger-Specific Line Item Type | ||
| AccountingDocCreatedByUser | AccountingDocCreatedByUser | User which created overhead document | ||
| LastChangeDateTime | LastChangeDateTime | Last Change Date Time | ||
| CreationDateTime | CreationDateTime | Creation Date Time | ||
| CreationDate | CreationDate | Creation Date | ||
| EliminationProfitCenter | EliminationProfitCenter | Elimination Profit Center | ||
| OriginObjectType | OriginObjectType | Type of Origin Object | ||
| GLAccountType | GLAccountType | Type of a General Ledger Account | ||
| AlternativeGLAccount | AlternativeGLAccount | Alternative G/L Account Number In Company Code | ||
| CountryChartOfAccounts | CountryChartOfAccounts | Alternative Chart of Accounts for Country/Region | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| InvoiceItemReference | InvoiceItemReference | Invoice Item Reference | ||
| ReferencePurchaseOrderCategory | ReferencePurchaseOrderCategory | Category of Reference Purchase Order | ||
| PurchasingDocument | PurchasingDocument | Purchasing Document | ||
| PurchasingDocumentItem | PurchasingDocumentItem | Purchasing Document Item | ||
| AccountAssignmentNumber | AccountAssignmentNumber | Account Assignment Number | ||
| DocumentItemText | DocumentItemText | Item Text | ||
| SalesOrder | SalesOrder | SD Document | ||
| SalesOrderItem | SalesOrderItem | Sales Order Item | ||
| SalesDocument | SalesDocument | Sales Document | ||
| Product | Product | Product Number | ||
| Plant | Plant | Valuation Area | ||
| Supplier | Supplier | Supplier | ||
| Customer | Customer | Customer Number | ||
| ServicesRenderedDate | ServicesRenderedDate | Date on which services are rendered | ||
| ConditionContract | ConditionContract | Condition Contract | ||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| SpecialGLCode | SpecialGLCode | Special G/L Indicator | ||
| TaxCode | TaxCode | Tax on Sales/Purchases Code | ||
| HouseBank | HouseBank | House Bank Key | ||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| IsOpenItemManaged | IsOpenItemManaged | Managed on an Open Item Basis | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingAccountingDocument | ClearingAccountingDocument | Clearing Journal Entry (Deprecated) | ||
| ClearingDocFiscalYear | ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry (Deprecated) | ||
| AssetDepreciationArea | AssetDepreciationArea | Asset Depreciation Area (Real or Derived) | ||
| MasterFixedAsset | MasterFixedAsset | Fixed Asset | ||
| FixedAsset | FixedAsset | Asset Subnumber | ||
| AssetValueDate | AssetValueDate | Asset Value Date | ||
| AssetTransactionType | AssetTransactionType | Asset Transaction Type | ||
| AssetAcctTransClassfctn | AssetAcctTransClassfctn | Transaction Type Category | ||
| DepreciationFiscalPeriod | DepreciationFiscalPeriod | Fiscal Period of Depreciation | ||
| GroupMasterFixedAsset | GroupMasterFixedAsset | Group Asset | ||
| GroupFixedAsset | GroupFixedAsset | Group Asset Subnumber | ||
| CostEstimate | CostEstimate | Cost EstimateNo | ||
| InventorySpecialStockValnType | InventorySpecialStockValnType | Inventory Special Stock Valuation Type (Deprecated) | ||
| InvtrySpecialStockValnType_2 | InvtrySpecialStockValnType_2 | Inventory Special Stock Valuation Type | ||
| InventorySpecialStockType | InventorySpecialStockType | Inventory Special Stock Type | ||
| InventorySpclStkSalesDocument | InventorySpclStkSalesDocument | Inventory Special Stock Sales Document | ||
| InventorySpclStkSalesDocItm | InventorySpclStkSalesDocItm | Inventory Special Stock Sales Document Item | ||
| InvtrySpclStockWBSElmntIntID | InvtrySpclStockWBSElmntIntID | Inventory Special Stock WBS Element Internal ID | ||
| InvtrySpclStockWBSElmntExtID | InvtrySpclStockWBSElmntExtID | Work Breakdown Structure Element (WBS Element) Edited | ||
| InventorySpclStockWBSElement | InventorySpclStockWBSElement | Inventory Special Stock WBS Element | ||
| InventorySpecialStockSupplier | InventorySpecialStockSupplier | Supplier of Inventory Special Stock | ||
| InventoryValuationType | InventoryValuationType | Inventory Valuation Type | ||
| ValuationArea | ValuationArea | Valuation Area | ||
| SenderGLAccount | SenderGLAccount | Sender G/L Account | ||
| SenderAccountAssignment | SenderAccountAssignment | Sender Account Assignment | ||
| SenderAccountAssignmentType | SenderAccountAssignmentType | Account Assignment Type in Sender System | ||
| CostOriginGroup | CostOriginGroup | Origin Group as Subdivision of Cost Element | ||
| OriginSenderObject | OriginSenderObject | Origin Sender Object | ||
| ControllingDebitCreditCode | ControllingDebitCreditCode | Controlling Debit Credit Code | ||
| ControllingObjectDebitType | ControllingObjectDebitType | Controlling Object Debit Type | ||
| QuantityIsIncomplete | QuantityIsIncomplete | Indicator: Quantity Is Incomplete | ||
| OffsettingAccount | OffsettingAccount | Offsetting Account | ||
| OffsettingAccountType | OffsettingAccountType | Offsetting Account Type | ||
| OffsettingChartOfAccounts | OffsettingChartOfAccounts | Offsetting Chart of Accounts | ||
| LineItemIsCompleted | LineItemIsCompleted | Indicator: Line Item is Completed | ||
| PersonnelNumber | PersonnelNumber | Personnel Number | ||
| ControllingObjectClass | ControllingObjectClass | Controlling Object Class | ||
| PartnerCompanyCode | PartnerCompanyCode | Partner Company Code | ||
| PartnerControllingObjectClass | PartnerControllingObjectClass | Partner Controlling Object Class | ||
| OriginCostCenter | OriginCostCenter | Origin Cost Center | ||
| OriginProfitCenter | OriginProfitCenter | Origin Profit Center | ||
| OriginCostCtrActivityType | OriginCostCtrActivityType | Origin Cost Center Activity Type | ||
| AccountAssignment | AccountAssignment | Sender Acct Assgmt | ||
| AccountAssignmentType | AccountAssignmentType | Account Assignment Type | ||
| CostCtrActivityType | CostCtrActivityType | Activity Type | ||
| OrderID | OrderID | Order ID | ||
| OrderCategory | OrderCategory | Order Category | ||
| WBSElementInternalID | WBSElementInternalID | WBS Element Internal ID | ||
| WBSElementExternalID | WBSElementExternalID | Work Breakdown Structure Element (WBS Element) Edited | ||
| WBSElement | WBSElement | WBS Internal ID | ||
| PartnerWBSElementInternalID | PartnerWBSElementInternalID | Partner WBS Element Internal ID | ||
| PartnerWBSElementExternalID | PartnerWBSElementExternalID | Work Breakdown Structure Element (WBS Element) Edited | ||
| ProjectInternalID | ProjectInternalID | Project Internal ID | ||
| ProjectExternalID | ProjectExternalID | Project Number (External) Edited | ||
| Project | Project | WBS Element | ||
| PartnerProjectInternalID | PartnerProjectInternalID | Partner Project Internal ID | ||
| PartnerProjectExternalID | PartnerProjectExternalID | Project Number (External) Edited | ||
| OperatingConcern | OperatingConcern | Operating concern | ||
| ProjectNetwork | ProjectNetwork | Network Number for Account Assignment | ||
| RelatedNetworkActivity | RelatedNetworkActivity | Related Network Activity | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| CostObject | CostObject | Cost Object | ||
| BillableControl | BillableControl | Billable Control | ||
| CostAnalysisResource | CostAnalysisResource | Cost Analysis Resource | ||
| CustomerServiceNotification | CustomerServiceNotification | Customer Service Notification | ||
| ServiceDocumentType | ServiceDocumentType | Service Document Type | ||
| ServiceDocument | ServiceDocument | Service Document ID | ||
| ServiceDocumentItem | ServiceDocumentItem | Service Document Item ID | ||
| ServiceContractType | ServiceContractType | Service Contract Type | ||
| ServiceContract | ServiceContract | Service Contract ID | ||
| ServiceContractItem | ServiceContractItem | Service Contract Item ID | ||
| BusinessSolutionOrder | BusinessSolutionOrder | Solution Order | ||
| BusinessSolutionOrderItem | BusinessSolutionOrderItem | Solution Order Item | ||
| ProviderContract | ProviderContract | Provider Contract | ||
| ProviderContractItem | ProviderContractItem | Provider Contract Item | ||
| PartnerAccountAssignment | PartnerAccountAssignment | Partner Account Assignment | ||
| PartnerAccountAssignmentType | PartnerAccountAssignmentType | Partner Account Assignment Type | ||
| PartnerCostCtrActivityType | PartnerCostCtrActivityType | Partner Cost Center Activity Type | ||
| PartnerOrder | PartnerOrder | Partner Order (Deprecated) | ||
| PartnerOrder_2 | PartnerOrder_2 | Partner Order | ||
| PartnerOrderCategory | PartnerOrderCategory | Partner Order Category | ||
| PartnerWBSElement | PartnerWBSElement | Partner WBS Element | ||
| PartnerProject | PartnerProject | Partner Project | ||
| PartnerSalesDocument | PartnerSalesDocument | Partner Sales Document | ||
| PartnerSalesDocumentItem | PartnerSalesDocumentItem | Partner Sales Document Item | ||
| PartnerProjectNetwork | PartnerProjectNetwork | Partner Project Network | ||
| PartnerProjectNetworkActivity | PartnerProjectNetworkActivity | Partner Project Network Activity | ||
| PartnerBusinessProcess | PartnerBusinessProcess | Partner Business Process | ||
| PartnerCostObject | PartnerCostObject | Partner Cost Object | ||
| BillingDocumentType | BillingDocumentType | Billing Type | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| DistributionChannel | DistributionChannel | Distribution Channel | ||
| OrganizationDivision | OrganizationDivision | Org. Division | ||
| SoldProduct | SoldProduct | Product Sold | ||
| SoldProductGroup | SoldProductGroup | Product Sold Group | ||
| ProductGroup | ProductGroup | Product Sold Group | ||
| CustomerGroup | CustomerGroup | Customer Group | ||
| CustomerSupplierCountry | CustomerSupplierCountry | Customer or Supplier Country/Region | ||
| CustomerSupplierIndustry | CustomerSupplierIndustry | Customer Supplier Industry | ||
| SalesDistrict | SalesDistrict | Sales District | ||
| BillToParty | BillToParty | Inv. Recipient | ||
| ShipToParty | ShipToParty | Ship-To Party (obsolete) | ||
| CustomerSupplierCorporateGroup | CustomerSupplierCorporateGroup | Customer Supplier Corporate Group | ||
| FinancialManagementArea | FinancialManagementArea | Financial Management Area | ||
| Fund | Fund | Sender Fund | ||
| GrantID | GrantID | Sender Grant | ||
| BudgetPeriod | BudgetPeriod | Budget Period | ||
| PartnerFund | PartnerFund | Receiver Fund | ||
| PartnerGrant | PartnerGrant | Receiver Grant | ||
| PartnerBudgetPeriod | PartnerBudgetPeriod | FM: Partner Budget Period | ||
| FundsCenter | FundsCenter | Funds Management Center | ||
| FundedProgram | FundedProgram | Funded Program | ||
| JointVenture | JointVenture | Joint venture | ||
| JointVentureEquityGroup | JointVentureEquityGroup | Joint Venture Equity Group | ||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | Joint Venture Cost Recovery Code | ||
| JointVentureEquityType | JointVentureEquityType | Joint Venture Equity Type | ||
| SettlementReferenceDate | SettlementReferenceDate | Settlement Reference Date | ||
| WorkCenterInternalID | WorkCenterInternalID | Object ID of the resource | ||
| OrderOperation | OrderOperation | Operation or Phase | ||
| OrderItem | OrderItem | Order item number | ||
| OrderSuboperation | OrderSuboperation | Order Suboperation | ||
| Equipment | Equipment | Equipment Number | ||
| FunctionalLocation | FunctionalLocation | Functional Location | ||
| Assembly | Assembly | Pegged Reqmt | ||
| MaintenanceActivityType | MaintenanceActivityType | Maintenance activity type | ||
| MaintenanceOrderPlanningCode | MaintenanceOrderPlanningCode | Maintenance order planning indicator | ||
| MaintPriorityType | MaintPriorityType | Priority Type | ||
| MaintPriority | MaintPriority | Priority | ||
| SuperiorOrder | SuperiorOrder | Number of Superior Order | ||
| MaintenanceOrderIsPlanned | MaintenanceOrderIsPlanned | Planned Parts/Work | ||
| DebitAmountInCoCodeCrcy | DebitAmountInCoCodeCrcy | Debit Amount in Company Code Currency | ||
| CreditAmountInCoCodeCrcy | CreditAmountInCoCodeCrcy | Credit Amount in Company Code Currency | ||
| DebitAmountInTransCrcy | DebitAmountInTransCrcy | Debit Amount in Transaction Currency | ||
| CreditAmountInTransCrcy | CreditAmountInTransCrcy | Credit Amount in Transaction Currency | ||
| DebitAmountInBalanceTransCrcy | DebitAmountInBalanceTransCrcy | Debit Amount in Balance Transaction Currency | ||
| CreditAmountInBalanceTransCrcy | CreditAmountInBalanceTransCrcy | Credit Amount in Balance Transaction Currency | ||
| DebitAmountInGlobalCrcy | DebitAmountInGlobalCrcy | Debit Amount in Global Currency | ||
| CreditAmountInGlobalCrcy | CreditAmountInGlobalCrcy | Credit Amount in Global Currency | ||
| DebitAmountInFreeDfndCrcy1 | DebitAmountInFreeDfndCrcy1 | Debit Amount in Free Defined Currency 1 | ||
| CreditAmountInFreeDfndCrcy1 | CreditAmountInFreeDfndCrcy1 | Credit Amount in Free Defined Currency 1 | ||
| DebitAmountInFreeDfndCrcy2 | DebitAmountInFreeDfndCrcy2 | Debit Amount in Free Defined Currency 2 | ||
| CreditAmountInFreeDfndCrcy2 | CreditAmountInFreeDfndCrcy2 | Credit Amount in Free Defined Currency 2 | ||
| DebitAmountInFreeDfndCrcy3 | DebitAmountInFreeDfndCrcy3 | Debit Amount in Free Defined Currency 3 | ||
| CreditAmountInFreeDfndCrcy3 | CreditAmountInFreeDfndCrcy3 | Credit Amount in Free Defined Currency 3 | ||
| DebitAmountInFreeDfndCrcy4 | DebitAmountInFreeDfndCrcy4 | Debit Amount in Free Defined Currency 4 | ||
| CreditAmountInFreeDfndCrcy4 | CreditAmountInFreeDfndCrcy4 | Credit Amount in Free Defined Currency 4 | ||
| DebitAmountInFreeDfndCrcy5 | DebitAmountInFreeDfndCrcy5 | Debit Amount in Free Defined Currency 5 | ||
| CreditAmountInFreeDfndCrcy5 | CreditAmountInFreeDfndCrcy5 | Credit Amount in Free Defined Currency 5 | ||
| DebitAmountInFreeDfndCrcy6 | DebitAmountInFreeDfndCrcy6 | Debit Amount in Free Defined Currency 6 | ||
| CreditAmountInFreeDfndCrcy6 | CreditAmountInFreeDfndCrcy6 | Credit Amount in Free Defined Currency 6 | ||
| DebitAmountInFreeDfndCrcy7 | DebitAmountInFreeDfndCrcy7 | Debit Amount in Free Defined Currency 7 | ||
| CreditAmountInFreeDfndCrcy7 | CreditAmountInFreeDfndCrcy7 | Credit Amount in Free Defined Currency 7 | ||
| DebitAmountInFreeDfndCrcy8 | DebitAmountInFreeDfndCrcy8 | Debit Amount in Free Defined Currency 8 | ||
| CreditAmountInFreeDfndCrcy8 | CreditAmountInFreeDfndCrcy8 | Credit Amount in Free Defined Currency 8 | ||
| IsStatisticalOrder | IsStatisticalOrder | Indicator: Internal Order is Statistical Account Assignment | ||
| IsStatisticalCostCenter | IsStatisticalCostCenter | Indicator: Cost Center is Statistical Account Assignment | ||
| IsStatisticalSalesDocument | IsStatisticalSalesDocument | Sales Document is statistical | ||
| WBSIsStatisticalWBSElement | WBSIsStatisticalWBSElement | Indicator: WBS Element is Statistical Account Assignment | ||
| FiscalQuarter | FiscalQuarter | Fiscal Quarter | ||
| AssetAccountingKeyFigure | AssetAccountingKeyFigure | Key Figure for Asset Accounting | ||
| AssetAmtInCCCrcy | AssetAmtInCCCrcy | Asset Amount In CompanyCode Currency | ||
| LiabilityEquityAmtInCCCrcy | LiabilityEquityAmtInCCCrcy | Liabilities and Equity Amount In Company Code Currency | ||
| NotAssignedAmtInCCCrcy | NotAssignedAmtInCCCrcy | Not Assigned Amount In Company Code Currency | ||
| NetResultAmtInCCCrcy | NetResultAmtInCCCrcy | Net Result Amount In Company Code Currency | ||
| PnLResultAmtInCCCrcy | PnLResultAmtInCCCrcy | Profit for the Period | ||
| GLAcctNetIncomeAmtInCCCrcy | GLAcctNetIncomeAmtInCCCrcy | Net Income Amount In Company Code Currency | ||
| _JournalEntry | _JournalEntry | |||
| _CompanyCode | _CompanyCode | |||
| _FiscalYear | _FiscalYear | |||
| _FiscalPeriod | _FiscalPeriod | |||
| _FiscalPeriodForVariant | _FiscalPeriodForVariant | |||
| _LedgerFiscalYear | _LedgerFiscalYear | |||
| _LedgerFiscalYearForVariant | _LedgerFiscalYearForVariant | |||
| _FiscalYearVariant | _FiscalYearVariant | |||
| _FiscalYearPeriod | _FiscalYearPeriod | |||
| _FiscalYearPeriodForVariant | _FiscalYearPeriodForVariant | |||
| _CalendarDate | _CalendarDate | |||
| _FiscalCalendarDate | _FiscalCalendarDate | |||
| _ControllingArea | _ControllingArea | |||
| _BalanceTransactionCurrency | _BalanceTransactionCurrency | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _CompanyCodeCurrency | _CompanyCodeCurrency | |||
| _GlobalCurrency | _GlobalCurrency | |||
| _FreeDefinedCurrency1 | _FreeDefinedCurrency1 | |||
| _FreeDefinedCurrency2 | _FreeDefinedCurrency2 | |||
| _FreeDefinedCurrency3 | _FreeDefinedCurrency3 | |||
| _FreeDefinedCurrency4 | _FreeDefinedCurrency4 | |||
| _FreeDefinedCurrency5 | _FreeDefinedCurrency5 | |||
| _FreeDefinedCurrency6 | _FreeDefinedCurrency6 | |||
| _FreeDefinedCurrency7 | _FreeDefinedCurrency7 | |||
| _FreeDefinedCurrency8 | _FreeDefinedCurrency8 | |||
| _BaseUnit | _BaseUnit | |||
| _CostSourceUnit | _CostSourceUnit | |||
| _AdditionalQuantity1Unit | _AdditionalQuantity1Unit | |||
| _AdditionalQuantity2Unit | _AdditionalQuantity2Unit | |||
| _AdditionalQuantity3Unit | _AdditionalQuantity3Unit | |||
| _Segment | _Segment | |||
| _ProfitCenter | _ProfitCenter | |||
| _CurrentProfitCenter | _CurrentProfitCenter | |||
| _CostCenter | _CostCenter | |||
| _CurrentCostCenter | _CurrentCostCenter | |||
| _CostAnalysisResource | _CostAnalysisResource | |||
| _WBSElementExternalID | _WBSElementExternalID | |||
| _ProjectExternalID | _ProjectExternalID | |||
| _BusinessArea | _BusinessArea | |||
| _FunctionalArea | _FunctionalArea | |||
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _AccountingDocumentType | _AccountingDocumentType | |||
| _FinancialAccountType | _FinancialAccountType | |||
| _DebitCreditCode | _DebitCreditCode | |||
| _Product | _Product | |||
| _Plant | _Plant | |||
| _Ledger | _Ledger | |||
| _SourceLedger | _SourceLedger | |||
| _Customer | _Customer | |||
| _CustomerGroup | _CustomerGroup | |||
| _Supplier | _Supplier | |||
| _ProductGroup | _ProductGroup | |||
| _SalesOrder | _SalesOrder | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _SalesDocument | _SalesDocument | |||
| _InternalOrder | _InternalOrder | |||
| _Order | _Order | |||
| _FinancialTransactionType | _FinancialTransactionType | |||
| _BusinessTransactionType | _BusinessTransactionType | |||
| _ReferenceDocumentType | _ReferenceDocumentType | |||
| _PredecessorReferenceDocType | _PredecessorReferenceDocType | |||
| _PartnerCostCenter | _PartnerCostCenter | |||
| _PartnerProfitCenter | _PartnerProfitCenter | |||
| _PartnerBusinessArea | _PartnerBusinessArea | |||
| _PartnerFunctionalArea | _PartnerFunctionalArea | |||
| _PartnerCompanyCode | _PartnerCompanyCode | |||
| _PartnerSegment | _PartnerSegment | |||
| _AccountingDocumentCategory | _AccountingDocumentCategory | |||
| _PostingKey | _PostingKey | |||
| _SubLedgerAccLineItemType | _SubLedgerAccLineItemType | |||
| _User | _User | |||
| _EliminationProfitCenter | _EliminationProfitCenter | |||
| _GLAccountType | _GLAccountType | |||
| _OffsettingAccountType | _OffsettingAccountType | |||
| _OffsettingChartOfAccounts | _OffsettingChartOfAccounts | |||
| _OffsettingAccount | _OffsettingAccount | |||
| _OffsettingAccountWithBP | _OffsettingAccountWithBP | |||
| _AlternativeGLAccount | _AlternativeGLAccount | |||
| _CountryChartOfAccounts | _CountryChartOfAccounts | |||
| _SpecialGLCode | _SpecialGLCode | |||
| _TaxCode | _TaxCode | |||
| _ClearingAccountingDocument | _ClearingAccountingDocument | |||
| _FixedAsset | _FixedAsset | |||
| _MasterFixedAsset | _MasterFixedAsset | |||
| _GroupMasterFixedAsset | _GroupMasterFixedAsset | |||
| _GroupFixedAsset | _GroupFixedAsset | |||
| _InventorySpecialStockValnType | _InventorySpecialStockValnType | |||
| _InventorySpclStockValnType | _InventorySpclStockValnType | |||
| _InventorySpecialStockType | _InventorySpecialStockType | |||
| _InventorySpclStkSalesDocument | _InventorySpclStkSalesDocument | |||
| _InventorySpclStkSalesDocItm | _InventorySpclStkSalesDocItm | |||
| _InventorySpecialStockSupplier | _InventorySpecialStockSupplier | |||
| _InventoryValuationType | _InventoryValuationType | |||
| _ControllingDebitCreditCode | _ControllingDebitCreditCode | |||
| _OriginSenderObject | _OriginSenderObject | |||
| _ControllingObjectClass | _ControllingObjectClass | |||
| _PartnerControllingObjectClass | _PartnerControllingObjectClass | |||
| _OriginCostCenter | _OriginCostCenter | |||
| _OriginProfitCenter | _OriginProfitCenter | |||
| _CostCtrActivityType | _CostCtrActivityType | |||
| _OriginCostCtrActivityType | _OriginCostCtrActivityType | |||
| _OrderCategory | _OrderCategory | |||
| _BusinessProcess | _BusinessProcess | |||
| _PartnerCostCtrActivityType | _PartnerCostCtrActivityType | |||
| _PartnerOrder | _PartnerOrder | |||
| _PartnerOrder_2 | _PartnerOrder_2 | |||
| _PartnerOrderCategory | _PartnerOrderCategory | |||
| _PartnerSalesDocument | _PartnerSalesDocument | |||
| _PartnerSalesDocumentItem | _PartnerSalesDocumentItem | |||
| _PartnerBusinessProcess | _PartnerBusinessProcess | |||
| _BillingDocumentType | _BillingDocumentType | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _SoldProduct | _SoldProduct | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _FundsCenter | _FundsCenter | |||
| _BudgetPeriod | _BudgetPeriod | |||
| _CostOriginGroup | _CostOriginGroup | |||
| _CustomerSupplierCountry | _CustomerSupplierCountry | |||
| _SalesDistrict | _SalesDistrict | |||
| _BillToParty | _BillToParty | |||
| _ShipToParty | _ShipToParty | |||
| _FinancialManagementArea | _FinancialManagementArea | |||
| _OperatingConcern | _OperatingConcern | |||
| _PartnerCompany | _PartnerCompany | |||
| _SemanticTag | _SemanticTag | |||
| _Equipment | _Equipment | |||
| _FunctionalLocation | _FunctionalLocation | |||
| _MaintenanceActivityType | _MaintenanceActivityType | |||
| _MaintenanceOrderSubOperation | _MaintenanceOrderSubOperation | |||
| _Assembly | _Assembly | |||
| _ConditionContract | _ConditionContract | |||
| _SoldProductGroup | _SoldProductGroup | |||
| _ServiceDocumentType | _ServiceDocumentType | |||
| _ServiceDocument | _ServiceDocument | |||
| _ServiceDocumentItem | _ServiceDocumentItem | |||
| _ServiceContract | _ServiceContract | |||
| _ServiceContractItem | _ServiceContractItem | |||
| _ServiceContractType | _ServiceContractType | |||
| _ProviderContract | _ProviderContract | |||
| _ProviderContractItem | _ProviderContractItem | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _WBSElementBasicDataText | _WBSElementBasicDataText | |||
| _ProjectBasicData | _ProjectBasicData | |||
| _ProjectBasicDataText | _ProjectBasicDataText | |||
| _PartnerProjectExternalID | _PartnerProjectExternalID | |||
| _PartnerProjectExternalIDText | _PartnerProjectExternalIDText | |||
| _PartnerWBSElementExternalID | _PartnerWBSElementExternalID | |||
| _PartnerWBSElementExtIDText | _PartnerWBSElementExtIDText | |||
| _PartnerProjectBasicData | _PartnerProjectBasicData | |||
| _PartnerProjectBasicDataText | _PartnerProjectBasicDataText | |||
| _PartnerWBSElementBasicData | _PartnerWBSElementBasicData | |||
| _PartnerWBSElementBscDataText | _PartnerWBSElementBscDataText | |||
| _InvtrySpclStkWBSElmntBscData | _InvtrySpclStkWBSElmntBscData | |||
| _InvtrySpclStockWBSElmntExtID | _InvtrySpclStockWBSElmntExtID | |||
| AssetClass | AssetClass | Asset Class | ||
| FiscalYearVariant | P_GLAcctLineItemSemTagGLAcct | FiscalYearVariant | Fiscal Year Variant |
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_GLAcctLineItemSemTagGLAcct.
-- 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.
-- SQL view name: IFIGLLITSTGLACC
CREATE VIEW I_GLAcctLineItemSemTagGLAcct AS
SELECT
Ledger,
SourceLedger,
CompanyCode,
FiscalYear,
AccountingDocument,
LedgerGLLineItem,
SemanticTag,
GLAccountHierarchy,
ValidityStartDate,
ValidityEndDate,
LedgerFiscalYear,
GLRecordType,
ChartOfAccounts,
ControllingArea,
FinancialTransactionType,
BusinessTransactionType,
ReferenceDocumentType,
LogicalSystem,
ReferenceDocumentContext,
ReferenceDocument,
ReferenceDocumentItem,
ReferenceDocumentItemGroup,
IsReversal,
IsReversed,
ReversalReferenceDocumentCntxt,
ReversalReferenceDocument,
IsSettlement,
IsSettled,
PredecessorReferenceDocType,
PredecessorReferenceDocCntxt,
PredecessorReferenceDocument,
PredecessorReferenceDocItem,
SourceReferenceDocumentType,
SourceLogicalSystem,
SourceReferenceDocumentCntxt,
SourceReferenceDocument,
SourceReferenceDocumentItem,
SourceReferenceDocSubitem,
IsCommitment,
JrnlEntryItemObsoleteReason,
GLAccount,
CostCenter,
ProfitCenter,
FunctionalArea,
BusinessArea,
Segment,
PartnerCostCenter,
PartnerProfitCenter,
PartnerFunctionalArea,
PartnerBusinessArea,
PartnerCompany,
PartnerSegment,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
TransactionCurrency,
AmountInTransactionCurrency,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
GlobalCurrency,
AmountInGlobalCurrency,
FreeDefinedCurrency1,
AmountInFreeDefinedCurrency1,
FreeDefinedCurrency2,
AmountInFreeDefinedCurrency2,
FreeDefinedCurrency3,
AmountInFreeDefinedCurrency3,
FreeDefinedCurrency4,
AmountInFreeDefinedCurrency4,
FreeDefinedCurrency5,
AmountInFreeDefinedCurrency5,
FreeDefinedCurrency6,
AmountInFreeDefinedCurrency6,
FreeDefinedCurrency7,
AmountInFreeDefinedCurrency7,
FreeDefinedCurrency8,
AmountInFreeDefinedCurrency8,
FixedAmountInGlobalCrcy,
GrpValnFixedAmtInGlobCrcy,
PrftCtrValnFxdAmtInGlobCrcy,
TotalPriceVarcInGlobalCrcy,
GrpValnTotPrcVarcInGlobCrcy,
PrftCtrValnTotPrcVarcInGlbCrcy,
FixedPriceVarcInGlobalCrcy,
GrpValnFixedPrcVarcInGlobCrcy,
PrftCtrValnFxdPrcVarcInGlbCrcy,
ControllingObjectCurrency,
AmountInObjectCurrency,
BaseUnit,
Quantity,
FixedQuantity,
CostSourceUnit,
ValuationQuantity,
ValuationFixedQuantity,
AdditionalQuantity1Unit,
AdditionalQuantity1,
AdditionalQuantity2Unit,
AdditionalQuantity2,
AdditionalQuantity3Unit,
AdditionalQuantity3,
DebitCreditCode,
FiscalPeriod,
FiscalYearPeriod,
PostingDate,
DocumentDate,
AccountingDocumentType,
AccountingDocumentItem,
AssignmentReference,
AccountingDocumentCategory,
PostingKey,
TransactionTypeDetermination,
SubLedgerAcctLineItemType,
AccountingDocCreatedByUser,
LastChangeDateTime,
CreationDateTime,
CreationDate,
EliminationProfitCenter,
OriginObjectType,
GLAccountType,
AlternativeGLAccount,
CountryChartOfAccounts,
InvoiceReference,
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
InvoiceItemReference,
ReferencePurchaseOrderCategory,
PurchasingDocument,
PurchasingDocumentItem,
AccountAssignmentNumber,
DocumentItemText,
SalesOrder,
SalesOrderItem,
SalesDocument,
Product,
Plant,
Supplier,
Customer,
ServicesRenderedDate,
ConditionContract,
FinancialAccountType,
SpecialGLCode,
TaxCode,
HouseBank,
HouseBankAccount,
IsOpenItemManaged,
ClearingDate,
ClearingAccountingDocument,
ClearingDocFiscalYear,
AssetDepreciationArea,
MasterFixedAsset,
FixedAsset,
AssetValueDate,
AssetTransactionType,
AssetAcctTransClassfctn,
DepreciationFiscalPeriod,
GroupMasterFixedAsset,
GroupFixedAsset,
CostEstimate,
InventorySpecialStockValnType,
InvtrySpecialStockValnType_2,
InventorySpecialStockType,
InventorySpclStkSalesDocument,
InventorySpclStkSalesDocItm,
InvtrySpclStockWBSElmntIntID,
InvtrySpclStockWBSElmntExtID,
InventorySpclStockWBSElement,
InventorySpecialStockSupplier,
InventoryValuationType,
ValuationArea,
SenderGLAccount,
SenderAccountAssignment,
SenderAccountAssignmentType,
CostOriginGroup,
OriginSenderObject,
ControllingDebitCreditCode,
ControllingObjectDebitType,
QuantityIsIncomplete,
OffsettingAccount,
OffsettingAccountType,
OffsettingChartOfAccounts,
LineItemIsCompleted,
PersonnelNumber,
ControllingObjectClass,
PartnerCompanyCode,
PartnerControllingObjectClass,
OriginCostCenter,
OriginProfitCenter,
OriginCostCtrActivityType,
AccountAssignment,
AccountAssignmentType,
CostCtrActivityType,
OrderID,
OrderCategory,
WBSElementInternalID,
WBSElementExternalID,
WBSElement,
PartnerWBSElementInternalID,
PartnerWBSElementExternalID,
ProjectInternalID,
ProjectExternalID,
Project,
PartnerProjectInternalID,
PartnerProjectExternalID,
OperatingConcern,
ProjectNetwork,
RelatedNetworkActivity,
BusinessProcess,
CostObject,
BillableControl,
CostAnalysisResource,
CustomerServiceNotification,
ServiceDocumentType,
ServiceDocument,
ServiceDocumentItem,
ServiceContractType,
ServiceContract,
ServiceContractItem,
BusinessSolutionOrder,
BusinessSolutionOrderItem,
ProviderContract,
ProviderContractItem,
PartnerAccountAssignment,
PartnerAccountAssignmentType,
PartnerCostCtrActivityType,
PartnerOrder,
PartnerOrder_2,
PartnerOrderCategory,
PartnerWBSElement,
PartnerProject,
PartnerSalesDocument,
PartnerSalesDocumentItem,
PartnerProjectNetwork,
PartnerProjectNetworkActivity,
PartnerBusinessProcess,
PartnerCostObject,
BillingDocumentType,
SalesOrganization,
DistributionChannel,
OrganizationDivision,
SoldProduct,
SoldProductGroup,
ProductGroup,
CustomerGroup,
CustomerSupplierCountry,
CustomerSupplierIndustry,
SalesDistrict,
BillToParty,
ShipToParty,
CustomerSupplierCorporateGroup,
FinancialManagementArea,
Fund,
GrantID,
BudgetPeriod,
PartnerFund,
PartnerGrant,
PartnerBudgetPeriod,
FundsCenter,
FundedProgram,
JointVenture,
JointVentureEquityGroup,
JointVentureCostRecoveryCode,
JointVentureEquityType,
SettlementReferenceDate,
WorkCenterInternalID,
OrderOperation,
OrderItem,
OrderSuboperation,
Equipment,
FunctionalLocation,
Assembly,
MaintenanceActivityType,
MaintenanceOrderPlanningCode,
MaintPriorityType,
MaintPriority,
SuperiorOrder,
MaintenanceOrderIsPlanned,
DebitAmountInCoCodeCrcy,
CreditAmountInCoCodeCrcy,
DebitAmountInTransCrcy,
CreditAmountInTransCrcy,
DebitAmountInBalanceTransCrcy,
CreditAmountInBalanceTransCrcy,
DebitAmountInGlobalCrcy,
CreditAmountInGlobalCrcy,
DebitAmountInFreeDfndCrcy1,
CreditAmountInFreeDfndCrcy1,
DebitAmountInFreeDfndCrcy2,
CreditAmountInFreeDfndCrcy2,
DebitAmountInFreeDfndCrcy3,
CreditAmountInFreeDfndCrcy3,
DebitAmountInFreeDfndCrcy4,
CreditAmountInFreeDfndCrcy4,
DebitAmountInFreeDfndCrcy5,
CreditAmountInFreeDfndCrcy5,
DebitAmountInFreeDfndCrcy6,
CreditAmountInFreeDfndCrcy6,
DebitAmountInFreeDfndCrcy7,
CreditAmountInFreeDfndCrcy7,
DebitAmountInFreeDfndCrcy8,
CreditAmountInFreeDfndCrcy8,
IsStatisticalOrder,
IsStatisticalCostCenter,
IsStatisticalSalesDocument,
WBSIsStatisticalWBSElement,
FiscalQuarter,
AssetAccountingKeyFigure,
AssetAmtInCCCrcy,
LiabilityEquityAmtInCCCrcy,
NotAssignedAmtInCCCrcy,
NetResultAmtInCCCrcy,
PnLResultAmtInCCCrcy,
GLAcctNetIncomeAmtInCCCrcy,
AssetClass,
P_GLAcctLineItemSemTagGLAcct.FiscalYearVariant AS FiscalYearVariant
FROM P_GLAcctLineItemSemTagGLAcct
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem -- association [1..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA