P_GLAccountLineItemSemTag

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 P_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: PFIGLACCTLITST

CREATE VIEW P_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,
  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,
  cast(_PersonWorkAgreement_1._WorkforcePerson.PersonExternalID as bu_id_number) AS Employee,
  _PersonWorkAgreement_1._WorkforcePerson.PersonFullName AS EmployeeFullName,
  cast(_AssetKeyFigureSpecification.AssetAccountingKeyFigure as fis_asset_key_figure) AS AssetAccountingKeyFigure,
  GLAccountAuthorizationGroup,
  SupplierBasicAuthorizationGrp,
  CustomerBasicAuthorizationGrp,
  AcctgDocTypeAuthorizationGroup,
  OrderType,
  SalesOrderType,
  AssetClass,
  P_GLAccountLineItemSemTagUnion.FiscalPeriod AS FiscalPeriod,
  P_GLAccountLineItemSemTagUnion.FiscalYearVariant AS FiscalYearVariant,
  P_GLAccountLineItemSemTagUnion.FiscalYearPeriod AS FiscalYearPeriod,
  P_GLAccountLineItemSemTagUnion._FiscalYear AS _FiscalYear,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter
FROM P_GLAccountLineItemSemTagUnion
LEFT OUTER JOIN I_ActlHistSheetHierKeyFigSpec AS _AssetKeyFigureSpecification ON AssetAcctTransClassfctn = _AssetKeyFigureSpecification.AssetAcctAnlytlTransClassfctn AND SubLedgerAcctLineItemType = _AssetKeyFigureSpecification.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_AssetKeyFigure AS _AssetKeyFigure ON AssetAccountingKeyFigure = _AssetKeyFigure.AssetAccountingKeyFigure  -- association [0..1]
LEFT OUTER JOIN I_FinancialStatementHierarchy AS _Hierarchy ON GLAccountHierarchy = _Hierarchy.GLAccountHierarchy  -- association [0..*]
LEFT OUTER JOIN I_GLAccountHierarchy AS _GLAccountHierarchy ON GLAccountHierarchy = _GLAccountHierarchy.GLAccountHierarchy  -- association [0..*]
;