C_ApplicationOfFundTP

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 C_ApplicationOfFundTP.
-- 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: CAPPLOFFUNDTP

CREATE VIEW C_ApplicationOfFundTP AS
SELECT
  iApplicationOfFund.ApplicationOfFunds AS ApplicationOfFunds,
  iApplicationOfFund.FinancialManagementArea AS FinancialManagementArea,
  iApplicationOfFund.FinancialManagementAreaForEdit AS FinancialManagementAreaForEdit,
  iApplicationOfFund.ApplicationOfFundsForEdit AS ApplicationOfFundsForEdit,
  iApplicationOfFund.ApplicationOfFundsName AS ApplicationOfFundsName,
  iApplicationOfFund.ApplicationOfFundsDescription AS ApplicationOfFundsDescription,
  iApplicationOfFund.ValidityStartDate AS ValidityStartDate,
  iApplicationOfFund.ValidityEndDate AS ValidityEndDate,
  iApplicationOfFund.US_IsFedGvmntGtasRelevant AS US_IsFedGvmntGtasRelevant,
  iApplicationOfFund.US_FedGvmntSubLevelPrefix AS US_FedGvmntSubLevelPrefix,
  iApplicationOfFund.US_FedGvmntAgency AS US_FedGvmntAgency,
  iApplicationOfFund.US_FedGvmntAllocTransferAgcy AS US_FedGvmntAllocTransferAgcy,
  iApplicationOfFund.US_FedGvmntAvailyPerdStartDate AS US_FedGvmntAvailyPerdStartDate,
  iApplicationOfFund.US_FedGvmntAvailyPerdEndDate AS US_FedGvmntAvailyPerdEndDate,
  iApplicationOfFund.US_FedGvmntAvailabilityType AS US_FedGvmntAvailabilityType,
  iApplicationOfFund.US_FedGvmntMainAccount AS US_FedGvmntMainAccount,
  iApplicationOfFund.US_FedGvmntSubAccount AS US_FedGvmntSubAccount,
  iApplicationOfFund.US_FedGvmntPreparer AS US_FedGvmntPreparer,
  iApplicationOfFund.US_FedGvmntCertifier AS US_FedGvmntCertifier,
  iApplicationOfFund.US_IsFedGvmntFACTS2Relevant AS US_IsFedGvmntFACTS2Relevant,
  iApplicationOfFund.US_FedGvmntDepartmentRegular AS US_FedGvmntDepartmentRegular,
  iApplicationOfFund.US_FedGvmntDepartmentTransfer AS US_FedGvmntDepartmentTransfer,
  iApplicationOfFund.US_FedGvmntSplitSequenceNumber AS US_FedGvmntSplitSequenceNumber,
  iApplicationOfFund.CreatedByUser AS CreatedByUser,
  iApplicationOfFund.CreationDate AS CreationDate,
  iApplicationOfFund.LastChangedByUser AS LastChangedByUser,
  iApplicationOfFund.LastChangeDate AS LastChangeDate,
  iApplicationOfFund._FinMgmtArea AS _FinMgmtArea
FROM I_ApplicationOfFundTP AS iApplicationOfFund
LEFT OUTER JOIN C_FundWST AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND ApplicationOfFunds = _Fund.ApplicationOfFunds  -- association [0..*]
LEFT OUTER JOIN C_FundToBudgetPeriod AS _FundToBudgetPeriod ON FinancialManagementArea = _FundToBudgetPeriod.FinancialManagementArea AND ApplicationOfFunds = _FundToBudgetPeriod.ApplOfFundByBudgetPeriod  -- association [0..*]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea1VH ON FinancialManagementAreaForEdit = _FinMgmtArea1VH.FinancialManagementArea  -- association [1]
LEFT OUTER JOIN I_US_FedGvmntAvailabilityType AS _US_FedGvmntAvailabilityType ON US_FedGvmntAvailabilityType = _US_FedGvmntAvailabilityType.US_FedGvmntAvailabilityType  -- association [1..1]
LEFT OUTER JOIN I_US_IsFedGvmntFacts2Relevant AS _US_IsFedGvmntFACTS2Relevant ON US_IsFedGvmntFACTS2Relevant = _US_IsFedGvmntFACTS2Relevant.US_IsFedGvmntFACTS2Relevant  -- association [0..1]
LEFT OUTER JOIN I_US_IsGvmntTrsyAcctSymRlvt AS _US_IsFedGvmntGtasRelevant ON US_IsFedGvmntGtasRelevant = _US_IsFedGvmntGtasRelevant.US_IsFedGvmntGtasRelevant  -- association [1..1]
;