I_SDDocumentCustomer

DDL: I_SDDOCUMENTCUSTOMER SQL: ISDDOCCUSTOMER Type: view BASIC
17 Fields 1 Data Sources

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.

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 SD Document
KEY PartnerFunction I_SDDocumentPartner PartnerFunction Partner Functn
Customer Customer Sold-to Party
ReferenceBusinessPartner ReferenceBusinessPartner Busn. Partner
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address Type
SDDocPartnerAddressRefType SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific
_PartnerFunction _PartnerFunction
_Customer _Customer
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SDDocumentCustomer.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISDDOCCUSTOMER

CREATE VIEW I_SDDocumentCustomer AS
SELECT
  SDDocument,
  Partner.PartnerFunction AS PartnerFunction,
  Customer,
  ReferenceBusinessPartner,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  SDDocPartnerAddrIsDocSpecific
FROM I_SDDocumentPartner AS Partner
;

Learn More