P_BG_SAFTONETIMECUSTOMER
One Time Customer Data for BG SAFT
P_BG_SAFTONETIMECUSTOMER is a CDS View in S/4HANA. One Time Customer Data for BG SAFT. It contains 7 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_BG_SAFTCustomer | view_entity | inner | CONSUMPTION | Customer Data for BG SAFT |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | VATRegistration | TaxID5 | 1 |
| CityName | CityName | 1 | |
| CountryISOCode | CountryISOCode | 1 | |
| CustomerName | CustomerName | 1 | |
| PostalCode | PostalCode | 1 | |
| Region | Region | 1 | |
| StreetName | StreetName | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
define view entity P_BG_SAFTOneTimeCustomer as select from I_BG_SAFTOneTimeCustomer
{
key CompanyCode,
key Customer,
key VATRegistration,
max(CustomerName) as CustomerName,
cast(max(Country) as land1 ) as CountryISOCode,
max(Region) as Region,
max(PostalCode) as PostalCode,
max(CityName) as CityName,
max(StreetName) as StreetName
}
group by
CompanyCode,
Customer,
VATRegistration