SAP Table F000 stores Condition Table for Secondary Indexes $data

  

In this post, I will try and describe everything you need to know about the SAP f000 table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for F000 what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from F000....Right lets get started!


SAP F000 dictionary attributes

Object Name: F000
Dictionary Type: Transparent table
Description: Condition Table for Secondary Indexes $


F000 field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
KAPPLKAPPLCHAR2(0) T681AApplicationKAPPLKAPVF
VAKEYVAKEY_FCHAR100(0) Variable keyVAKEY_FVS
DATABDATABDATS8(0) Valid-From DateDATUMV
DATBIDATBIDATS8(0) Valid To DateDATUMV
KNUMHKNUMHCHAR10(0) Condition record numberKNUMBVF
KOPOSKOPOSNUMC2(0) Sequential number of the conditionNUM02VF