SAP Table JGTVSG

IS-M/SD: Service Companies

JGTVSG (IS-M/SD: Service Companies) 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 JGTVSG to other SAP tables.

JGTVSG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VERSERVGES IS-M: Service Company VERSERVGES JGTGPNR CHAR 10 0
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
XZUGLOE IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
ANZZUST IS-M: Number of Carriers ANZZUST DEC 5 0
ANZAUSD IS-M: Number of Employees in External Sales Force ANZAUSD DEC 5 0
WEGSTRECKE IS-M: Estimated Path Length WEGSTRECKE QUAN 13 3
LEINS IS-M: Metric Unit of Measurement (Length) LEINS T006 UNIT 3 0
BUKRS IS-M: Company Code for Service Company JBUKRS T001 CHAR 4 0
XSERVZUST IS-M: Service Company in Home Delivery Role XSERVZUST CHAR 1 0
X Yes
NULL No
XSERVRECH IS-M: Service Company in Research Role XSERVRECH CHAR 1 0
X Yes
NULL No
XSERVVERM IS-M: Service Company in Sales Agent Role XSERVVERM CHAR 1 0
X Yes
NULL No
XSERVINK IS-M: Service Company in Collection Role XSERVINK CHAR 1 0
X Yes
NULL No
JZUGEHOER IS-M: Membership Status Own/Co-Administered/Third Party JZUGEHOER CHAR 1 0
1 Own
2 Co-administered
3 Third party
JFEIERTKAL IS-M: Public Holiday Calendar JFEIKAL THOCI CHAR 2 0

JGTVSG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JGTVSG BUKRS JGTVSG MANDT T001 Company Codes MANDT
JGTVSG BUKRS JGTVSG BUKRS T001 Company Codes BUKRS
JGTVSG JFEIERTKAL JGTVSG JFEIERTKAL THOCI Public holiday calendar index IDENT
JGTVSG LEINS JGTVSG LEINS T006 Units of Measurement MSEHI
JGTVSG LEINS JGTVSG MANDT T006 Units of Measurement MANDT
JGTVSG MANDT JGTVSG MANDT T000 Clients MANDT
JGTVSG VERSERVGES JGTVSG MANDT JGTGPNR IS-M: Central Business Partner Table MANDT
JGTVSG VERSERVGES JGTVSG VERSERVGES JGTGPNR IS-M: Central Business Partner Table GPNR