SAP Table S071

Condition Update

S071 (Condition Update) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link S071 to other SAP tables.

S071 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SSOUR Statistic(s) origin SSOUR CHAR 4 0
VRSIO Version number in the information structure VRSIO CHAR 3 0
KNUMH Condition record number KNUMH CHAR 10 0
KOPOS Sequential number of the condition KOPOS NUMC 2 0
SPMON Period to analyze - month SPMON NUMC 6 0
SPTAG Period to analyze - current date SPTAG DATS 8 0
SPWOC Period to analyze - week SPWOC NUMC 6 0
SPBUP Period to analyze - posting period SPBUP NUMC 6 0
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
VWDAT Pointer to administrative data VWDAT NUMC 10 0
STWAE Statistics currency STWAE CUKY 5 0
KWERT Accumulated condition value in local currency MC_KWERT CURR 19 2
KAWRT Cumulated condition base value MC_KAWRT CURR 19 2
AUNR1 Sales Document VBELN_VA CHAR 10 0
ANZKONV1 Number of a condition in the document MC_ANZKONV DEC 9 0
AUNR2 Sales Document VBELN_VA CHAR 10 0
ANZKONV2 Number of a condition in the document MC_ANZKONV DEC 9 0
AUNR3 Sales Document VBELN_VA CHAR 10 0
ANZKONV3 Number of a condition in the document MC_ANZKONV DEC 9 0

S071 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
S071 MANDT S071 MANDT T000 Clients MANDT
S071 PERIV S071 PERIV T009 Fiscal Year Variants PERIV
S071 PERIV S071 MANDT T009 Fiscal Year Variants MANDT