	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

289 columns | ERP 6.0 | VALIDFROM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/CFMFND/ACCTASS	Kontierungsdaten für Raumnutzung	6	VALIDFROM	Kontierungsdaten gültig ab	nvarchar	8	0
2	/CFMFND/AREA	Umlagedaten	6	VALIDFROM	Umlagedaten gültig ab	nvarchar	8	0
3	/CFMFND/BP_AA	Kontierungsdaten	3	VALIDFROM	Kontierungsdaten gültig ab	nvarchar	8	0
4	/ORS/SUBSTITUTE	Optura's Substitution Table for user map	5	VALIDFROM	User valid from	nvarchar	8	0
5	CIAP_C_NO_QUO_BP	Table for customizing of quotas quantity by CCode / B Place	4	VALIDFROM	Start Date	nvarchar	8	0
6	CIAP_C_NO_QUO_ST	Table for customizing of quotas quantity by Country/State	4	VALIDFROM	Start Date	nvarchar	8	0
7	CPEC_QUOTRULE	CPE Quotation Rule	4	VALIDFROM	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
8	EBILLPRG	IS-U: Billing Programs	3	VALIDFROM	Conditional Billing Program Valid From	nvarchar	8	0
9	ECONDIPROCINTF	IS-U: Processing Interface for Conditions	4	VALIDFROM	From-Date for Conditional Billing Program	nvarchar	8	0
10	EINV_CUST_TW	TW: Customers Eligible for E-INVOICE	4	VALIDFROM	Valid From	nvarchar	8	0
11	ETOUEXCPTPRG	TOU Exception Program	4	VALIDFROM	Validity From-Date for TOU Exception Program	nvarchar	8	0
12	FISAFTPTC_SBINFO	SAFT: Customization for Self Billing File Generation	5	VALIDFROM	Date for beginning of validity	nvarchar	8	0
13	GRACMITOBJECT	Mitigating control assignment	8	VALIDFROM	Validity Start Date	nvarchar	8	0
14	GRACMITPROF	Profile mitigating control assignment	7	VALIDFROM	Validity Start Date	nvarchar	8	0
15	GRACMITROLE	Role mitigating control assignment	7	VALIDFROM	Validity Start Date	nvarchar	8	0
16	GRACMITROLEORG	Role Org mitigating control assignment	8	VALIDFROM	Validity Start Date	nvarchar	8	0
17	GRACMITUSER	User mitigating control assignment	7	VALIDFROM	Validity Start Date	nvarchar	8	0
18	GRACMITUSERAR	User mitigating control assignment for Access Request	8	VALIDFROM	Validity Start Date	nvarchar	8	0
19	GRACMITUSERGP	User Group mitigating control assignment	7	VALIDFROM	Validity Start Date	nvarchar	8	0
20	GRACMITUSERORG	User Org mitigating control assignment	8	VALIDFROM	Validity Start Date	nvarchar	8	0
21	GRACMITUSERORGAR	User Org mitigating control assignment for Access Request	9	VALIDFROM	Validity Start Date	nvarchar	8	0
22	GRACMITUSER_AR	Obsolete	7	VALIDFROM	Validity Start Date	nvarchar	8	0
23	GRACMITUSRORG_AR	Obsolete	8	VALIDFROM	Validity Start Date	nvarchar	8	0
24	GRFNAUSTEP	Audit Proposal Steps	9	VALIDFROM	Start Date	nvarchar	8	0
25	GRFNAUSTEPLOG	Audit Proposal Steps Transfer Log	10	VALIDFROM	Start Date	nvarchar	8	0
26	GRFNDSBACKUP	DS & status backup	3	VALIDFROM	Start Date	nvarchar	8	0
27	IDHU_VATPROP	Hungary: Domestic Sales List - Tax proportioning	3	VALIDFROM	Valid-From Date	nvarchar	8	0
28	J_1BTTAXDET	Tax Determination - Validity	5	VALIDFROM	Valid From	nvarchar	8	0
29	TBAC_BADI_PER	Parameter Definition for dynamic DCS periods	4	VALIDFROM	LME-Specific Settings for Period Determination: Valid From	nvarchar	8	0
30	TBAC_BADI_PER_FW	Parameters for Period Determination of Commodity Forwards	6	VALIDFROM	LME-Specific Settings for Period Determination: Valid From	nvarchar	8	0
31	TBAC_DCS_CTY	Definition Contract Specification LOF Commodity	3	VALIDFROM	Derivative Contract Specification: Valid From	nvarchar	8	0
32	TBAC_DCS_MIC_CTY	Derivative Contract Specification MIC LOF Commodity	4	VALIDFROM	Derivative Contract Specification: Valid From	nvarchar	8	0
33	TBAC_DCS_STRIKE	Derivative Contract Specification-Option: Strike Structure	3	VALIDFROM	Derivative Contract Specification: Valid From	nvarchar	8	0
34	TBAT_PRICEQUOT	Derivative Contract Specification: Price Quotations	9	VALIDFROM	Commodity Price Valid From (Date and Time)	decimal	21	7
35	TBAT_PRICEQUOT_F	Derivative Contract Specification: Price Quotations Futures	8	VALIDFROM	Commodity Price Valid From (Date and Time)	decimal	21	7
36	TBAT_PRICEQUOT_O	Derivative Contract Specification: Price Quotations Options	10	VALIDFROM	Commodity Price Valid From (Date and Time)	decimal	21	7
37	TBAT_PRICE_FWD	Derivative Contract Specification: Commodity Forward Prices	9	VALIDFROM	Commodity Price Valid From (Date and Time)	decimal	21	7
38	TEXT_POSF_DCS_PR	Exposure Position Flow DCS Pricing Data	22	VALIDFROM	Valid From Date	nvarchar	8	0
39	TFK_ODNNR_DET	Assign Number Range Numbers to Document Classes	6	VALIDFROM	Valid from date	nvarchar	8	0
40	TIVXCITIREFT	Mapping of IRE Status to Contract-Flow type-Taxcode	4	VALIDFROM	Start Date of Mapping Contract Status, Tax Code, Flow Type	nvarchar	8	0
41	TIVXCNLHPCITY	Highly populated cities	3	VALIDFROM	Valid From	nvarchar	8	0
42	TIVXCNLWOZBAS	Define basic settings for extra point calculation	3	VALIDFROM	Valid From	nvarchar	8	0
43	TIVXCNLWOZPTS	Extra points per Rental object value/M2	3	VALIDFROM	Valid From	nvarchar	8	0
44	VIBDAOFUNCTION	Architectural Object: Function	3	VALIDFROM	Date: Valid From	nvarchar	8	0
45	VIBDOBJASSIFRS	Valuation Data for Contract Objects	6	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
46	VIXCCHCATASTER	Localization Switzerland: RE Property Cataster	9	VALIDFROM	Date: Valid From	nvarchar	8	0
47	VIXCITCADAO	Temporary architectural object data	10	VALIDFROM	Date: Object Valid From	nvarchar	8	0
48	VIXCITCADRO	Temporary rental object data	21	VALIDFROM	Date: Object Valid From	nvarchar	8	0
49	VIYCCAP	Capping Parameters	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
50	VIYCCE2EXP	Cost Element to Expense Type	5	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
51	VIYCCE2POOL	Cost Elements in Pool	6	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
52	VIYCCN	Table for assignment of CAM Terms to a RE Contract	6	VALIDFROM	Date: Valid From	nvarchar	8	0
53	VIYCEXP	Expense Type to Expense Pool	4	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
54	VIYCMAJTENANT	Major Tenant Parameters	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
55	VIYCMARK	Mark-up Parameters	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
56	VIYCOBJ2POOL	Objects in CAM Pool	6	VALIDFROM	Period Start Date	nvarchar	8	0
57	VIYCPROV	Provision Parameters	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
58	VIYCRECEIVABLE	Receivables from Settlement	41	VALIDFROM	Period Start Date	nvarchar	8	0
59	VIYCREFFACTOR	Reference Factors	6	VALIDFROM	Date: Measurement Valid From	nvarchar	8	0
60	VIYCRENT	Rental period	13	VALIDFROM	Period Start Date	nvarchar	8	0
61	VIYCRHYTHM	CAM Expense Recovery Frequency Rule	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
62	ZSKSYSUSER	user in den IDES-Systemen	10	VALIDFROM		nvarchar	8	0
TOPAudit Management
63	PLMM_AUDITPLAN	Audit Plan	7	VALIDFROM	Valid From	decimal	15	0
64	PLMM_QUEST_H	Question List	4	VALIDFROM	Valid From	decimal	15	0
TOPBank Customer Accounts
65	TBCA_US_R_HOLD	Refrence adjustment types that can be created	4	VALIDFROM	Valid From	nvarchar	8	0
TOPBasic Data
66	VIBDAO	Architectural Object	6	VALIDFROM	Date: Object Valid From	nvarchar	8	0
67	VIBDBE	Business Entity	19	VALIDFROM	Date: Object Valid From	nvarchar	8	0
68	VIBDBU	Building	20	VALIDFROM	Date: Object Valid From	nvarchar	8	0
69	VIBDCHARACT	Fixtures/Fittings	5	VALIDFROM	Date: Valid From	nvarchar	8	0
70	VIBDMEAS	Measurement	5	VALIDFROM	Date: Measurement Valid From	nvarchar	8	0
71	VIBDOBJASS	Object Assignment	5	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
72	VIBDOBJREL	Object Relationship A/U Object <-> A/U Object	5	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
73	VIBDOBJRELPART	Object Relationship A/U Object <-> A/U Object: Percent	6	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
74	VIBDPLANOBJ	Plan Pooled Space	8	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
75	VIBDPLANOCC	Planned Occupancy of Usage Objects	8	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
76	VIBDPR	Land	20	VALIDFROM	Date: Object Valid From	nvarchar	8	0
77	VIBDRO	Rental Object	20	VALIDFROM	Date: Object Valid From	nvarchar	8	0
TOPBusiness Partner
78	VIBPADDRREL	Addresses of RE Object	5	VALIDFROM	Date: Valid From	nvarchar	8	0
79	VIBPOBJREL	Business Partner-Object Relationship	8	VALIDFROM	Date of Start of Relationship	nvarchar	8	0
TOPClaims Management
80	ICLITEM	Claim Item	30	VALIDFROM	Claim Item: Valid From	nvarchar	8	0
81	ICLPAYI	Claim Payment Item	28	VALIDFROM	Payment Item: Valid From	nvarchar	8	0
82	ICLPOL	Policy Snapshot	11	VALIDFROM	Contract Version: Valid-From Date	decimal	15	0
83	ICL_BENSPLIT_HDR	Benefit Split (Onetime)	9	VALIDFROM	Benefit Split Valid From	nvarchar	8	0
84	ICL_BENSPPER_HDR	Benefit Split (Periodic)	9	VALIDFROM	Benefit Split Valid From	nvarchar	8	0
85	ICL_CRBPCLTYPE	RBP: Assignment of Profile to Claim Type and Subclaim Type	6	VALIDFROM	Changed: Date + Time	decimal	15	0
86	ICSITEM	Claim Item	30	VALIDFROM	Claim Item: Valid From	nvarchar	8	0
87	ICSPAYI	Payment Item	28	VALIDFROM	Payment Item: Valid From	nvarchar	8	0
88	ICSPOL	Policy Snapshot	11	VALIDFROM	Contract Version: Valid-From Date	decimal	15	0
89	ICS_BENSPLIT_HDR	Benefit Split (Shadow Table)	9	VALIDFROM	Benefit Split Valid From	nvarchar	8	0
90	ICS_BENSPPER_HDR	Benefit Split (Shadow Table)	9	VALIDFROM	Benefit Split Valid From	nvarchar	8	0
TOPClinical System
91	TN2STAMPADM	IS-H*MED: Stamp Administration	4	VALIDFROM	Valid From Stamp	nvarchar	8	0
92	TN2STAMPGP	IS-H*MED: Assignment of Stamp to Person	4	VALIDFROM	Valid From Stamp	nvarchar	8	0
93	TN2STAMPORG	IS-H*MED: Preferred Stamp of Employee in Surgery	4	VALIDFROM	Valid From Stamp	nvarchar	8	0
TOPCondition
94	BKK81	Bank Condition	4	VALIDFROM	Valid from	nvarchar	8	0
95	BKK82	Bank Condition Item	4	VALIDFROM	Valid from	nvarchar	8	0
96	BKK83	Bank Condition Determination	9	VALIDFROM	Valid from	nvarchar	8	0
97	BKK84	Bank Account - Individual Condition	5	VALIDFROM	Valid from	nvarchar	8	0
98	BKK85	Bank Account - Individual Condition Position	5	VALIDFROM	Valid from	nvarchar	8	0
99	BKK8RK	Standard Conditions: Retroactive Condition Changes	7	VALIDFROM	Date till when Condition was Used	nvarchar	8	0
100	BKK95	Account Specific Amount Limits for Graduated Conditions	5	VALIDFROM	Valid from	nvarchar	8	0
TOPConsumption-Based Planning See Also PP-MRP
101	WSAF_PROMO_DELTA	Change Information for Promotions	7	VALIDFROM	Valid From	nvarchar	8	0
TOPControlling
102	FCOMC_SETVER	Hierarchy Versions	3	VALIDFROM	Valid-From Date	nvarchar	8	0
TOPCountry-Specific Objects
103	COMC_CFOP_REGION	Assignment of departure region to CFOP Version	4	VALIDFROM	CFOP Version Effective From	nvarchar	8	0
TOPFinancial Accounting
104	OFF_NUM_LV2	Assign Number Ranges to Document Class, Number Group, Date	5	VALIDFROM	Valid From	nvarchar	8	0
TOPFlexible Real Estate Management
105	TIVCARECUR	Recurrence Rule	4	VALIDFROM	Start of a Recurring Appointment	nvarchar	8	0
106	VIBDARCOMPREL	OBSOLETE: Assignment of Architecture to Company Code	5	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
107	VIBDPMEQ	OBSOLETE: Link from RE Object to Equipment	5	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
108	VIBDPMFL	OBSOLETE: Link from RE Object to Functional Location	6	VALIDFROM	Date: Relationship Valid From	nvarchar	8	0
109	VICAECPRECONV	RE-FX: Currency Conversion - Conditions Before Conversion	7	VALIDFROM	Date from when condition is valid	nvarchar	8	0
110	VICARECUR	Deadline Regulation	4	VALIDFROM	Start of a Recurring Appointment	nvarchar	8	0
111	VICARSRULE	Resubmission Rule for Object	6	VALIDFROM	Start Date of Reminder Rule	nvarchar	8	0
112	VIITTCBASE	Basis for Input Tax Correction	12	VALIDFROM	Date: Valid From	nvarchar	8	0
113	VISCS_MEAS	OBSOLETE: Measurement Amount (Replaced by VISCSMEAS)	7	VALIDFROM	Date: Measurement Valid From	nvarchar	8	0
114	VISCS_RECEIVE	OBSOLETE: Receivables (Replaced by VISCRECEIVABLE)	7	VALIDFROM	Period Start Date	nvarchar	8	0
115	VIXCAJOBJCH01	Contract/Rental Object: Adjustment Term Data CH01	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
116	VIXCAJSPECH01	Contract/Rental Object: Adjustment Rule CH01	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
117	VIXCITCADASTCH	Cadaster changes	5	VALIDFROM	Date: Valid From	nvarchar	8	0
TOPFunds Management
118	FMFG_RE_PMT_EXT	RECN Condition:Payment Term Extension	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
119	RECN_OA_SPLIT	RECN: Group Number of Organizazional Assignment Split	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
TOPGenerated Enhancements Easy Enhancement Workbench
120	BUX_TDCHECK	Table containingdetails to construct entries for BUT_TDTRANS	5	VALIDFROM	Field Name	nvarchar	30	0
TOPInput Tax Treatment
121	VIITOPTRATE	Option Rate per Object and Period	6	VALIDFROM	Option Rate Valid From	nvarchar	8	0
TOPIntegration Customer Relationship Management
122	EPDESC	IS-U MD template description: header entries	9	VALIDFROM	IS-U Master Data Template Description: Valid From	nvarchar	8	0
TOPLand Use Management
123	VILMEMCHG	Rights and Easements - Changes (Header)	5	VALIDFROM	Date: Valid From	nvarchar	8	0
124	VILMJL	Joint Liability	18	VALIDFROM	Date: Valid From	nvarchar	8	0
125	VILMLR	Land Register	21	VALIDFROM	Date: Valid From	nvarchar	8	0
126	VILMNA	Notice of Assessment	18	VALIDFROM	Date Notice of Assessment Is Valid From	nvarchar	8	0
127	VILMNAVAL	Notice of Assessment: Annual Values	3	VALIDFROM	Assessed Value Valid From	nvarchar	8	0
128	VILMPE	Other Public Register	19	VALIDFROM	Date: Valid From	nvarchar	8	0
129	VILMPL	Parcel of Land	20	VALIDFROM	Date Parcel Valid From	nvarchar	8	0
130	VILMPLMAP	Parcel Maps	5	VALIDFROM	Date: Valid From	nvarchar	8	0
131	VILMPLSL	Overlays and Classifications	5	VALIDFROM	Date: Valid From	nvarchar	8	0
132	VILMPLUS	Usage and Development Planning	11	VALIDFROM	Date: Valid From	nvarchar	8	0
133	VILMRC	Parcel Update	20	VALIDFROM	Date the Official Notice of Parcel Update Was Issued	nvarchar	8	0
134	VILMRGCHG	Real Estate Register - Additions/Removals	4	VALIDFROM	Date: Valid From	nvarchar	8	0
TOPLocalization
135	ISJPPAYTERMS	Terms of payment with validity period	4	VALIDFROM	Valid From Date	nvarchar	8	0
136	J_1BCFOP_XREGN	Regions with differing CFOP version and extension	4	VALIDFROM	Valid-From Date of CFOP Version	nvarchar	8	0
137	J_1BNFE_CUST3	NF-e: System Configuration per Business Place	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
138	J_1BTXCI1	Tax calc.: Complement of ICMS rules	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
139	J_1BTXCOF	Tax Calculation: COFINS	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
140	J_1BTXDEF	Tax calc.: Default rates	3	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
141	J_1BTXIC1	Tax calc.: ICMS general rules	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
142	J_1BTXIC2	Tax calc.: ICMS rules	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
143	J_1BTXIC3	Grouped ICMS	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
144	J_1BTXIP1	Tax calc.: IPI rules	3	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
145	J_1BTXIP2	Tax calc.: IPI rules (material dependent)	3	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
146	J_1BTXIP3	Grouped IPI	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
147	J_1BTXIS1	Tax calc.: ISS rules for sales	3	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
148	J_1BTXIS3	Grouped ISS	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
149	J_1BTXISS	Tax Calculation: ISS	8	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
150	J_1BTXPIS	Tax Calculation: PIS	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
151	J_1BTXST1	Tax calc.: Sub.Trib. rules	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
152	J_1BTXST2	Tax calc.: Sub.Trib. rules (general)	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
153	J_1BTXST3	Dynamic Calculation of Substituição Tributária	10	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
154	J_1BTXWITH	Withholding Tax Calculation: Rates and Collection Codes	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
155	J_1IADDEXC	Additional Excise rate table	4	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
156	J_1IEXCTAX	Tax calc. - Excise tax rates	4	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
157	J_1IMATEXP	Exceptional materials excise rates	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
158	J_1IQEXCISE	Quantity based AED, NCCD and SED	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
159	OFF_NUM_ID	Settings for Official Document Numbering Indonesia	5	VALIDFROM	Date from	nvarchar	8	0
160	OFNUM_TW_2	Official Numbering by Business Places-enabled ranges(TW)	5	VALIDFROM	Date from	nvarchar	8	0
161	TIVXCFRBDGPRD	Annual Budget Periods	4	VALIDFROM	Valid From	nvarchar	8	0
162	TIVXCNLSUBSICAT	Define Categories for Subsidized Rent	3	VALIDFROM	Date: Valid From	nvarchar	8	0
163	TIVXCNLSUBSICATT	Category texts for Subsidizable Rent	4	VALIDFROM	Date: Valid From	nvarchar	8	0
164	TIVXCNLSUBSICOND	Define Condition Types for Subsidized Rent	4	VALIDFROM	Date: Valid From	nvarchar	8	0
165	VIXCJPFXDUNPRICE	Fixed Unit Prices for Service Charge Settlement	9	VALIDFROM	Start Date of Validity Interval	nvarchar	8	0
166	VIXCNLCHARACT	Fixtures/Fittings NL	5	VALIDFROM	Date: Valid From	nvarchar	8	0
167	VIXCPTCASHF	IMI Cash flow data for the incoming payments	3	VALIDFROM	Date: Valid From	nvarchar	8	0
TOPMarket Risk Analyzer
168	TMDT_MDCRVALUES	MDCR Values	4	VALIDFROM	Valid From / Effective From	nvarchar	8	0
TOPMaster Data
169	BCA_US_HLD2REL	Hold Records which have not been released - Dual Control	10	VALIDFROM	Valid From	nvarchar	8	0
170	BCA_US_HOLD	Hold Amounts Which Affect Available Balance	9	VALIDFROM	Valid From	nvarchar	8	0
171	BKKE1	Current Account: Limits	6	VALIDFROM	Limit Valid From	nvarchar	8	0
172	EPDPROD	IS-U Master Data Generator: Master Data Template	18	VALIDFROM	IS-U Master Data Template Description: Valid From	nvarchar	8	0
173	EWATWASTESRVPROD	Service Products for Waste and Recycling	3	VALIDFROM	Date from which the service product waste&recycling is valid	nvarchar	8	0
174	JGTEUWVGEO	IS-M: Retailer - Geographical Unit Assignment	8	VALIDFROM	Valid-From Date	nvarchar	8	0
TOPMedia Product Sales and Distribution
175	JKSD_ASORT_HEAD	IS-M: Contract Data - Contract for Assortment	3	VALIDFROM	Contract start date	nvarchar	8	0
176	JKSD_KNVP_CONTR	IS-M: Time-Dependent Partner Roles in MPS - Contracts	7	VALIDFROM	Valid-From Date	nvarchar	8	0
177	JKSD_KNVP_HEAD	IS-M: Time-Dependent Partner Roles in MPS - Admin. Data	7	VALIDFROM	Valid-From Date	nvarchar	8	0
178	JKSD_KNVP_PARVW	IS-M: Time-Dependent Partner Roles in MPS - Partners	7	VALIDFROM	Valid-From Date	nvarchar	8	0
179	JPSEPRODCOMP	IS-M: Subscription Mix Type Definition	5	VALIDFROM	Date of Start of Relationship	nvarchar	8	0
180	JVSDDELIVCYCLESA	IS-M: Assignment of Media Prods to Delivery Cycle/Sales Area	9	VALIDFROM	Valid-From Date	nvarchar	8	0
181	JVSDDELIVCYCLGRP	IS-M: Delivery Group per Cycle and Plant	7	VALIDFROM	Valid-From Date	nvarchar	8	0
182	JVSDDELIVCYCPROD	IS-M: Assign Media Products to Delivery Cycle	7	VALIDFROM	Valid-From Date	nvarchar	8	0
183	JVSDDELIVCYCVIPL	IS-M: Assign Visit Plans to Delivery Cycle	6	VALIDFROM	Valid-From Date	nvarchar	8	0
184	JVSDPRODCOMP	IS-M: Media Product - Components	7	VALIDFROM	Date of Start of Relationship	nvarchar	8	0
185	JVSDTPVISITPLANS	IS-M: Assignment of Plant to Visit Plan	5	VALIDFROM	Valid-From Date	nvarchar	8	0
TOPMedia Sales and Distribution
186	/NAM/ABC_DATES	Alternative ABC Categories for Specific Dates	4	VALIDFROM	Valid-From Date	nvarchar	8	0
TOPMigration
187	VIMIMAPCNNR	Conversion Decisions: Contract Numbers	11	VALIDFROM	Date: Valid From	nvarchar	8	0
TOPPeriodical Sales and Distribution
188	JKWWWTEMP_SERV	IS-M: Temporary Table for Changes from Internet	89	VALIDFROM	Valid-From Date	nvarchar	8	0
189	JVSOH	IS-M/SD Shipping Order Header	11	VALIDFROM	Valid-From Date	nvarchar	8	0
190	JVSOP	IS-M/SD Shipping Order Item	4	VALIDFROM	Valid-From Date	nvarchar	8	0
191	JVSOPDV	IS-M/SD Delivery Viability Set for Shipping Order Item	4	VALIDFROM	Valid-From Date	nvarchar	8	0
192	JVTPHMODELL	IS-M/SD: Phase Shipping - Model	8	VALIDFROM	Valid-From Date	nvarchar	8	0
TOPPerishables Procurement
193	FIP_D_PROMO	Promotion data	7	VALIDFROM	Valid-From Date	nvarchar	8	0
TOPProcess Controls
194	GRPCCTRLPROPOSAL	GRPC:Control Proposal	23	VALIDFROM	Start Date	nvarchar	8	0
195	GRPCRULE	Rule	9	VALIDFROM	Valid From	nvarchar	8	0
196	GRPCRULE_SNP	Rule for Snapshot	10	VALIDFROM	Valid From	nvarchar	8	0
197	GRPCRULE_TEMP	Rule - Temporary table for installation	9	VALIDFROM	Valid From	nvarchar	8	0
TOPReal Estate Contract
198	VICNMEASCN	Contract Measurement	6	VALIDFROM	Date: Measurement Valid From	nvarchar	8	0
199	VITMOBJREL	Object Assignment	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
TOPReal Estate Management
200	VIAK03	Settlement Unit Master Record	32	VALIDFROM	Valid-From Date of Settlement Unit	nvarchar	8	0
201	VIMI01	Rental unit - Master data	94	VALIDFROM	Date: Object Valid From	nvarchar	8	0
202	VIOB01	Business entities	49	VALIDFROM	Date: Object Valid From	nvarchar	8	0
203	VIOB02	Property master data	67	VALIDFROM	Date: Object Valid From	nvarchar	8	0
204	VIOB03	Real estate building master	80	VALIDFROM	Date: Object Valid From	nvarchar	8	0
TOPRent Adjustment
205	TIVAJEPCRTD	Time-Dependent Calculation Formula for Expense Item	3	VALIDFROM	Calculation Formula Valid From	nvarchar	8	0
206	TIVAJRLRAMAP	Representative List of Rents Reference	3	VALIDFROM	Rep. List of Rents Valid From	nvarchar	8	0
207	VIAJAT	Adjustment Measure	17	VALIDFROM	Adjustment Measure Valid From	nvarchar	8	0
208	VIAJCOMPGRP	Comparative Group of Apartments	7	VALIDFROM	Valid From	nvarchar	8	0
209	VIAJOBJCOMP	Contract/Rental Object: COMP	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
210	VIAJOBJINDX	Contract/Rental Object: INDX	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
211	VIAJRULE	Contract/Rental Object: Adjustment Rule	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
212	VIAJSPECINDX	Contract/Rental Object: Adjustment Method INDX	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
213	VIAJTERM	Contract/Rental Object: Adjustment Term	6	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
TOPRental Accounting
214	TIVEXFITAXMAP	Tax Code Assignment per RE Tax Type/Group	5	VALIDFROM	Date: Valid From	nvarchar	8	0
215	TIVEXFITAXTRKEY	Assignment of Tax Transaction Key	4	VALIDFROM	Date: Valid From	nvarchar	8	0
216	TIVEXTAXCODEMAP	Assignment of RE Tax Type/Group per Tax Code	4	VALIDFROM	Date: Valid From	nvarchar	8	0
217	VIEXFIWTITEM	Term: Withholding Tax Item	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
218	VIRAADVPAY	OBSOLETE: Advance Payment	10	VALIDFROM	Period Start Date	nvarchar	8	0
219	VIRAADVPAYEXT	Advance Payment - Legacy Data Transfer	7	VALIDFROM	Period Start Date	nvarchar	8	0
220	VIRAADVPAYPROC	Advance Payments per Settlement	7	VALIDFROM	Period Start Date	nvarchar	8	0
221	VIRAADVPAYSPLIT	Split Advance Payments	6	VALIDFROM	Date: Valid From	nvarchar	8	0
222	VITMOA	Term: Organizational Assignment	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
223	VITMPY	Term: Posting Rule	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
224	VITMPYSPLIT	Term: Split for Posting Rule	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
225	VITMRH	Terms: Frequency Rule	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
226	VITMWT	Term: Withholding Tax	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
TOPRoom Reservations and Seating Arrangements
227	VIORPO	Continuous Occupancy	7	VALIDFROM	Occupancy Effective From	nvarchar	8	0
228	VIORRS	Reservation	7	VALIDFROM	Reserved From	decimal	15	0
229	VIORRSCOST	Reservation - Costs	5	VALIDFROM	Reserved From	decimal	15	0
230	VIORRSREC	Recurring Reservation	29	VALIDFROM	Start of a Recurring Appointment	nvarchar	8	0
TOPSales-Based Rent and Settlement
231	VISRCALCSALES	Reference to Sales Report Used	6	VALIDFROM	Reporting Interval Start for Sales-Based Lease-Out	nvarchar	8	0
232	VISRREPORT	Sales Report	5	VALIDFROM	Reporting Interval Start for Sales-Based Lease-Out	nvarchar	8	0
233	VISRSETTL	Settlement Identification with Log Reference	11	VALIDFROM	Reporting Interval Start for Sales-Based Lease-Out	nvarchar	8	0
234	VISRTMRP	Reporting Rule	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
235	VISRTMSB	Sales Rule	5	VALIDFROM	Valid-From Date of Term	nvarchar	8	0
TOPService Charge Settlement
236	VISCCC	Cost collector for SU (per settlement period)	4	VALIDFROM	Start of Settlement Period	nvarchar	8	0
237	VISCCNPART	Settlement Participation for Service Charge Settlement	6	VALIDFROM	Date from when assignment is valid	nvarchar	8	0
238	VISCEXBASERATE	Basic Components for External Settlement per SU	3	VALIDFROM	Date from when assignment is valid	nvarchar	8	0
239	VISCMPPROP	Additional Characteristics of Meter	4	VALIDFROM	Date: Valid From	nvarchar	8	0
240	VISCMPSUBOBJ	Subordinate Objects of Meter	5	VALIDFROM	Date: Valid From	nvarchar	8	0
241	VISCPG	Participation Group	7	VALIDFROM	Valid-From Date of Participation Group	nvarchar	8	0
242	VISCRECEIVABLE	Receivables from Settlement	8	VALIDFROM	Period Start Date	nvarchar	8	0
243	VISCSHAREOUT	Split settlement factors for settlement variant	3	VALIDFROM	Date: Valid From	nvarchar	8	0
244	VISCSMEAS	Measurement Amount Used	8	VALIDFROM	Date: Measurement Valid From	nvarchar	8	0
245	VISCSU	Settlement unit	21	VALIDFROM	Valid-From Date of Settlement Unit	nvarchar	8	0
246	VISCSUREL	Master Settlement Unit: Participating Settlement Units	4	VALIDFROM	Date: Valid From	nvarchar	8	0
247	VISCSURH	Allocation of Settlement Variants to Settlement Unit	3	VALIDFROM	Date: Valid From	nvarchar	8	0
248	VISCSUSE	Settings per Settlement Purpose	5	VALIDFROM	Date: Valid From	nvarchar	8	0
TOPTariffs, Duties and Permits
249	OIH07	TDP allowed combinations of ED Group and Handling Type	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
250	OIH07A	TDP allowed combinations of ED Group and Handling Type	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
251	OIH24	ED GROUPING CODE	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
252	OIH24A	ED GROUPING CODE	8	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
253	OIH25	TDP additional checks for purchasing	4	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
254	OIH26	License Requirements Tab	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
255	OIH26A	License Requirements Tab	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
256	OIH27	TDP additional checks for sales	4	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
257	OIH_J1B_ACSVAL	Brazil: Oil Access Values	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
258	OIH_J1B_ALC	Brazil: Percentage of alcohol in gasoline	4	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
259	OIH_J1B_APR	Brazil tax: Acquisition price table	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
260	OIH_J1B_CON	Brazil: Convenio application rules per state	5	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
261	OIH_J1B_COP	Brazil: Controled prices table	8	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
262	OIH_J1B_CPR	Brazil: Posting exceptions for ICMS complement	8	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
263	OIH_J1B_FAC	Brazil: Factor for calculation of PIS / COFINS ST	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
264	OIH_J1B_INC	Brazil: Incoming taxation table	11	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
265	OIH_J1B_PIC	Brazil: Printing exceptions for ICMS	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
266	OIH_J1B_PIS	Brazil: PIS/COFINS taxation table (exactly one entry)	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
267	OIH_J1B_PPR	Brazil Tax: Pondered average price table for final consume	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
268	OIH_J1B_RAF	Brazil: Refinery taxation table	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
269	OIH_J1B_SAL_2	Brazil: ICMS Deferment	12	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
270	OIH_J1B_ZFD	Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
271	OIH_J_1BTXCI1	Tax calc.: Complement of ICMS rules	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
272	OIH_J_1BTXCI2	Tax calc.: Complement of ICMS rules INSIDE CALCULATION	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
273	OIH_J_1BTXIC2	Tax calc.: ICMS rules (exceptions)	7	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
274	OIH_J_1BTXIS1	Tax calc.: ISS rules for sales exeptions	6	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
275	OIH_J_1BTXIX1	Tax calc.: ISS rules for sales and purchasing exeptions	12	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
276	OIH_J_1BTXST1	Tax calc.: Sub.Trib. rules	9	VALIDFROM	Date from which the tax rule is valid	nvarchar	8	0
TOPThird Party ManagementCOA
277	VIMMMN	Mandate	17	VALIDFROM	Mandate Valid From	nvarchar	8	0
TOPTransaction Manager
278	TEXT_POSF_PRICES	Exposure Position Flow Pricing Data	19	VALIDFROM	Valid From Date	nvarchar	8	0
279	TEXT_POS_FLOW	Exposure Position Flows	45	VALIDFROM	Valid From Date	nvarchar	8	0
TOPTransaction Tax Engine
280	TTEC_DT_DATA	Decision Tree Data	17	VALIDFROM	Valid from Date	nvarchar	8	0
281	TTED_INEXEMP_COM	Exemptions	16	VALIDFROM	Valid From	nvarchar	8	0
282	TTED_OEXEMP_COM	Output Exemptions	16	VALIDFROM	Valid From	nvarchar	8	0
283	TTEPD3_EXEMP	Exemptions	16	VALIDFROM	Valid From	nvarchar	8	0
284	TTEPDT_EXEMPT	Persistency TTE Document Output Exemptions	13	VALIDFROM	Valid From	nvarchar	8	0
285	TTEPDT_EXEMPVALU	Persistency TTE Document Item Exemption Value	7	VALIDFROM	Valid From	nvarchar	8	0
286	TTESDT_EXEMPT	Output Exemptions	13	VALIDFROM	Valid From	nvarchar	8	0
287	TTESDT_EXEMPVALU	Document business partner exemption values for with. tax.	8	VALIDFROM	Valid From	nvarchar	8	0
TOPTreasury and Risk Management
288	FTVVT_KWG_MD	Master Data for KWG Relevant Business Partners	3	VALIDFROM	Date	nvarchar	8	0
TOPWorkforce Management Core
289	WFDS_QUA_REQ	Qualification Requirements	4	VALIDFROM	Time Stamp (Date and Time)	decimal	15	0

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

289 columns | ERP 6.0 | VALIDFROM