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
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: 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'.
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)
write: / w_t004f-fstag.
endloop. " i_t004f
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.
gruptab-ftext = text-ngg.
write: /5 gruptab-ftext,
endselect. " FROM tmodf
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.
write: 60 'X'. " obligatory
write: 70 'X'. " optional.
write: 50 'X'. " supress
endselect. " FROM tmodp
Edited by: Bruce Tjosvold on Jun 30, 2011 7:17 PM
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
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
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
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.,
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
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
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
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
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
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
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?
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
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
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
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
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
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
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
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