I_GLAccountLineItemSemTag
G/L Line Item with Semantic Tag Including FA
I_GLAccountLineItemSemTag (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_GLAccountLineItemSemTag is a Composite CDS View (Cube) that provides data about "G/L Line Item with Semantic Tag Including FA" in SAP S/4HANA. It reads from 1 data source (P_GLAccountLineItemSemTag) and exposes 586 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 1 association to related views.
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Accounting and Financial Close |
| Application Component | FI-GL-IS |
| Capabilities | Data Source in SQL Select, Data Provider for Analytical Queries, 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_GLAccountLineItemSemTag | P_GLAccountLineItemSemTag | 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 (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IFIGLACCTLITST | view | |
| EndUserText.label | G/L Line Item with Semantic Tag Including FA | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| Analytics.dataCategory | #CUBE | view | |
| ObjectModel.representativeKey | LedgerGLLineItem | 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 |
Fields (586)
| 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 | GLAccountHierarchy | GLAccountHierarchy | Financial Statement Version | |
| KEY | SemanticTag | SemanticTag | Semantic Tag of a Hierarchy Node | |
| 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 | ||
| FunctionalCurrency | FunctionalCurrency | Functional Currency | ||
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | Amount in Functional Currency | ||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | Freely Defined Currency 1 | ||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | ||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | Freely Defined Currency 2 | ||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | ||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | Freely Defined Currency 3 | ||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | ||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | Freely Defined Currency 4 | ||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | ||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | Freely Defined Currency 5 | ||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | ||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | Freely Defined Currency 6 | ||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | ||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | Freely Defined Currency 7 | ||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | ||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | Freely Defined Currency 8 | ||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | ||
| FixedAmountInGlobalCrcy | FixedAmountInGlobalCrcy | 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. | ||
| FixedAmountInCoCodeCrcy | FixedAmountInCoCodeCrcy | Fixed Amount in Company Currency | ||
| 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 | ||
| FiscalYearVariant | P_GLAccountLineItemSemTag | FiscalYearVariant | Fiscal Year Variant | |
| 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 | ||
| SalesDocumentItem | SalesDocumentItem | Sales Document Item | ||
| Material | Material | Material Number | ||
| 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) | ||
| ClearingJournalEntry | ClearingJournalEntry | Clearing Journal Entry | ||
| ClearingJournalEntryFiscalYear | ClearingJournalEntryFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| 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 | Work Breakdown Structure Element (WBS Element) | ||
| 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 | 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 | ||
| WorkPackage | WorkPackage | Plan Item | ||
| WorkItem | WorkItem | Work Item ID | ||
| 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 | ||
| SoldMaterial | SoldMaterial | Sold Material | ||
| SoldProduct | SoldProduct | Product Sold | ||
| MaterialGroup | MaterialGroup | Product Sold Group (Deprecated) | ||
| 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 | ||
| DebitAmountInFunctionalCrcy | DebitAmountInFunctionalCrcy | Debit Amount in Functional Currency | ||
| CreditAmountInFunctionalCrcy | CreditAmountInFunctionalCrcy | Credit Amount in Functional Currency | ||
| DebitAmountInFreeDefinedCrcy1 | DebitAmountInFreeDefinedCrcy1 | Debit Amount in Free Defined Currency 1 | ||
| CreditAmountInFreeDefinedCrcy1 | CreditAmountInFreeDefinedCrcy1 | Credit Amount in Free Defined Currency 1 | ||
| DebitAmountInFreeDefinedCrcy2 | DebitAmountInFreeDefinedCrcy2 | Debit Amount in Free Defined Currency 2 | ||
| CreditAmountInFreeDefinedCrcy2 | CreditAmountInFreeDefinedCrcy2 | Credit Amount in Free Defined Currency 2 | ||
| DebitAmountInFreeDefinedCrcy3 | DebitAmountInFreeDefinedCrcy3 | Debit Amount in Free Defined Currency 3 | ||
| CreditAmountInFreeDefinedCrcy3 | CreditAmountInFreeDefinedCrcy3 | Credit Amount in Free Defined Currency 3 | ||
| DebitAmountInFreeDefinedCrcy4 | DebitAmountInFreeDefinedCrcy4 | Debit Amount in Free Defined Currency 4 | ||
| CreditAmountInFreeDefinedCrcy4 | CreditAmountInFreeDefinedCrcy4 | Credit Amount in Free Defined Currency 4 | ||
| DebitAmountInFreeDefinedCrcy5 | DebitAmountInFreeDefinedCrcy5 | Debit Amount in Free Defined Currency 5 | ||
| CreditAmountInFreeDefinedCrcy5 | CreditAmountInFreeDefinedCrcy5 | Credit Amount in Free Defined Currency 5 | ||
| DebitAmountInFreeDefinedCrcy6 | DebitAmountInFreeDefinedCrcy6 | Debit Amount in Free Defined Currency 6 | ||
| CreditAmountInFreeDefinedCrcy6 | CreditAmountInFreeDefinedCrcy6 | Credit Amount in Free Defined Currency 6 | ||
| DebitAmountInFreeDefinedCrcy7 | DebitAmountInFreeDefinedCrcy7 | Debit Amount in Free Defined Currency 7 | ||
| CreditAmountInFreeDefinedCrcy7 | CreditAmountInFreeDefinedCrcy7 | Credit Amount in Free Defined Currency 7 | ||
| DebitAmountInFreeDefinedCrcy8 | DebitAmountInFreeDefinedCrcy8 | Debit Amount in Free Defined Currency 8 | ||
| CreditAmountInFreeDefinedCrcy8 | CreditAmountInFreeDefinedCrcy8 | 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 | ||
| Employee | Employee | Identification Number | ||
| EmployeeFullName | EmployeeFullName | Full Name | ||
| AssetAccountingKeyFigure | AssetAccountingKeyFigure | Key Figure for Asset Accounting | ||
| ProjAndSlsOrdStkAmtInCCCrcy | ProjAndSlsOrdStkAmtInCCCrcy | Project/Sales Order Stock | ||
| ProjAndSlsOrdStkAmtInGlobCrcy | ProjAndSlsOrdStkAmtInGlobCrcy | Project/Sales Order Stock | ||
| RevenueAmountInCompanyCodeCrcy | RevenueAmountInCompanyCodeCrcy | Revenue Amount in Company Code Currency | ||
| RevenueInGlobalCurrency | RevenueInGlobalCurrency | Revenue Amount in Global Currency | ||
| GrossRevenueAmtInCCCrcy | GrossRevenueAmtInCCCrcy | Gross Revenue | ||
| RecognizedRevnAmtInCCCrcy | RecognizedRevnAmtInCCCrcy | Recognized Revenue | ||
| RecognizedRevnAmtInGlobCrcy | RecognizedRevnAmtInGlobCrcy | Recognized Revenue | ||
| RevenueAdjustmentAmtInCCCrcy | RevenueAdjustmentAmtInCCCrcy | Revenue Adjustment | ||
| RevenueAdjustAmtInGlobCrcy | RevenueAdjustAmtInGlobCrcy | Revenue Adjustment | ||
| DeferredRevenueAmtInCCCrcy | DeferredRevenueAmtInCCCrcy | Deferred Revenue | ||
| AccruedRevenueAmtInCCCrcy | AccruedRevenueAmtInCCCrcy | Accrued Revenue | ||
| RecognizableRevenueAmtInCCCrcy | RecognizableRevenueAmtInCCCrcy | Actual Revenue | ||
| RecognizableRevnAmtInGlobCrcy | RecognizableRevnAmtInGlobCrcy | Actual Revenue | ||
| BilledRevenueAmtInCoCodeCrcy | BilledRevenueAmtInCoCodeCrcy | Actual Revenue | ||
| BilledRevenueAmtInGlobCrcy | BilledRevenueAmtInGlobCrcy | Actual Revenue | ||
| BilledValnQtyInCostSourceUnit | BilledValnQtyInCostSourceUnit | Billed Quantity | ||
| UnbilledRevnInCoCodeCrcy | UnbilledRevnInCoCodeCrcy | Unbilled Revenue | ||
| RecognizedMarginAmtInCCCrcy | RecognizedMarginAmtInCCCrcy | Recognized Margin | ||
| MnlContrAccrPnLItmAmtInCCCrcy | MnlContrAccrPnLItmAmtInCCCrcy | Manual Contract Accruals Income Statement in CCCrcy | ||
| CostAmountInCompanyCodeCrcy | CostAmountInCompanyCodeCrcy | Cost Amount in Company Code Currency | ||
| CostOfGoodsSoldAmtInGlobCrcy | CostOfGoodsSoldAmtInGlobCrcy | Cost of Goods Sold - Total | ||
| COGSAmountInCoCodeCrcy | COGSAmountInCoCodeCrcy | Cost of Goods Sold - Total | ||
| FxdCOGSAmtInGlobCrcy | FxdCOGSAmtInGlobCrcy | Cost of Goods Sold - Fixed | ||
| FxdCOGSAmtInCCCrcy | FxdCOGSAmtInCCCrcy | Cost of Goods Sold - Fixed | ||
| RecognizedCOGSAmtInCCCrcy | RecognizedCOGSAmtInCCCrcy | Recognized COS | ||
| COGSAdjustmentAmtInCCCrcy | COGSAdjustmentAmtInCCCrcy | COS Adjustment | ||
| DeferredCOGSAmtInCCCrcy | DeferredCOGSAmtInCCCrcy | Deferred COS | ||
| AccruedCOGSAmtInCCCrcy | AccruedCOGSAmtInCCCrcy | Accrued COS | ||
| RecognizableCostAmtInCCCrcy | RecognizableCostAmtInCCCrcy | Actual Cost | ||
| ImminentLossRsrvAmtInCCCrcy | ImminentLossRsrvAmtInCCCrcy | Reserves for Imminent Loss | ||
| SalesDeductReserveAmtInCCCrcy | SalesDeductReserveAmtInCCCrcy | Reserves for Anticipated Sales Deductions | ||
| UnrlzdCostsReserveAmtInCCCrcy | UnrlzdCostsReserveAmtInCCCrcy | Reserves for Unrealized Costs | ||
| MnlContrAccrBalShtAmtInCCCrcy | MnlContrAccrBalShtAmtInCCCrcy | Manual Contract Accruals Balance Sheet in CCCrcy | ||
| SalesDeductionAmountInGlobCrcy | SalesDeductionAmountInGlobCrcy | Sales Deduction | ||
| SalesDeductionAmtInCoCodeCrcy | SalesDeductionAmtInCoCodeCrcy | Sales Deduction | ||
| PriceDifferenceAmtInGlobCrcy | PriceDifferenceAmtInGlobCrcy | Price Differences | ||
| PriceDifferenceAmtInCCCrcy | PriceDifferenceAmtInCCCrcy | Price Differences | ||
| AdminOverheadAmtInGlobCrcy | AdminOverheadAmtInGlobCrcy | Administration Overhead | ||
| AdminOverheadAmtInCoCodeCrcy | AdminOverheadAmtInCoCodeCrcy | Administration Overhead | ||
| SalesOverheadAmtInGlobCrcy | SalesOverheadAmtInGlobCrcy | Sales Overhead | ||
| SalesOverheadAmtInCoCodeCrcy | SalesOverheadAmtInCoCodeCrcy | Sales Overhead | ||
| MarketingOverheadAmtInGlobCrcy | MarketingOverheadAmtInGlobCrcy | Marketing Overhead | ||
| MarketingOvhdAmtInCoCodeCrcy | MarketingOvhdAmtInCoCodeCrcy | Marketing Overhead | ||
| RnDOverheadAmtInGlobCrcy | RnDOverheadAmtInGlobCrcy | Research and Development Overhead | ||
| RnDOverheadAmtInCCCrcy | RnDOverheadAmtInCCCrcy | Research and Development Overhead | ||
| LongTermInvmtAmtInCCCrcy | LongTermInvmtAmtInCCCrcy | Increase (Decrease) in Long-term Investments | ||
| AcctsRblAmtInCCCrcy | AcctsRblAmtInCCCrcy | Increase (Decrease) in Accounts Receivable (Net) | ||
| AcctsOthRblAmtInCCCrcy | AcctsOthRblAmtInCCCrcy | Increase (Decrease) in Accounts Other Receivable (Net) | ||
| AcctsPyblAmtInCCCrcy | AcctsPyblAmtInCCCrcy | Increase (Decrease) in Accounts Payable (Net) | ||
| AcctsOthPyblAmtInCCCrcy | AcctsOthPyblAmtInCCCrcy | Increase (Decrease) in Accounts Other Payables (Net) | ||
| ProvisionAmtInCCCrcy | ProvisionAmtInCCCrcy | Increase/Decrease of Provisions | ||
| NotesReceivableAmtInCCCrcy | NotesReceivableAmtInCCCrcy | Increase (Decrease) in Notes Receivable | ||
| TangibleAstDeprAmtInCCCrcy | TangibleAstDeprAmtInCCCrcy | Depreciation of Tangible Assets | ||
| IntngblAssetAmtznAmtInCCCrcy | IntngblAssetAmtznAmtInCCCrcy | Amortization of Intangible Assets | ||
| TangibleAstAmtInCCCrcy | TangibleAstAmtInCCCrcy | Purchase (Sale) of Tangible Assets | ||
| IntangibleAstAmtInCCCrcy | IntangibleAstAmtInCCCrcy | Purchase (Sale) of Intangible Assets | ||
| FixedAssetRtrmtAmtInCCCrcy | FixedAssetRtrmtAmtInCCCrcy | Gain/Loss from Retirement of Fixed Assets | ||
| InventoryAmtInCCCrcy | InventoryAmtInCCCrcy | Increase/Decrease of Inventories | ||
| CommonStockAmtInCCCrcy | CommonStockAmtInCCCrcy | Increase (Decrease) in Common Stocks | ||
| CashAndCashEqvlntAmtInCCCrcy | CashAndCashEqvlntAmtInCCCrcy | Change (Increase/ Decrease) in cash and cash equivalents | ||
| 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 | |||
| _FunctionalCurrency | _FunctionalCurrency | |||
| _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 | |||
| _WBSElement | _WBSElement | |||
| _WBSElementInternalID | _WBSElementInternalID | |||
| _WBSElementExternalID | _WBSElementExternalID | |||
| _Project | _Project | |||
| _ProjectExternalID | _ProjectExternalID | |||
| _BusinessArea | _BusinessArea | |||
| _FunctionalArea | _FunctionalArea | |||
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | |||
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _AccountingDocumentType | _AccountingDocumentType | |||
| _FinancialAccountType | _FinancialAccountType | |||
| _DebitCreditCode | _DebitCreditCode | |||
| _Material | _Material | |||
| _Product | _Product | |||
| _Plant | _Plant | |||
| _Ledger | _Ledger | |||
| _SourceLedger | _SourceLedger | |||
| _Customer | _Customer | |||
| _CustomerGroup | _CustomerGroup | |||
| _Supplier | _Supplier | |||
| _MaterialGroup | _MaterialGroup | |||
| _ProductGroup | _ProductGroup | |||
| _SalesOrder | _SalesOrder | |||
| _SalesOrderItem | _SalesOrderItem | |||
| _SalesDocument | _SalesDocument | |||
| _SalesDocumentItem | _SalesDocumentItem | |||
| _InternalOrder | _InternalOrder | |||
| _Order | _Order | |||
| _Employment | _Employment | |||
| _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 | |||
| _PurchasingDocument | _PurchasingDocument | |||
| _PurchasingDocumentItem | _PurchasingDocumentItem | |||
| _SpecialGLCode | _SpecialGLCode | |||
| _TaxCode | _TaxCode | |||
| _HouseBank | _HouseBank | |||
| _ClearingJrnlEntryFiscalYear | _ClearingJrnlEntryFiscalYear | |||
| _ClearingJournalEntry | _ClearingJournalEntry | |||
| _ClearingAccountingDocument | _ClearingAccountingDocument | |||
| _FixedAsset | _FixedAsset | |||
| _MasterFixedAsset | _MasterFixedAsset | |||
| _GroupMasterFixedAsset | _GroupMasterFixedAsset | |||
| _GroupFixedAsset | _GroupFixedAsset | |||
| _InventorySpecialStockValnType | _InventorySpecialStockValnType | |||
| _InventorySpclStockValnType | _InventorySpclStockValnType | |||
| _InventorySpecialStockType | _InventorySpecialStockType | |||
| _InventorySpclStkSalesDocument | _InventorySpclStkSalesDocument | |||
| _InventorySpclStkSalesDocItm | _InventorySpclStkSalesDocItm | |||
| _InvtrySpclStockWBSElmntIntID | _InvtrySpclStockWBSElmntIntID | |||
| _InventorySpclStockWBSElement | _InventorySpclStockWBSElement | |||
| _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 | |||
| _PartnerWBSElement | _PartnerWBSElement | |||
| _PartnerProject | _PartnerProject | |||
| _PartnerSalesDocument | _PartnerSalesDocument | |||
| _PartnerSalesDocumentItem | _PartnerSalesDocumentItem | |||
| _PartnerBusinessProcess | _PartnerBusinessProcess | |||
| _WorkPackage | _WorkPackage | |||
| _WorkPackageWorkItem | _WorkPackageWorkItem | |||
| _BillingDocumentType | _BillingDocumentType | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _SoldMaterial | _SoldMaterial | |||
| _SoldProduct | _SoldProduct | |||
| _Fund | _Fund | |||
| _PartnerFund | _PartnerFund | |||
| _FundsCenter | _FundsCenter | |||
| _MovementCategory | _MovementCategory | |||
| _AssetTransactionType | _AssetTransactionType | |||
| _BudgetPeriod | _BudgetPeriod | |||
| _CostOriginGroup | _CostOriginGroup | |||
| _CustomerSupplierCountry | _CustomerSupplierCountry | |||
| _SalesDistrict | _SalesDistrict | |||
| _BillToParty | _BillToParty | |||
| _ShipToParty | _ShipToParty | |||
| _FinancialManagementArea | _FinancialManagementArea | |||
| _HouseBankAccount | _HouseBankAccount | |||
| _LogicalSystem | _LogicalSystem | |||
| _OperatingConcern | _OperatingConcern | |||
| _PartnerCompany | _PartnerCompany | |||
| _ProjectNetwork | _ProjectNetwork | |||
| _PurReqValuationArea | _PurReqValuationArea | |||
| _SemanticTag | _SemanticTag | |||
| _Hierarchy | _Hierarchy | |||
| _GLAccountHierarchy | _GLAccountHierarchy | |||
| _Equipment | _Equipment | |||
| _FunctionalLocation | _FunctionalLocation | |||
| _MaintenanceActivityType | _MaintenanceActivityType | |||
| _MaintOrdPlngDegreeCode | _MaintOrdPlngDegreeCode | |||
| _PMNotificationPriorityType | _PMNotificationPriorityType | |||
| _PMNotificationPriority | _PMNotificationPriority | |||
| _MaintenanceOrderSubOperation | _MaintenanceOrderSubOperation | |||
| _Assembly | _Assembly | |||
| _SuperiorOrder | _SuperiorOrder | |||
| _ProjectInternalID | _ProjectInternalID | |||
| _ConditionContract | _ConditionContract | |||
| _SoldProductGroup | _SoldProductGroup | |||
| _ServiceDocumentType | _ServiceDocumentType | |||
| _ServiceDocument | _ServiceDocument | |||
| _ServiceDocumentItem | _ServiceDocumentItem | |||
| _ServiceContract | _ServiceContract | |||
| _ServiceContractItem | _ServiceContractItem | |||
| _ServiceContractType | _ServiceContractType | |||
| _WBSElementBasicData | _WBSElementBasicData | |||
| _WBSElementBasicDataText | _WBSElementBasicDataText | |||
| _ProjectBasicData | _ProjectBasicData | |||
| _ProjectBasicDataText | _ProjectBasicDataText | |||
| _PartnerProjectExternalID | _PartnerProjectExternalID | |||
| _PartnerProjctExtrnalIDText | _PartnerProjctExtrnalIDText | |||
| _PartnerWBSElementExternalID | _PartnerWBSElementExternalID | |||
| _PartnerWBSElemntExtrnalIDText | _PartnerWBSElemntExtrnalIDText | |||
| _PartnerProjectBasicData | _PartnerProjectBasicData | |||
| _PartnerProjectBasicDataText | _PartnerProjectBasicDataText | |||
| _PartnerWBSElementBasicData | _PartnerWBSElementBasicData | |||
| _PartnerWBSElemntBasicDataText | _PartnerWBSElemntBasicDataText | |||
| _InvtrySpclStockWBSElmntBD | _InvtrySpclStockWBSElmntBD | |||
| _InvtrySpclStockWBSElmntExtID | _InvtrySpclStockWBSElmntExtID | |||
| _ProviderContract | _ProviderContract | |||
| _ProviderContractItem | _ProviderContractItem | |||
| GLAccountAuthorizationGroup | GLAccountAuthorizationGroup | Authorization Group | ||
| SupplierBasicAuthorizationGrp | SupplierBasicAuthorizationGrp | Authorization Group | ||
| CustomerBasicAuthorizationGrp | CustomerBasicAuthorizationGrp | Authorization Group | ||
| AcctgDocTypeAuthorizationGroup | AcctgDocTypeAuthorizationGroup | Authorization Group | ||
| OrderType | OrderType | Order Type | ||
| SalesOrderType | SalesOrderType | Sales Document Type | ||
| AssetClass | AssetClass | Asset Class | ||
| _AssetKeyFigure | _AssetKeyFigure |
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_GLAccountLineItemSemTag.
-- 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: IFIGLACCTLITST
CREATE VIEW I_GLAccountLineItemSemTag AS
SELECT
Ledger,
SourceLedger,
CompanyCode,
FiscalYear,
AccountingDocument,
LedgerGLLineItem,
GLAccountHierarchy,
SemanticTag,
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,
FunctionalCurrency,
AmountInFunctionalCurrency,
FreeDefinedCurrency1,
AmountInFreeDefinedCurrency1,
FreeDefinedCurrency2,
AmountInFreeDefinedCurrency2,
FreeDefinedCurrency3,
AmountInFreeDefinedCurrency3,
FreeDefinedCurrency4,
AmountInFreeDefinedCurrency4,
FreeDefinedCurrency5,
AmountInFreeDefinedCurrency5,
FreeDefinedCurrency6,
AmountInFreeDefinedCurrency6,
FreeDefinedCurrency7,
AmountInFreeDefinedCurrency7,
FreeDefinedCurrency8,
AmountInFreeDefinedCurrency8,
FixedAmountInGlobalCrcy,
GrpValnFixedAmtInGlobCrcy,
PrftCtrValnFxdAmtInGlobCrcy,
TotalPriceVarcInGlobalCrcy,
GrpValnTotPrcVarcInGlobCrcy,
PrftCtrValnTotPrcVarcInGlbCrcy,
FixedPriceVarcInGlobalCrcy,
GrpValnFixedPrcVarcInGlobCrcy,
PrftCtrValnFxdPrcVarcInGlbCrcy,
FixedAmountInCoCodeCrcy,
ControllingObjectCurrency,
AmountInObjectCurrency,
BaseUnit,
Quantity,
FixedQuantity,
CostSourceUnit,
ValuationQuantity,
ValuationFixedQuantity,
AdditionalQuantity1Unit,
AdditionalQuantity1,
AdditionalQuantity2Unit,
AdditionalQuantity2,
AdditionalQuantity3Unit,
AdditionalQuantity3,
DebitCreditCode,
FiscalPeriod,
P_GLAccountLineItemSemTag.FiscalYearVariant AS FiscalYearVariant,
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,
SalesDocumentItem,
Material,
Product,
Plant,
Supplier,
Customer,
ServicesRenderedDate,
ConditionContract,
FinancialAccountType,
SpecialGLCode,
TaxCode,
HouseBank,
HouseBankAccount,
IsOpenItemManaged,
ClearingDate,
ClearingAccountingDocument,
ClearingDocFiscalYear,
ClearingJournalEntry,
ClearingJournalEntryFiscalYear,
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,
WorkPackage,
WorkItem,
PartnerCostCtrActivityType,
PartnerOrder,
PartnerOrder_2,
PartnerOrderCategory,
PartnerWBSElement,
PartnerProject,
PartnerSalesDocument,
PartnerSalesDocumentItem,
PartnerProjectNetwork,
PartnerProjectNetworkActivity,
PartnerBusinessProcess,
PartnerCostObject,
BillingDocumentType,
SalesOrganization,
DistributionChannel,
OrganizationDivision,
SoldMaterial,
SoldProduct,
MaterialGroup,
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,
DebitAmountInFunctionalCrcy,
CreditAmountInFunctionalCrcy,
DebitAmountInFreeDefinedCrcy1,
CreditAmountInFreeDefinedCrcy1,
DebitAmountInFreeDefinedCrcy2,
CreditAmountInFreeDefinedCrcy2,
DebitAmountInFreeDefinedCrcy3,
CreditAmountInFreeDefinedCrcy3,
DebitAmountInFreeDefinedCrcy4,
CreditAmountInFreeDefinedCrcy4,
DebitAmountInFreeDefinedCrcy5,
CreditAmountInFreeDefinedCrcy5,
DebitAmountInFreeDefinedCrcy6,
CreditAmountInFreeDefinedCrcy6,
DebitAmountInFreeDefinedCrcy7,
CreditAmountInFreeDefinedCrcy7,
DebitAmountInFreeDefinedCrcy8,
CreditAmountInFreeDefinedCrcy8,
IsStatisticalOrder,
IsStatisticalCostCenter,
IsStatisticalSalesDocument,
WBSIsStatisticalWBSElement,
FiscalQuarter,
Employee,
EmployeeFullName,
AssetAccountingKeyFigure,
ProjAndSlsOrdStkAmtInCCCrcy,
ProjAndSlsOrdStkAmtInGlobCrcy,
RevenueAmountInCompanyCodeCrcy,
RevenueInGlobalCurrency,
GrossRevenueAmtInCCCrcy,
RecognizedRevnAmtInCCCrcy,
RecognizedRevnAmtInGlobCrcy,
RevenueAdjustmentAmtInCCCrcy,
RevenueAdjustAmtInGlobCrcy,
DeferredRevenueAmtInCCCrcy,
AccruedRevenueAmtInCCCrcy,
RecognizableRevenueAmtInCCCrcy,
RecognizableRevnAmtInGlobCrcy,
BilledRevenueAmtInCoCodeCrcy,
BilledRevenueAmtInGlobCrcy,
BilledValnQtyInCostSourceUnit,
UnbilledRevnInCoCodeCrcy,
RecognizedMarginAmtInCCCrcy,
MnlContrAccrPnLItmAmtInCCCrcy,
CostAmountInCompanyCodeCrcy,
CostOfGoodsSoldAmtInGlobCrcy,
COGSAmountInCoCodeCrcy,
FxdCOGSAmtInGlobCrcy,
FxdCOGSAmtInCCCrcy,
RecognizedCOGSAmtInCCCrcy,
COGSAdjustmentAmtInCCCrcy,
DeferredCOGSAmtInCCCrcy,
AccruedCOGSAmtInCCCrcy,
RecognizableCostAmtInCCCrcy,
ImminentLossRsrvAmtInCCCrcy,
SalesDeductReserveAmtInCCCrcy,
UnrlzdCostsReserveAmtInCCCrcy,
MnlContrAccrBalShtAmtInCCCrcy,
SalesDeductionAmountInGlobCrcy,
SalesDeductionAmtInCoCodeCrcy,
PriceDifferenceAmtInGlobCrcy,
PriceDifferenceAmtInCCCrcy,
AdminOverheadAmtInGlobCrcy,
AdminOverheadAmtInCoCodeCrcy,
SalesOverheadAmtInGlobCrcy,
SalesOverheadAmtInCoCodeCrcy,
MarketingOverheadAmtInGlobCrcy,
MarketingOvhdAmtInCoCodeCrcy,
RnDOverheadAmtInGlobCrcy,
RnDOverheadAmtInCCCrcy,
LongTermInvmtAmtInCCCrcy,
AcctsRblAmtInCCCrcy,
AcctsOthRblAmtInCCCrcy,
AcctsPyblAmtInCCCrcy,
AcctsOthPyblAmtInCCCrcy,
ProvisionAmtInCCCrcy,
NotesReceivableAmtInCCCrcy,
TangibleAstDeprAmtInCCCrcy,
IntngblAssetAmtznAmtInCCCrcy,
TangibleAstAmtInCCCrcy,
IntangibleAstAmtInCCCrcy,
FixedAssetRtrmtAmtInCCCrcy,
InventoryAmtInCCCrcy,
CommonStockAmtInCCCrcy,
CashAndCashEqvlntAmtInCCCrcy,
AssetAmtInCCCrcy,
LiabilityEquityAmtInCCCrcy,
NotAssignedAmtInCCCrcy,
NetResultAmtInCCCrcy,
PnLResultAmtInCCCrcy,
GLAcctNetIncomeAmtInCCCrcy,
GLAccountAuthorizationGroup,
SupplierBasicAuthorizationGrp,
CustomerBasicAuthorizationGrp,
AcctgDocTypeAuthorizationGroup,
OrderType,
SalesOrderType,
AssetClass
FROM P_GLAccountLineItemSemTag
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