Srf_Ushlp1042pdf

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 Srf_Ushlp1042pdf.
-- 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: SRFUSHLP1042PDF
-- Parameters: P_Qscod : abap.char( 4 ), P_WhldgTaxReferenceText : abap.char(4), P_Payername1 : abap.char(30), P_Payername2 : abap.char(30), P_RecipientName1 : abap.char(40), P_RecipientName2 : abap.char(40), P_PayerCtry : abap.char(15), P_Payercity : abap.char(25), P_Payerpostalcode : abap.char(10), P_Payerregion : abap.char(3), P_HouseNumber : abap.char(10), P_Street : abap.char(60), P_City : abap.char(40), P_Region : abap.char(3), P_PostCode : abap.char(10), P_Country : abap.char(3)

CREATE VIEW Srf_Ushlp1042pdf AS
SELECT
  concat_with_space($parameters.P_Payername1,$parameters.P_Payername2,1) AS PayerName,
  case $parameters.P_RecipientName1 when ' ' then concat($parameters.P_RecipientName2,'') else concat_with_space ($parameters.P_RecipientName1,$parameters.P_RecipientName2,1) end as RecipientName AS P_RecipientName21endasRecipientName,
  concat_with_space($parameters.P_Payercity,concat_with_space($parameters.P_Payerregion,concat_with_space($parameters.P_PayerCtry,$parameters.P_Payerpostalcode,1),1),1) AS PayerCityPostalCode,
  concat_with_space($parameters.P_HouseNumber,$parameters.P_Street,1) AS PayerAddress,
  case $parameters.P_City when' ' then case $parameters.P_Region when ' ' then ' ' else concat($parameters.P_Region, ' ') end else concat_with_space ($parameters.P_City, $parameters.P_Region, 1 ) end as CityState AS P_Region1endasCityState,
  case $parameters.P_Country when' ' then case $parameters.P_PostCode when ' ' then ' ' else concat($parameters.P_PostCode, ' ') end else concat_with_space ($parameters.P_Country, $parameters.P_PostCode, 1 ) end as CountryPostalCode AS P_PostCode1endasCountryPostalCode
FROM I_SAPClient
;