IPURREQDELADD_D - I_PURCHASEREQNDELIVERYADDRTP I_PURCHASEREQNDELIVERYADDRTP
I_PURCHASEREQNDELIVERYADDRTP I_PURCHASEREQNDELIVERYADDRTP information is stored in SAP table IPURREQDELADD_D.
It is part of development package APPL_MM_PUR_PR_APPRVL_COMPL in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "S4HANA Artefacts for PR Approval Completion".
It is part of development package APPL_MM_PUR_PR_APPRVL_COMPL in software component MM-PUR-REQ. This development package consists of objects that can be grouped under "S4HANA Artefacts for PR Approval Completion".
Fields for table IPURREQDELADD_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
DRAFTUUID | UUID serving as key (parent key, root key) | X | /BOBF/UUID | RAW | 16 | |
PURCHASEREQUISITION | Purchase requisition number | VDM_PURCHASEREQUISITION | CHAR | 20 | ||
PURCHASEREQUISITIONITEM | Item number of purchase requisition | VDM_PURCHASEREQUISITIONITEM | NUMC | 10 | ||
ADDRESSID | Address Number | AD_ADDRNUM | CHAR | 20 | ||
ADDRESSIDFOREDIT | Address Number | AD_ADDRNUM | CHAR | 20 | ||
ADDRESSTYPE | Purchase Requisition Address Type | PURREQNADDRTYPE | CHAR | 2 | ||
PLANT | Plant | EWERK | CHAR | 8 | ||
MANUALDELIVERYADDRESSID | Manual address number in purchasing document item | ADRNR_MM | CHAR | 20 | ||
ITEMDELIVERYADDRESSID | Number of delivery address | ADRN2 | CHAR | 20 | ||
CAREOFNAME | c/o name | AD_NAME_CO | CHAR | 80 | ||
ADDITIONALSTREETSUFFIXNAME | Street 5 | AD_LCTN | CHAR | 80 | ||
CORRESPONDENCELANGUAGE | Language Key | SPRAS | LANG | 2 | ||
PRFRDCOMMMEDIUMTYPE | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 6 | ||
POBOX | PO Box | AD_POBX | CHAR | 20 | ||
POBOXISWITHOUTNUMBER | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 2 | ||
POBOXPOSTALCODE | PO Box Postal Code | AD_PSTCD2 | CHAR | 20 | ||
POBOXLOBBYNAME | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 80 | ||
POBOXDEVIATINGCITYNAME | PO Box city | AD_POBXLOC | CHAR | 80 | ||
POBOXDEVIATINGREGION | Region for PO Box (Country/Region, State, Province, ...) | AD_POBXREG | CHAR | 6 | ||
POBOXDEVIATINGCOUNTRY | PO Box of Country/Region | AD_POBXCTY | CHAR | 6 | ||
DELIVERYSERVICETYPECODE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 8 | ||
DELIVERYSERVICENUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 20 | ||
ADDRESSTIMEZONE | Address time zone | AD_TZONE | CHAR | 12 | ||
FULLNAME | Full name of a party (Bus. Partner, Org. Unit, Doc. address) | ADFULLNAME | CHAR | 160 | ||
CITYNAME | City | AD_CITY1 | CHAR | 80 | ||
DISTRICT | District | AD_CITY2 | CHAR | 80 | ||
CITYCODE | City code for city/street file | AD_CITYNUM | CHAR | 24 | ||
HOMECITYNAME | City (different from postal city) | AD_CITY3 | CHAR | 80 | ||
POSTALCODE | City postal code | AD_PSTCD1 | CHAR | 20 | ||
COMPANYPOSTALCODE | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 20 | ||
STREETNAME | Street | AD_STREET | CHAR | 120 | ||
STREETPREFIXNAME | Street 2 | AD_STRSPP1 | CHAR | 80 | ||
ADDITIONALSTREETPREFIXNAME | Street 3 | AD_STRSPP2 | CHAR | 80 | ||
STREETSUFFIXNAME | Street 4 | AD_STRSPP3 | CHAR | 80 | ||
HOUSENUMBER | House Number | AD_HSNM1 | CHAR | 20 | ||
HOUSENUMBERSUPPLEMENTTEXT | House number supplement | AD_HSNM2 | CHAR | 20 | ||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 40 | ||
FLOOR | Floor in building | AD_FLOOR | CHAR | 20 | ||
ROOMNUMBER | Room or Apartment Number | AD_ROOMNUM | CHAR | 20 | ||
COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | ||
REGION | Region (State, Province, County) | REGIO | CHAR | 6 | ||
COUNTY | County | AD_COUNTY | CHAR | 80 | ||
FORMOFADDRESS | Form-of-Address Key | AD_TITLE | CHAR | 8 | ||
BUSINESSPARTNERNAME1 | Name 1 | AD_NAME1 | CHAR | 80 | ||
BUSINESSPARTNERNAME2 | Name 2 | AD_NAME2 | CHAR | 80 | ||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 2 | ||
PHONENUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 60 | ||
FAXNUMBER | First Fax No.: Area Code + Number | AD_FXNMBR1 | CHAR | 60 | ||
SEARCHTERM1 | Search Term 1 | AD_SORT1 | CHAR | 40 | ||
STREETSEARCH | Street Name in Uppercase for Search Help | AD_MC_STRT | CHAR | 50 | ||
CITYSEARCH | City name in Uppercase for Search Help | AD_MC_CITY | CHAR | 50 | ||
BUSINESSPARTNERNAME3 | Name 3 | AD_NAME3 | CHAR | 80 | ||
BUSINESSPARTNERNAME4 | Name 4 | AD_NAME4 | CHAR | 80 | ||
TAXJURISDICTION | Tax Jurisdiction | AD_TXJCD | CHAR | 30 | ||
TRANSPORTZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 20 | ||
PERSON | Person Number | AD_PERSNUM | CHAR | 20 | ||
HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
.INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 |