SAP report of field status variant, in 4.7

Advertisement
Hello all,
Is there a SAP report that lists a field status variant, its groups, the groups fields, and the entry properties of the fields?
In customization, path  /Financial Accounting/Financial Accounting Global Settings/Document/Line Items/Controls/Maintain Field Status Variants - execute
Gets you to the transaction where this is set up.  If you have access to this transaction, you can see all of that information, even capture it to a spool or presentation file.
We want to give this information to users who don't have that access. 
I am hoping that someone knows of a SAP report with that information, or someone has already created their own report and is willing to share some code.
I started to look at function PREPARE_FIELD_SELECT_STRING, but got lost in the detail.  If that is only way to get what I want, well...
Thanks
Bruce
Advertisement

Replay

This is my solution.  Simple code, once I finished debugging the function module PREPARE_FIELD_SELECT_STRING.
tables: t004f,       " Field status definition groups
        tmodf,       " Groups in Field Selection Bar
        tmodg,       " Name of Groups in Field Selection Bar
        tmodo,       " Items in Field Selection Definitions
        tmodp.       " Name of Items in Field Selection Definitions
data: w_t004f type t004f.
data: i_t004f type table of t004f.
data: begin of gruptab occurs 0,
        ggrup   like tmodo-ggrup,
        ftext   like tmodp-ftext,
        xhell   type c,
      end of gruptab.
data: c500(500)    type c.
data: incoming_string(200).
data: fleng(4)     type n.
data: w_string_position(3) type n.
select-options: s_fstva for w_t004f-bukrs  default '0001'  obligatory.
selection-screen skip 1.
select-options: s_group for t004f-fstag default 'GT02'.
start-of-selection.
  select * from t004f into table i_t004f   "
           where bukrs in s_fstva
             and fstag in s_group.
  loop at i_t004f into w_t004f.          " field status groups (FSG)
    skip 1.
    write: / w_t004f-fstag.
    perform get_subgroup_list.
  endloop.                                                  " i_t004f
end-of-selection.
form get_subgroup_list .
  clear gruptab.  refresh gruptab.
  incoming_string        = w_t004f-faus1.
  incoming_string+90(50) = w_t004f-faus2.
  select * from tmodf where fauna = 'SKB1-FAUS1'.
    gruptab-ggrup = tmodf-ggrup.
    select single * from tmodg where spras = sy-langu
                               and   fauna = tmodf-fauna
                               and   ggrup = tmodf-ggrup.
    if sy-subrc = 0.
      gruptab-ftext = tmodg-ftext.
    else.
      gruptab-ftext = text-ngg.
    endif.
    append gruptab.
    skip 1.
    write: /5 gruptab-ftext,
           50 'Suppress',
           60 'Required',
           70 'Optional'.
    perform get_fields.
  endselect.  "  FROM tmodf
endform.
form get_fields .
* ------- Read the item texts
  select * from tmodo where fauna = 'SKB1-FAUS1'
                        and ggrup = tmodf-ggrup.
    select single * from tmodp where spras = sy-langu
                               and   fauna = tmodo-fauna
                               and   modif = tmodo-modif.
    write: /10 tmodp-ftext.
* get individual field options
    write tmodp-modif to w_string_position.
    w_string_position = w_string_position - 1.
    case incoming_string+w_string_position(1).
      when '+'.
        write: 60 'X'.             " obligatory
      when '.'.
        write: 70 'X'.             " optional.
      when '-'.
        write: 50 'X'.             " supress
    endcase.
  endselect.  " FROM tmodp
endform.
Edited by: Bruce Tjosvold on Jun 30, 2011 7:17 PM

Field status variant

HI, in Tcode OBC5 what is field status variant - use of it where it is defined & assignedHi, Field status variant is defined in tcode OBC4. It is the field group which defines which field should be suppressed, mandatory & optional to fill while cr

Field Status variant for creating FB60/65/70/75

Hello everyone, Our client wants to make Material Group field (V023-MATKL) field mandatory for FI invoices. I looked at the FSV and FSG. It has materials management and below that it has only purchase order etc but no Material Group. I know BSEG does

