Srf_UsHelpPayeeAddr

DDL: SRF_USHELPPAYEEADDR SQL: SRFUSHLPPAYEADDR Type: view

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.

1 data source(s) 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 
@AbapCatalog.sqlViewName: 'SRFUSHLPPAYEADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Helper view for payee address'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED

define view Srf_UsHelpPayeeAddr
  with 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 )

  as select from I_SAPClient
{

  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,

  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,



  // City or Town, Province or State, Country, and Zip or foreign postal code

  CONCAT_WITH_SPACE( COALESCE( $parameters.P_PoBoxLoc, $parameters.P_PayeeCity ) ,
                              (CONCAT_WITH_SPACE ( COALESCE( $parameters.P_PoBoxRegion, $parameters.P_PayeeRegion ),
                                                  COALESCE( $parameters.P_PostalCode1 ,$parameters.P_PostalCode2 ),1 )), 1 )

                                                                                                                             as PartnerCityRegionCode_PDF,



  // Country

  case  $parameters.P_Country
  when  'US'
  then ''
  else
    concat($parameters.P_Country, '')
    end                                                                                                                      as PartnerCountry_PDF
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More