P_PT_SAFTCUSTMAX

CDS View

P_PT_SAFTCUSTMAX is a CDS View in S/4HANA. 5 CDS views read from this table.

Used by 5 CDS view(s)

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PT_SAFTAcctgOneTimeCustomer view left_outer COMPOSITE SAF-T PT Accounting One Time Customer
I_PT_SAFTBillingOneTimeCust view left_outer COMPOSITE SAF-T PT Billing One Time Custmer
I_PT_SAFTDeliveryOneTimeCust view left_outer COMPOSITE SAF-T PT Billing One Time Custmer
I_PT_SAFTGenLedgerOneTimeCust view left_outer COMPOSITE SAF-T PT Gen Ledger OneTimeCustomer
I_PT_SAFTPaymentOneTimeCust view left_outer COMPOSITE SAF-T Payment One Time Customer 
@AbapCatalog.sqlViewName: 'PPTSAFTCUSTM'
@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_SAFTCUSTMAX
  as select from P_PT_SAFTCUSTADDR
{
  key CompanyCode,
  key Customer,
  key CustomerVATRegistration,

      max(CompanyName)                as CompanyName,
      max(StreetName)                 as StreetName,
      max(StreetPrefixName)           as StreetPrefixName,
      max(AdditionalStreetPrefixName) as AdditionalStreetPrefixName,
      max(StreetSuffixName)           as StreetSuffixName,
      max(AdditionalStreetSuffixName) as AdditionalStreetSuffixName,
      max(HouseNumber)                as HouseNumber,
      max(CityName)                   as CityName,
      max(Region)                     as Region,
      max(PostalCode)                 as PostalCode,
      max(Country)                    as Country,
      max(AddressID)                  as AddressID,
      max(PostingDate)                as PostingDate,
      max(PhoneNumber)                as PhoneNumber,
      max(FaxNumber)                  as FaxNumber,
      max(EmailAddress)               as EmailAddress,
      max(WebsiteURL)                 as WebsiteURL  
}
group by
  CompanyCode,
  Customer,
  CustomerVATRegistration
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PT_SAFTCUSTADDR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More