SAP table SVKO (Allocation Rule / IS-R Allocation)

SAP table SVKO has 2 primary key fields being MANDT,SBELN.

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
SBELN No. of allocation rule CHAR 10 0 SBELN
SVBEZ Description of alloc rule CHAR 40 0 SVBES
SVART Allocation rule type CHAR 4 0 T622 SVEAR
GUELT Validity date of allocation rule DATS 8 0 SGDAT
ARAKT Alloc. rule status CHAR 1 0 ARAKT
1 Not active
2 Active
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
ACLIN Internal class number, material class NUMC 10 0 KLAH ACLIN
FCLIN Internal class number, plant NUMC 10 0 KLAH FCLIN
FIXIE Plants fixed in AR CHAR 1 0 SVFIX
DYFKL Indicates generated alloc rule CHAR 1 0 DYFKL
MSTER Indicates that alloc rule is a model CHAR 1 0 MSTER
RUNDG Rounding off in allocation table CHAR 1 0 RUNDG
A Round up
B Round down
C Round off
D Quantity optimizing (round off as per rounding profile)
RESTV Split remainder CHAR 1 0 RESTV
A Accept remainder - adjust total quantity
B Remainder to plant with largest quantity
C Remainder to plant with smallest quantity
D Remainder to plants with largest quantities
E Remainder to plants with smallest quantities
DIMAQ Category of Quotas (Ratios/Quantities) CHAR 1 0 DIM
A Ratio (Manual Entry and Allocation Rule Generation)
B Fixed Quantity in Order Units (Entered Manually)
C Fixed Qty in OUn (AR Generation: Total of Key Figures)
D Fixed Qty in OUn (AR Generation: Average of Key Figures)
E Trend Factor (Usage in Allocation Strategy)
KETYP Key Figure Category CHAR 1 0 T625 KETYP
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
SPERI Period split: info structure CHAR 1 0 DTPER
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
PDVON Starting date of period DATS 8 0 PDVON
PDBIS End date of period DATS 8 0 PDBIS
MATNR Material Number CHAR 40 0 MARA MATNR

SVKO foreign key relationships

Table Field Check Table Check Field
0 SVKO ACLIN KLAH Class Header Data MANDT
0 SVKO ACLIN KLAH Class Header Data CLINT
1 SVKO EKGRP T024 Purchasing Groups EKGRP
0 SVKO EKORG T024E Purchasing Organizations EKORG
1 SVKO FCLIN KLAH Class Header Data MANDT
1 SVKO FCLIN KLAH Class Header Data CLINT
0 SVKO KETYP T625 Field Relationship for Info Structure MANDT
0 SVKO KETYP T625 Field Relationship for Info Structure KETYP
0 SVKO KETYP T625 Field Relationship for Info Structure FIELDNAME
1 SVKO MANDT T000 Clients MANDT
0 SVKO MATNR MARA General Material Data MANDT
0 SVKO MATNR MARA General Material Data MATNR
1 SVKO PERIV T009 Fiscal Year Variants MANDT
1 SVKO PERIV T009 Fiscal Year Variants PERIV
0 SVKO SVART T622 Allocation Rule Document Types MANDT
0 SVKO SVART T622 Allocation Rule Document Types SVART