P_PT_SAFTTAXLAND

DDL: P_PT_SAFTTAXLAND SQL: PPTSAFTPAYLAND Type: view COMPOSITE

P_PT_SAFTTAXLAND is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SAFTCustTaxRegnNmbr, I_Customer) and exposes 3 fields with key field Customer.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_SAFTCustTaxRegnNmbr a from
I_Customer b inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPTSAFTPAYLAND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Customer I_SAFTCustTaxRegnNmbr CustomerNum
CustomerCountry
CustomerHasMultiTaxRegnNumber 
@AbapCatalog.sqlViewName: 'PPTSAFTPAYLAND'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE 
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking : #NOT_REQUIRED
define view P_PT_SAFTTAXLAND as select from I_SAFTCustTaxRegnNmbr as a

   inner join I_Customer as b on b.Customer = a.CustomerNum   
  
{

   key  a.CustomerNum as Customer,  
   
   max(b.Country) as CustomerCountry,
      
   'X' as CustomerHasMultiTaxRegnNumber 
          
}group by a.CustomerNum

Learn More