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".

Fields for table IPURREQDELADD_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
PURCHASEREQUISITIONPurchase requisition numberVDM_PURCHASEREQUISITIONCHAR20
PURCHASEREQUISITIONITEMItem number of purchase requisitionVDM_PURCHASEREQUISITIONITEMNUMC10
ADDRESSIDAddress NumberAD_ADDRNUMCHAR20
ADDRESSIDFOREDITAddress NumberAD_ADDRNUMCHAR20
ADDRESSTYPEPurchase Requisition Address TypePURREQNADDRTYPECHAR2
PLANTPlantEWERKCHAR8
MANUALDELIVERYADDRESSIDManual address number in purchasing document itemADRNR_MMCHAR20
ITEMDELIVERYADDRESSIDNumber of delivery addressADRN2CHAR20
CAREOFNAMEc/o nameAD_NAME_COCHAR80
ADDITIONALSTREETSUFFIXNAMEStreet 5AD_LCTNCHAR80
CORRESPONDENCELANGUAGELanguage KeySPRASLANG2
PRFRDCOMMMEDIUMTYPECommunication Method (Key) (Business Address Services)AD_COMMCHAR6
POBOXPO BoxAD_POBXCHAR20
POBOXISWITHOUTNUMBERFlag: PO Box Without NumberAD_POBXNUMCHAR2
POBOXPOSTALCODEPO Box Postal CodeAD_PSTCD2CHAR20
POBOXLOBBYNAMEPO Box LobbyAD_PO_BOX_LBYCHAR80
POBOXDEVIATINGCITYNAMEPO Box cityAD_POBXLOCCHAR80
POBOXDEVIATINGREGIONRegion for PO Box (Country/Region, State, Province, ...)AD_POBXREGCHAR6
POBOXDEVIATINGCOUNTRYPO Box of Country/RegionAD_POBXCTYCHAR6
DELIVERYSERVICETYPECODEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8
DELIVERYSERVICENUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
ADDRESSTIMEZONEAddress time zoneAD_TZONECHAR12
FULLNAMEFull name of a party (Bus. Partner, Org. Unit, Doc. address)ADFULLNAMECHAR160
CITYNAMECityAD_CITY1CHAR80
DISTRICTDistrictAD_CITY2CHAR80
CITYCODECity code for city/street fileAD_CITYNUMCHAR24
HOMECITYNAMECity (different from postal city)AD_CITY3CHAR80
POSTALCODECity postal codeAD_PSTCD1CHAR20
COMPANYPOSTALCODECompany Postal Code (for Large Customers)AD_PSTCD3CHAR20
STREETNAMEStreetAD_STREETCHAR120
STREETPREFIXNAMEStreet 2AD_STRSPP1CHAR80
ADDITIONALSTREETPREFIXNAMEStreet 3AD_STRSPP2CHAR80
STREETSUFFIXNAMEStreet 4AD_STRSPP3CHAR80
HOUSENUMBERHouse NumberAD_HSNM1CHAR20
HOUSENUMBERSUPPLEMENTTEXTHouse number supplementAD_HSNM2CHAR20
BUILDINGBuilding (Number or Code)AD_BLDNGCHAR40
FLOORFloor in buildingAD_FLOORCHAR20
ROOMNUMBERRoom or Apartment NumberAD_ROOMNUMCHAR20
COUNTRYCountry/Region KeyLAND1CHAR6
REGIONRegion (State, Province, County)REGIOCHAR6
COUNTYCountyAD_COUNTYCHAR80
FORMOFADDRESSForm-of-Address KeyAD_TITLECHAR8
BUSINESSPARTNERNAME1Name 1AD_NAME1CHAR80
BUSINESSPARTNERNAME2Name 2AD_NAME2CHAR80
NATIONVersion ID for International AddressesAD_NATIONCHAR2
PHONENUMBERFirst telephone no.: dialling code+numberAD_TLNMBR1CHAR60
FAXNUMBERFirst Fax No.: Area Code + NumberAD_FXNMBR1CHAR60
SEARCHTERM1Search Term 1AD_SORT1CHAR40
STREETSEARCHStreet Name in Uppercase for Search HelpAD_MC_STRTCHAR50
CITYSEARCHCity name in Uppercase for Search HelpAD_MC_CITYCHAR50
BUSINESSPARTNERNAME3Name 3AD_NAME3CHAR80
BUSINESSPARTNERNAME4Name 4AD_NAME4CHAR80
TAXJURISDICTIONTax JurisdictionAD_TXJCDCHAR30
TRANSPORTZONETransportation zone to or from which the goods are deliveredLZONECHAR20
PERSONPerson NumberAD_PERSNUMCHAR20
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
Privacy Policy