PPS_PR_DELADDR_D

Transparent Table Application Table
60 Fields 1 CDS Views

Draft table for entity R_PPS_PURCHASEREQNDELIVADDRTP

PPS_PR_DELADDR_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASEREQNDELIVADDRTP. It contains 60 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurReqnDelivAddrDraft view from BASIC Purchase Reqn Delivery Address - Draft

Fields (60)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchaserequisition vdm_purchaserequisition Purch.Reqn.
KEY purchaserequisitionitem vdm_purchaserequisitionitem Requisn. item
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
addresstype purreqnaddrtype Address Type
addressid ad_addrnum Address Number
plant ewerk Plant
storagelocation lgort_d Location
manualdeliveryaddressid adrnr_mm Address
itemdeliveryaddressid adrn2 Address
careofname ad_name_co c/o
additionalstreetsuffixname ad_lctn Street 5
correspondencelanguage spras Language
prfrdcommmediumtype ad_comm Comm. Method
pobox ad_pobx PO Box
poboxiswithoutnumber ad_pobxnum PO Box w/o No.
poboxpostalcode ad_pstcd2 PO Box Post Cde
poboxlobbyname ad_po_box_lby PO Box Lobby
poboxdeviatingcityname ad_pobxloc PO Box City
poboxdeviatingregion ad_pobxreg PO Region
poboxdeviatingcountry ad_pobxcty PO Box C/R
deliveryservicetypecode ad_delivery_service_type Delvry Serv Type
deliveryservicenumber ad_delivery_service_number Delivery Service No.
addresstimezone ad_tzone Time Zone
fullname ad_namtext Full Name
cityname ad_city1 City
district ad_city2 District
citycode ad_citynum City Code
homecityname ad_city3 Different City
postalcode ad_pstcd1 Postal Code
companypostalcode ad_pstcd3 Company Post Cd
streetname ad_street Street
streetprefixname ad_strspp1 Street 2
additionalstreetprefixname ad_strspp2 Street 3
streetsuffixname ad_strspp3 Street 4
housenumber ad_hsnm1 House Number
housenumbersupplementtext ad_hsnm2 Supplement
building ad_bldng Building Code
floor ad_floor Floor
roomnumber ad_roomnum Room Number
country land1 Country/Reg.
region regio Region
county ad_county County
formofaddress ad_title Title Key
businesspartnername1 ad_name1 Name
businesspartnername2 ad_name2 Name 2
nation ad_nation Address Version
phonenumber ad_tlnmbr Telephone
faxnumber ad_fxnmbr Fax
searchterm1 ad_sort1 Search Term 1
businesspartnername3 ad_name3 Name 3
businesspartnername4 ad_name4 Name 4
taxjurisdiction ad_txjcd Tax Jurisdiction
transportzone lzone Transport Zone
person ad_persnum Person Number
planttext werks_name Plant Name
requesteddeliverydate eindt Delivery Date
addresstypedesc val_text Short Description
purchasereqndraftuuid sdraft_uuid Draft Document ID

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_PPS_PURCHASEREQNDELIVADDRTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PR_DELADDR_D (
    MANDT,                       -- Client [mandt]
    PURCHASEREQUISITION,         -- Purch.Reqn. [vdm_purchaserequisition]
    PURCHASEREQUISITIONITEM,     -- Requisn. item [vdm_purchaserequisitionitem]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    ADDRESSTYPE,                 -- Address Type [purreqnaddrtype]
    ADDRESSID,                   -- Address Number [ad_addrnum]
    PLANT,                       -- Plant [ewerk]
    STORAGELOCATION,             -- Location [lgort_d]
    MANUALDELIVERYADDRESSID,     -- Address [adrnr_mm]
    ITEMDELIVERYADDRESSID,       -- Address [adrn2]
    CAREOFNAME,                  -- c/o [ad_name_co]
    ADDITIONALSTREETSUFFIXNAME,  -- Street 5 [ad_lctn]
    CORRESPONDENCELANGUAGE,      -- Language [spras]
    PRFRDCOMMMEDIUMTYPE,         -- Comm. Method [ad_comm]
    POBOX,                       -- PO Box [ad_pobx]
    POBOXISWITHOUTNUMBER,        -- PO Box w/o No. [ad_pobxnum]
    POBOXPOSTALCODE,             -- PO Box Post Cde [ad_pstcd2]
    POBOXLOBBYNAME,              -- PO Box Lobby [ad_po_box_lby]
    POBOXDEVIATINGCITYNAME,      -- PO Box City [ad_pobxloc]
    POBOXDEVIATINGREGION,        -- PO Region [ad_pobxreg]
    POBOXDEVIATINGCOUNTRY,       -- PO Box C/R [ad_pobxcty]
    DELIVERYSERVICETYPECODE,     -- Delvry Serv Type [ad_delivery_service_type]
    DELIVERYSERVICENUMBER,       -- Delivery Service No. [ad_delivery_service_number]
    ADDRESSTIMEZONE,             -- Time Zone [ad_tzone]
    FULLNAME,                    -- Full Name [ad_namtext]
    CITYNAME,                    -- City [ad_city1]
    DISTRICT,                    -- District [ad_city2]
    CITYCODE,                    -- City Code [ad_citynum]
    HOMECITYNAME,                -- Different City [ad_city3]
    POSTALCODE,                  -- Postal Code [ad_pstcd1]
    COMPANYPOSTALCODE,           -- Company Post Cd [ad_pstcd3]
    STREETNAME,                  -- Street [ad_street]
    STREETPREFIXNAME,            -- Street 2 [ad_strspp1]
    ADDITIONALSTREETPREFIXNAME,  -- Street 3 [ad_strspp2]
    STREETSUFFIXNAME,            -- Street 4 [ad_strspp3]
    HOUSENUMBER,                 -- House Number [ad_hsnm1]
    HOUSENUMBERSUPPLEMENTTEXT,   -- Supplement [ad_hsnm2]
    BUILDING,                    -- Building Code [ad_bldng]
    FLOOR,                       -- Floor [ad_floor]
    ROOMNUMBER,                  -- Room Number [ad_roomnum]
    COUNTRY,                     -- Country/Reg. [land1]
    REGION,                      -- Region [regio]
    COUNTY,                      -- County [ad_county]
    FORMOFADDRESS,               -- Title Key [ad_title]
    BUSINESSPARTNERNAME1,        -- Name [ad_name1]
    BUSINESSPARTNERNAME2,        -- Name 2 [ad_name2]
    NATION,                      -- Address Version [ad_nation]
    PHONENUMBER,                 -- Telephone [ad_tlnmbr]
    FAXNUMBER,                   -- Fax [ad_fxnmbr]
    SEARCHTERM1,                 -- Search Term 1 [ad_sort1]
    BUSINESSPARTNERNAME3,        -- Name 3 [ad_name3]
    BUSINESSPARTNERNAME4,        -- Name 4 [ad_name4]
    TAXJURISDICTION,             -- Tax Jurisdiction [ad_txjcd]
    TRANSPORTZONE,               -- Transport Zone [lzone]
    PERSON,                      -- Person Number [ad_persnum]
    PLANTTEXT,                   -- Plant Name [werks_name]
    REQUESTEDDELIVERYDATE,       -- Delivery Date [eindt]
    ADDRESSTYPEDESC,             -- Short Description [val_text]
    PURCHASEREQNDRAFTUUID,       -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, DRAFTUUID)
);

Learn More