PPS_PRITM_DLAD_D

Transparent Table Application Table

Draft table for entity R_PPS_PurReqItemDelivAddressD

PPS_PRITM_DLAD_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PurReqItemDelivAddressD. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurReqItemDelivAddressD view_entity from BASIC Purchase Request item Del Addr - Draft

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ppspurchaserequestitemuuid PPS_E_PUR_REQUEST_ITEM_UUID Item UUID
ppspurchaserequestuuid PPS_E_PURCHASE_REQUEST_UUID UUID
ppspurchaserequest VDM_PURCHASEREQUISITION Purch.Reqn.
ppspurchaserequestitem VDM_PURCHASEREQUISITIONITEM Requisn. item
purchasingdeliveryaddresstype PURDELIVERYADDRTYPE Delivery Addr Type
plant EWERK Plant
storagelocation LGORT_D Location
deliveryaddressid ADRNR Address
streetname AD_STREET Street
region REGIO Region
postalcode AD_PSTCD1 Postal Code
fullname AD_NAMTEXT Full Name
businesspartnername2 AD_NAME2 Name 2
cityname AD_CITY1 City
country LAND1 Country/Reg.
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft 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_PurReqItemDelivAddressD
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PRITM_DLAD_D (
    MANDT,                          -- Client [MANDT]
    PPSPURCHASEREQUESTITEMUUID,     -- Item UUID [PPS_E_PUR_REQUEST_ITEM_UUID]
    PPSPURCHASEREQUESTUUID,         -- UUID [PPS_E_PURCHASE_REQUEST_UUID]
    PPSPURCHASEREQUEST,             -- Purch.Reqn. [VDM_PURCHASEREQUISITION]
    PPSPURCHASEREQUESTITEM,         -- Requisn. item [VDM_PURCHASEREQUISITIONITEM]
    PURCHASINGDELIVERYADDRESSTYPE,  -- Delivery Addr Type [PURDELIVERYADDRTYPE]
    PLANT,                          -- Plant [EWERK]
    STORAGELOCATION,                -- Location [LGORT_D]
    DELIVERYADDRESSID,              -- Address [ADRNR]
    STREETNAME,                     -- Street [AD_STREET]
    REGION,                         -- Region [REGIO]
    POSTALCODE,                     -- Postal Code [AD_PSTCD1]
    FULLNAME,                       -- Full Name [AD_NAMTEXT]
    BUSINESSPARTNERNAME2,           -- Name 2 [AD_NAME2]
    CITYNAME,                       -- City [AD_CITY1]
    COUNTRY,                        -- Country/Reg. [LAND1]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, PPSPURCHASEREQUESTITEMUUID)
);