WFP_D_WAPRAD_DFT

Transparent Table Application Table
18 Fields 1 CDS Views

Draft table for entity R_WORKASSGMTPRIVATEADDRESSTP

WFP_D_WAPRAD_DFT is an SAP database table in S/4HANA. Draft table for entity R_WORKASSGMTPRIVATEADDRESSTP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WrkAssgmtPrivateAddressDraft view_entity from BASIC View for the Draft Table wfp_d_waprad_dft

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workassignmentuuid bu_partner_guid BP GUID
KEY addressnumber ad_addrnum Address Number
validityenddate endda End Date
validitystartdate begda Start Date
housenumber ad_hsnm1 House Number
streetname ad_street Street
housenumbersupplementtext ad_hsnm2 Supplement
districtname ad_city2 District
postalcode ad_pstcd1 Postal Code
cityname ad_city1 City
country land1 Country/Reg.
region regio Region
pobox ad_pobx PO Box
poboxpostalcode ad_pstcd2 PO Box Post Cde
floor ad_floor Floor
roomnumber ad_roomnum Room Number
personuuid bu_partner_guid BP GUID

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 entity R_WORKASSGMTPRIVATEADDRESSTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFP_D_WAPRAD_DFT (
    MANDT,                      -- Client [mandt]
    WORKASSIGNMENTUUID,         -- BP GUID [bu_partner_guid]
    ADDRESSNUMBER,              -- Address Number [ad_addrnum]
    VALIDITYENDDATE,            -- End Date [endda]
    VALIDITYSTARTDATE,          -- Start Date [begda]
    HOUSENUMBER,                -- House Number [ad_hsnm1]
    STREETNAME,                 -- Street [ad_street]
    HOUSENUMBERSUPPLEMENTTEXT,  -- Supplement [ad_hsnm2]
    DISTRICTNAME,               -- District [ad_city2]
    POSTALCODE,                 -- Postal Code [ad_pstcd1]
    CITYNAME,                   -- City [ad_city1]
    COUNTRY,                    -- Country/Reg. [land1]
    REGION,                     -- Region [regio]
    POBOX,                      -- PO Box [ad_pobx]
    POBOXPOSTALCODE,            -- PO Box Post Cde [ad_pstcd2]
    FLOOR,                      -- Floor [ad_floor]
    ROOMNUMBER,                 -- Room Number [ad_roomnum]
    PERSONUUID,                 -- BP GUID [bu_partner_guid]
    PRIMARY KEY (MANDT, WORKASSIGNMENTUUID, ADDRESSNUMBER)
);

Learn More