Value Date Field in FF67

[abdul_jabbar]

Hi All,

I want to restrict value date field in Tcode FF67 - Manual Bank Statement.

Restriction is, user should not enter future date in Value date field during manual bank statement entered.

Bank statement have value date 01.01.2015, user wrongly entered 01.01.2201. How it can be controlled.

Waiting for reply

Regards

AJ

[pankaj_pandey2]

HI Abdul,

user can given value date prior to the bank statement date as well. So it would be difficult to apply a perfect validation which would restrict user according to bank statement. You can either hide the field value date in FF67 scree and also make this entry as optional in clearing process as well, or you can write a substitution , which would change the value date to statement date.

Check the above option hope this will suit you.

Regards

Pankaj p

[abdul_jabbar]

Waiting for reply.

[abdul_jabbar]

No Reply.

[abdul_jabbar]

No Reply.

[abdul_jabbar]

Hi All,

Can we restrict validation to a particular Tcode. Like i want to restrict value date field in FB05 but validation is also working on F-48 and F-53 tcode.

Regards

AJ

[nico_dewaele]

hello,

in your prerequisites define system transaction code as F-05

like:

kr

Nico

[abdul_jabbar]

Hi,

I already tried but it is still working on other transaction like F-48, F-29, F-53 etc. I only want to restrict in Tcode FB05.

Below is my Validation.

Pre-requisite:   

BSEG-BUKRS = 'XXXX' OR BSEG-BUKRS = 'XXXX' AND

SYST-TCODE = 'FB05'

Check: BSEG-VALUT <= SYST-DATUM

Regards

AJ

[nico_dewaele]

Abdul,

can you try

( BSEG-BUKRS = 'XXXX' OR BSEG-BUKRS = 'XXXX' )

AND

SYST-TCODE = 'FB05'

please put also the trace on, so you see what's happening

kr

Nico

[abdul_jabbar]

Hi Nico,

Thanks for replying. It is now working for only Tcode FB05.

Is there any way to restrict user on FF67 screen to enter value date >= system date.

Regards

AJ

[nico_dewaele]

there's sth called screen validations, but I doubt that you can use it here without changing the standard code in the system.

[jayj07]

Hi Abdul,

I believe this is not possible without customization as you can only create screen variants for FF67.

Let me know if you found a way to do it.

Jayj

[former_member198650]

Hi Jabbar,

Create validation in GGB0 and assign the same to the co.code in OB28.

Regards,

Mukthar

[abdul_jabbar]

Hi Mukhtar,

Thanks for replying.

Validation is on BKPF and BSEG table but in FF67 value date field is maintained in FEBEP table.

Regards

AJ

[former_member198650]

Hi,

Even though it has maintained in FEBEP table, you can select it in BSEG/BKPF table. Because this field will update in these tables also. So first define it in Dev and test it.

Regards,

Mukthar

[abdul_jabbar]

Hi Mukhrar,

I already test successfully. Valuse date is being checking while posting in Tcode FB05, but i want to restrict user in Tcode FF67 while entering bank statement not at posting time.

If i use above process,

1- How i can restrict user to enter value date within current fiscal year.

2- How i can restrict validation to Tcode FB05 only, but it is also working in Tcode F-53 and F-48. Even i only mention Tcode FB05 in validation.

Regards

AJ