I_SAFTDeliveryOneTimeCustomer

DDL: I_SAFTDELIVERYONETIMECUSTOMER SQL: ISAFTOTDELCUST Type: view COMPOSITE

SAF-T Delivery OneTimeCustomers

I_SAFTDeliveryOneTimeCustomer is a Composite CDS View that provides data about "SAF-T Delivery OneTimeCustomers" in SAP S/4HANA. It reads from 3 data sources (I_SDDocumentCompletePartners, I_DeliveryDocument, I_OneTimeCustomerTaxNumber) and exposes 13 fields with key fields DeliveryDocument, CompanyCode, PartnerFunction.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_SDDocumentCompletePartners Cust inner
I_DeliveryDocument delDoc from
I_OneTimeCustomerTaxNumber Tax left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTOTDELCUST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label SAF-T Delivery OneTimeCustomers view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocument DeliveryDocument
KEY CompanyCode
KEY PartnerFunction I_SDDocumentCompletePartners PartnerFunction
DeliveryDate I_DeliveryDocument DeliveryDate
Customer I_SDDocumentCompletePartners Customer
IsOneTimeAccount I_SDDocumentCompletePartners PartnerIsOneTimeAccount
AddressNumber I_SDDocumentCompletePartners AddressID
AddressID I_SDDocumentCompletePartners AddressID
_Address I_SDDocumentCompletePartners _Address
PhoneNumber
FaxNumber
EmailAddress
WebsiteURL 
@AbapCatalog.sqlViewName: 'ISAFTOTDELCUST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'SAF-T Delivery OneTimeCustomers'

define view I_SAFTDeliveryOneTimeCustomer
  as select from    I_DeliveryDocument           as delDoc
    inner join      I_SDDocumentCompletePartners as Cust on delDoc.DeliveryDocument = Cust.SDDocument
    left outer join I_OneTimeCustomerTaxNumber   as Tax  on  Cust.SDDocument      = Tax.SDDocument
                                                         and Cust.SDDocumentItem  = Tax.SDDocumentItem
                                                         and Cust.PartnerFunction = Tax.PartnerFunction
{
  key  delDoc.DeliveryDocument                                                   as DeliveryDocument,
  key  delDoc._SalesOrganization.CompanyCode                                     as CompanyCode,
  key  Cust.PartnerFunction                                                      as PartnerFunction,
       delDoc.DeliveryDate                                                       as DeliveryDate,
       Cust.Customer                                                             as Customer,
       Cust.PartnerIsOneTimeAccount                                              as IsOneTimeAccount,

       //case

       //  when delDoc._ShipToParty.VATRegistration is initial or delDoc._ShipToParty.VATRegistration is null

       //    then Tax.TaxNumber1

       //    else substring(delDoc._ShipToParty.VATRegistration,3,18)

       //end as CustomerVATRegistration,


       case
         when PartnerIsOneTimeAccount = 'X'
             then substring(Cust.VATRegistration,3,18)
         else
             '9999999990'
       end                                                                       as CustomerVATRegistration,

       Cust.AddressID                                                            as AddressNumber,
       Cust.AddressID,

       Cust._Address,


       Cust._Address._DefaultPhoneNumber.PhoneNumber                             as PhoneNumber,
       Cust._Address._DefaultFaxNumber.FaxNumber                                 as FaxNumber,
       Cust._Address._DefaultEmailAddress.EmailAddress                           as EmailAddress,
       cast(lower(Cust._Address._DefaultURLAddress.SearchURLAddress) as ad_uri2) as WebsiteURL

}
where
  PartnerIsOneTimeAccount = 'X'

Learn More