| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 14 | BSTAT | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 14 | BSTAT | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 14 | BSTAT | | nvarchar | 1 | 0 | | |
4 | /CCEE/SIFIPOBOTI | ePoboti: Obligatory manysided reconciliation - XML output | 24 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
5 | /SAPF15/XXBPDK | F15 FI DUMMY | 11 | BSTAT | | nvarchar | 1 | 0 | | |
6 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 177 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
7 | /SMERP/STG_MM002 | Data staging - Material storage location view complex table | 177 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
8 | /SMERP/STG_MM003 | Data staging - Material UoM view complex table | 178 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
9 | /SMERP/STG_MM004 | Data staging - Material warehouse view complex table | 177 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
10 | /SMERP/STG_MM005 | Data staging - Material batch view complex table | 177 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
11 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 81 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
12 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 87 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
13 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
14 | BSID_BAK | Accounting: Secondary Index for Customers | 81 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
15 | BSIK_BAK | Accounting: Secondary index for vendors | 87 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
16 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
17 | DVK00 | unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | 12 | BSTAT | Checkbox | nvarchar | 1 | 0 | | |
18 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
19 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
20 | FUDT_VDOCBKPF | Verification Document Header | 26 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
21 | FUDT_VDOCBKPFH | Verification Document Header(History) | 26 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
22 | GLPOS_C_CT | FI Document: Entry View | 64 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
23 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 64 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
24 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 64 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
25 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 64 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
26 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 64 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
27 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 64 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
28 | T74_BPS17 | Benefit request type catalog | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
29 | ZEIMMARA | USING FOR STORING EIM MARA DATAS | 208 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
30 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 79 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
31 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 79 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPAssortment |
32 | WRFT_APC_GEN | Operational APC: General Customizing | 12 | BSTAT | Default Material Status Retail Fashion (Operational APC) | nvarchar | 2 | 0 | | |
TOPBasis Components |
33 | ZDS400_BKPF | Belegkopf für Buchhaltung | 26 | BSTAT | Belegstatus | nvarchar | 1 | 0 | | |
TOPBenefits |
34 | PA0167 | HR Master Record: Infotype 0167 (Health Plans) | 28 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
35 | PA0168 | HR Master Record: Infotype 0168 (Insurance Plans) | 28 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
36 | PA0169 | HR Master Record: Infotype 0169 (Savings Plan) | 28 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
37 | PA0170 | HR Master Record: Infotype 0170 (Flexible Spending Accounts) | 28 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
38 | PA0171 | HR Master Record: Infotype 0171 (Gen. Benefits Information) | 26 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
39 | PA0211 | HR Master Record: Infotype 0211 (COBRA Beneficiaries) | 35 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
40 | PA0212 | HR Master Record: Infotpye 0212 (COBRA Health Plan) | 28 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
41 | PA0236 | HR Master Record: Infotype 0236 (Credit Plans) | 28 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
42 | T5UB6 | Benefit Standard Health Selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
43 | T5UB7 | Benefit standard insurance selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
44 | T5UB9 | Benefit second program grouping | 3 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
45 | T5UBU | Benefit program | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
46 | T5UC9 | Benefit Second Program Grouping Texts | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
47 | T5UDB | COBRA beneficiary | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
48 | T74FM | Benefit Standard Savings Selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
49 | T74FN | Benefit Standard Spending Account Selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
50 | T74FO | Benefit standard credit selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
51 | T74FP | Benefit Standard Miscellaneous Selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
52 | T74FQ | Benefit standard stock purchase selection | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
TOPBudget Management |
53 | HRP1500 | DB Table for Infotype 1500 | 20 | BSTAT | Budget status | nvarchar | 1 | 0 | | |
54 | T7PMQ | Budget Status | 2 | BSTAT | Budget status | nvarchar | 1 | 0 | | |
55 | T7PMR | Name of Budget Status | 3 | BSTAT | Budget status | nvarchar | 1 | 0 | | |
56 | T7PMS | Budget Status Changeover | 2 | BSTAT | Budget status | nvarchar | 1 | 0 | | |
57 | T7PMS_PM005 | Table for Feature PM005 | 3 | BSTAT | Budget status | nvarchar | 1 | 0 | | |
TOPClaims Processing Asia |
58 | T7XAS2 | Assignment of Claim formula to Program | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
59 | BBSID | Accounting: Secondary index for customers | 81 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
60 | BKKPF | Accounting document header | 26 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
61 | MMARA | General material data | 208 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
TOPData Retention Tool |
62 | TXW_S_BKPF | Retrieve BKPF from archive | 40 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
63 | TXW_S_BSEG | Retrieve BSEG from archive | 105 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
64 | /BGLOCS/FI001Z | VAT Company detail settings | 4 | BSTAT | BULSTAT Identification | nvarchar | 15 | 0 | | |
65 | BKPF | Accounting Document Header | 26 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
66 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 81 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
67 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 87 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
68 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
69 | BSID | Accounting: Secondary Index for Customers | 81 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
70 | BSIK | Accounting: Secondary Index for Vendors | 87 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
71 | BSIS | Accounting: Secondary Index for G/L Accounts | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
72 | EBKPF | Fin.Accntng Doc.Header (of Docs from Extern.Systems) | 35 | BSTAT | External Document Status | nvarchar | 1 | 0 | | |
73 | VBKPF | Document Header for Document Parking | 6 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPFund Accounting |
74 | FMGLFLEXA | General Ledger: Actual Line Items | 42 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
75 | PSGLFLEXA | General Ledger: Actual Line Items | 46 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPFunds Management |
76 | BPDK | Header Entry Document | 11 | BSTAT | Document/Document Line Item Status | nvarchar | 1 | 0 | | |
77 | BPVK | Document Header for Parked Documents | 10 | BSTAT | Document/Document Line Item Status | nvarchar | 1 | 0 | | |
78 | FMFG_REPOST_CNTL | Document batching/control for SL Repost for ECC 600 migratio | 5 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
79 | PSO50 | Stop Mass Processing Data for Invoice Reference | 9 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
80 | PSOKPF | Recurring Request Document Header | 7 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Accounting |
81 | BKPF_ADD | Accounting Document Header | 26 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
82 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 6 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
83 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
84 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 33 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
85 | FAGLFLEXA | General Ledger: Actual Line Items | 44 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
86 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 21 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
87 | FAGL_MIG_RPITEMS | Migration in New G/L: Objects To Be Posted Subsequently | 7 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPGeneral Ledger Reorganization |
88 | FAGL_R_APAR | Reorganization: Object List for Receivables and Payables | 21 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
89 | JVGLFLEXA | General Ledger: Actual Line Items | 46 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPLocal Currency Changeover |
90 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 39 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPLocalization |
91 | ISJPINVSUMIT | Line items for invoice summary | 6 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
92 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 17 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
93 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 17 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
94 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 17 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
95 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 17 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPMaterial Master |
96 | MARA | General Material Data | 208 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
97 | MARA_TMP | File for Incorrect Data in Direct Input | 215 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
98 | MVRA | Cross-version fields for MARA | 208 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
99 | WRFMATBSTAT | Creation Status - Seasonal Procurement | 2 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
100 | WRFMATBSTATT | Creation Status - Seasonal Procurement | 2 | BSTAT | Creation Status - Seasonal Procurement | nvarchar | 2 | 0 | | |
TOPNetherlands |
101 | P05FBN_KMOD_PRGR | Program assignment | 4 | BSTAT | Benefit Second Program Grouping | nvarchar | 4 | 0 | | |
TOPPatient Management |
102 | NKSK | IS-H: Insurance verification/certificate - Header data | 10 | BSTAT | Insurance Verification Processing Status | nvarchar | 1 | 0 | | |
TOPPayment Transactions |
103 | CRFILESTAT | Payment Card File: Status Information for Individual Records | 13 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPPayroll |
104 | PA0938 | HR Master Record: Infotype 0938 | 24 | BSTAT | BULSTAT-EIK - Company ID | nvarchar | 15 | 0 | | |
105 | PB0938 | Applicant data infotype 0938 (model) | 24 | BSTAT | BULSTAT-EIK - Company ID | nvarchar | 15 | 0 | | |
106 | T7BG01P | Personnel Area/Subarea Groupings for Bulgaria | 4 | BSTAT | BULSTAT-EIK - Company ID | nvarchar | 15 | 0 | | |
107 | T7BGA1 | Bank transfer - interface table | 6 | BSTAT | BULSTAT-EIK - Company ID | nvarchar | 15 | 0 | | |
TOPPosition Budgeting and Control |
108 | T77HRFPM_POSACT | Actions Allowed in a Budget Status | 2 | BSTAT | Budget status | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
109 | TIVC3 | Rental Request Processing Status | 2 | BSTAT | Rental Request Processing Status | nvarchar | 4 | 0 | | |
110 | TIVCC | Application: Preselection indicator (text table) | 3 | BSTAT | Rental Request Processing Status | nvarchar | 4 | 0 | | |
111 | VIMI11 | Applications - Real Estate Management | 45 | BSTAT | Rental Request Processing Status | nvarchar | 4 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
112 | /BEV3/CH1030BKPF | Header Data for CH Event Ledger 00001030 | 28 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
113 | NKSA | IS-H: Insurance verification declaration (Austria) | 24 | BSTAT | | nvarchar | 1 | 0 | | |
TOPSpecial Purpose Ledger |
114 | /CCIS/PROFTAXA | Actual Line Items Table for General Ledger | 54 | BSTAT | Document Status | nvarchar | 1 | 0 | | |
TOPSubsequent Settlement |
115 | AVORRAT | Worklist | 12 | BSTAT | Worklist, Processing Status | nvarchar | 1 | 0 | | |
TOPTreasury |
116 | FLQHEADMA | Liquidity Calculation - Header for Manual Transfer Postings | 7 | BSTAT | Liquidity Calculation: Doc. Status Manual Transfer Posting | nvarchar | 1 | 0 | | |
TOPUSA |
117 | PA0104 | HR Master Record: Infotype 0104 (Bond Denominations NA) | 47 | BSTAT | Region (State, Province, County) | nvarchar | 3 | 0 | | |
TOPWarehouse Management |
118 | T311A | Cross-Reference WM Group for Documents | 6 | BSTAT | Processing status of document in WM reference number | nvarchar | 1 | 0 | | |