SAP B1 Query on Business Partner

[Former Member]

Dear All,

I need to write a simple query that will provide me with the following details

• Business Partner Number
• Business Partner Name
• The date the Business Partner was created/setup

I am able to extract the first two bits of information, not quite sure which table holds the 3rd data, will appreciate your comments/suggestions.

Regards

Raj

[kothandaraman_nagarajan · Accepted solution]

Hi,

Try this query:

SELECT T0.[CardCode], T0.[CardName], T0.[CreateDate] FROM OCRD T0 WHERE T0.[CardType]  = [%0]

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thank You Nagarajan

[FarazMaqsud]

For HANA DB :-

Select T0."CardCode",T0."CardName",T0."CreateDate" From "OCRD" T0

Order By T0."CardCode"

Regards,

Faraz Maqsud

[Former Member]

Hi,

Try this:

SELECT T0.[CardCode], T0.[CardName], T0.[CreateDate], T0.[CardType], T0.[CntctPrsn], T0.[Balance] FROM OCRD T0 WHERE T0.[CardType]  = [%0]

Thanks & Regards,

Amrut Sabnis

[KennedyT21]

HI

Select Cardname,cardcode,Phone1,Phone2,CreateDate

from OCRD

Try This

Regards

Kennedy

[Former Member]

Thank You Kennedy

Regards