SEPMRA_I_ADDRESS

CDS View
13 Fields 2 CDS Views

Address

SEPMRA_I_ADDRESS is a CDS View in S/4HANA. Address. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SEPMRA_C_PD_Address view from Address
SEPMRA_I_PurOrdDeliveryAddress view left_outer Purchase Order Delivery Address

Fields (13)

KeyField CDS FieldsUsed in Views
_Country _Country 1
_Type _Type 1
AddressType AddressType 1
AddressValidityEndDate AddressValidityEndDate 1
AddressValidityStartDate AddressValidityStartDate 1
CityName CityName 1
Country Country 1
FormattedAddress FormattedAddress 1
HouseNumber HouseNumber 1
Latitude Latitude 1
Longitude Longitude 1
PostalCode PostalCode 1
StreetName StreetName 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.

-- Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPMRA_I_ADDRESS (
    _COUNTRY,
    _TYPE,
    ADDRESSTYPE,
    ADDRESSVALIDITYENDDATE,
    ADDRESSVALIDITYSTARTDATE,
    CITYNAME,
    COUNTRY,
    FORMATTEDADDRESS,
    HOUSENUMBER,
    LATITUDE,
    LONGITUDE,
    POSTALCODE,
    STREETNAME
);

Learn More