P_PurReqAddDelivery

Purchase Reqn Delivery address | view: PDELIVADD | TRAN | Extraction: Not supported | Component: Purchase Requisitions
Column Name Description
PurchaseRequisition Purchase requisition number
PurchaseRequisitionItem Item number of purchase requisition
Column Name Description
Column Name Description
Column Name Description
Column Name Description
AddressType Purchase Requisition Address Type Show values
Column Name Description Domain name
DeliveryAddressID Address ADRNR
Customer Customer Number KUNNR
Master Data Relations Join Conditions
Number of delivery address
  • Number of delivery address
  • Client
  • ?
  • ?
  • P_PURREQADDDELIVERY.ITEMDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • P_PURREQADDDELIVERY.MANDT == ADRC.CLIENT
  • P_PURREQADDDELIVERY.[column in domain "AD_NATION"] == ADRC.NATION
  • P_PURREQADDDELIVERY.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Link to Central Address Management
  • Client
  • ?
  • ?
  • Manual address number in purchasing document item
  • P_PURREQADDDELIVERY.MANDT == ADRC.CLIENT
  • P_PURREQADDDELIVERY.[column in domain "AD_NATION"] == ADRC.NATION
  • P_PURREQADDDELIVERY.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • P_PURREQADDDELIVERY.MANUALDELIVERYADDRESSID == ADRC.ADDRNUMBER
Plant
  • Client
  • Plant
  • P_PURREQADDDELIVERY.MANDT == T001W.MANDT
  • P_PURREQADDDELIVERY.PLANT == T001W.WERKS
Customer
  • Customer Number
  • Customer
  • Client
  • P_PURREQADDDELIVERY.CUSTOMER == KNA1.KUNNR
  • P_PURREQADDDELIVERY.PURREQNRECEIVINGCUSTOMER == KNA1.KUNNR
  • P_PURREQADDDELIVERY.MANDT == KNA1.MANDT
Storage location
  • Client
  • Plant
  • Storage location
  • P_PURREQADDDELIVERY.MANDT == T001L.MANDT
  • P_PURREQADDDELIVERY.PLANT == T001L.WERKS
  • P_PURREQADDDELIVERY.STORAGELOCATION == T001L.LGORT
Supplier to be Supplied/Who is to Receive Delivery
  • Client
  • Supplier to be Supplied/Who is to Receive Delivery
  • P_PURREQADDDELIVERY.MANDT == LFA1.MANDT
  • P_PURREQADDDELIVERY.SUBCONTRACTOR == LFA1.LIFNR