I_PlanLineItemSemTagGLAcct

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_PlanLineItemSemTagGLAcct.
-- 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: IFIPLANLITSTGL

CREATE VIEW I_PlanLineItemSemTagGLAcct AS
SELECT
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  FinancialPlanningEntryItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  ControllingArea,
  CompanyCode,
  Ledger,
  GLAccount,
  ChartOfAccounts,
  FiscalYear,
  LedgerFiscalYear,
  _FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  BusinessArea,
  ProfitCenter,
  CostCenter,
  Project,
  ProjectInternalID,
  _ProjectBasicData.ProjectExternalID AS ProjectExternalID,
  PartnerProjectInternalID,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  SoldProduct,
  SoldProductGroup,
  _ProjectBasicData.ProjectExternalID AS PartnerProjectExternalID,
  WBSElement,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  PartnerWBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS PartnerWBSElementExternalID,
  FunctionalArea,
  Segment,
  CostCtrActivityType,
  CostAnalysisResource,
  WorkPackage,
  WorkItem,
  BillableControl,
  IsLotSizeIndependent,
  PartnerCompanyCode,
  PartnerBusinessArea,
  PartnerSegment,
  PartnerProfitCenter,
  PartnerCostCenter,
  PartnerProject,
  PartnerWBSElement,
  PartnerFunctionalArea,
  PartnerCostCtrActivityType,
  OrderID,
  PartnerOrder,
  PartnerOrder_2,
  PartnerCompany,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  ReferenceDocument,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FunctionalCurrency,
  AmountInFunctionalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  CostSourceUnit,
  ValuationQuantity,
  FiscalPeriod,
  FiscalYearPeriod,
  FiscalYearVariant,
  PostingDate,
  SubLedgerAcctLineItemType,
  ProjectNetwork,
  AccountAssignmentType,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  SalesOrder,
  SalesOrderItem,
  SalesDocument,
  SalesDocumentItem,
  Plant,
  Material,
  Customer,
  PlanningCategory,
  ControllingDebitCreditCode,
  PersonnelNumber,
  BillingDocumentType,
  SalesOrganization,
  DistributionChannel,
  Division,
  OrganizationDivision,
  SoldMaterial,
  MaterialGroup,
  ProductGroup,
  CustomerGroup,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  BillToParty,
  ShipToParty,
  CustomerSupplierCorporateGroup,
  AssetDepreciationArea,
  MasterFixedAsset,
  FixedAsset,
  AssetAcctTransClassfctn,
  AssetClass,
  PlnAssetAmtInCCCrcy,
  PlnLbltyEquityAmtInCCCrcy,
  PlnNotAssignedAmtInCCCrcy,
  PlnNetRsltAmtInCCCrcy,
  PlnPnLResultAmtInCCCrcy,
  PlnGLAcctNetIncAmtInCCCrcy,
  cast( '' as brgru) AS GLAccountAuthorizationGroup,
  cast( '' as brgru) AS CustomerBasicAuthorizationGrp,
  cast( '' as aufart) AS OrderType,
  cast( '' as auart) AS SalesOrderType
FROM P_PlnLineItemSemTagGLAcct
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalIDText ON WBSElementExternalID = _WBSElementExternalIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExternalID ON PartnerWBSElementExternalID = _PartnerWBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _PartnerWBSElementExtIDText ON PartnerWBSElementExternalID = _PartnerWBSElementExtIDText.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalID ON PartnerProjectExternalID = _PartnerProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _PartnerProjectExternalIDText ON PartnerProjectExternalID = _PartnerProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalIDText ON ProjectExternalID = _ProjectExternalIDText.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
;