| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /IBS/TRB_KTO_PRP | RBD Account. Master Data | 16 | LOEVM | RBD: Deletion Flag | nvarchar | 1 | 0 | | |
2 | CNV_20100_CSKB | Backup copy - CSKB | 19 | LOEVM | | nvarchar | 1 | 0 | | |
3 | CNV_20800_KNVK | CNV backup copy: Customer master contact person | 72 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
4 | DFKK_MA_H | Header Data of Master Agreement | 11 | LOEVM | Flag Master Agreement for Deletion | nvarchar | 1 | 0 | | |
5 | PEG_TASS_HIST_D | Pegging History: Detail | 21 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
6 | PEG_TXPT_HIST | Pegging: intransit stock history | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
7 | TEWA_EL_OBJBH | Behavioral Control (Behavior) | 10 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPAdvertising Management |
8 | JJCPFREESUB | IS-M: Free Subscription - Contact Person Relationship | 14 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
9 | JJCPRESPONSIB | IS-M: Responsibility in Contact Person Relationship | 15 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
10 | JJTAF | IS-M/AM: Free Subscription for Media Contact Person | 14 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
11 | JJTAM | IS-M/AM: Media Contact Person | 4 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
12 | JJTAZ | IS-M/AM: Media Contact Person Responsibility | 15 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
13 | JJTDIEN | IS-M/AM: Service | 8 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
14 | JJTPE | IS-M/AM: Production Units | 19 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPBalancing |
15 | OIUBL01_PBA | Product Balancing Agreement | 15 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
TOPBank |
16 | BNKA | Bank master record | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPBusiness Partner |
17 | TIVBPVENDORCMP | Vendor Preassignment (CoCd Data) | 7 | LOEVM | Deletion Flag for Master Record (Company Code Level) | nvarchar | 1 | 0 | | |
18 | TIVBPVENDORGEN | Vendor Preassignment (General Data) | 20 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
19 | DFKKCIBW_STAT | CIBW Extraction - Status Table | 8 | LOEVM | Mark Results for Deletion | nvarchar | 1 | 0 | | |
20 | DFKKOPBW_STAT | OIBW Extraction - Status Table | 7 | LOEVM | Mark Results for Deletion | nvarchar | 1 | 0 | | |
21 | DFKK_VT_H | CT: Header Data of Provider Contract | 7 | LOEVM | Flag Provider Contract for Deletion | nvarchar | 1 | 0 | | |
22 | FKKVK | Contract Account Header | 5 | LOEVM | Mark Contract Account for Deletion | nvarchar | 1 | 0 | | |
23 | FKKVKP | Contract Account Partner-Specific | 36 | LOEVM | Mark Contract Account for Deletion | nvarchar | 1 | 0 | | |
TOPContract Billing |
24 | EDSC | Disc.Header Data | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
25 | EPREI | Mstr Pricing Table for All Prices | 21 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
26 | EPRESCL | Price Adjustment Clause for All Price Categories | 10 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
27 | ERCH | Billing Doc. Data | 47 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
28 | ESCH | Billing Schema (Header Data) | 15 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
29 | ETRF | Rate (Head. Data) | 21 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
30 | ETTA | General Rate Category (Header Data) | 23 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPControlling |
31 | CSKB | Cost Elements (Data Dependent on Controlling Area) | 18 | LOEVM | Indicator: Cost element is flagged for deletion | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
32 | ALM_ME_SYNC_ARCH | MAM 1.0 Obsolete | 26 | LOEVM | | nvarchar | 1 | 0 | | |
33 | BC490KKNA1 | General data in customer master | 41 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
34 | KKNA1 | General Data in Customer Master | 41 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
35 | SKNA1 | Customer Master table for BC417 Course | 41 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
36 | SKNVK | Customer Master Contact table for BC417 Course | 71 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
TOPCustomer Contact |
37 | BCONT | Business Partner Contact | 19 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPCustomer Master |
38 | KNA1 | General Data in Customer Master | 41 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
39 | KNVK | Customer Master Contact Partner | 71 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
40 | KNVV | Customer Master Sales Data | 9 | LOEVM | Deletion flag for customer (sales level) | nvarchar | 1 | 0 | | |
TOPCustomer Service |
41 | EDISCDOC | DiscDoc.: Header | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
42 | EINIDATCR | Init. Data Cr. Doc.: Premise - Header Data | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPDevice Management |
43 | EDEVGR | Master Data for Device Group | 9 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
44 | TE271 | Sample Lot | 30 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPDSD Connector |
45 | /DSD/ME_CUST_SA | DSD CN: Sales area dependent customer master data | 15 | LOEVM | Deletion flag for customer (sales level) | nvarchar | 1 | 0 | | |
TOPEnergy Data Management |
46 | EEDMSETTLDOC | Settlement Document (Header) | 19 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
47 | EEDMSETTLDOCALER | Settlement Document (Alerts) | 24 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
48 | EEDMSETTLDOCERR | Settlement Document (Errors) | 25 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
49 | EEDMSETTLDOCRUN | Settlement Document (Run) | 12 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
50 | EEDMSETTLDOCVARH | Variants for Header Info of Settlement Document | 11 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
51 | EPROFHEAD | Profile Header Data | 25 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
52 | EPROFHEAD_TMP | Header Data of Temporary Profile | 25 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
53 | ESERVPROV | Service provider | 12 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
54 | KNB1 | Customer Master (Company Code) | 8 | LOEVM | Deletion Flag for Master Record (Company Code Level) | nvarchar | 1 | 0 | | |
55 | LFA1 | Vendor Master (General Section) | 37 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
56 | LFB1 | Vendor Master (Company Code) | 8 | LOEVM | Deletion Flag for Master Record (Company Code Level) | nvarchar | 1 | 0 | | |
TOPFunds Management |
57 | FMFPO | FIFM: Commitment Item | 12 | LOEVM | Commitment item is flagged for deletion (indicator) | nvarchar | 1 | 0 | | |
TOPIntegration Customer Relationship Management |
58 | ECRM_REPL_HD | Header Data for IS-U Sales Replication Error Handling | 20 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPIntercompany Data Exchange |
59 | EIDESWTDOC | Switch Document Header | 30 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
60 | EIDESWTDOCTMP | Temporary Switch Document Header Data | 31 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
61 | EIDESWTMSGDATA | Message Data for Switch Document | 36 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
62 | EIDESWTMSGTMP | Temporary Switch Document Message Data | 38 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
63 | ESERVICE | Point of delivery service | 20 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPInvoicing |
64 | ERDK | Print Document/Header Data | 44 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPMaintenance Processing |
65 | ALM_ME_SYNC | Sync Status | 26 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPMaster Data |
66 | EANL | Installation | 25 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
67 | EKON | Franchise Contract MasterData | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
68 | ELACC | Loyalty Account Header | 14 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
69 | EPROP | Owner Allocation | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
70 | EREDEMP | Redemption Document for Loyalty Program | 23 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
71 | EVBS | Premise | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
72 | EVER | IS-U Cont. | 37 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
73 | EVERH | IS-U Contract History | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
74 | EWATWASTESRVPROD | Service Products for Waste and Recycling | 10 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPMaterials Management |
75 | /ISDFPS/EQUITRP | Assignment: Storage Bin --> Equipment (Loading Object) | 8 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPMove-InOut |
76 | EAUS | Move-out Doc. for Contract Acc. | 36 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
77 | EAUSV | Move-out Doc. Contract Level | 26 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
78 | ECAMIOPRHEAD | IS-U: Parked Document: Header Data | 14 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
79 | EEIN | Move-in Doc. for ContAcc. | 39 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPOperative Structures |
80 | PROJ | Project definition | 59 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
81 | PRPS | WBS (Work Breakdown Structure) Element Master Data | 79 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPPegging, Grouping, and Distribution |
82 | DIS_TOBJS | Distribution: cost objects posted to per group | 21 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
83 | DIS_TOBJS_COSP | Distribution: Objects distributed to per Group WBS (Cost) | 19 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
84 | DIS_TOBJS_COSS | Distribution: Objects distributed to per Group WBS (Cost) | 19 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
85 | DIS_TOBJS_FMSU | Distribution: Objects distributed to per Group WBS (Cash) | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
86 | PEG_STO | Pegging: Record of goods movements w.r.t STO's | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
87 | PEG_TACTASS | Pegging: Current Assignments Based on Goods Movements | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
88 | PEG_TASS | Pegging: Assignment Replenishment Element to WBS Elements | 20 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
89 | PEG_TASS_TMP | Grp-to-Grp Transf. Pegging: Assign. of Replen to WBS Elems. | 20 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
90 | PEG_TASS_WLST | Temp. assignments for sub-components of grp to grp transfers | 15 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
91 | PEG_TGTG | Pegging: Record of group to group transfers | 12 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
92 | PEG_TGTG_EXC | A&D GPD: Group to group initial peg | 15 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
93 | PEG_TSTK | Pegging: Stock table | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
94 | PEG_TSTK_TRANS | Pegging: Stock transfered without costs (Excess) | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
95 | PEG_TXPT | Pegging: Record of intransit stock in cross plant transfers | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
96 | JDTPVA | IS-M/SD: Editions | 47 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
97 | JDTVAUSGB | IS-M/SD: Issues | 53 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
98 | JKTGU | IS-M/SD: Coupon Booklet | 9 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
99 | JMTMAT | IS-M/SD: Promotional Material | 13 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
100 | JNTRECH | IS-M/SD: Research | 22 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
101 | JRTBEABST | IS-M/SD: Unloading Point | 23 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
102 | JRTROUTE | IS-M/SD: Truck Route Master Data | 51 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
103 | JRTRVERT | IS-M/SD: Truck Route Contract | 15 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
104 | JRTTROUTE | IS-M/SD: Daily Truck Routes | 77 | LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | nvarchar | 1 | 0 | | |
TOPPoint of delivery |
105 | EUIGRID | Allocation of PoD to Grid | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
106 | EUIHEAD | PoD Header Data | 12 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
107 | EUIINSTLN | Allocation of Installation to PoD | 15 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
108 | EUILNR | Allocation of Logical Device to PoD | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
109 | EUILZW | Allocation of Logical Register to PoD | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
110 | EUITRANS | Transformation of Internal/External Point of Delivery No. | 14 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
111 | TFICA_DEF | Samples for Contract Account Types | 17 | LOEVM | Mark Contract Account for Deletion | nvarchar | 1 | 0 | | |
TOPSimulation |
112 | VSPROJ_CN | Version: Project definition | 60 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
113 | VSPRPS_CN | Version: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data | 80 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPTemplates |
114 | PROJS | Standard project definition | 59 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
115 | PRPSS | Standard WBS Element (WBS element) - Master Data | 79 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPTreasury |
116 | VWPANLA | Asset master for securities | 15 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
117 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 45 | LOEVM | Central Deletion Flag for Master Record | nvarchar | 1 | 0 | | |
118 | VZKNB1 | Collector for batch input KNB1 from RF-VV | 41 | LOEVM | Deletion Flag for Master Record (Company Code Level) | nvarchar | 1 | 0 | | |
TOPValue Adjustment |
119 | /IBS/TRB_KTO | RBD Account. Master Data | 16 | LOEVM | RBD: Deletion Flag | nvarchar | 1 | 0 | | |
TOPVendor Master |
120 | LFM1 | Vendor master record purchasing organization data | 7 | LOEVM | Delete flag for vendor at purchasing level | nvarchar | 1 | 0 | | |
121 | LFM2 | Vendor Master Record: Purchasing Data | 9 | LOEVM | Delete flag for vendor at purchasing level | nvarchar | 1 | 0 | | |
122 | WYT4 | Operative Control | 6 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
TOPWaste Management |
123 | EEWA_CAPAB_HEAD | IS-U Waste: Capacity Planning - Header | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
124 | EEWA_GUARANTOR | Guarantor Contract | 17 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
125 | EEWA_ROB | Cleaning Object | 40 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
126 | EWACALENDER | Definition of General Non-Workdays | 11 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
127 | EWAEHSGP | Business Partner Integration Table EHS/ IS-W | 11 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
128 | EWAEQUI | IS-U WA: Additional Data for Equipment Master | 36 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
129 | EWAOBJ | Header Data for Service Frequency | 49 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
130 | EWAROUTE | Header table of route | 74 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
131 | EWATDEVLOC | Provisional Container/Container Location Allocation | 20 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
132 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 37 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
133 | EWA_EL_WDPLANT | Waste Disposal Facility | 27 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
134 | EWA_EL_WDPPROC | Transaction Within Facility | 21 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
135 | EWA_EL_WDPPROGR | Transaction Group | 10 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
136 | EWA_EL_WDPPROTE | Transaction Template | 12 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
137 | EWA_EL_WDPPROTY | Procedure Category | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
138 | EWA_FAKTOR | Factors for Billing of Waste Management Services | 12 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
139 | EWA_OBJADDRESS | Object Address | 15 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
140 | EWA_ORDER_HEAD | Header Table for Waste Disposal Order | 56 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
141 | EWA_SERVADDRESS | Service Address | 16 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
142 | EWA_VBS | Table Supplement for Premise with Historical Data | 13 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
143 | EWA_WA_WEIGHOFFL | Offline Weighing | 90 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
144 | TEWA_EL_OBJTRA | Object Transaction Configuration (CL_EEWA_TRANSACTION) | 9 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |
145 | TEWA_EL_OBJTRAM | Object Transaction Configuration (Overriding Clients) | 10 | LOEVM | Deletion Indicator | nvarchar | 1 | 0 | | |