I_SAFTDeliveryCustomer

DDL: I_SAFTDELIVERYCUSTOMER SQL: ISAFTDELCUST Type: view BASIC

SAF-T Regular Billing Customers

I_SAFTDeliveryCustomer is a Basic CDS View that provides data about "SAF-T Regular Billing Customers" in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_DeliveryDocument) and exposes 9 fields with key fields DeliveryDocument, ReferenceDocumentNumber.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_Customer Cust inner
I_DeliveryDocument deldoc from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTDELCUST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label SAF-T Regular Billing Customers view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument
KEY ReferenceDocumentNumber ReferenceDocumentNumber
CompanyCode _SalesOrganization CompanyCode
DocumentDate DeliveryDate
Customer ShipToParty
_ShipToParty _ShipToParty
AddressID I_Customer AddressID
Country I_Customer Country
_StandardAddress I_Customer _StandardAddress 
@AbapCatalog.sqlViewName: 'ISAFTDELCUST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'SAF-T Regular Billing Customers'
define view I_SAFTDeliveryCustomer
  as select from I_DeliveryDocument as deldoc
    inner join   I_Customer as Cust on  Cust.Customer         = deldoc.ShipToParty
                                    and Cust.IsOneTimeAccount = ' '             //update 1905


{
  key  DeliveryDocument,
  key  ReferenceDocumentNumber,
      
       _SalesOrganization.CompanyCode,
       
  
       DeliveryDate                   as DocumentDate,
       ShipToParty                            as Customer,

    _ShipToParty,
    Cust.AddressID,
    Cust.Country,
    Cust._StandardAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_DELIVERYDOCUMENT",
"I_SALESORGANIZATION"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTOMER",
"I_DELIVERYDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More