Relationship into tables BKPF/RBKP to ASMD

[caio_dh_consultig]

hello,

I have a problem with a join in sap, i need join the document belnr to service number (ASNUM), but how i do join BKPF or RBKP with master service table ASMD.
please, if someone maybe helpe me, thankyou

[raymond_giuseppi · Accepted solution]

Look at table EKBE 'History per Purchasing Document', field EKBE-SRVPOS should be ASMD-ASNUM 'service number' (Check also Customizing for service based IV-Based)

[caio_dh_consultig · Accepted solution]

thankyou for help me, but in this field in company is null, there are another field or path join?

[raymond_giuseppi · Accepted solution]

Did you check your Custiomizing, if fields such as 'GR.Bsd-IV' and 'S.-Based IV' are not checked, the system doesn't maitain a link between posted documents (so don't expect a simple join to solve your requirement, go for creation of a logic - code - of matching data)

Read some KBA such as 1914810 - Maintain Purchase Order Service PO link to posted documents