| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 95 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 96 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
3 | /OPT/VIM_1ITEM_S | Document Item | 101 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
4 | /OPT/VIM_TITEM | Document Item | 101 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
5 | AUAA | Settlement Document: Receiver Segment | 21 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
6 | BSEG | Accounting Document Segment | 210 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
7 | BSSEG | Accounting Document Segment | 199 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
8 | CNV_20100_CSKB | Backup copy - CSKB | 20 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
9 | CNV_20100_SKB1 | CNV backup copy for SKB1 | 35 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
10 | CNV_20305_CBUKRS | SAP LT: Backup table of CEPC_BUKRS | 7 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
11 | CNV_20305_CEPC | SAP LT: Backup table of CEPC | 38 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
12 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 199 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
13 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 199 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
14 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 199 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
15 | GLPOS_C_CT | FI Document: Entry View | 211 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
16 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 211 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
17 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 211 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
18 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 211 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
19 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 216 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
20 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 216 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
21 | NNL_ZH308_V9_R04 | ZH308 V09 Record04 Soll Daten | 6 | RECID | | nvarchar | 10 | 0 | | |
22 | NNL_ZH308_V9_R06 | ZH308 V09 Record06 Soll Daten | 6 | RECID | | nvarchar | 10 | 0 | | |
23 | NNL_ZH308_V9_R16 | ZH308 V09 Record16 Soll Daten | 6 | RECID | | nvarchar | 10 | 0 | | |
24 | PA3347 | HR Master Record Infotype 3347 | 32 | RECID | Unique Record Identifier (ID) | nvarchar | 32 | 0 | | |
25 | PAPBSGBH_13_C | HESA: Contract table (2012/13 onwards) | 8 | RECID | HESA: Record type indicator | nvarchar | 5 | 0 | | |
26 | PAPBSGBH_13_P | HESA: Person table (2012/13 onwards) | 7 | RECID | HESA: Record type indicator | nvarchar | 5 | 0 | | |
27 | PAPBSGB_HESA_C | HESA Archive table for NISR Contract table | 8 | RECID | HESA: Record type indicator | nvarchar | 5 | 0 | | |
28 | PAPBSGB_HESA_GR | HESA Archive table for NISR Grade table | 8 | RECID | HESA: Record type indicator | nvarchar | 5 | 0 | | |
29 | PAPBSGB_HESA_P | HESA: Archive table for NISR Person table | 7 | RECID | HESA: Record type indicator | nvarchar | 5 | 0 | | |
30 | PAPBSGB_TPS_ARCH | TPS Archive table for TPS Annual return records of type 1 | 3 | RECID | TPS Control record ID | nvarchar | 8 | 0 | | |
31 | T052R | Rules for Issuing Invoices | 5 | RECID | Rules for Issuing an Invoice | nvarchar | 4 | 0 | | |
32 | T5GPBST_CONTROL | TPS Control records | 2 | RECID | TPS Control record ID | nvarchar | 8 | 0 | | |
33 | T7CNTPM_PROCREC | TPM: Process Record | 2 | RECID | Process Record ID | nvarchar | 32 | 0 | | |
34 | VIXCESM180REC | Modelo 180 - Witholding Tax Recipients DMEE Line 02 | 6 | RECID | Recipient VAT Registration Number | nvarchar | 20 | 0 | | |
35 | YVIM_1ITEM | Document Item | 101 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
36 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 213 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
37 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 213 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPBasic Functions |
38 | SKB1 | G/L account master (company code) | 34 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
39 | SKM1 | Sample G/L accounts | 32 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPBelgium |
40 | T5BSR | Reductions for an employee reported on level 3 | 8 | RECID | Record identification on SI tape | nvarchar | 3 | 0 | | |
TOPConstruction Equipment Management |
41 | J_3GBELK | Document File - Header Data | 96 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
42 | J_3GBELP | Document Data - Item Data | 129 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
43 | DFKKTHI | Transfer Records for Invoice Issue by Third Party | 18 | RECID | Recipient | nvarchar | 40 | 0 | | |
44 | DFKKTHI_HIST2 | Reversal: Historical Entries DFKKTHI (w/o Tax Posting) | 11 | RECID | Recipient | nvarchar | 40 | 0 | | |
45 | DFKKTHI_SUM | Aggregated Transfer Records for Invoicing | 9 | RECID | Recipient | nvarchar | 40 | 0 | | |
46 | DFKKTHP | Transfer Records for Billing on Behalf of 3rd Party | 21 | RECID | Recipient | nvarchar | 40 | 0 | | |
TOPControlling |
47 | CSKB | Cost Elements (Data Dependent on Controlling Area) | 19 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
48 | CSKS | Cost Center Master Data | 68 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
49 | AAUUFK | Order master data | 94 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPDocument Management System |
50 | DRZA | DDS: Recipient list (document <-> recipient allocations) | 8 | RECID | Recipient for document distribution | nvarchar | 70 | 0 | | |
51 | DRZOC | DDS: partial order | 7 | RECID | Recipient for document distribution | nvarchar | 70 | 0 | | |
52 | DRZOP | DDS: distribution order package | 10 | RECID | Recipient for document distribution | nvarchar | 70 | 0 | | |
TOPElectronic Bank Statement |
53 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 48 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
54 | FEB_ACT | Acct Assignment Templates | 48 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPExternal Services |
55 | ESKN | Account Assignment in Service Package | 34 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
56 | /OPT/VIM_1ITEM | Document Item | 101 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
57 | ACCTIT | Compressed Data from FI/CO Document | 84 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
58 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 63 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
59 | KMZEI | FI: Account Assignment Model Item Information | 41 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
60 | KOMU | Account Assignment Templates for G/L Account Items | 41 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
61 | T003 | Document Types | 14 | RECID | Debit Recovery Indicator | nvarchar | 2 | 0 | | |
62 | VBSEGA | Document Segment for Document Parking - Asset Database | 40 | RECID | Rules for Issuing an Invoice | nvarchar | 4 | 0 | | |
63 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 67 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPFinland |
64 | T7FIA0 | Record Identifiers (ATS) | 2 | RECID | Record identifier for Annual Tax Statement | nvarchar | 8 | 0 | | |
65 | T7FIA0T | Record Identifier Texts (ATS) | 2 | RECID | Record identifier for Annual Tax Statement | nvarchar | 8 | 0 | | |
66 | T7FIA2 | Tax Code Assignments to ATS Data Records | 2 | RECID | Record identifier for Annual Tax Statement | nvarchar | 8 | 0 | | |
67 | T7FIA3 | Assign Structure Fields to Tax Codes (ATS) | 2 | RECID | Record identifier for Annual Tax Statement | nvarchar | 8 | 0 | | |
68 | T7FIA4 | Wage Type Assignment to Tax Codes (ATS) | 4 | RECID | Record identifier for Annual Tax Statement | nvarchar | 8 | 0 | | |
TOPFreight Processing |
69 | VFKN | Account Determination in Shipment Costs Item | 33 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPFunctions for U.S. Federal Government |
70 | FMFG_PRIOR_RPT | Table for Prior Reported Information | 2 | RECID | Recording ID | nvarchar | 16 | 0 | | |
71 | FMFG_PRIOR_RPTKF | Prior Reported Keyfigures | 2 | RECID | Recording ID | nvarchar | 16 | 0 | | |
TOPFunds Management-Specific Postings |
72 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 66 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
73 | PSOSEGA | Document Segment for Assets Document Parking | 41 | RECID | Rules for Issuing an Invoice | nvarchar | 4 | 0 | | |
74 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 65 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
75 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 39 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
76 | FAGLSKF | General Ledger: Statistical Key Figures (Current Values) | 3 | RECID | GUID in 'CHAR' format with upper-/lowercase (!) | nvarchar | 22 | 0 | | |
77 | FAGL_SPLINFO | Splittling Information of Open Items | 84 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPGL Account Posting |
78 | TCJ_POSITIONS | Cash Journal Document Items | 55 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPIntercompany Data Exchange |
79 | EPAYTHP | IDE: transfer records for third party payments | 8 | RECID | Recipient | nvarchar | 40 | 0 | | |
80 | IUEEDPPLOTATHEAD | Distribution Lot Header | 8 | RECID | Service Provider That Invoices the Contract | nvarchar | 10 | 0 | | |
81 | TINV_BW_TRIG_THI | Trigger for Delta Extraction of Transfer Recs f. Third Party | 10 | RECID | Recipient | nvarchar | 40 | 0 | | |
TOPInventory Management |
82 | MWZDM07M2 | ZDM07M2 | 13 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
83 | RKPF | Document Header: Reservation | 48 | RECID | Internal Recovery Indicator | nvarchar | 2 | 0 | | |
TOPInvoice Verification |
84 | RBCO | Document Item, Incoming Invoice, Account Assignment | 25 | RECID | Rules for Issuing an Invoice | nvarchar | 4 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
85 | JVGLFLEX07 | General Ledger: Joint Venture Accounting Fields | 4 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
86 | JVGLFLEXA | General Ledger: Actual Line Items | 31 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
87 | JVGLFLEXP | General Ledger: Plan Line Items | 33 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
88 | JVGLFLEXT | General Ledger: Totals | 40 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
89 | T8J0G | Billing Method Posting Rule Detail | 6 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
90 | T8J5C | JV Recovery indicator for supplemental detail | 3 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
91 | T8JJ | Recovery Indicator | 3 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
92 | T8JJT | Recovery Indicator Description | 4 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
93 | T8JPT1 | Cutback Payment Terms per Recovery Indicator | 4 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
94 | T8JPT2 | Cutback Payment Terms per RI and Original Payment Terms | 4 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
95 | T8JRI | JV Recovery indicator determination method | 4 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
96 | T8JSC | Joint Venture Substitute Cost Object | 5 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
97 | T8JW | Internal Recovery Indicator | 2 | RECID | Internal Recovery Indicator | nvarchar | 2 | 0 | | |
98 | T8JWT | Internal Recovery Indicator Description | 3 | RECID | Internal Recovery Indicator | nvarchar | 2 | 0 | | |
TOPOperative Structures |
99 | PROJ | Project definition | 78 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
100 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 104 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPOverhead Cost Controlling |
101 | CMDT_CC | Generic Master Data: Cost Center Enhancements | 32 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPOverhead Cost Orders |
102 | AUFK | Order master data | 97 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
103 | COBRB | Distribution Rules Settlement Rule Order Settlement | 48 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
104 | TKB6 | Account Determination for Settlement | 8 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPProduct Safety |
105 | CVDPH | DDS: OBSOLETE !! DDOC log, header record | 12 | RECID | Generic recipient number | nvarchar | 20 | 0 | | |
TOPProduction Orders |
106 | AFVU | DB structure of the user fields of the operation | 22 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPProfit Center Accounting |
107 | CEPC | Profit Center Master Data Table | 38 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
108 | CEPC_BUKRS | Assignment of Profit Centers to a Company Code | 6 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
109 | CMDT_PC_BUKRS | Generic Master Record: Company Code Assign. for Profit Cent. | 8 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPPurchasing |
110 | EBKN | Purchase Requisition Account Assignment | 36 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
111 | EKKN | Account Assignment in Purchasing Document | 39 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
112 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 201 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPRevenue |
113 | OIUHS_JE_ACC_ID | PRA: Journal Entry Posting Rules per Account Type | 7 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
114 | OIUHS_JE_ACC_TYP | PRA: Journal Entry Posting Rules per Account Type | 6 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
115 | OIUHS_JE_ACR | PRA: Journal Entry Account Categories | 3 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPSAP Business Workflow |
116 | SWEINSTCOU | Instance Linkage Event - Receiver | 7 | RECID | Receiver ID | nvarchar | 90 | 0 | | |
117 | SWELOG | Table for entries of the event log | 4 | RECID | Receiver ID | nvarchar | 90 | 0 | | |
118 | SWEQUEUE | Event Queue for Temporary Storage of Triggered Events | 9 | RECID | Receiver ID | nvarchar | 90 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
119 | NLVERP | Rechnungregister-position | 6 | RECID | | nvarchar | 10 | 0 | | |
TOPSelf-Service Procurement |
120 | /SRMERP/D_ACC_IT | Account assignment item | 33 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPSimulation |
121 | VSAFVU_CN | Version: User fields in operation in order | 23 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
122 | VSAUFK_CN | Version: Order master data | 98 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
123 | VSEBKN_CN | Version: Purchase requisition account assignment | 37 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
124 | VSPROJ_CN | Version: Project definition | 79 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
125 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 105 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
TOPTemplates |
126 | PROJS | Standard project definition | 80 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |
127 | PRPSS | Standard WBS Element (WBS element) - Master Data | 87 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | |