Description
This report determines which data records contain a value in tableDFKKOP in the fields MANSP, SPZAH, or SPERZ. This specifies that for these line items, a dunning lock, incoming pa
yment lock and outgoing payment lock, or an interest lock was set.
Some line items are split into repetition items. In this repetitionitems (table DFKKOPW), you can set an alternative dunning lock tothe line item. This is considered for conversion.
A data record is created in table DFKKLOCKS for each of thesedata records.
The fields are filled as follows:
CLIENT,,Same client as in table DFKKOP
LOOBJ1,,Document number, repetition item, item number
,,and subitem (all key fields of table DFKKOP)
LOTYP,,02 (Entry from system table TFK080B)
PROID,,01 (Dunning lock), 10 (Incoming and outgoing payment lock)
,,04(Interest lock) (Entry from system table TFK080F)
LOCKR,,The lock reason of the old data fields (MANSP
,,SPZAH, SPERZ) is transferred to this field
FDATE,,An unrestricted lock is entered and
,,receives 01/01/0001 as start date.
TDATE,,An unrestricted lock is entered and
,,receives 12/31/9999 as end date.
PART,,Business partner assigned to the line item
,,
VKONT,,Contract account assigned to the line item
COND_LOOBJ,,Is not filled
ACTKEY,,Is not filled
UNAME,,Name of the user that runs the XPRA
ADATUM,,System date for the process event of the XPRA
AZEIT,,System time for the process event of the XPRA
Once all data records have been successfully created in tableDFKKLOCKS, the fields MANSP, SPZAH, SPERZ ofall data records in table DFKKOP and DFKKOPW have aninitial value (SPACE).