I_AllocationSenderBasisUpldTP

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_AllocationSenderBasisUpldTP.
-- 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: ALLOUPLSNDRBSTP

CREATE VIEW I_AllocationSenderBasisUpldTP AS
SELECT
  AllocationUploadRowUUID,
  UploadUUID,
  RowIndex,
  AllocationCycle,
  AllocationType,
  Ledger,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationFieldName,
  AllocationFieldText,
  AllocationFieldMinimumValue,
  AllocationFieldMaximumValue,
  AllocationSetId,
  UploadedByUser,
  UploadCreationDateTime,
  cast('' as fco_alloc_shlp_entity_name) AS AllocationSearchHelpEntityName,
  cast('' as domname) AS AllocationSearchHelpOutput,
  cast('' as fco_group_shlp_entity_name) AS GroupValueHelpEntityName,
  cast('' as domname) AS GroupValueHelpOutput,
  cast('' as domname) AS GroupValueHelpOutputText
FROM I_AllocationSenderBasisUpload
LEFT OUTER JOIN I_AllocationFileUploadTP AS _File ON UploadUUID = _File.UploadUUID  -- association [1..1]
LEFT OUTER JOIN I_AllocationCycleUpload AS _AllocationCycle ON AllocationType = _AllocationCycle.AllocationType AND AllocationCycle = _AllocationCycle.AllocationCycle AND AllocationCycleStartDate = _AllocationCycle.AllocationCycleStartDate AND UploadUUID = _AllocationCycle.UploadUUID  -- association [0..1]
;