P_NO_SAFTSUPADDR

DDL: P_NO_SAFTSUPADDR SQL: PNOSAFTSUPADM Type: view COMPOSITE

P_NO_SAFTSUPADDR is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SAFTGenLedgerOneTimeSupplier) and exposes 22 fields with key fields CompanyCode, Supplier, VATRegistration.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_SAFTGenLedgerOneTimeSupplier I_SAFTGenLedgerOneTimeSupplier from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PNOSAFTSUPADM 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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Supplier Supplier
KEY VATRegistration VATRegistration
CompanyName CompanyName
StreetAddressName StreetAddressName
StreetPrefixName StreetPrefixName
AdditionalStreetPrefixName AdditionalStreetPrefixName
StreetSuffixName StreetSuffixName
AdditionalStreetSuffixName AdditionalStreetSuffixName
HouseNumber HouseNumber
CityName CityName
PostalCode PostalCode
Country Country
Region Region
POBox POBox
POBoxPostalCode POBoxPostalCode
AddressID AddressID
PostingDate
PhoneNumber
FaxNumber
EmailAddress
WebsiteURL 
@AbapCatalog.sqlViewName: 'PNOSAFTSUPADM'
@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
define view P_NO_SAFTSUPADDR 
as select from I_SAFTGenLedgerOneTimeSupplier
{
  key CompanyCode,
  key Supplier,
  key VATRegistration,

      CompanyName,
      StreetAddressName,
      StreetPrefixName,
      AdditionalStreetPrefixName,
      StreetSuffixName,
      AdditionalStreetSuffixName,
      HouseNumber,
      CityName,
      PostalCode,
      Country,
      Region,
      POBox,
      POBoxPostalCode,
      AddressID,
      max(PostingDate) as PostingDate,
      
      _Address._DefaultPhoneNumber.PhoneNumber as PhoneNumber,
      _Address._DefaultFaxNumber.FaxNumber as FaxNumber,
      _Address._DefaultEmailAddress.EmailAddress as EmailAddress,
      _Address._DefaultURLAddress.SearchURLAddress as WebsiteURL
}
where
  VATRegistration is not initial
group by
  CompanyCode,
  Supplier,
  VATRegistration,
  CompanyName,
  StreetAddressName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  HouseNumber,
  CityName,
  PostalCode,
  Country,
  Region,
  POBox,
  POBoxPostalCode,
  AddressID,
  _Address._DefaultPhoneNumber.PhoneNumber,
  _Address._DefaultFaxNumber.FaxNumber,
  _Address._DefaultEmailAddress.EmailAddress,
  _Address._DefaultURLAddress.SearchURLAddress
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_ADDRESSEMAILADDRESS",
"I_ADDRESSFAXNUMBER",
"I_ADDRESSHOMEPAGEURL",
"I_ADDRESSPHONENUMBER",
"I_SAFTGENLEDGERONETIMESUPPLIER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More