| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DVKTX | R/2-R/3 Link: Delivery texts R2 -> R3 | 37 | TEXT30 | Text R/2-R/3 Link | nvarchar | 72 | 0 | | |
2 | T159Q | Inventory Management Print Function: Value Table for KZDRU | 3 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
3 | T159T | Invntry Mgmt. Printing: Text Table for Table T159Q | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPBasic Functions |
4 | T007D | Texts for Tax Groups | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
5 | T059W | Reasons for exemption per withholding tax type | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
6 | WITH_CTNCLT | Numbering class text table for withholding tax certificate | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
7 | WITH_CTNGRT | Numbering group text table for withholding tax certificate | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPBilling |
8 | J_1ADOCCL2 | Texts for official document class in Argentina | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPBudgeting |
9 | FMBTGROUPT | Text for Budget Type Group | 6 | TEXT30 | Budget Type group description | nvarchar | 30 | 0 | | |
10 | FMBUDTYPET | Texts for Budget Types | 8 | TEXT30 | Budget type long text (30) | nvarchar | 30 | 0 | | |
11 | FMCUPRPT | Texts for Field Profiles for Provisionally Posted Bdgt Docs | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
12 | FMFSGT | Text for Field Status Group | 4 | TEXT30 | Field Status Group description | nvarchar | 30 | 0 | | |
13 | FMFSST | Text for Field Status definition | 4 | TEXT30 | Field Status String description | nvarchar | 30 | 0 | | |
14 | FMFSVT | Text for Field Status Variant definition | 4 | TEXT30 | Field Status Variant description | nvarchar | 30 | 0 | | |
TOPBusiness Partner |
15 | TP019T | Business Partner: Key for Blank Fields | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
16 | TPZ18T | Business Partner: Key for Blank Fields | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPCollectionsDisbursements |
17 | TKKVITVORT | Text Table Internal Subtransactions FS-CD | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPContract Accounts Receivable and Payable |
18 | TFK010T | Text Table for Set of Rules for Sales/Purchase Tax Recording | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
19 | TFK_NUMGR_IT_T | Texts for numbering group for official documents Italy | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
20 | TFK_ODNGRP_T | Text for Grouping for Official Document Numbers | 4 | TEXT30 | Description of Grouping for Official Document Numbers | nvarchar | 30 | 0 | | |
TOPContract Billing |
21 | EDSCT | Disct Header Data (Txts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
22 | EOPGROUPT | Operand Group (Text) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
23 | EPREIT | Mstr Pricing Table for All Prices (Texts) | 6 | TEXT30 | Text Field | nvarchar | 50 | 0 | | |
24 | KJCCSJ3DBI03T | Naming Convention for Operands for Installed Demand | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
25 | TE021T | Reas.for Blocking Billg (Txts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
26 | TE023T | Reas.for Releas.(Txts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
27 | TE067T | Rate Fact Groups (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
28 | TE069T | Rate Types (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
29 | TE093T | Doc.Type (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
30 | TE127T | Manual Bill Outsorting (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
31 | TE128T | Manual Bill Outsorting (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
32 | TE187T | Utility Company (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
33 | TE191T | Outsorting Check Groups for Billing (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
34 | TE192T | Outsorting Check Groups for Invoicing (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
35 | TE221T | Operands (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
36 | TE369T | Voltage Level (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
37 | TE375T | Operand Categories (Texts) | 3 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
38 | TE432T | Period Control (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
39 | TE473T | Industry (Txts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
40 | TE497T | Operation Type for Lighting Unit | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
41 | TE667T | Doc.Type Cat. | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
42 | TE677T | Heating Inst. Descript. (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
43 | TE681T | Process. Status of Spec. Agreement for Heating Inst. (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
44 | TE696T | Gas Pressure Level at Installation Level (Grid) (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
45 | TE697T | Classification of Employees (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
46 | TE835T | Line Item Type (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPData Collection |
47 | TMC5T | Description of Events for Statistics Updating | 3 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
48 | TMC6T | Description of Units for Statistics Updating | 3 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPDevice installation |
49 | TE791T | Rec. Reasons (Txt) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPIncentive and Commission Management ICM |
50 | TCACS_AVAD1T | Type of AVAD message: Text | 4 | TEXT30 | AVAD Message Type Description | nvarchar | 30 | 0 | | |
TOPInformation System |
51 | T007X | Text for Grouping Tax Amounts | 7 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPLocalization |
52 | DOCCLSST | Texts for official document class | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
53 | J_1AACTT | Texts for activity codes for social security withholding | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
54 | J_1ACFOPT | Texts for codes for foreign natural or legal persons | 6 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
55 | J_1ACITIT | Texts for C.I.T.I. codes | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
56 | J_1ACMCDT | Texts for customs codes | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
57 | J_1ACTYPT | C.I.T.I. transaction type | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
58 | J_1ADRVERT | Texts for versions of VAT daily report | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
59 | J_1ADTYPT | Texts for distribution types for Gross Income Tax | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
60 | J_1AFITPT | Texts for Fiscal Types | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
61 | J_1AINFSKT | Text Table: Inflation Keys - G/L Account | 5 | TEXT30 | Inflation Key - G/L Account (Description) | nvarchar | 30 | 0 | | |
62 | J_1ANUGR1T | Texts for numbering group for official documents | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
63 | J_1ANUGR3T | Texts for numbering groups for withh. cert. numbering | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
64 | J_1AOFTPT | Texts for official document types | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
65 | J_1APRTCH2 | Capital letters - texts | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
66 | J_1ARFZT | Texts for reasons for zero VAT | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
67 | J_1ASKCLST | Account class text table | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
68 | J_1ASNRT | Texts for subsidiary numbers | 5 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
69 | J_1ATODCT | Texts for types of identification | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
70 | J_1AZFSCHT | Text Table: Allocation Key: Branch - Company Code | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPMaster Data |
71 | TE687T | Texts: Contract Cat. of Heat. Installation | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPMeter Reading |
72 | TE017T | MR Group (Text) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
73 | TE115T | Mtr Rdr (Text) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
74 | TE408T | Check Classes of Independent Validations (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
75 | TE438T | Meter Reading Control (Texts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
76 | TE439T | Instlltn Ty.(Txts) | 4 | TEXT30 | Text (30 Characters) | nvarchar | 30 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
77 | /BEV3/CHCKTGWE | Account group of the ship-to party | 3 | TEXT30 | Account Group Name | nvarchar | 30 | 0 | | |
TOPReuse Services for Country Development |
78 | T5F99FCT | Forms: Condition description | 6 | TEXT30 | Text | nvarchar | 30 | 0 | | |
TOPSAP Business Partner |
79 | TB930T | Business Partner: Marital Property Regime: Texts | 4 | TEXT30 | Description | nvarchar | 30 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
80 | NLVERZF_002 | Konversion SAP Facharzt nach VEKTIS Sorge arzt | 7 | TEXT30 | Tekst 30 posities | nvarchar | 30 | 0 | | |
81 | NLVERZF_003 | Konversion SAP Entlassung nach VEKTIS Entlassung | 5 | TEXT30 | Tekst 30 posities | nvarchar | 30 | 0 | | |
TOPTraders and Schedulers Workbench |
82 | OIJWLRCST | Worklist reason code source texts | 4 | TEXT30 | OIL-TSW: Short text 30 char's | nvarchar | 30 | 0 | | |
TOPUse AP-MD-BP Components |
83 | TB905T | BP Relationship Types: Texts | 5 | TEXT30 | Description | nvarchar | 30 | 0 | | |