need VBRK_BillingDocument_Header table fields info

[#1]

hi guys,

VBRK_BillingDocument_Header:

Load

BUKRS AS [Compnay Code._BUKRS];

SQL SELECT  BUKRS   FROM VBRK;

Frm above script i am getting company code but i need  Billing Company code&Name,how we can get it...?

from which field we need to get name of the company in VBRK table?

pls help us.

[rob_centrix · Accepted solution]

This is where I get the Co Name from:

[T001]:   // Company Codes
Load
[BUKRS] as [Company Code_BUKRS],
[BUTXT] as [Company Name_BUTXT];
SQL Select BUKRS BUTXT  from T001
;
STORE * FROM [T001] INTO T001.QVD;
DROP TABLE [T001];