Srf_UsHelpPayeeAddr

DDL: SRF_USHELPPAYEEADDR SQL: SRFUSHLPPAYEADDR Type: view
3 Fields 1 Data Sources

Helper view for payee address

Srf_UsHelpPayeeAddr is a CDS View that provides data about "Helper view for payee address" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 3 fields.

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (11)

NameTypeDefault
P_PoBoxLoc abap.char( 40 )
P_Country abap.char( 3 )
P_PayeeCity abap.char( 40 )
P_PoBoxRegion abap.char( 3 )
P_PayeeRegion abap.char( 3 )
P_PostalCode1 abap.char( 10 )
P_PostalCode2 abap.char( 10 )
P_POBOX abap.char( 10 )
P_HouseNo abap.char( 10 )
P_Street abap.char( 40 )
P_AprtmntNo abap.char( 10 )

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName SRFUSHLPPAYEADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Helper view for payee address view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (3)

KeyFieldSource TableSource FieldDescription
P_Country1endasPayeeAddress
P_POBOX1endasPartnerStreet_PDF
P_CountryendasPartnerCountry_PDF

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_UsHelpPayeeAddr.
-- 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: SRFUSHLPPAYEADDR
-- Parameters: P_PoBoxLoc : abap.char( 40 ), P_Country : abap.char( 3 ), P_PayeeCity : abap.char( 40 ), P_PoBoxRegion : abap.char( 3 ), P_PayeeRegion : abap.char( 3 ), P_PostalCode1 : abap.char( 10 ), P_PostalCode2 : abap.char( 10 ), P_POBOX : abap.char( 10 ), P_HouseNo : abap.char( 10 ), P_Street : abap.char( 40 ), P_AprtmntNo : abap.char( 10 )

CREATE VIEW Srf_UsHelpPayeeAddr AS
SELECT
  case $parameters.P_Country when 'US' then CONCAT_WITH_SPACE ( CONCAT_WITH_SPACE ( COALESCE( $parameters.P_PoBoxLoc, $parameters.P_PayeeCity ), COALESCE( $parameters.P_PoBoxRegion, $parameters.P_PayeeRegion ),1 ) , COALESCE( $parameters.P_PostalCode1, $parameters.P_PostalCode2 ),1 ) else CONCAT_WITH_SPACE ( CONCAT_WITH_SPACE ( CONCAT_WITH_SPACE ( COALESCE( $parameters.P_PoBoxLoc, $parameters.P_PayeeCity ), COALESCE( $parameters.P_PoBoxRegion, $parameters.P_PayeeRegion ),1 ) ,COALESCE( $parameters.P_PostalCode1, $parameters.P_PostalCode2 ),1 ) ,$parameters.P_Country,1 ) end as PayeeAddress AS P_Country1endasPayeeAddress,
  case $parameters.P_POBOX when '' then case $parameters.P_HouseNo when '' then CONCAT_WITH_SPACE( $parameters.P_Street , $parameters.P_AprtmntNo , 1 ) else concat_WITH_SPACE( $parameters.P_HouseNo , CONCAT_WITH_SPACE( $parameters.P_Street , $parameters.P_AprtmntNo , 1 ) ,1) end else concat_WITH_SPACE('PO Box' , $parameters.P_POBOX , 1) end as PartnerStreet_PDF AS P_POBOX1endasPartnerStreet_PDF,
  case $parameters.P_Country when 'US' then '' else concat($parameters.P_Country, '') end as PartnerCountry_PDF AS P_CountryendasPartnerCountry_PDF
FROM I_SAPClient
;

Learn More