topic Re: Help - BSAS/BSAK in Application Development and Automation Discussions

Help - BSAS/BSAK

Former Member — Mon, 14 Feb 2011 17:05:20 GMT

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

Re: Help - BSAS/BSAK

Former Member — Mon, 14 Feb 2011 17:14:30 GMT

Config?

Rob

Re: Help - BSAS/BSAK

Former Member — Mon, 14 Feb 2011 17:52:36 GMT

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

Re: Help - BSAS/BSAK

brad_bohn — Mon, 14 Feb 2011 18:06:56 GMT


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

Re: Help - BSAS/BSAK

Former Member — Mon, 14 Feb 2011 18:09:48 GMT

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

Re: Help - BSAS/BSAK

Former Member — Mon, 14 Feb 2011 18:12:15 GMT

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

Re: Help - BSAS/BSAK

Former Member — Mon, 14 Feb 2011 18:14:06 GMT

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.