cheque number in purchase register (fbl1n) urgent

[Former Member]

i want to down load the Purchase Ledger historic data from SAP thru FBL1N and one field we require is the cheque number that payment is made. Can this field is available or is there another report where this is available.

thanks in advance and value points assigned.

thanks and regards

Sunitha Reddy

[Former Member]

Try tcode O7R3 and the following is the documentation

For the table enter PAYR and select the field ChECF.

This should work. Let me know if you have any issues.

Define Additional Fields for Line Item Display

In this activity you can add additional fields to the field list for line item display.

Example

You have the option of displaying additional fields, such as User who entered the document from table BKPF or Quantity and Unit of measure from table BSEG.

Recommendation

Consider whether you really need to enhance the line item display. Note that this enhancement can reduce performance, since the system has to read more table entries.

[Former Member]

Hi

Ples use T Code SA38 to execute the program RFKAPO00. I guess your issue would be resolved. Pls assign points if the information is useful to you.

Regards

Sanil Bhandari

[Former Member]

hi sanil

i am sorry its not showing check information.could you please let me know how to add check number column in the Report (FBL1N).

That could be grate help for me.

Thanks in advance and value points will assigned.

Regards

Sunitha Reddy

[Former Member]

Sunitha,

You cannot get check number from FBL1N.

What you can do is go to get the clearing document number (Vendor also to make sure that you are doing correct) from FBL1N and then use that as a key to get the check number from table PAYR.

Hope it helps..

Thanks,

Nandita

[Former Member]

Firstly for you to be able to get the cheque no. you would have to assign it using FCH5, once done, you can activate the cross client changes for the addtional field of cheque no to be appeared using OBVU to add the PAYR-CHECF field to be assigned. Only then users can activate the field to be seen in FBL1N. In case the field is not seen , then Using Transaction SE11, check whether the special field exists in structure RFPOSXEXT.'U_' is prefixed to actual field names, for example, U_EBELN.Provided that this field is missing, start program RFPOSXEXTEND using Transaction SE38.The program regenerates structure RFPOSXEXT and consequently eliminates the inconsistency.

[Former Member]

hi,

i think u need a report from FBL1N, in this u need cheque no in one field -

step 1 : whicle making the payment in F-53, you can put cheque no in assignement coloumn , based on this information it will be automatically appears in FBL1n

thanks

if you ok with this, pls assign the reward points