P_ProjectMargin

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_ProjectMargin.
-- 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.
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW P_ProjectMargin AS
SELECT
  P_ActPlnSemTagAndSubldgrItm.Ledger AS Ledger,
  P_ActPlnSemTagAndSubldgrItm.SourceLedger AS SourceLedger,
  P_ActPlnSemTagAndSubldgrItm.CompanyCode AS CompanyCode,
  P_ActPlnSemTagAndSubldgrItm.FiscalYear AS FiscalYear,
  P_ActPlnSemTagAndSubldgrItm.AccountingDocument AS AccountingDocument,
  P_ActPlnSemTagAndSubldgrItm.LedgerGLLineItem AS LedgerGLLineItem,
  P_ActPlnSemTagAndSubldgrItm.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  P_ActPlnSemTagAndSubldgrItm.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  P_ActPlnSemTagAndSubldgrItm.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  P_ActPlnSemTagAndSubldgrItm.SemanticTag AS SemanticTag,
  P_ActPlnSemTagAndSubldgrItm.CurrencyField AS CurrencyField,
  P_ActPlnSemTagAndSubldgrItm.LineIsSemTagCalculated AS LineIsSemTagCalculated,
  P_ActPlnSemTagAndSubldgrItm.ActualPlanCode AS ActualPlanCode,
  P_ActPlnSemTagAndSubldgrItm.PlanningCategory AS PlanningCategory,
  P_ActPlnSemTagAndSubldgrItm.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActPlnSemTagAndSubldgrItm.FiscalPeriod AS FiscalPeriod,
  P_ActPlnSemTagAndSubldgrItm.PostingDate AS PostingDate,
  cast( lifecyc.PostingDate as fins_rep_last_revaldat preserving type ) AS EvtBsdRevnRecgnLastEvalDate,
  P_ActPlnSemTagAndSubldgrItm.ProfitCenter AS ProfitCenter,
  P_ActPlnSemTagAndSubldgrItm.OriginProfitCenter AS OriginProfitCenter,
  P_ActPlnSemTagAndSubldgrItm.SoldProduct AS SoldProduct,
  P_ActPlnSemTagAndSubldgrItm.SoldProductGroup AS SoldProductGroup,
  P_ActPlnSemTagAndSubldgrItm.Customer AS Customer,
  P_ActPlnSemTagAndSubldgrItm.CustomerGroup AS CustomerGroup,
  P_ActPlnSemTagAndSubldgrItm.PurchasingDocument AS PurchasingDocument,
  P_ActPlnSemTagAndSubldgrItm.SalesOrder AS SalesOrder,
  P_ActPlnSemTagAndSubldgrItm.SalesOrderItem AS SalesOrderItem,
  P_ActPlnSemTagAndSubldgrItm.SalesDocument AS SalesDocument,
  P_ActPlnSemTagAndSubldgrItm.SalesDocumentItem AS SalesDocumentItem,
  P_ActPlnSemTagAndSubldgrItm.OrderID AS OrderID,
  P_ActPlnSemTagAndSubldgrItm.OrderCategory AS OrderCategory,
  P_ActPlnSemTagAndSubldgrItm.ConditionContract AS ConditionContract,
  P_ActPlnSemTagAndSubldgrItm.FiscalYearPeriod AS FiscalYearPeriod,
  P_ActPlnSemTagAndSubldgrItm.ChartOfAccounts AS ChartOfAccounts,
  P_ActPlnSemTagAndSubldgrItm.GLAccount AS GLAccount,
  P_ActPlnSemTagAndSubldgrItm.SalesOrganization AS SalesOrganization,
  P_ActPlnSemTagAndSubldgrItm.CustomerSupplierCountry AS CustomerSupplierCountry,
  P_ActPlnSemTagAndSubldgrItm.CustomerSupplierIndustry AS CustomerSupplierIndustry,
  P_ActPlnSemTagAndSubldgrItm.SalesDistrict AS SalesDistrict,
  P_ActPlnSemTagAndSubldgrItm.ShipToParty AS ShipToParty,
  P_ActPlnSemTagAndSubldgrItm.BillToParty AS BillToParty,
  P_ActPlnSemTagAndSubldgrItm.ControllingArea AS ControllingArea,
  P_ActPlnSemTagAndSubldgrItm.CostSourceUnit AS CostSourceUnit,
  P_ActPlnSemTagAndSubldgrItm.BusinessTransactionType AS BusinessTransactionType,
  P_ActPlnSemTagAndSubldgrItm.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  P_ActPlnSemTagAndSubldgrItm.DistributionChannel AS DistributionChannel,
  P_ActPlnSemTagAndSubldgrItm.OrganizationDivision AS OrganizationDivision,
  P_ActPlnSemTagAndSubldgrItm.BaseUnit AS BaseUnit,
  P_ActPlnSemTagAndSubldgrItm.OrderType AS OrderType,
  P_ActPlnSemTagAndSubldgrItm.Segment AS Segment,
  P_ActPlnSemTagAndSubldgrItm.WBSElementInternalID AS WBSElementInternalID,
  P_ActPlnSemTagAndSubldgrItm._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  P_ActPlnSemTagAndSubldgrItm.ProjectNetwork AS ProjectNetwork,
  P_ActPlnSemTagAndSubldgrItm.FunctionalArea AS FunctionalArea,
  P_ActPlnSemTagAndSubldgrItm.Plant AS Plant,
  P_ActPlnSemTagAndSubldgrItm.FiscalYearVariant AS FiscalYearVariant,
  P_ActPlnSemTagAndSubldgrItm.ServiceContract AS ServiceContract,
  P_ActPlnSemTagAndSubldgrItm.ServiceContractItem AS ServiceContractItem,
  P_ActPlnSemTagAndSubldgrItm.BusinessSolutionOrder AS BusinessSolutionOrder,
  P_ActPlnSemTagAndSubldgrItm.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  P_ActPlnSemTagAndSubldgrItm.ProviderContract AS ProviderContract,
  P_ActPlnSemTagAndSubldgrItm.ProviderContractItem AS ProviderContractItem,
  P_ActPlnSemTagAndSubldgrItm.ServiceContractType AS ServiceContractType,
  P_ActPlnSemTagAndSubldgrItm.AccountAssignmentType AS AccountAssignmentType,
  P_ActPlnSemTagAndSubldgrItm.ServiceDocument AS ServiceDocument,
  P_ActPlnSemTagAndSubldgrItm.ServiceDocumentItem AS ServiceDocumentItem,
  P_ActPlnSemTagAndSubldgrItm.ServiceDocumentType AS ServiceDocumentType,
  cast( P_ActPlnSemTagAndSubldgrItm.ProjectExternalID as fis_rep_project preserving type ) AS Project,
  P_ActPlnSemTagAndSubldgrItm.ProjectInternalID AS ProjectInternalID,
  P_ActPlnSemTagAndSubldgrItm.ProjectExternalID AS ProjectExternalID,
  P_ActPlnSemTagAndSubldgrItm.Supplier AS Supplier,
  P_ActPlnSemTagAndSubldgrItm.AccountingDocumentType AS AccountingDocumentType,
  P_ActPlnSemTagAndSubldgrItm.FinancialAccountType AS FinancialAccountType,
  P_ActPlnSemTagAndSubldgrItm.CostCenter AS CostCenter,
  P_ActPlnSemTagAndSubldgrItm.AssetClass AS AssetClass,
  P_ActPlnSemTagAndSubldgrItm.ValuationArea AS ValuationArea,
  P_ActPlnSemTagAndSubldgrItm.BillableControl AS BillableControl,
  P_ActPlnSemTagAndSubldgrItm.ServicesRenderedDate AS ServicesRenderedDate,
  P_ActPlnSemTagAndSubldgrItm.Material AS Material,
  P_ActPlnSemTagAndSubldgrItm.WorkPackage AS WorkPackage,
  P_ActPlnSemTagAndSubldgrItm.WorkItem AS WorkItem,
  P_ActPlnSemTagAndSubldgrItm.CostAnalysisResource AS CostAnalysisResource,
  P_ActPlnSemTagAndSubldgrItm.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  P_ActPlnSemTagAndSubldgrItm.PersonnelNumber AS PersonnelNumber,
  P_ActPlnSemTagAndSubldgrItm.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  P_ActPlnSemTagAndSubldgrItm.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  P_ActPlnSemTagAndSubldgrItm.IsCommitment AS IsCommitment,
  cast( P_ActPlnSemTagAndSubldgrItm.ControllingDebitCreditCode as co_belkz ) AS ControllingDebitCreditCode,
  P_ActPlnSemTagAndSubldgrItm.DocumentItemText AS DocumentItemText,
  P_ActPlnSemTagAndSubldgrItm.Currency AS Currency,
  P_ActPlnSemTagAndSubldgrItm.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  P_ActPlnSemTagAndSubldgrItm.FixedAmountInDspCrcy AS FixedAmountInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.BilledRevenueAmtInDspCrcy AS BilledRevenueAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.ActualSalesDdctdInDspCrcy AS ActualSalesDdctdInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.ActualCostAmtInDspCrcy AS ActualCostAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.ActlFixedCostInDspCrcy AS ActlFixedCostInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.RevenueAdjustmentAmtInDspCrcy AS RevenueAdjustmentAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.COGSAdjustmentAmtInDspCrcy AS COGSAdjustmentAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.DeferredRevenueAmtInDspCrcy AS DeferredRevenueAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.DeferredCOGSAmtInDspCrcy AS DeferredCOGSAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.AccruedRevenueAmtInDspCrcy AS AccruedRevenueAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.AccruedCOGSAmtInDspCrcy AS AccruedCOGSAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.RecognizedMargAmtInDisplayCrcy AS RecognizedMargAmtInDisplayCrcy,
  P_ActPlnSemTagAndSubldgrItm.RecognizedRevnAmtInDspCrcy AS RecognizedRevnAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.RecognizedCOGSAmtInDspCrcy AS RecognizedCOGSAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.CostOfGoodsSoldAmtInDspCrcy AS CostOfGoodsSoldAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.FxdCOGSAmtInDspCrcy AS FxdCOGSAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.PriceDiffAmtInDisplayCrcy AS PriceDiffAmtInDisplayCrcy,
  P_ActPlnSemTagAndSubldgrItm.AdminOverheadAmtInDspCrcy AS AdminOverheadAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.SalesOverheadAmtInDspCrcy AS SalesOverheadAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.MarketingOvhdAmtInDspCrcy AS MarketingOvhdAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.RnDOverheadAmtInDspCrcy AS RnDOverheadAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.InptPrVarcAmtInDspCrcy AS InptPrVarcAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.OutpPrVarcAmtInDspCrcy AS OutpPrVarcAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.InptQtyVarcAmtInDspCrcy AS InptQtyVarcAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.RsceUsgeVarcAmtInDspCrcy AS RsceUsgeVarcAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.LotSizeVarcAmtInDspCrcy AS LotSizeVarcAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.InptRmngVarcAmtInDspCrcy AS InptRmngVarcAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.PlannedCosAmtInDspCrcy AS PlannedCosAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.PlannedRevenueAmtInDspCrcy AS PlannedRevenueAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.MnlContrAccrPnLItmAmtInDspCrcy AS MnlContrAccrPnLItmAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.UnbilledRevnInDspCrcy AS UnbilledRevnInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.MnlContrAccrBalShtAmtInDspCrcy AS MnlContrAccrBalShtAmtInDspCrcy,
  / P_ActPlnSemTagAndSubldgrItm.WIPProjAmtInDspCrcy AS WIPProjAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.MatlStkAmtInDspCrcy AS MatlStkAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.WIPProdnAmtInDspCrcy AS WIPProdnAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.DownPaymentAmountInDspCrcy AS DownPaymentAmountInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.Quantity AS Quantity,
  P_ActPlnSemTagAndSubldgrItm.TimeConfirmationAmtInDspCrcy AS TimeConfirmationAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.ConfirmedHoursQuantity AS ConfirmedHoursQuantity,
  P_ActPlnSemTagAndSubldgrItm.BilledHoursQuantity AS BilledHoursQuantity,
  P_ActPlnSemTagAndSubldgrItm.WrittenOffHoursQuantity AS WrittenOffHoursQuantity,
  P_ActPlnSemTagAndSubldgrItm.WrittenOffAmtInDspCrcy AS WrittenOffAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.NonBillableHoursQuantity AS NonBillableHoursQuantity,
  P_ActPlnSemTagAndSubldgrItm.NonBillableAmtInDspCrcy AS NonBillableAmtInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.WIPHoursQuantity AS WIPHoursQuantity,
  P_ActPlnSemTagAndSubldgrItm.WIPAmtInDisplayCurrency AS WIPAmtInDisplayCurrency,
  P_ActPlnSemTagAndSubldgrItm.CapAmountInDspCrcy AS CapAmountInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.BdgtCtrldBdgtCostInDspCrcy AS BdgtCtrldBdgtCostInDspCrcy,
  P_ActPlnSemTagAndSubldgrItm.CompletedWorkQuantity AS CompletedWorkQuantity,
  P_ActPlnSemTagAndSubldgrItm.ActualValuationQuantity AS ActualValuationQuantity,
  P_ActPlnSemTagAndSubldgrItm.PlanValuationQuantity AS PlanValuationQuantity,
  P_ActPlnSemTagAndSubldgrItm.MnlContrAccrIncStatAmtInDC AS MnlContrAccrIncStatAmtInDC,
  P_ActPlnSemTagAndSubldgrItm.ImminentLossRsrvAdjAmtInDC AS ImminentLossRsrvAdjAmtInDC,
  P_ActPlnSemTagAndSubldgrItm.ImmntLossRsrvBalShtAmtInDC AS ImmntLossRsrvBalShtAmtInDC,
  P_ActPlnSemTagAndSubldgrItm._ProjectBasicData AS _ProjectBasicData,
  P_ActPlnSemTagAndSubldgrItm._Ledger AS _Ledger,
  P_ActPlnSemTagAndSubldgrItm._SourceLedger AS _SourceLedger,
  P_ActPlnSemTagAndSubldgrItm._CompanyCode AS _CompanyCode,
  P_ActPlnSemTagAndSubldgrItm._SemanticTag AS _SemanticTag,
  P_ActPlnSemTagAndSubldgrItm._FiscalYear AS _FiscalYear,
  P_ActPlnSemTagAndSubldgrItm._Customer AS _Customer,
  P_ActPlnSemTagAndSubldgrItm._CustomerGroup AS _CustomerGroup,
  P_ActPlnSemTagAndSubldgrItm._SoldProduct AS _SoldProduct,
  P_ActPlnSemTagAndSubldgrItm._SoldProductGroup AS _SoldProductGroup,
  P_ActPlnSemTagAndSubldgrItm._ProfitCenter AS _ProfitCenter,
  P_ActPlnSemTagAndSubldgrItm._OriginProfitCenter AS _OriginProfitCenter,
  P_ActPlnSemTagAndSubldgrItm._ControllingArea AS _ControllingArea,
  P_ActPlnSemTagAndSubldgrItm._CostSourceUnit AS _CostSourceUnit,
  P_ActPlnSemTagAndSubldgrItm._SalesDocument AS _SalesDocument,
  P_ActPlnSemTagAndSubldgrItm._SalesOrder AS _SalesOrder,
  P_ActPlnSemTagAndSubldgrItm._SalesOrderItem AS _SalesOrderItem,
  P_ActPlnSemTagAndSubldgrItm._Order AS _Order,
  P_ActPlnSemTagAndSubldgrItm._DistributionChannel AS _DistributionChannel,
  P_ActPlnSemTagAndSubldgrItm._BaseUnit AS _BaseUnit,
  P_ActPlnSemTagAndSubldgrItm._Segment AS _Segment,
  P_ActPlnSemTagAndSubldgrItm._ChartOfAccounts AS _ChartOfAccounts,
  P_ActPlnSemTagAndSubldgrItm._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  P_ActPlnSemTagAndSubldgrItm._FunctionalArea AS _FunctionalArea,
  P_ActPlnSemTagAndSubldgrItm._Plant AS _Plant,
  P_ActPlnSemTagAndSubldgrItm._SalesOrganization AS _SalesOrganization,
  P_ActPlnSemTagAndSubldgrItm._SalesDistrict AS _SalesDistrict,
  P_ActPlnSemTagAndSubldgrItm._CustomerSupplierCountry AS _CustomerSupplierCountry,
  P_ActPlnSemTagAndSubldgrItm._CustomerSupplierIndustry AS _CustomerSupplierIndustry,
  P_ActPlnSemTagAndSubldgrItm._ShipToParty AS _ShipToParty,
  P_ActPlnSemTagAndSubldgrItm._BillToParty AS _BillToParty,
  P_ActPlnSemTagAndSubldgrItm._FiscalYearVariant AS _FiscalYearVariant,
  P_ActPlnSemTagAndSubldgrItm._WBSElementBasicData AS _WBSElementBasicData,
  P_ActPlnSemTagAndSubldgrItm._Supplier AS _Supplier,
  P_ActPlnSemTagAndSubldgrItm._AccountingDocumentType AS _AccountingDocumentType,
  P_ActPlnSemTagAndSubldgrItm._CurrentProfitCenter AS _CurrentProfitCenter,
  P_ActPlnSemTagAndSubldgrItm._CurrentCostCenter AS _CurrentCostCenter,
  P_ActPlnSemTagAndSubldgrItm._ServiceDocument AS _ServiceDocument,
  P_ActPlnSemTagAndSubldgrItm._Material AS _Material,
  P_ActPlnSemTagAndSubldgrItm._WorkPackage AS _WorkPackage,
  P_ActPlnSemTagAndSubldgrItm._WorkPackageWorkItem AS _WorkPackageWorkItem,
  P_ActPlnSemTagAndSubldgrItm._CostAnalysisResource AS _CostAnalysisResource,
  P_ActPlnSemTagAndSubldgrItm._Employment AS _Employment,
  P_ActPlnSemTagAndSubldgrItm._OriginCostCtrActivityType AS _OriginCostCtrActivityType,
  P_ActPlnSemTagAndSubldgrItm._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType
