Link between service order and terms of payment

[Former Member]

Hello experts,

can anybody tell me the link between an order and terms of payment of the current buyer? Which tables do I have to join? Or is there any function module to use for that purpose?

Very urgent!

Thanks in advance

Tanja

[ceedee666 · Accepted solution]

Hi Tanja,

instead of directly selecting some data from the DB tables you should read this information via the BOL (c.f BOL Programing - CRM - SCN Wiki for a short introduction).

Using the transaction GENIL_MODEL_BROWSER you can browse through the data model and find the suitable relations for reading the required data. In your case one possible approach to access the data is BTAdminH->BTHeaderBillingSet->BTBillingSetBuAg. Once you have the BuAg BOL object you can simply read the TOFPAYM property.

Best,

Christian