| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BSEC | One-Time Account Data Document Segment | 40 | ANRED | Title | nvarchar | 15 | 0 | | |
2 | CNV_20305_CEPC | SAP LT: Backup table of CEPC | 15 | ANRED | Title | nvarchar | 15 | 0 | | |
3 | CNV_20800_KNVK | CNV backup copy: Customer master contact person | 14 | ANRED | Form of address for contact person (Mr, Mrs...etc) | nvarchar | 30 | 0 | | |
4 | FUDT_VDOCBSEC | One-Time Account Data Segment of Verification Document | 40 | ANRED | Title | nvarchar | 15 | 0 | | |
5 | FUDT_VDOCBSECH | One-Time Account Data Segment of Verification Doc(History) | 40 | ANRED | Title | nvarchar | 15 | 0 | | |
6 | P2RB_NAME | Payroll Results: Name of Employee | 10 | ANRED | Title | nvarchar | 15 | 0 | | |
7 | P2RD_NAME | Payroll Results: Name of Employee | 10 | ANRED | Title | nvarchar | 15 | 0 | | |
8 | P2RK_NAME | Name of Employee | 6 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
9 | P2RN_NNAM | Personal Data | 14 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
10 | P2RU_NAME | Name of Employee | 7 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
11 | TXV01 | Forms of address key translations | 3 | ANRED | Form-of-Address Key | nvarchar | 2 | 0 | | |
12 | TZV01 | Form-of-Address Key | 2 | ANRED | Form-of-Address Key | nvarchar | 2 | 0 | | |
13 | HRP1702 | DB Table for Infotype 1702 | 36 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
14 | T7PIQ_GB_TITLE | UCAS: Mapping table UCAS Titles -> SAP Title/Form of Addre | 3 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPAddress ManagementBusiness Address |
15 | SADR | Address Management: Company Data | 4 | ANRED | Title | nvarchar | 15 | 0 | | |
16 | SADRP | Address Management: Personal Data | 4 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPAdvertising Management |
17 | JJTAM | IS-M/AM: Media Contact Person | 13 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
18 | TJHAF | IS-M/AM: Assign Address to Name Fields in Address Creation | 3 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
19 | TJHWWW_JHAW | IS-M/AM: Enter Classified Ad IAC: General Settings | 13 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
TOPAustria |
20 | PA0632 | HR Master Record: Infotype 0632 (Semiretirement A) | 39 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPAutomatic Payments |
21 | PAYRQ | Payment Requests | 30 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPBank Customer Accounts |
22 | BKKPOGISP | EDI Payments: Reporting Data to Clearing, Segm. E1EDLA1 | 29 | ANRED | Form of Address | nvarchar | 15 | 0 | | |
TOPBasic Data |
23 | NGPA | IS-H: Business Partners | 12 | ANRED | IS-H: Form-of-Address Key | nvarchar | 2 | 0 | | |
TOPBusiness Partner |
24 | TIVBPVENDORGEN | Vendor Preassignment (General Data) | 3 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPChina |
25 | PA0528 | HR Master Record: Infotype 0528 (Family information) | 41 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPClinical System |
26 | N1PRPAT | IS-H*MED: PATREG: Patientenstammdatentabelle | 26 | ANRED | IS-H: Hitap biçimi anahtari | nvarchar | 2 | 0 | | |
27 | N1PRTMPPAT | IS-H*MED: PATREG: Temporäre Patientenstammdatentabelle | 27 | ANRED | IS-H: Hitap biçimi anahtari | nvarchar | 2 | 0 | | |
28 | N1PRTMPPATLOC | IS-H*MED: PATREG: NPAT umgeschlüsselt auf N1PRPAT lokal | 27 | ANRED | IS-H: Hitap biçimi anahtari | nvarchar | 2 | 0 | | |
TOPControlling |
29 | CSKS | Cost Center Master Data | 34 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPCross-Application Components |
30 | BC490KKNA1 | General data in customer master | 18 | ANRED | Title | nvarchar | 15 | 0 | | |
31 | KKNA1 | General Data in Customer Master | 18 | ANRED | Title | nvarchar | 15 | 0 | | |
32 | SKNA1 | Customer Master table for BC417 Course | 18 | ANRED | Title | nvarchar | 15 | 0 | | |
33 | SKNVK | Customer Master Contact table for BC417 Course | 13 | ANRED | Form of address for contact person (Mr, Mrs...etc) | nvarchar | 30 | 0 | | |
TOPCross-Application Objects in HR |
34 | BBP_TSAD3HR | SRM Decoupling: Copy of Table TSAD3HR | 2 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
35 | HRP5582 | DB Table for Infotype 5582 | 20 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
36 | TCACS_ANRED | Conversion of Form of Address: HR -> Business Partner | 2 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPCustomer Master |
37 | KNA1 | General Data in Customer Master | 18 | ANRED | Title | nvarchar | 15 | 0 | | |
38 | KNVK | Customer Master Contact Partner | 13 | ANRED | Form of address for contact person (Mr, Mrs...etc) | nvarchar | 30 | 0 | | |
TOPFinancial Accounting |
39 | LFA1 | Vendor Master (General Section) | 20 | ANRED | Title | nvarchar | 15 | 0 | | |
40 | VBSEC | Document Parking One-Time Data Document Segment | 40 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPFSCM In-House Cash |
41 | IHC_DB_PN_BP | IHC: Address Data of Bus. Partners Involved in Payment Order | 7 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPFunds Management-Specific Postings |
42 | PAYRC | Additional Header Data for Recovery Order | 13 | ANRED | Title | nvarchar | 15 | 0 | | |
43 | PSOSEC | Recurring Request Document Segment, One-Time Data | 38 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPGL Account Posting |
44 | TCJ_CPD | FBCJ: One-Time Account Data of Cash Journal Document Items | 41 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPHong Kong |
45 | PA0344 | HR Master Record: Infotype 0344 (Familiy members HK) | 45 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPInformation System |
46 | DKKOS | Balance Audit Trail | 8 | ANRED | Title | nvarchar | 15 | 0 | | |
47 | DKOKS | Open Item Account Balance Audit Trail Master Record | 9 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPInvoice Verification |
48 | RBKP | Document Header: Invoice Receipt | 115 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPLoans Management |
49 | VDAUSZ | Drawings on Disbursement | 52 | ANRED | Title | nvarchar | 15 | 0 | | |
50 | VDZNB_USAGE | Payment Postprocessing: Usage of a Payment Postpr. Activity | 66 | ANRED | Title | nvarchar | 15 | 0 | | |
51 | VZFZE_VDAUSZ | Central Entry Table for Release Procedure | 54 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPLocalization |
52 | J_1BNFDOC | Nota Fiscal Header | 67 | ANRED | Title | nvarchar | 15 | 0 | | |
53 | J_1BNFNAD | Nota Fiscal partners | 7 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPMaster Data |
54 | JGTSADR | IS-M: Extended Address Management | 14 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
TOPOverhead Cost Controlling |
55 | CMDT_ADR | Generic Master Record: Address | 7 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPPatient Management |
56 | NPAP | IS-H: Provisional Patient Master Data | 14 | ANRED | IS-H: Form-of-Address Key | nvarchar | 2 | 0 | | |
57 | NPAT | IS-H: Patient Master Data (General) | 23 | ANRED | IS-H: Form-of-Address Key | nvarchar | 2 | 0 | | |
TOPPayment Transactions |
58 | REGUH | Settlement data from payment program | 13 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPPendulum List Indirect Sales |
59 | /BEV4/PLDUMKDN | Conversion Table Customer/Object Numbers | 9 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPPeriodical Sales and Distribution |
60 | JKWWWTEMP_BP | IS-M/SD: WWW, Temporary Table for BP Data from Internet | 5 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
61 | JKWWWTEMP_GIFT | IS-M: Internet Temporary Table: Gift Data | 23 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
62 | JKWWWTEMP_REDIR | IS-M: Temporary Internet Table: Redirection Data | 23 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
63 | JKWWWTEMP_SERV | IS-M: Temporary Table for Changes from Internet | 4 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
64 | PA0002 | HR Master Record: Infotype 0002 (Personal Data) | 38 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
65 | T522 | Title Keys | 3 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
66 | T522G | Title Keys | 2 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
67 | T522T | Forms of Address | 3 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPProduct Cost Planning |
68 | CKBS | Base Planning Object - Unit Costing | 24 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPProfit Center Accounting |
69 | CEPC | Profit Center Master Data Table | 15 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPPurchasing |
70 | EKAN | Vendor Address: Purchasing Document | 13 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPRecruitment |
71 | PB0002 | HR Master Record: Infotype 0002 (Personal Data) | 38 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPRecycling Administration Core Functions |
72 | J_7LSADR | Address Management: Company Data | 4 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
73 | /BEV1/CLDEB | Customer Information | 3 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPReuse Services for Country Development |
74 | T5F99FOADM | Form of Address status key recodification for DAQ reports | 4 | ANRED | Form-of-Address Key | nvarchar | 4 | 0 | | |
75 | T5F99FOAM | Form of Address status key recodification for DAQ reports | 4 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPSales Promotions |
76 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 16 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
77 | NPSPAT | IS-H: Pseudonymized Patient Master Data (General) | 8 | ANRED | Pseudonymized Form of Address Key | nvarchar | 4 | 0 | | |
TOPSAP Media |
78 | J_1SFSPED | IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping | 10 | ANRED | Form of Address Key | nvarchar | 2 | 0 | | |
TOPShipping |
79 | DVK01 | R/2-R/3 Link: Delivery Header Data R2 -> R3 | 6 | ANRED | Form of address | nvarchar | 15 | 0 | | |
TOPStrategic Enterprise Management |
80 | TSAD3HR | Form of Address Conversion: HR Format - SAP Business Partner | 2 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPThailand |
81 | PA0187 | Additional family data | 24 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
82 | T7THSP | Name Prefix/ Form of Address Codes | 2 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPTraining and Event Management |
83 | HRP1034 | Infotype 1034 DB table | 18 | ANRED | Form-of-Address Key | nvarchar | 1 | 0 | | |
TOPTransfer Postings |
84 | J_1AAWAYBL | Way Bills for asset movements | 26 | ANRED | Title | nvarchar | 15 | 0 | | |
TOPTreasury |
85 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 3 | ANRED | Title | nvarchar | 15 | 0 | | |