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 |
Possible values
|
||||||||
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 |
Possible values
|
||||||||
XSERVRECH | IS-M: Service Company in Research Role | XSERVRECH | CHAR | 1 | 0 |
Possible values
|
||||||||
XSERVVERM | IS-M: Service Company in Sales Agent Role | XSERVVERM | CHAR | 1 | 0 |
Possible values
|
||||||||
XSERVINK | IS-M: Service Company in Collection Role | XSERVINK | CHAR | 1 | 0 |
Possible values
|
||||||||
JZUGEHOER | IS-M: Membership Status Own/Co-Administered/Third Party | JZUGEHOER | CHAR | 1 | 0 |
Possible values
|
||||||||
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 |