topic Re: need VBRK_BillingDocument_Header table fields info in QlikView

need VBRK_BillingDocument_Header table fields info

Wed, 20 Jul 2011 10:54:49 GMT

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.

Re: need VBRK_BillingDocument_Header table fields info

rob_centrix — Thu, 21 Jul 2011 05:49:35 GMT

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