Field status varint

what is the difference between field status, and fieldstaus group?Hi, Field status variant is the bundle of field status groups.You bind all the fields status groups  into a field status variant. field status is the how the fields should appear when

Field Status Varient

Any body can give the configuration settings or full details about Field Status Varient.... and Field Status Group.... Why it is required to be configured...in the system...?Hi TCode to be used-OBC4 For each category of general ledger account, e.g.,

Is there any Standard SAP Report?for displaying Billing block/Status-Order

Hi, Am a ABAP Developer. I heard that there is SAP Query/ABAP Query/Standard SAP report for the below functionality/requirement. SO, pls. let me know if there is any SAP Query/ABAP Query/Standard SAP report? "This report is suppose to display Credit

SAP report to see orders TECO with Details

Hi All, I am looking for a sap report to see all the orders that have been TECO'ed by Date (Selection screen - Peroid From - To) & plant. I know i can use COOIS & CO26 but i need more details output report somthing like who done the TECO, Date and

Standard SAP Report - Payments blocked and released

Hi Experts, We are having a requirement where the payment will be blocked for the invoices generated through Invoicing Plan. But we need a report " To know the status of payments blocked and released according to the invoicing plan". Do we have

Validation:  Field status of G/L account

Problem:  When posting non-goods receipt invoices in MIRO, G/L account and acct assignment object are proposed by purchase order, but they can be overwritten by users with no validation, often resulting in incorrect posting.  Such validation controls

Cost Center Master data field status change

Hello Gurus, I need to change the field status of 'User Responsible' field as required from optional in the cost center master data. I am not being able to get the exact answer from my searches. If anyone can help with an answer, it would be great.De

Sap report error

Hai in outgoing payment field having two remarks table is there one is journa remarks ,another one is manually we enter the remark(reason) , when i will import general ledger report(default report in sap ) only one remarks table is come , (journal re

CJE0 - Reports to be able to report on 'system status'

Hi there, Is there already an ability in CJE0 reports, or other reports, to be able to report on 'system status' (Project status) in the dynamic selections by another name?  If not can we get it added as a field choice in the dynamic selections list?

Need a report on delivery status and response status for capaign recipients

hi, i need to make a report on delivery status and response status for capaign recipients but cannot find them in the campaign subject area nor the campaign response subject area, any idea? thanksCorrect the Campaign Response History is the report yo

MIRO didnt validate GL field status group

Is it an SAP standard for MIGO not to read/validate GL account's FSG? Scenario:  GL account from PO has field status group Cost center required and WBS suppressed. During Invoice user was able to enter WBS data in the WBS column, system should have n

Create G/L Account Centrally cant find "Field Status group"

Dear All, When i create G/L Account Centrally i can no t find "Field Status group" as the picture showed. Before i do this, i have already defined the field status groupd and assign this to the company code J610. However i can not find "Fie

GL accounts- field status group table

Hi guys, any idea whether there is a table that contains data about field status for the GL accounts similar to T082 for assets? Thanks and regards StefanHi Stefan, Why, yes It's a structured field where every sign represens 'hidden' 'mandatory' 'opt

Call  an internal SAP report

Hello everyone, I would help you if you can :). I have an add-ons that adds buttons to the "Sale". Now I would like to add a button to create a PDF invoice. I  have  call  an internal SAP report , with code 'INV20001' in table [RDOC] Who can hel

Report for PO status

Hello Experts , Can you tell me the standard report for the status of PO as in GR qty , value , in voiced qty & value etc & open qty & value ?? Regardshi, There is no direct report, but for a single material you can check the PO history from M

SAP report with sales (invoices) and cost of goods sold

Is there standard SAP report that would show list of invoices, the materials sold, and the cost of goods sold (for how much they were bought)?Dear sapfan22222222 If it is a one time activity, the please do the following. SE11 , put the table VBRK and

SAP reporting - currency translation

Hello Guys, In  SAP report S_ALR_87013558 - the output is beeing displayed in unwanted currency. The database currency is XXX but the report is beeing displayed in List currency YYY. When checking report painter form: 12KST1A, I can see that the key