| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/VIM_1ITEM_S | Document Item | 41 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
2 | /OPT/VIM_TITEM | Document Item | 41 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
3 | AUAA | Settlement Document: Receiver Segment | 26 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
4 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 97 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
5 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 101 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
6 | BSEG | Accounting Document Segment | 223 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
7 | BSID_BAK | Accounting: Secondary Index for Customers | 97 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
8 | BSIK_BAK | Accounting: Secondary index for vendors | 101 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
9 | BSSEG | Accounting Document Segment | 212 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
10 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 212 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
11 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 212 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
12 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 212 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
13 | GLPOS_C_CT | FI Document: Entry View | 181 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
14 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 181 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
15 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 181 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
16 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 181 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
17 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 184 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
18 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 184 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
19 | P2B2_C1 | HCM Declustering B2 - Cost Distribution Table C1 | 15 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
20 | P2B2_CWST | HCM Declustering B2 - PDC Time Tickets | 103 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
21 | P2B2_WST | HCM Declustering B2 - PDC Time Tickets | 103 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
22 | P2PL_RETROADJ | Payroll Result PL: Retro, originals and changes | 25 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
23 | P2PL_RETRODIF | Payroll Result PL: Retro, originals and changes | 25 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
24 | P2PL_RETROMEM | Payroll Result PL: Retro, originals and changes | 25 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
25 | P2RG_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 32 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
26 | P2RT_CZDAV | P18_03 | 16 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
27 | P2RU_COSTS | Distribution of Employer's Cost (Payroll Function XDEC) | 32 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
28 | P2RX_C1 | Cost Distribution Table C1 | 13 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
29 | P2RX_FUND | Accounting Structure for Funds Management | 25 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
30 | REGUP | Processed items from payment program | 99 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
31 | YVIM_1ITEM | Document Item | 41 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPAccounting Interface |
32 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 176 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
33 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 176 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPActual CostingMaterial Ledger |
34 | MLCO | Material valuation document account assignment information | 23 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPAlternative Valuation Run |
35 | CKMLAVRDOCIT | Lines for Cumulation Posting Document | 49 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPConfirmations |
36 | AFRV | Confirmation pool | 23 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
37 | AFRV_DEL | Backup Copy for Confirmation Pool | 23 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPConstruction Industry |
38 | T5DB4 | HR Construction Site File | 7 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
39 | T5DB8 | Construction Sector: Team Assignment to Work Site | 29 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
40 | T5DBV | Construction Pay: Cost Assignment: Hostels | 12 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
41 | T5DBX | Construction Pay: Incentive Wage Connection | 12 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPCross-Application Components |
42 | BBSID | Accounting: Secondary index for customers | 97 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPData Retention Tool |
43 | TXW_S_BSEG | Retrieve BSEG from archive | 67 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
44 | TXW_S_MSEG | Retrieve MSEG from archive | 40 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPData Transfer |
45 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 21 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
46 | PPDST | Transfer to Accounting: Substituted Acc. Assig. Object | 10 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
47 | PPKIX | Transfer FI/CO: Index of Account Assignment Combinations | 12 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPElectronic Bank Statement |
48 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 32 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
49 | FEB_ACT | Acct Assignment Templates | 32 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPExternal Services |
50 | ESKN | Account Assignment in Service Package | 28 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPFinancial Accounting |
51 | /OPT/VIM_1ITEM | Document Item | 41 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
52 | ACCTIT | Compressed Data from FI/CO Document | 67 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
53 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 97 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
54 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 101 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
55 | BSID | Accounting: Secondary Index for Customers | 97 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
56 | BSIK | Accounting: Secondary Index for Vendors | 101 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
57 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 69 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
58 | KMZEI | FI: Account Assignment Model Item Information | 47 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
59 | KOMU | Account Assignment Templates for G/L Account Items | 47 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
60 | T076K | FI-EDI: Additional Account Assignments | 15 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
61 | VBSEGA | Document Segment for Document Parking - Asset Database | 50 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
62 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 76 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPFreight Processing |
63 | VFKN | Account Determination in Shipment Costs Item | 26 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPFunds Management |
64 | KBLP | Document Item: Manual Document Entry | 39 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPFunds Management-Specific Postings |
65 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 75 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
66 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 74 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPGeneral Ledger Accounting |
67 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 45 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
68 | FAGL_SPLINFO | Splittling Information of Open Items | 24 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPGeneral Ledger Reorganization |
69 | FAGL_R_SPL | Reorganization: Splitting Information of the Open Items | 21 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPGL Account Posting |
70 | TCJ_POSITIONS | Cash Journal Document Items | 39 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPInterest |
71 | TZIN1 | Document Header Data from Source Document (PS Int.Calc.) | 20 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPInventory Management |
72 | MSEG | Document Segment: Material | 114 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
73 | MWXMSEG | ZMSEG: Interface for Posting of Value | 114 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
74 | MWZMSEG | ZMSEG:Interface for Posting of Value | 114 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
75 | RKPF | Document Header: Reservation | 31 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPInvoice Verification |
76 | RBCO | Document Item, Incoming Invoice, Account Assignment | 64 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPJapan |
77 | T7JPSK_CONTT | Shukko Contract Template | 12 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
78 | JVCO1 | JV Object Table 2 for JVTO1 | 3 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
79 | JVPO1 | JVA: Plan Line Items | 31 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
80 | JVSO1 | JV LI Table with Objects for JVTO1 | 31 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
81 | JVTO1 | JV Summary Table with Objects | 28 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPLocal Currency Changeover |
82 | EWUFI_SCA | EMU conversion: Table of the clearings to be adjusted | 20 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPLocalization |
83 | J_1BNFLIN | Nota Fiscal line items | 93 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
84 | J_1B_CIAP_OBJECT | CIAP document data | 22 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
85 | J_3RNDSINV | Target use of ingoing invoice positions for AuC | 16 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPMaintenance Orders |
86 | AUFM | Goods movements for order | 37 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPMaterials Management |
87 | J_1GVL_ML | Material Ledger | 89 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPOverhead Cost Orders |
88 | COBRB | Distribution Rules Settlement Rule Order Settlement | 41 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPPayment Transactions |
89 | CRACC | Payment Cards: Account Assignments in Card Master Record | 29 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
90 | CRNUM | Payment cards: Card master record | 50 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
91 | FPRL_ITEM | Item Data | 57 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPPayroll |
92 | T5TPSC1SPLIT | Rozdelení nákladu | 23 | NPLNR | Cís.sít.diagramu pro prirazení úctu | nvarchar | 12 | 0 | | |
TOPPersonnel Time Events |
93 | TPTCOR_KOSTL | Cost Assignment (Correction Scenario) | 6 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPPersonnel Time Management |
94 | ASSOB | Assignment Objects | 11 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
95 | CC1ERP | Incorrect Time Events from CC1, Postings | 105 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
96 | CC1TEV | Temporary Buffer for Time Events from CC1 | 28 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
97 | COIFT | Interface to Activity Allocation | 43 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
98 | PTEX2000 | Interface Table for Attendances/Absences Infotype(2001/2002) | 53 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
99 | PTEX2003GEN | Interface Table for IT 2003: General Information | 52 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
100 | PTEX2003SPEC | Interface Table for IT 2003: Interval Information | 28 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
101 | PTEX2010 | Interface Table for EE Remuneration Info. Infotype (2010) | 52 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
102 | TEVEN_MORE | Additional Data for Time Events | 104 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPPlant Data Collection |
103 | RUECK | Temp. storage for subsystem confirmations | 18 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPPosition Budgeting and Control |
104 | HRFPM_DIFFERENCE | HRFPM: Personnel Costs Savings/ Overrun | 34 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
105 | HRFPM_FM_POS | HRFPM: FM Documents - Items | 18 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
106 | HRFPM_FM_POS_BU | HRFPM: FM Documents - Items for Budget | 19 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
107 | HRFPM_FPM_POS | HRFPM: FPM Documents - Items | 32 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
108 | HRFPM_FPM_POS_BU | HRFPM: FPM Documents - Items for Budget | 33 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
109 | HRFPM_OBJECTS | HRFPM: Object table of the commitment engine | 28 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPPurchasing |
110 | EBKN | Purchase Requisition Account Assignment | 30 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
111 | EKCPA | Purchasing Contract Commitment Plan Account Assignment Data | 15 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
112 | EKKN | Account Assignment in Purchasing Document | 33 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPQuality Inspection |
113 | QALS | Inspection lot record | 188 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPQuality Notifications |
114 | TQ8CO | Assignment of reference orders to notification type | 10 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
115 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 214 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPRemote Logistics Management |
116 | OIO_RT_RTDOC_MT | Returns document - material items | 17 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPRepetitive Manufacturing |
117 | COMPMOVE | Goods Movement of Components | 119 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPSelf-Service Procurement |
118 | /SRMERP/D_ACC_IT | Account assignment item | 27 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPSimulation |
119 | VSEBKN_CN | Version: Purchase requisition account assignment | 31 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPSocial Insurance |
120 | T5D3P | HR Technical Assignments for Workers' Compensation Assoc. | 7 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPTechnical Application Support |
121 | CNV_20425_SCA | EMU conversion: Table of the clearings to be adjusted | 17 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPTravel Expenses |
122 | PTRV_DOC_IT | Transfer Travel -> FI/CO: Lines of TRV interm. document | 20 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |
TOPTravel Planning |
123 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 15 | NPLNR | Network Number for Account Assignment | nvarchar | 12 | 0 | | |