SAP Table G000 stores Condition Table for Material Listing/Exclusion $data

  

In this post, I will try and describe everything you need to know about the SAP g000 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 G000 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 G000....Right lets get started!


SAP G000 dictionary attributes

Object Name: G000
Dictionary Type: Transparent table
Description: Condition Table for Material Listing/Exclusion $


G000 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
KSCHLKSCHGCHAR4(0) T685Material listing/exclusion typeKSCHLVGKVF
VAKEYVAKEYCHAR100(0) Variable key 100 bytesVAKEYVS
DATBIKODATBIDATS8(0) Validity end date of the condition recordDATUMVF
DATABKODATABDATS8(0) Validity start date of the condition recordDATUMVF