| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OTEI/OCR_TSTG | Staging table for HDCC download data | 13 | ORT02 | District | nvarchar | 40 | 0 | | |
2 | CNV_20305_CEPC | SAP LT: Backup table of CEPC | 21 | ORT02 | District | nvarchar | 35 | 0 | | |
3 | P2AR_ARDIMP | Tax deduction results | 22 | ORT02 | District | nvarchar | 25 | 0 | | |
4 | P2AR_AROIMP | Other employers | 14 | ORT02 | District | nvarchar | 25 | 0 | | |
5 | P2RB_ADR | Address payroll Belgium | 8 | ORT02 | District | nvarchar | 40 | 0 | | |
6 | P2RD_ADR | Payroll Results: Address | 8 | ORT02 | District | nvarchar | 40 | 0 | | |
7 | P2RK_ADR | Address | 7 | ORT02 | District | nvarchar | 40 | 0 | | |
8 | P2RU_ADR | Address | 8 | ORT02 | District | nvarchar | 40 | 0 | | |
9 | T5W2MC | Municipality Codes | 8 | ORT02 | District | nvarchar | 40 | 0 | | |
10 | T7RUAB | KLADR: Boroughs (City districts) | 7 | ORT02 | District | nvarchar | 40 | 0 | | |
11 | T7RUPA0006 | PA0006 copy | 28 | ORT02 | District | nvarchar | 40 | 0 | | |
12 | T7RU_521B | Payee Keys (Russia extension for T521B) | 7 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPAddress ManagementBusiness Address |
13 | SADR | Address Management: Company Data | 11 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPArgentina |
14 | PA0390 | Income Tax: Deductions | 40 | ORT02 | District | nvarchar | 40 | 0 | | |
15 | PA0391 | Income Tax: Information on other employers | 33 | ORT02 | District | nvarchar | 40 | 0 | | |
16 | PA0392 | Social Security: General data | 48 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPBank Customer Accounts |
17 | BKKPOGISP | EDI Payments: Reporting Data to Clearing, Segm. E1EDLA1 | 30 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPBrazil |
18 | PA0736 | Alimony order for Brazil | 38 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPConstruction Industry |
19 | T5DB4 | HR Construction Site File | 34 | ORT02 | District | nvarchar | 25 | 0 | | |
20 | T5DB5 | Construction Site File: Work Breakdown Structure Element | 25 | ORT02 | District | nvarchar | 25 | 0 | | |
21 | T5DB6 | Construction Site File: Order | 25 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPControlling |
22 | CSKS | Cost Center Master Data | 40 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPCross-Application Components |
23 | BC490KKNA1 | General data in customer master | 45 | ORT02 | District | nvarchar | 35 | 0 | | |
24 | KKNA1 | General Data in Customer Master | 45 | ORT02 | District | nvarchar | 35 | 0 | | |
25 | SKNA1 | Customer Master table for BC417 Course | 45 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPCross-Application Objects in HR |
26 | HRP5583 | DB Table for Infotype 5583 | 21 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPCustomer Master |
27 | KNA1 | General Data in Customer Master | 45 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPFinancial Accounting |
28 | LFA1 | Vendor Master (General Section) | 9 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPHong Kong |
29 | T7HK2H | Provider Attributes | 10 | ORT02 | City | nvarchar | 25 | 0 | | |
TOPIndonesia |
30 | PA0318 | HR Master Record: Infotype Family data for Indonesia (0318) | 37 | ORT02 | District | nvarchar | 25 | 0 | | |
31 | T7ID1A | Jamsostek office address (Indonesia) | 9 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPInformation System |
32 | DKKOS | Balance Audit Trail | 17 | ORT02 | District | nvarchar | 25 | 0 | | |
33 | DKOKS | Open Item Account Balance Audit Trail Master Record | 18 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPJapan |
34 | T5JAD | HR company office address JP | 8 | ORT02 | District | nvarchar | 25 | 0 | | |
35 | T5JL1 | HR Address Infomation 1 of Personnel Subarea for LI JP | 8 | ORT02 | Line of Address in Kanji | nvarchar | 30 | 0 | | |
36 | T5JL2 | HR Address Infomation 2 of Personnel Subarea for LI JP | 8 | ORT02 | Line of Address in Kanji | nvarchar | 30 | 0 | | |
37 | T5JSI | HR Branch Office Information for Social Insurance JP | 8 | ORT02 | Line of Address in Kanji | nvarchar | 30 | 0 | | |
TOPLocalization |
38 | J_1BNFDOC | Nota Fiscal Header | 74 | ORT02 | District | nvarchar | 35 | 0 | | |
39 | J_1BNFNAD | Nota Fiscal partners | 14 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPMalaysia |
40 | PA0213 | Additional family information - Malaysia | 37 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPMaster Data |
41 | JGTSADR | IS-M: Extended Address Management | 25 | ORT02 | IS-M: City District | nvarchar | 35 | 0 | | |
42 | JSTALIAS | IS-M: Alias Table for Streets | 11 | ORT02 | IS-M: City District | nvarchar | 35 | 0 | | |
TOPMexico |
43 | PA0426 | Garnishment | 37 | ORT02 | District | nvarchar | 40 | 0 | | |
44 | T7MX01 | Additional Company Informaton | 8 | ORT02 | District | nvarchar | 40 | 0 | | |
45 | T7MX24 | IMSS Employer Regis. nos. | 7 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPOverhead Cost Controlling |
46 | CMDT_ADR | Generic Master Record: Address | 13 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPPatient Management |
47 | NPEZ | IS-H: Assignment of postal code to geographical area | 7 | ORT02 | IS-H: District | nvarchar | 40 | 0 | | |
48 | NPLZ | IS-H: Postal code catalog | 6 | ORT02 | IS-H: District | nvarchar | 40 | 0 | | |
TOPPendulum List Indirect Sales |
49 | /BEV4/PLDUMKDN | Conversion Table Customer/Object Numbers | 16 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPPersonnel Administration |
50 | PA0006 | HR Master Record: Infotype 0006 (Addresses) | 28 | ORT02 | District | nvarchar | 40 | 0 | | |
51 | PA0517 | HR Master Record: Infotype 0517 | 29 | ORT02 | District | nvarchar | 40 | 0 | | |
52 | PA0835 | HR master record for infotypes 0835 | 70 | ORT02 | City | nvarchar | 35 | 0 | | |
53 | T7SI1P | Slovenia items for personal areas | 20 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPProduct Cost Planning |
54 | CKBS | Base Planning Object - Unit Costing | 35 | ORT02 | City | nvarchar | 35 | 0 | | |
TOPProfit Center Accounting |
55 | CEPC | Profit Center Master Data Table | 21 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPRecruitment |
56 | PB0006 | HR Master Record: Infotype 0006 (Addresses) | 28 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPRecycling Administration Core Functions |
57 | J_7LSADR | Address Management: Company Data | 11 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
58 | /BEV1/CLDEB | Customer Information | 9 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPRussia |
59 | T7RU1B | Payee Keys of receiving orders (Russia standard) | 8 | ORT02 | District | nvarchar | 25 | 0 | | |
TOPSAP Media |
60 | J_1SFSPED | IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping | 23 | ORT02 | IS-M: City District | nvarchar | 35 | 0 | | |
TOPShipping |
61 | DVK01 | R/2-R/3 Link: Delivery Header Data R2 -> R3 | 16 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPThailand |
62 | PA0187 | Additional family data | 27 | ORT02 | District (TH) | nvarchar | 40 | 0 | | |
TOPTransfer Postings |
63 | J_1AAWAYBL | Way Bills for asset movements | 31 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPTravel Expenses |
64 | PTRV_TRIPCHN_46C | Table of all Trip Destinations f. Processing Recurring Dest. | 29 | ORT02 | District | nvarchar | 40 | 0 | | |
65 | PTRV_TRIP_CHAIN | Table of all Trip Destinations f. Processing Recurring Dest. | 29 | ORT02 | District | nvarchar | 40 | 0 | | |
66 | T706_CITY_CD_46C | Table for Specifying the City Code/Community Code Number | 5 | ORT02 | District | nvarchar | 40 | 0 | | |
67 | T706_CITY_CD_D | Definition: City Codes / Community Code No., Date-Dependent | 5 | ORT02 | District | nvarchar | 40 | 0 | | |
68 | T706_CITY_CD_D_2 | Definition: City Codes / Community Code No., Date-Dependent | 5 | ORT02 | District | nvarchar | 40 | 0 | | |
69 | T706_CITY_CODE | Table for Specifying the City Code/Community Code Number | 5 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPTravel Planning |
70 | TA20BUILDING | Buildings | 5 | ORT02 | District | nvarchar | 40 | 0 | | |
TOPTreasury |
71 | SANS1 | Address table | 6 | ORT02 | District | nvarchar | 35 | 0 | | |
72 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 21 | ORT02 | District | nvarchar | 35 | 0 | | |
TOPUser and Authorization Management |
73 | USR03 | User address data | 26 | ORT02 | Location | nvarchar | 25 | 0 | | |