C_CAWriteOffAnalysis_2

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_CAWriteOffAnalysis_2.
-- 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_DisplayCurrency : waers_kk

CREATE VIEW C_CAWriteOffAnalysis_2 AS
SELECT
  entity: { name: 'I_CurrencyStdVH', element: 'Currency' AS CASubItemNumber
FROM I_CAWriteOffHistory AS _History
LEFT OUTER JOIN I_CADocumentBPItemLogical AS _DocBPItemLogical ON _History.CADocumentNumber = _DocBPItemLogical.CADocumentNumber AND _History.CARepetitionItemNumber = _DocBPItemLogical.CARepetitionItemNumber AND _History.CABPItemNumber = _DocBPItemLogical.CABPItemNumber AND _History.CASubItemNumber = _DocBPItemLogical.CASubItemNumber  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarWriteOffDate ON CAWriteOffDate = _CalendarWriteOffDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarIssueDate ON CAIssueDate = _CalendarIssueDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedureText AS _CADunProcedTxt ON CADunningProcedure = _CADunProcedTxt.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CACollectionStrategyText AS _CACollStrgyTxt ON CACollectionStrategy = _CACollStrgyTxt.CACollectionStrategy  -- association [0..1]
LEFT OUTER JOIN I_CADocumentTypeText AS _CADocTypeTxt ON CADocumentType = _CADocTypeTxt.CADocumentType AND caapplicationarea = _CADocTypeTxt.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAStatisticalItemCodeText AS _CAStstclItmCodeTxt ON castatisticalitemcode = _CAStstclItmCodeTxt.CAStatisticalItemCode  -- association [0..1]
LEFT OUTER JOIN I_CASubApplicationText AS _CASubapplicationTxt ON casubapplication = _CASubapplicationTxt.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CAWriteOffReasonText AS _CAWriteOffReasonTxt ON CAWriteOffReason = _CAWriteOffReasonTxt.CAWriteOffReason  -- association [0..1]
LEFT OUTER JOIN I_CADocumentOriginCodeText AS _CADocumentOriginCodeTxt ON CADocumentOriginCode = _CADocumentOriginCodeTxt.CADocumentOriginCode  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountCategoryText AS _ContractAccountCategoryTxt ON contractaccountcategory = _ContractAccountCategoryTxt.ContractAccountCategory AND caapplicationarea = _ContractAccountCategoryTxt.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAMainTransactionText AS _CAMainTransactionTxt ON camaintransaction = _CAMainTransactionTxt.CAMainTransaction AND caapplicationarea = _CAMainTransactionTxt.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CASubTransactionText AS _CASubtransactionTxt ON casubtransaction = _CASubtransactionTxt.CASubTransaction AND camaintransaction = _CASubtransactionTxt.CAMainTransaction AND caapplicationarea = _CASubtransactionTxt.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _DivisionTxt ON division = _DivisionTxt.Division  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentTxt ON segment = _SegmentTxt.Segment  -- association [0..1]
;