I_SupplierOrAddressContactCard

DDL: I_SUPPLIERORADDRESSCONTACTCARD SQL: ISUPLRADRCTC Type: view COMPOSITE Package: VDM_CC_CDS
21 Fields 2 Data Sources

Supplier or Address Contact Card

I_SupplierOrAddressContactCard is a Composite CDS View that provides data about "Supplier or Address Contact Card" in SAP S/4HANA. It reads from 2 data sources (I_AddressContactCard, I_SuplrContactCard) and exposes 21 fields with key fields ContactCardID, ContactCardRole, ContactCardType, ContactCardRole, ContactCardType. Part of development package VDM_CC_CDS.

Data Sources (2)

SourceAliasJoin Type
I_AddressContactCard _Address union_all
I_SuplrContactCard _Supplier from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISUPLRADRCTC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Supplier or Address Contact Card view
ObjectModel.representativeKey ContactCardID view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality C view
ObjectModel.usageType.sizeCategory #L view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID I_SuplrContactCard ContactCardID Vendor no.
KEY ContactCardRole I_SuplrContactCard ContactCardRole
KEY ContactCardType I_SuplrContactCard ContactCardType
FullName I_SuplrContactCard FullName Name
AddressID I_SuplrContactCard AddressID Ship-to address
PhoneNumber I_SuplrContactCard PhoneNumber Telephone no.
MobilePhoneNumber I_SuplrContactCard MobilePhoneNumber Telephone
EmailAddress I_SuplrContactCard EmailAddress E-Mail Address
Country I_SuplrContactCard Country Venue: Ctry/Reg
ContactCardNavLinkSemanticObj I_SuplrContactCard ContactCardNavLinkSemanticObj
ContactCardID Vendor no.
KEY ContactCardRole I_AddressContactCard ContactCardRole
KEY ContactCardType I_AddressContactCard ContactCardType
FullName I_AddressContactCard FullName Name
AddressID I_AddressContactCard AddressID Ship-to address
PhoneNumber I_AddressContactCard PhoneNumber Telephone no.
MobilePhoneNumber I_AddressContactCard MobilePhoneNumber Telephone
EmailAddress I_AddressContactCard EmailAddress E-Mail Address
Country I_AddressContactCard Country Venue: Ctry/Reg
ContactCardNavLinkSemanticObj I_AddressContactCard ContactCardNavLinkSemanticObj
ContactCardNavLinkQueryPart I_AddressContactCard ContactCardNavLinkQueryPart

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_SupplierOrAddressContactCard.
-- 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: ISUPLRADRCTC

CREATE VIEW I_SupplierOrAddressContactCard AS
SELECT
  _Supplier.ContactCardID AS ContactCardID,
  _Supplier.ContactCardRole AS ContactCardRole,
  _Supplier.ContactCardType AS ContactCardType,
  _Supplier.FullName AS FullName,
  _Supplier.AddressID AS AddressID,
  _Supplier.PhoneNumber AS PhoneNumber,
  _Supplier.MobilePhoneNumber AS MobilePhoneNumber,
  _Supplier.EmailAddress AS EmailAddress,
  _Supplier.Country AS Country,
  _Supplier.ContactCardNavLinkSemanticObj AS ContactCardNavLinkSemanticObj,
  _Address.ContactCardNavLinkQueryPart AS ContactCardNavLinkQueryPart
FROM I_SuplrContactCard AS _Supplier
-- UNION ALL with additional select branch(es): I_AddressContactCard
;

Learn More