I_SDDocumentCustomer

DDL: I_SDDOCUMENTCUSTOMER SQL: ISDDOCCUSTOMER Type: view BASIC

SD Document Customer

I_SDDocumentCustomer is a Basic CDS View that provides data about "SD Document Customer" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentPartner) and exposes 17 fields with key fields SDDocument, PartnerFunction.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentPartner Partner from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label SD Document Customer view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName ISDDOCCUSTOMER view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SDDocument SDDocument
KEY PartnerFunction I_SDDocumentPartner PartnerFunction
Customer Customer
ReferenceBusinessPartner ReferenceBusinessPartner
AddressID AddressID
AddressPersonID AddressPersonID
AddressObjectType AddressObjectType
SDDocPartnerAddressRefType SDDocPartnerAddressRefType
BPAddrDeterminationTransaction BPAddrDeterminationTransaction
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific
_PartnerFunction _PartnerFunction
_Customer _Customer
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED 
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L 
@EndUserText.label: 'SD Document Customer'
@VDM.viewType: #BASIC
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ],
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog.sqlViewName: 'ISDDOCCUSTOMER'

define view I_SDDocumentCustomer

as select from I_SDDocumentPartner as Partner

association[0..1] to I_Customer as _Customer
  on $projection.Customer = _Customer.Customer
{
  key SDDocument,
  @ObjectModel.foreignKey.association: '_PartnerFunction'
  key Partner.PartnerFunction as PartnerFunction,
    
  @ObjectModel.foreignKey.association: '_Customer'
  Customer,

  ReferenceBusinessPartner,

  @ObjectModel.foreignKey.association: '_Address'
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  
  SDDocPartnerAddrIsDocSpecific,
    
  _PartnerFunction,
  _Customer,
    
  _Address,
  _DfltAddrRprstn,
  _BusinessPartnerAddress,
  _BPRefAddressForDocSpcfcAddr
}
where _PartnerFunction.SDDocumentPartnerType = 'KU';
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PARTNERFUNCTION",
"I_SDDOCUMENTPARTNER"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_BUSPARTADDRESS",
"I_CUSTOMER",
"I_PARTNERFUNCTION"
],
"BASE":
[
"I_SDDOCUMENTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More