PPS_PO_DELADDR_D

Transparent Table Application Table
30 Fields 1 CDS Views

Draft table for entity R_PPS_PURORDITMDELIVADDRESSTP

PPS_PO_DELADDR_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURORDITMDELIVADDRESSTP. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurOrdItmDelivAddrDrft view_entity from BASIC PurchaseOrder Item Del Address - Draft

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchaseorder ebeln Purchasing Doc.
KEY purchaseorderitem vdm_purchaseorderitem Purchase Order Item
KEY deliveryaddressid adrnr_mm Address
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
addressid ad_addrnum Address Number
referencedeliveryaddressid adrn2 Address
addresspersonid ad_persnum Person Number
organizationname1 ad_name1 Name
organizationname2 ad_name2 Name 2
cityname ad_city1 City
districtname ad_city2 District
postalcode ad_pstcd1 Postal Code
companypostalcode ad_pstcd3 Company Post Cd
streetname ad_street Street
housenumber ad_hsnm1 House Number
country land1 Country/Reg.
region regio Region
formofaddress ad_title Title Key
taxjurisdiction ad_txjcd Tax Jurisdiction
addressrepresentationcode ad_nation Address Version
correspondencelanguage spras Language
prfrdcommmediumtype ad_comm Comm. Method
purchasingdeliveryaddresstype purreqnaddrtype Address Type
emailaddress ad_smtpadr E-Mail Address
internationalphonenumber ad_telnrlg Telephone no.
internationalfaxnumber ad_fxnrlng Fax Number
ppsfieldchangeindicatorbinary pps_e_control_flag Control
purchaseorderdraftuuid 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_PURORDITMDELIVADDRESSTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PO_DELADDR_D (
    MANDT,                          -- Client [mandt]
    PURCHASEORDER,                  -- Purchasing Doc. [ebeln]
    PURCHASEORDERITEM,              -- Purchase Order Item [vdm_purchaseorderitem]
    DELIVERYADDRESSID,              -- Address [adrnr_mm]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    ADDRESSID,                      -- Address Number [ad_addrnum]
    REFERENCEDELIVERYADDRESSID,     -- Address [adrn2]
    ADDRESSPERSONID,                -- Person Number [ad_persnum]
    ORGANIZATIONNAME1,              -- Name [ad_name1]
    ORGANIZATIONNAME2,              -- Name 2 [ad_name2]
    CITYNAME,                       -- City [ad_city1]
    DISTRICTNAME,                   -- District [ad_city2]
    POSTALCODE,                     -- Postal Code [ad_pstcd1]
    COMPANYPOSTALCODE,              -- Company Post Cd [ad_pstcd3]
    STREETNAME,                     -- Street [ad_street]
    HOUSENUMBER,                    -- House Number [ad_hsnm1]
    COUNTRY,                        -- Country/Reg. [land1]
    REGION,                         -- Region [regio]
    FORMOFADDRESS,                  -- Title Key [ad_title]
    TAXJURISDICTION,                -- Tax Jurisdiction [ad_txjcd]
    ADDRESSREPRESENTATIONCODE,      -- Address Version [ad_nation]
    CORRESPONDENCELANGUAGE,         -- Language [spras]
    PRFRDCOMMMEDIUMTYPE,            -- Comm. Method [ad_comm]
    PURCHASINGDELIVERYADDRESSTYPE,  -- Address Type [purreqnaddrtype]
    EMAILADDRESS,                   -- E-Mail Address [ad_smtpadr]
    INTERNATIONALPHONENUMBER,       -- Telephone no. [ad_telnrlg]
    INTERNATIONALFAXNUMBER,         -- Fax Number [ad_fxnrlng]
    PPSFIELDCHANGEINDICATORBINARY,  -- Control [pps_e_control_flag]
    PURCHASEORDERDRAFTUUID,         -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, DELIVERYADDRESSID, DRAFTUUID)
);

Learn More