PPS_PRITM_DLAD_D
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_PPS_PurReqItemDelivAddressD | view_entity | from | BASIC | Purchase Request item Del Addr - Draft |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA