‎2008 Jan 12 12:41 PM
Hi All,
How to get the Text associated with Document Catagory(VBRK-VBTYP) of Billing Documents?
For each Billing Document, we can get the Document catagory as 'M', 'O, etc...
I would like to fetch the Text associated with this field...."M" refers to Invoice, 'O" refers to Inquiry..etc...
From which table, can i get the description...???
Regards
Pavan
‎2008 Jan 13 4:23 PM
Did You try the table VBFA for the same .
Just check this table and in the document category try to see if there is a check table associated in the field of document category.
I hope this might be defined at the domain level.
Vijay.
‎2008 Jan 12 12:52 PM
‎2008 Jan 13 2:07 PM
‎2008 Jan 13 2:36 PM
Pawan,
I do not think there is a table for that.
Values are Stored at the domain level.
Check the Values Range in Domain "VBTYP".
To get the values from domain,
Use the Function module "FICO_DOMAIN_VALUES_GET".
Pass the values
I_TABLE_NAME VBRK
I_FIELD_NAME VBTYP
I_LANGU EN
You will get all the values
Hope this helps.
Vinodh Balakrishnan
‎2008 Jan 13 4:23 PM
Did You try the table VBFA for the same .
Just check this table and in the document category try to see if there is a check table associated in the field of document category.
I hope this might be defined at the domain level.
Vijay.
‎2010 Dec 29 7:10 AM
Hi.. In case you didn't find the solution yet... hope this can help...
SELECT SINGLE ddtext
INTO p_ccattxt
FROM dd07t
WHERE domname EQ 'VBTYP'
AND ddlanguage EQ 'E'
AND domvalue_l EQ <vbtyp>.
<vbtyp> is the value of the Document Category.