| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | PB0290 | HR Master Record: Infotype 0290 - Identity card CIS | 30 | PCODE | Subunit Code | nvarchar | 10 | 0 | | |
2 | T063O | OK Codes in Inventory Management | 4 | PCODE | Function Code | nvarchar | 20 | 0 | | |
3 | T5BPC | Postal Codes | 2 | PCODE | Postal Code | nvarchar | 4 | 0 | | |
4 | T5BPCT | Postal Code Name | 3 | PCODE | Postal Code | nvarchar | 4 | 0 | | |
5 | T5QPC | ETP Payment Codes for evaluation class 11 | 5 | PCODE | ETP Payment Code | nvarchar | 1 | 0 | | |
6 | T7GR2PRM | Global Payroll Parameters | 2 | PCODE | Parameter code (future use) | nvarchar | 12 | 0 | | |
7 | TCIC | CAD Process and Sub-process Codes | 2 | PCODE | Process code | nvarchar | 5 | 0 | | |
8 | TCIM | Set Parameters for CAD Transfer Strings | 3 | PCODE | Process code | nvarchar | 5 | 0 | | |
9 | TCIQ | CAD Control Table for Screens and Field Sets and Tables | 1 | PCODE | Process code | nvarchar | 5 | 0 | | |
10 | TCIR | Definition of User-defined Functions | 4 | PCODE | Process code for user-defined functions | nvarchar | 5 | 0 | | |
TOPAustralia |
11 | PA0850 | Infotype for Eligible Termination Payment | 66 | PCODE | ETP Payment Code | nvarchar | 1 | 0 | | |
TOPBenefits |
12 | PA0270 | HR Master Data Record: Infotype 0270 (COBRA Payments) | 27 | PCODE | Payment Method | nvarchar | 1 | 0 | | |
TOPCAD Integration |
13 | TCIQT | CAD Interface Function Texts | 2 | PCODE | Process code | nvarchar | 5 | 0 | | |
TOPChina |
14 | PA0529 | HR Master Record: Infotype 0529 (Add. Personal Data CN) | 28 | PCODE | Political status | nvarchar | 2 | 0 | | |
15 | PA0534 | HR Master Record: Infotype 0534 (Party Infomation) | 24 | PCODE | Political status | nvarchar | 2 | 0 | | |
16 | T7CN59 | Political status | 2 | PCODE | Political status | nvarchar | 2 | 0 | | |
17 | T7CN5R | Political status text | 3 | PCODE | Political status | nvarchar | 2 | 0 | | |
TOPClinical System |
18 | N1PRDOC | IS-H*MED: PATREG: Dokumente | 35 | PCODE | Özel gösterge (sunum kodu) | nvarchar | 4 | 0 | | |
19 | NDOCA | IS-H*MED: Document Management Data for Archived Documents | 30 | PCODE | Special Indicator (Presentation Code) | nvarchar | 4 | 0 | | |
20 | NDOCSTORNO | IS-H*MED: Canceled Documents | 31 | PCODE | Special Indicator (Presentation Code) | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
21 | DFKKOPUSTAXOUT00 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
22 | DFKKOPUSTAXOUT01 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
23 | DFKKOPUSTAXOUT02 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
24 | DFKKOPUSTAXOUT03 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
25 | DFKKOPUSTAXOUT04 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
26 | DFKKOPUSTAXOUT05 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
27 | DFKKOPUSTAXOUT06 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
28 | DFKKOPUSTAXOUT07 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
29 | DFKKOPUSTAXOUT08 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
30 | DFKKOPUSTAXOUT09 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
31 | DFKKOPUSTAXOUT10 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
32 | DFKKOPUSTAXOUT11 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
33 | DFKKOPUSTAXOUT12 | Tax Details - Telecommunications Tax (U.S.A.) | 6 | PCODE | Postal Code | nvarchar | 10 | 0 | | |
TOPDSD Connector |
34 | /DSD/ME_CUST_CPD | DSD CN: One-time Customer | 12 | PCODE | DSD Connector: Post Code | nvarchar | 10 | 0 | | |
35 | /DSD/ME_CUST_HD | DSD CN: Customer Details | 12 | PCODE | DSD Connector: Post Code | nvarchar | 10 | 0 | | |
TOPGlobal Trade Services |
36 | /SAPSLL/CORACT | Legal & Logistics Services: Activities | 10 | PCODE | Postal Code of Activity Location | nvarchar | 10 | 0 | | |
TOPLocalization |
37 | J_1BPRODCOD | Product Code | 2 | PCODE | Brazilian Product Code | nvarchar | 3 | 0 | | |
38 | J_1BPRODCODT | Product Code Text | 3 | PCODE | Brazilian Product Code | nvarchar | 3 | 0 | | |
TOPMexico |
39 | T77PAYMX65 | Districts for IT0006 | 7 | PCODE | Postal code | nvarchar | 10 | 0 | | |
TOPMonitoring |
40 | SAPBWPRFLS | BW Workload: Relation of Workload Profile and Class Names | 1 | PCODE | SAP Workload: Analysis View ID | nvarchar | 4 | 0 | | |
41 | SGLWLPRFLS | SAP Workload: Profile Codes and Class Names | 3 | PCODE | SAP Workload: Analysis View ID | nvarchar | 4 | 0 | | |
TOPNorway |
42 | T5V13 | SSB Positions code assignment | 6 | PCODE | SSB Position Code | nvarchar | 4 | 0 | | |
43 | T5V6C | SSB Positional Codes | 3 | PCODE | SSB Position Code | nvarchar | 4 | 0 | | |
44 | T5V6D | SSB Position Code Description | 4 | PCODE | SSB Position Code | nvarchar | 4 | 0 | | |
TOPPatient Management |
45 | NDOC | IS-H: Assignment of IS-H Objects to Documents in DMS | 30 | PCODE | Special Indicator (Presentation Code) | nvarchar | 4 | 0 | | |
TOPPayroll |
46 | T7SIA6 | Bank transfer - interface table | 15 | PCODE | Code for APP | nvarchar | 4 | 0 | | |
47 | T7SIAP | Tranfer code for APP | 6 | PCODE | Code for APP | nvarchar | 4 | 0 | | |
48 | T7SIBT | Virman configuration (WT->Accounts) | 8 | PCODE | Code for APP | nvarchar | 4 | 0 | | |
TOPPOS Interface |
49 | TWPUB | POS interface: conversion of transaction types sales rcpts | 3 | PCODE | POS system code | nvarchar | 4 | 0 | | |
50 | TWPUC | POS interface: currency code conversion | 3 | PCODE | Currency code | nvarchar | 5 | 0 | | |
51 | TWPUE | POS interface: conversion of subsystem units of measure | 3 | PCODE | Unit of measure | nvarchar | 4 | 0 | | |
52 | TWPUF | POS interface: conversion of store numbers | 3 | PCODE | Plant | nvarchar | 10 | 0 | | |
53 | TWPUK | POS interface: conversion of POS condition types | 3 | PCODE | POS system code | nvarchar | 4 | 0 | | |
54 | TWPUL | POS interface: conversion of POS language codes | 3 | PCODE | Language code | nvarchar | 4 | 0 | | |
55 | TWPUM | POS interface: conversion of POS movements types | 3 | PCODE | Movement Type | nvarchar | 4 | 0 | | |
56 | TWPUS | POS interface: conversion of POS tax codes | 3 | PCODE | Tax Code | nvarchar | 10 | 0 | | |
57 | TWPUV | POS interface: conversion of POS transaction types FI | 3 | PCODE | Transaction Type in POS System | nvarchar | 4 | 0 | | |
58 | TWPUW | POS interface: conversion of POS material groups | 3 | PCODE | Number | nvarchar | 15 | 0 | | |
59 | TWPUX | POS interface: reassignment of mat. tax classification key | 3 | PCODE | Tax classification of material | nvarchar | 4 | 0 | | |
60 | TWPUZ | POS interface: conversion of POS payment methods | 3 | PCODE | Payment method at POS system | nvarchar | 4 | 0 | | |
TOPPublic sector Sweden |
61 | T5SK0_CE | KPA events | 13 | PCODE | Pension code | nvarchar | 2 | 0 | | |
TOPRussia |
62 | PA0290 | HR Master Record: Infotype 0290 - Identity card CIS | 30 | PCODE | Subunit Code | nvarchar | 10 | 0 | | |