Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 20, 2017 at 01:40 PM

    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:

    Add comment
    10|10000 characters needed characters exceeded