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

[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.

[S0012172276]

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:

[Former Member]

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.