FROM P_ActPlnSemTagAndSubldgrItm
LEFT OUTER JOIN I_MargAnlysProdAndSrvcObjType AS _ObjectType ON AccountAssignmentType = _ObjectType.MarginAnalysisObjectType  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocument AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _ServiceDocumentTypeNew ON ServiceDocumentType = _ServiceDocumentTypeNew.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingServiceDocument AS _ServiceDocumentNew ON ServiceDocumentType = _ServiceDocumentNew.ServiceDocumentType AND ServiceDocument = _ServiceDocumentNew.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _ServiceDocumentItemNew ON ServiceDocumentType = _ServiceDocumentItemNew.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItemNew.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItemNew.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _ServiceContractTypeNew ON ServiceContractType = _ServiceContractTypeNew.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AccountingServiceDocument AS _ServiceContractNew ON ServiceContractType = _ServiceContractNew.ServiceDocumentType AND ServiceContract = _ServiceContractNew.ServiceDocument  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _ServiceContractItemNew ON ServiceContractType = _ServiceContractItemNew.ServiceDocumentType AND ServiceContract = _ServiceContractItemNew.ServiceDocument AND ServiceContractItem = _ServiceContractItemNew.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForVariant AS _LedgerFiscalYearForVariant ON LedgerFiscalYear = _LedgerFiscalYearForVariant.FiscalYear AND FiscalYearVariant = _LedgerFiscalYearForVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForLedger AS _LedgerFiscalYearForLedger ON LedgerFiscalYear = _LedgerFiscalYearForLedger.FiscalYear AND CompanyCode = _LedgerFiscalYearForLedger.CompanyCode AND Ledger = _LedgerFiscalYearForLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_TimeSheetOvertimeCat AS _TimeSheetOvertimeCat ON TimeSheetOvertimeCategory = _TimeSheetOvertimeCat.TimeSheetOvertimeCategory  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _Project ON Project = _Project.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectByExternalID AS _ProjectExternalID ON ProjectExternalID = _ProjectExternalID.ProjectExternalID  -- association [0..1]
LEFT OUTER JOIN I_SubLedgerAccLineItemType AS _SubLedgerAccLineItemType ON SubLedgerAcctLineItemType = _SubLedgerAccLineItemType.SubLedgerAcctLineItemType  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON wbselementexternalid = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElementData_2 ON WBSElementInternalID = _WBSElementData_2.WBSElementInternalID  -- association [0..1]
;