SAP table UKPF (Retail Revaluation Document: Revaluation Header)

SAP table UKPF has 3 primary key fields being MANDT,UBLNR,UBJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
UBLNR Retail revaluation document number CHAR 10 0 UBLNR
UBJAHR Retail revaluation: document year NUMC 4 0 UBJAHR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
UBSTA Status of retail revaluation document CHAR 1 0 UBSTA
A New, not all items are for counting
B Changed, not all items have been revaluated
C All items in document have been revaluated
D Items with errors, document marked for deletion
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
MBLNR Number of Material Document CHAR 10 0 MBLNR

UKPF foreign key relationships

Table Field Check Table Check Field
0 UKPF MANDT T000 Clients MANDT