I_ADDRESSFAXNUMBER_2

CDS View
11 Fields 9 CDS Views

Fax Number

I_ADDRESSFAXNUMBER_2 is a CDS View in S/4HANA. Fax Number. It contains 11 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
/SCMTMS/VE_LocQuByPhysAdd view_entity left_outer BOPF: Location Query By Physical Address
C_Arberp_Address view left_outer CONSUMPTION CDS View for Addresses
I_AddrCurDefaultFaxNumber view_entity from BASIC Current Default Fax Number
I_BPAddressIndependentFax view from BASIC BP Address independent Fax
I_BPContactFaxNmbrTP view inner TRANSACTIONAL BO view for BP contact Fax number
I_BPFaxNumber view from BASIC BP Fax number core view
I_BPRelshpCntctPersnFaxNmbrTP view_entity inner TRANSACTIONAL BO view for Contact Person Fax Number
R_AddressFaxNumberTP view_entity from Fax Number - TP
R_FaxNumberTP view_entity from TRANSACTIONAL Fax Number - TP

Fields (11)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY AddressPersonID Person 1
KEY CommMediumSequenceNumber OrdinalNumber,OrdinalNumberForEdit 3
_AddressCommunicationRemark _AddressCommunicationRemark 1
_FaxNumberCountry _FaxNumberCountry 1
CommLineNotForUnsolicitedCntct CommNumberIsNotUsed 2
FaxAreaCodeSubscriberNumber fax_subscriber_id,FaxNumber 4
FaxExtensionNumber fax_extension_id,FaxNumberExtension 4
FaxNumberCountry fax_country_code,FaxCountry 4
FaxNumberIsCurrentDefault IsDefaultFaxNumber 3
InternationalFaxNumber InternationalFaxNumber 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fax Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSFAXNUMBER_2 (
    ADDRESSID,
    ADDRESSPERSONID,
    COMMMEDIUMSEQUENCENUMBER,
    _ADDRESSCOMMUNICATIONREMARK,
    _FAXNUMBERCOUNTRY,
    COMMLINENOTFORUNSOLICITEDCNTCT,
    FAXAREACODESUBSCRIBERNUMBER,
    FAXEXTENSIONNUMBER,
    FAXNUMBERCOUNTRY,
    FAXNUMBERISCURRENTDEFAULT,
    INTERNATIONALFAXNUMBER,
    PRIMARY KEY (ADDRESSID, ADDRESSPERSONID, COMMMEDIUMSEQUENCENUMBER)
);

Learn More