SAP ABAP Table JST_KGS_CONS (IS-M: Table for DMK Consolidation)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-MD (Application Component) Master Data
     ⤷ JMDGEN (Package) Generic Master Data Media

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JST_KGS_CONS	Table Relationship Diagram
Short Description	IS-M: Table for DMK Consolidation

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LAND1_ALT	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
3	KREISG_ALT	☑	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	JSTKGSPRO
4	KGSART_ALT	☑	KG_SATZART	KG_SATZART	CHAR	1	0	IS-M: Record type for district municipality key
5	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
6	KREISG_SCH	☑	KREISG_SCH	KREISG_SCH	CHAR	15	0	IS-M: District Municipality Key	JSTKGSPRO
7	KG_SATZART	☑	KG_SATZART	KG_SATZART	CHAR	1	0	IS-M: Record type for district municipality key
8	VERSION	☑			CHAR	7	0
9	.INCLUDE	☐				0	0	IS-PSD: Include with Attributes of Table JSTKGSPRO
10	KG_NAME	☐	KG_NAME	TEXT40	CHAR	40	0	IS-M: Name for district municipality key
11	KG_NAME_G	☐	KG_NAME_G	CHAR40	CHAR	40	0	IS-M: Name of district munic.in block capitals for MC
12	SUCHFELDKG	☐	SUCHFELD	CHAR40	CHAR	40	0	Search field for accessing postal structures w/o matchcode
13	X_FEHLER	☐	X_FEHLER	ANKREUZ	CHAR	1	0	IS-M: Incorrect data record
14	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
15	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
16	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
17	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
18	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
19	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
20	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
21	.INCLUDE	☐				0	0	Version (for upgrade procedures for postal data)
22	VERSION_J	☐	VERSION_J	JAHR	NUMC	4	0	IS-M: Version year
23	VERSION_M	☐	VERSION_M	AM_MONAT	NUMC	2	0	IS-M: Version month
24	VERSION_T	☐	VERSION_T	AM_TAG	NUMC	2	0	IS-M: Version day
25	VERSION_NR	☐	VERSION_NR	VERSION_NR	CHAR	5	0	IS-M: Version number
26	GUELTIGAB	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
27	GUELTIGBIS	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
28	LOESCH_VM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
29	KG_NAMEALT	☐	KG_NAME	TEXT40	CHAR	40	0	IS-M: Name for district municipality key

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JST_KGS_CONS	KREISG_ALT	JSTKGSPRO	KREISG_SCH	KEY	1	CN
2	JST_KGS_CONS	KREISG_SCH	JSTKGSPRO	KREISG_SCH	KEY	1	CN
3	JST_KGS_CONS	LAND1	T005	LAND1	KEY	1	CN
4	JST_KGS_CONS	LAND1_ALT	T005	LAND1	KEY	1	CN
5	JST_KGS_CONS	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	473