SAP table S136 (Index: conditions in document)

SAP table S136 has 12 primary key fields being MANDT,KNUMH,KOPOS,BLTYP,KOBLNR,KNUMV,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,SSOUR.

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
KNUMH Number of the Condition Record CHAR 10 0 KNUMH
KOPOS Sequential number of the condition NUMC 2 0 KOPOS
BLTYP Document category for document index updates CHAR 2 0 BLTYP
01 Purchase Order/Scheduling Agreement
02 Optimized PO-Based Load-Building
10 Pricing: Pricing Worklist
11 Pricing: Index Structure
20 Customer Billing Document
30 Supplier Billing Document
31 Expenses Settlement
32 Supplier Settlement
35 Settlement Document List
40 Settlement Document
50 Assortment List
55 POS Outbound
60 Customer Settlement
70 Condition Contract: Billing Due List
71 Condition Contract: Purchase Order
85 Document category for Demand Management Foundation
90 Trading Contract
KOBLNR Document number: document index update CHAR 10 0 KOBLNR
KNUMV Number of the Document Condition CHAR 10 0 KNUMV
VRSIO Version number in the information structure CHAR 3 0 VRSIO
SPMON Period to analyze - month NUMC 6 0 SPMON
SPTAG Period to analyze - current date DATS 8 0 SPTAG
SPWOC Period to analyze - week NUMC 6 0 SPWOC
SPBUP Period to analyze - posting period NUMC 6 0 SPBUP
SSOUR Statistic(s) origin CHAR 4 0 SSOUR
PERIV Fiscal Year Variant CHAR 2 0 PERIV
VWDAT Pointer to administrative data NUMC 10 0 VWDAT
ANZKONV1 Number of a condition in the document DEC 9 0 MC_ANZKONV