Help - BSAS/BSAK

[Former Member]

Hi

Complete newbie calling... really appreciate some help.

I am trying to get a text description for a VI document type from the BSAK table. I am looking at the BSAS table where there is a SGTXT field and the link appears to be BELNR. This works for RE document types no problem but VI doesn't. Any ideas why?

Cheers

Steve

[Former Member]

Config?

Rob

[Former Member]

Hi Rob

Thanks for your reply. I can see that very few VI document types appear in the BSAS file. Is this normal? if it is, is there another table where would you normally expect to see the any descriptive text for these line items.

Apologies if this sounds noddy but I'm from the business not the SAP side of the fence.

Cheers

Steve

[brad_bohn]

Is this normal?

It depends on your clearing procedures and settings. I don't know what a 'VI' document is though. Check the documents in question and whether or not the vendor line items are cleared and whether or not the g/l accounts are open item managed. You'll find the vendor side in BSIK or BSAK and the g/l side in BSIS or BSAS

[Former Member]

I don't think VI is a standard SAP document type. (At leaset, I don't see it anywhere.) You should talk to the SAP functional person who set this up.

Rob

[Former Member]

Hi Steve,

The fact if the SGTXT (item text) field is filled depends on the following variables:

- Like Rob pointed out, in configuration the field can be set as mandatory as such or controlled by an user-exit;

- Creation of the accounting document.

- a. external interface posts this document and populates the field with data;

- b. internal posting. Part of SAP internal integration posts this document, e.g. billing dociment -> accounting document (RV).

- Manually by business user as part of your business process.

Hope this helps, however it makes most sense in order for you to discuss this with your SAP support team.

Kind regards,

Robert

[Former Member]

Use table T003T-BLART (document type) and ltext (description).

SELECT * FROM t003t INTO TABLE lt_t003t

WHERE blart IN ('RE', 'AA', 'AB',) " Document type

AND spras EQ 'E'. " Language

"LTEXT" will contain the description.