Skip to Content
0

How to obtain a list of GL Accounts/Cost Centers that require Statistical Internal Orders (SIO)?

Jul 08, 2017 at 12:05 AM

88

avatar image
Former Member

Hi Experts,

How to obtain a list of GL Accounts/Cost Centers that require Statistical Internal Orders (SIO)?

Basically a report/list containing GL Accounts, Cost Centers and Statistical Internal Orders on the basis of GL accounts that require Statistical Internal Orders (SIOs).

Thanks in advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jul 19, 2017 at 09:02 AM
0

Not sure which angle of your question is. My guess is, it must be only from GL Master listing. The std way is from field status group that controls the behavior of posting in the GL account, if lets say I had assign a FSG code ="Z099" that has a required entry on the field CO/PP order. Then I would just do a query on table SKB1 by company code and where FSTAG = "Z099" FSG code(s) that has a mandatory/required on CO/PP Order. Or just any std GL report ex:- S_ALR_87012328 with a dynamic selection of FSG ="Z099" , problem is the listing output is not Excel friendly.

Share
10 |10000 characters needed characters left characters exceeded
Seref Can Kucukkarakurt Jul 20, 2017 at 01:40 PM
0

Hi Pankaj Dhyani,

You can use function GET_FIELDSTATUS_FOR_GL_ACCT(you may use T004F table as well).

Result of function shows fields are as:

  • "." - supress
  • "-" - optional
  • "+" - required

To find out sequence of field you may use OBC4 customizing.

In OBC4 customizing, click on field status group and go "Maintain Field Status Group: Overview" screen.

Select your groups for related GLs and then click on "Extras --> Subgroup List --> With Item specification".

You will see sequence of field in the pop-up. You can match this sequence in the export parameters of function by counting.

For example in group of "Payment transactions", "Due Date" has a sequence as "005". It means in export parameters, fifth character is "+".

Kind Regards,

Example:

Fifth character is plus as shown:


2007.png (17.9 kB)
1212.png (12.3 kB)
due-date.png (7.7 kB)
5.png (3.2 kB)
Share
10 |10000 characters needed characters left characters exceeded