Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

need VBRK_BillingDocument_Header table fields info

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.

1 Solution

Accepted Solutions
robobi_co_za
New Contributor II

Re: need VBRK_BillingDocument_Header table fields info

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];

1 Reply
robobi_co_za
New Contributor II

Re: need VBRK_BillingDocument_Header table fields info

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];

Community Browser