SAP table BLPK (Document log header)

SAP table BLPK has 2 primary key fields being MANDT,PRTNR.

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
PRTNR Confirmation number NUMC 10 0 PRTNR
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
VERID Production Version CHAR 4 0 MKAL VERID
DATUM Created On DATS 8 0 SA_ERDAT
UZEIT Time TIMS 6 0 UZEIT
REPTP Production Type CHAR 2 0 REPTP
01 Repetitive Manufacturing
02 Make-to-order production
03 Kanban
04 Production lot
STORN Reversal indicator CHAR 1 0 SA_STORN
Document has not been reversed
C Document is a reversal document
P Document has been partially reversed
V Document created with reprocessing records
X Document has been reversed
AUFNR Run schedule header number CHAR 12 0 SAFK SA_AUFNR
KDAUF Sales and Distribution Document Number CHAR 10 0 VBELN
KDPOS Item number of the SD document NUMC 6 0 POSNR
PKNUM Control Cycle CHAR 7 0 PKHD PKNUM
PKPOS Kanban Control Cycle Item NUMC 3 0 PKPOS
MENGE Quantity QUAN 13 3 MENGE_D
BDENR PDC Number (Specific ID for all PDC Systems) CHAR 12 0 SA_BDENR
VAART Processing Type for Backflush CHAR 4 0 SA_VAART
UNAME User Name CHAR 12 0 UNAME
USR01 User group in backflushing CHAR 12 0 SA_USR01
SCHIV Shift number NUMC 1 0 SA_SHIFT
MEINH Unit of Measure for Display UNIT 3 0 T006 MEINH
VORNE Reporting point operation number CHAR 4 0 PZPNR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
WAKZH Post goods issues in the background (worklist) CHAR 1 0 SA_WAKZH
Goods issue posted immediately online
1 Goods issue process immediately in update
2 Goods issue process later in the background
P Goods issue process posted (update/background)
FLKZH Production activities in the background (worklist) CHAR 1 0 SA_FLKZH
Production activities posted immediately online
1 Production activities immediately included in update
2 Production activities later in background
P Production activities posted (update/background)
KAPKZH Capacity reduction in the background (worklist) CHAR 1 0 SA_KAPKZH
Capacity reduction posted immediately online
1 Capacity reduction immediately in update
2 Capacity reduction later in the background
P Capacity reduction posted (update/background)
PLCNF Indicator: Backflushing With Planned Order CHAR 1 0 SA_PLCNF
OBART Object type for reference in document log - repetitive mfg CHAR 1 0 SA_OBART
1 KANBAN
2 Production lot
OBNUM Object reference: Document log - repetitive manufacturing CHAR 20 0 OBNUM
RSKZG Ind.: Reservation or dependent requirements object CHAR 1 0 SA_RSKZG
1 Reprocessing record (make-to-stk, KANBAN, nonval. m-t-ord.)
A Reprocessing record (valuated m-t-ord., common stock)
M Reprocessing record (valuated m-t-ord., separate stock)
RSNUM Number of reservation/dependent requirements NUMC 10 0 RSNUM
PWERK Planning Plant CHAR 4 0 WERKS_PL
ACHARG Receiving Batch for Repetitive Manufacturing CHAR 10 0 SA_CHARG
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINH Parallel Unit of Measure UNIT 3 0 * /CWM/MEINS
AUFLD Explosion Date for Bill of Material (BOM) DATS 8 0 REM_AUFLD

BLPK foreign key relationships

Table Field Check Table Check Field
0 BLPK AUFNR SAFK Run Schedule Master Data MANDT
0 BLPK AUFNR SAFK Run Schedule Master Data AUFNR
1 BLPK MANDT T000 Clients MANDT
0 BLPK MATNR MARA General Material Data MANDT
0 BLPK MATNR MARA General Material Data MATNR
1 BLPK MEINH T006 Units of Measurement MANDT
1 BLPK MEINH T006 Units of Measurement MSEHI
0 BLPK PKNUM PKHD Control Cycle MANDT
1 BLPK VERID MKAL Production Versions of Material WERKS
1 BLPK VERID MKAL Production Versions of Material VERID
0 BLPK WERKS T001W Plants/Branches MANDT
0 BLPK WERKS T001W Plants/Branches WERKS