Q45: OCRD GroupNum - where can I find the 'Name' fields?

[Former Member]

I am searching in vain for the field that gives the text/name to go with GroupNum, can anyone help??? (I do not have the acces to define a new field)

This is the field that gives the payment terms for BPs, I just want a list by Supplier e.g.

30 days nett

30 days month end etc

Not

-1

5

etc

Thanks,

Robin

[Former Member · Accepted solution]

Hi Robin.......

For Payment Terms name just join OCTG table with OCRD you get Payment Group Name......

Try This.....

SELECT T0.[CardCode], T0.[CardName], T1.[GroupNum], T1.[PymntGroup] FROM OCRD T0  
INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum

Regards,

Rahul

[Former Member]

Hi Robin,

The 3 posts above are all correct and will give you the payment group name in a query, the bottom 2 filter suppliers.

A few tips to help you in this area. In SAP, if you go into the Payment Terms setup screen, then go to the View menu and select System Information. This will then allow you to hover over the fields in the setup screen and it will tell you the table and field names in the bottom left hand corner of the screen. As soon as you log out of SAP this will be switched off again so you'll need to turn this on each time you want to find out a table or field name.

Once you know the table names, if you are unsure how to join these tables together, another tip is to go in to either query generator or query wizard and add the OCRD table and OCTG table to the query and SAP 9 times out of 10 adds the correct joins for you. Sometimes however SAP will not know how to join the tables together if there is not a logical join. Also, SAP will always default it to the standard inner join and sometimes you will need to change this to be a different type of join for example outer joins.

Regards,

Adrian

[Former Member]

Hi Robin,

Try:

SELECT T0.CardCode, T0.CardName, T1.PymntGroup

FROM OCRD T0

INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum

WHERE T0.CardType = 'S'

Thanks,

Gordon

[agustin_marcoscividanes]

Hi

If you want to print the payment terms group name you have to select in the PLD and tick Get Description.

I tried in purchase orders, and it is OK.

But if you want a list with the code and the name only suppliers you can run:

SELECT T0.[PymntGroup] FROM OCTG T0 INNER JOIN OCRD T1 ON T0.GroupNum = T1.GroupNum WHERE cardtype = 'S' GROUP BY T0.[PymntGroup]

Kind regards.

Agustí