MMSRCGPADDR_D

Transparent Table Application Table
37 Fields 1 CDS Views

Draft Table for R_SrcgProjDeliveryAddressTP

MMSRCGPADDR_D is an SAP database table in S/4HANA. Draft Table for R_SrcgProjDeliveryAddressTP. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SrcgProjItmDlvAddressDraft view_entity from BASIC Dlv Address for Item in SrcPrj - Draft

Fields (37)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY srcgprojaddressuuid vdm_sourcingprojectaddressuuid Delivery Address UUID
srcgprojaddressid vdm_sourcingprojectaddressid Address Number in Sourcing Project
addressid ad_addrnum Address Number
sourcingprojectuuid vdm_sourcingprojectuuid Sourcing Project UUID
sourcingprojectitemuuid vdm_sourcingprojectitemuuid Item UUID
pobox ad_pobx PO Box
poboxpostalcode ad_pstcd2 PO Box Post Cde
fullname caaddr_fullname Name
cityname ad_city1 City
district ad_city2 District
districtname ad_city2 District
postalcode ad_pstcd1 Postal Code
streetname ad_street Street
housenumber ad_hsnm1 House Number
building ad_bldng Building Code
floor ad_floor Floor
roomnumber ad_roomnum Room Number
country caaddr_country Country/Region
region regio Region
county ad_county County
secondaryregionname ad_county County
formofaddress ad_title Title Key
phonenumber caaddr_phonenr Phone
faxnumber telfx Fax Number
addresstype bu_adrkind Address Type
addressownerobjectid vdm_addressownerobjectid Object ID of Address Owner
addressischangedmanually vdm_addressischangedmanually Address Is Changed Manually
activeaddressismanual vdm_activeaddressismanual Active Address Is Manual
addressownertablename ad_appltab Applic. table
addressownerfieldname ad_applfld Field
referenceaddressid vdm_referenceaddressid Reference Address ID
referenceobjectid vdm_referenceobjectid Reference Object ID
referenceaddresstype vdm_referenceaddresstype Reference Address Type
emailaddress caaddr_smtpadr E-Mail
sourcingorigin vdm_sourcingorigin Sourcing Origin
sourcingscenario vdm_sourcingscenario Integration Scenario

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.

-- Draft Table for R_SrcgProjDeliveryAddressTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMSRCGPADDR_D (
    MANDT,                     -- Client [mandt]
    SRCGPROJADDRESSUUID,       -- Delivery Address UUID [vdm_sourcingprojectaddressuuid]
    SRCGPROJADDRESSID,         -- Address Number in Sourcing Project [vdm_sourcingprojectaddressid]
    ADDRESSID,                 -- Address Number [ad_addrnum]
    SOURCINGPROJECTUUID,       -- Sourcing Project UUID [vdm_sourcingprojectuuid]
    SOURCINGPROJECTITEMUUID,   -- Item UUID [vdm_sourcingprojectitemuuid]
    POBOX,                     -- PO Box [ad_pobx]
    POBOXPOSTALCODE,           -- PO Box Post Cde [ad_pstcd2]
    FULLNAME,                  -- Name [caaddr_fullname]
    CITYNAME,                  -- City [ad_city1]
    DISTRICT,                  -- District [ad_city2]
    DISTRICTNAME,              -- District [ad_city2]
    POSTALCODE,                -- Postal Code [ad_pstcd1]
    STREETNAME,                -- Street [ad_street]
    HOUSENUMBER,               -- House Number [ad_hsnm1]
    BUILDING,                  -- Building Code [ad_bldng]
    FLOOR,                     -- Floor [ad_floor]
    ROOMNUMBER,                -- Room Number [ad_roomnum]
    COUNTRY,                   -- Country/Region [caaddr_country]
    REGION,                    -- Region [regio]
    COUNTY,                    -- County [ad_county]
    SECONDARYREGIONNAME,       -- County [ad_county]
    FORMOFADDRESS,             -- Title Key [ad_title]
    PHONENUMBER,               -- Phone [caaddr_phonenr]
    FAXNUMBER,                 -- Fax Number [telfx]
    ADDRESSTYPE,               -- Address Type [bu_adrkind]
    ADDRESSOWNEROBJECTID,      -- Object ID of Address Owner [vdm_addressownerobjectid]
    ADDRESSISCHANGEDMANUALLY,  -- Address Is Changed Manually [vdm_addressischangedmanually]
    ACTIVEADDRESSISMANUAL,     -- Active Address Is Manual [vdm_activeaddressismanual]
    ADDRESSOWNERTABLENAME,     -- Applic. table [ad_appltab]
    ADDRESSOWNERFIELDNAME,     -- Field [ad_applfld]
    REFERENCEADDRESSID,        -- Reference Address ID [vdm_referenceaddressid]
    REFERENCEOBJECTID,         -- Reference Object ID [vdm_referenceobjectid]
    REFERENCEADDRESSTYPE,      -- Reference Address Type [vdm_referenceaddresstype]
    EMAILADDRESS,              -- E-Mail [caaddr_smtpadr]
    SOURCINGORIGIN,            -- Sourcing Origin [vdm_sourcingorigin]
    SOURCINGSCENARIO,          -- Integration Scenario [vdm_sourcingscenario]
    PRIMARY KEY (MANDT, SRCGPROJADDRESSUUID)
);

Learn More