PPS_PR_DELADDR_D
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 66 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_PPS_PurReqnDelivAddrDraft | view_entity | from | BASIC | Purchase Reqn Delivery Address - Draft |
Fields (66)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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 | ||||
| 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_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]
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, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, DRAFTUUID)
);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