SAP table SER09 (Doc. Header for Serial Numbers for Purchase Requisition Item)

SAP table SER09 has 2 primary key fields being MANDT,OBKNR.

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 MANDT
OBKNR Object list number INT8 19 0 OBJKNR
BANFN Purchase Requisition Number CHAR 10 0 EBAN BANFN
BNFPO Item number of purchase requisition NUMC 5 0 EBAN BNFPO
ETENR Delivery Schedule Line Counter NUMC 4 0 EETEN
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BSART Purchasing Document Type CHAR 4 0 T161 ESART
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
WERK Plant CHAR 4 0 T001W EWERK
LOEKZ Deletion Indicator in Purchasing Document CHAR 1 0 ELOEK
ANZSN Number of serial numbers INT4 10 0 ANZSN
DATUM Date DATS 8 0 DATUM
SERRU Type of subcontracting CHAR 1 0 SERRU
Subcontracting
1 Refurbishment with unchanged material number
2 Refurbishment with changed material number
3 Replacement

SER09 foreign key relationships

Table Field Check Table Check Field
0 SER09 BANFN EBAN Purchase Requisition BANFN
0 SER09 BANFN EBAN Purchase Requisition BNFPO
1 SER09 BNFPO EBAN Purchase Requisition BANFN
1 SER09 BNFPO EBAN Purchase Requisition BNFPO
0 SER09 BSART T161 Purchasing Document Types MANDT
1 SER09 PSTYP T163 Item Categories in Purchasing Document MANDT
1 SER09 PSTYP T163 Item Categories in Purchasing Document PSTYP
0 SER09 WERK T001W Plants/Branches WERKS