We have 3.5 million records in BKPF. we an have application which search the documents based on document type, doc status, doc date and posting date. The below select statement taking 2mins to get the data.

hi experts, I want to create query with the tables of BKPF and BSEG and Structures COBL, RF05A How can i proceed? Please give me complete points Edited by: Alvaro Tejada Galindo on Feb 14, 2008 2:52 P

In BKPF table I can see the user name as WF-BATCH but how can I populate the approver's name intead of WF-BATCH. I have read many threads, they say find the approver's name and update BKPF table through a task, but is there any alternative or this is the only way..?.

2011年5月18日 · We are creating a transfer payment 'ZP' document through automatic payment run cycle in F110. The table BKPF gets updated with the field BKTXT with Run Date and Run ID separated by a '-'. I want to prevent this from happening as i want run date and id in continuation.

My question is regarding FI object F_BKPF_BLA. I have a requirement to restrict activity for the document types by using authorization groups. From what I know it is possible to restrict the activity on document type based on the authorization group assigned.

I have the reference key (bkpf-awkey), fiscal year (gjahr) and bukrs and I need to retreive the Accounting doc number (Belnr).

Hi to all Pls give me information i am trying from last two days For Bank Payement Advice, how to link bseg rseg and rbkp, From Bseg i am retriving - BELNR (Accounting Document Number) 1500000003 and

Hi All, I want to read the data from BKPF and BSEG tables by passing the company code, document type and fiscal year.I am able to read using select but i need a function module to read the data.

I am an ABAP developer working without any functional person for FI. Our accounts dept.person wants a list of all open accounting documents (BKPF-BELNR) with corresponding accounting documents (J_1IPART2-FAWREF).

I need to develop a report showing Despatch VS Collection.In that i need to include Bank Name cheque no/DD/JV and its amount along with the other fields.Please guide me about the dictionary tables that i have to use. through the selection screen i am allowing the user to enter the collection date and company code based on that i am fetching …