PPS_PO_DELADDR_D

Transparent Table Application Table
36 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 36 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 (36)

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, DELIVERYADDRESSID, DRAFTUUID)
);

Learn More