P_ProjectStockCostLineItem

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_ProjectStockCostLineItem.
-- 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: PPRJBYPRJSTCKCST

CREATE VIEW P_ProjectStockCostLineItem AS
SELECT
  _ProjCstLineItm.SourceLedger AS SourceLedger,
  _SourceLedger.Ledger AS Ledger,
  _ProjCstLineItm.CompanyCode AS CompanyCode,
  _ProjCstLineItm.FiscalYear AS FiscalYear,
  _ProjCstLineItm.AccountingDocument AS AccountingDocument,
  cast(cast( '00000000000000000000000' as abap.numc (23)) as fis_fp_request_tsn ) AS FinancialPlanningReqTransSqnc,
  cast(cast( '000000' as abap.numc (6)) as fis_fp_data_packet ) AS FinancialPlanningDataPacket,
  cast( LedgerGLLineItem as fis_act_pln_docln) AS ActualPlanJournalEntryItem,
  _ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  _ProjCstLineItm.LedgerGLLineItem AS LedgerGLLineItem,
  cast(cast( 0 as abap.int4 ) as fis_fp_entry_item ) AS FinancialPlanningEntryItem,
  cast(cast( 'A' as abap.char (1)) as fis_actual_plan_code) AS ActualPlanCode,
  _SemanticTag.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCstLineItm.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _ProjCstLineItm.BusinessArea AS BusinessArea,
  _ProjCstLineItm.PartnerOrder AS PartnerOrder,
  _ProjCstLineItm.OrderID AS OrderID,
  _ProjCstLineItm.OrderOperation AS OrderOperation,
  ' ' AS MaintenanceOrderDesc,
  _ProjCstLineItm.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  '' AS OperationDescription,
  _ProjCstLineItm.PartnerOrderCategory AS PartnerOrderCategory,
  _ProjCstLineItm._PartnerWBSElementBasicData.WBSElementExternalID AS PartnerWBSElement,
  _ProjCstLineItm._PartnerProjectBasicData.ProjectExternalID AS PartnerProject,
  _ProjCstLineItm.BusinessTransactionType AS BusinessTransactionType,
  _ProjCstLineItm.DebitCreditCode AS DebitCreditCode,
  _ProjCstLineItm.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _WBS.WBSElementExternalID AS WBSElement,
  _Project.ProjectExternalID AS Project,
  _Project.ProjectInternalID AS ProjectInternalID,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  _ProjCstLineItm.CreationDate AS CreationDate,
  _ProjCstLineItm.FunctionalArea AS FunctionalArea,
  _ProjCstLineItm.CostCtrActivityType AS CostCtrActivityType,
  _ProjCstLineItm.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjCstLineItm.TransactionCurrency AS TransactionCurrency,
  _ProjCstLineItm.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ProjCstLineItm.FunctionalCurrency AS FunctionalCurrency,
  _ProjCstLineItm.GlobalCurrency AS GlobalCurrency,
  _ProjCstLineItm.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjCstLineItm.AmountInGlobalCurrency AS PrjStockAmountInGlobalCurrency,
  _ProjCstLineItm.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _ProjCstLineItm.SourceLogicalSystem AS SourceLogicalSystem,
  _ProjCstLineItm.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _ProjCstLineItm.SourceReferenceDocument AS SourceReferenceDocument,
  _ProjCstLineItm.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  _ProjCstLineItm.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  _ProjCstLineItm.IsCommitment AS IsCommitment,
  cast( cast( 'ACT01' as abap.char( 10 )) as fcom_category) AS PlanningCategory,
  _ProjCstLineItm.PostingDate AS PostingDate,
  _ProjCstLineItm.DocumentDate AS DocumentDate,
  _ProjCstLineItm.FiscalPeriod AS FiscalPeriod,
  _ProjCstLineItm.FiscalYearPeriod AS FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  cast( 'X' as boolean ) AS MaintenanceOrderIsSelected,
  _SemanticTag.SemanticTag AS SemanticTag,
  _WBS.ProfitCenter AS WBSElementProfitCenter,
  _WBS.WBSDescription AS WBSDescription,
  _WBS.WBSElementObject AS ProjectObjectNode,
  _WBS.ResponsibleCostCenter AS ResponsibleCostCenter,
  _WBS.ProjectType AS ProjectType,
  _Project.ProjectDescription AS ProjectDescription,
  _Project.ProjectProfileCode AS ProjectProfileCode,
  _Project.ProjectObject AS ProjectObject,
  _Project.AvailabilityControlProfile AS AvailabilityControlProfile,
  _Project.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _Project._AvailabilityCtrlProfile.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _Project._AvailabilityCtrlProfile.BudgetCurrencyRole AS BudgetCurrencyRole
FROM I_ProjectBasicData AS _Project
INNER JOIN I_LedgerSourceLedger AS _SourceLedger ON /* join condition not captured in parsed metadata */
INNER JOIN P_IsLeadingLedger AS _Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProjectStockAcctSemanticTag AS _SemanticTag ON /* join condition not captured in parsed metadata */
;