	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

272 columns | ERP 6.0 | VALIDTO

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/CFMFND/ACCTASS	Kontierungsdaten für Raumnutzung	7	VALIDTO	Kontierungsdaten gültig bis	nvarchar	8	0
2	/CFMFND/AREA	Umlagedaten	7	VALIDTO	Umlagedaten gültig bis	nvarchar	8	0
3	/CFMFND/BP_AA	Kontierungsdaten	4	VALIDTO	Kontierungsdaten gültig bis	nvarchar	8	0
4	/ORS/SUBSTITUTE	Optura's Substitution Table for user map	6	VALIDTO	User valid to	nvarchar	8	0
5	CIAP_C_NO_QUO_BP	Table for customizing of quotas quantity by CCode / B Place	5	VALIDTO	End Date	nvarchar	8	0
6	CIAP_C_NO_QUO_ST	Table for customizing of quotas quantity by Country/State	5	VALIDTO	End Date	nvarchar	8	0
7	CPEC_CONDTYPE	CPE Condition Type - CPE extensions	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
8	CPEC_PRCFIXRULE	CPE Term - Rule for Def. of Price Fixation Option	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
9	EBILLPRG	IS-U: Billing Programs	4	VALIDTO	To-Date for Conditional Billing Program	nvarchar	8	0
10	ECONDIPROCINTF	IS-U: Processing Interface for Conditions	5	VALIDTO	To-Date for Conditional Billing Program	nvarchar	8	0
11	EINV_CUST_TW	TW: Customers Eligible for E-INVOICE	5	VALIDTO	Valid To	nvarchar	8	0
12	ETOUEXCPTPRG	TOU Exception Program	5	VALIDTO	Validity To-Date for TOU Exception Program	nvarchar	8	0
13	FISAFTPTC_SBINFO	SAFT: Customization for Self Billing File Generation	6	VALIDTO	Date validity ends	nvarchar	8	0
14	GRACMITOBJECT	Mitigating control assignment	9	VALIDTO	Validity End Date	nvarchar	8	0
15	GRACMITPROF	Profile mitigating control assignment	8	VALIDTO	Validity End Date	nvarchar	8	0
16	GRACMITROLE	Role mitigating control assignment	8	VALIDTO	Validity End Date	nvarchar	8	0
17	GRACMITROLEORG	Role Org mitigating control assignment	9	VALIDTO	Validity End Date	nvarchar	8	0
18	GRACMITUSER	User mitigating control assignment	8	VALIDTO	Validity End Date	nvarchar	8	0
19	GRACMITUSERAR	User mitigating control assignment for Access Request	9	VALIDTO	Validity End Date	nvarchar	8	0
20	GRACMITUSERGP	User Group mitigating control assignment	8	VALIDTO	Validity End Date	nvarchar	8	0
21	GRACMITUSERORG	User Org mitigating control assignment	9	VALIDTO	Validity End Date	nvarchar	8	0
22	GRACMITUSERORGAR	User Org mitigating control assignment for Access Request	10	VALIDTO	Validity End Date	nvarchar	8	0
23	GRACMITUSER_AR	Obsolete	8	VALIDTO	Validity End Date	nvarchar	8	0
24	GRACMITUSRORG_AR	Obsolete	9	VALIDTO	Validity End Date	nvarchar	8	0
25	GRFNAUSTEP	Audit Proposal Steps	10	VALIDTO	End Date	nvarchar	8	0
26	GRFNAUSTEPLOG	Audit Proposal Steps Transfer Log	11	VALIDTO	End Date	nvarchar	8	0
27	GRFNDSBACKUP	DS & status backup	4	VALIDTO	End Date	nvarchar	8	0
28	J_1BTTAXDET	Tax Determination - Validity	6	VALIDTO	Valid To	nvarchar	8	0
29	TFK_ODNNR_DET	Assign Number Range Numbers to Document Classes	7	VALIDTO	Valid to data	nvarchar	8	0
30	TIVXCNLHPCITY	Highly populated cities	4	VALIDTO	Valid To	nvarchar	8	0
31	TIVXCNLWOZBAS	Define basic settings for extra point calculation	4	VALIDTO	Valid To	nvarchar	8	0
32	TIVXCNLWOZPTS	Extra points per Rental object value/M2	6	VALIDTO	Valid To	nvarchar	8	0
33	VIBDAOFUNCTION	Architectural Object: Function	4	VALIDTO	Date: Valid To	nvarchar	8	0
34	VIXCCHCATASTER	Localization Switzerland: RE Property Cataster	6	VALIDTO	Date: Valid To	nvarchar	8	0
35	VIXCCHCATEGID	Localization Switzerland: RE Property Cataster EGID	6	VALIDTO	Date: Valid To	nvarchar	8	0
36	VIXCITCADAO	Temporary architectural object data	11	VALIDTO	Date: Object Valid To	nvarchar	8	0
37	VIXCITCADRO	Temporary rental object data	22	VALIDTO	Date: Object Valid To	nvarchar	8	0
38	VIYCCAP	Capping Parameters	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
39	VIYCCE2EXP	Cost Element to Expense Type	6	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
40	VIYCCE2POOL	Cost Elements in Pool	7	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
41	VIYCCN	Table for assignment of CAM Terms to a RE Contract	7	VALIDTO	Date: Valid To	nvarchar	8	0
42	VIYCEXP	Expense Type to Expense Pool	5	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
43	VIYCMAJTENANT	Major Tenant Parameters	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
44	VIYCMARK	Mark-up Parameters	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
45	VIYCOBJ2POOL	Objects in CAM Pool	7	VALIDTO	Period End Date	nvarchar	8	0
46	VIYCPROV	Provision Parameters	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
47	VIYCRECEIVABLE	Receivables from Settlement	42	VALIDTO	Assignment Is Valid to This Date	nvarchar	8	0
48	VIYCREFFACTOR	Reference Factors	7	VALIDTO	Date: Measurement Valid To	nvarchar	8	0
49	VIYCRENT	Rental period	14	VALIDTO	Period End Date	nvarchar	8	0
50	VIYCRHYTHM	CAM Expense Recovery Frequency Rule	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
51	ZCSM_SRVC_CATLOG	catalog for facility services	23	VALIDTO	Effective until date	nvarchar	8	0
52	ZSKSYSUSER	user in den IDES-Systemen	11	VALIDTO		nvarchar	8	0
TOPAerospace Defence Industry Solution
53	DIWPS_COMP	Reallocation: Conversion Storage Location	9	VALIDTO	Date	nvarchar	8	0
TOPAudit Management
54	PLMM_AUDITPLAN	Audit Plan	8	VALIDTO	Valid To	decimal	15	0
55	PLMM_QUEST_H	Question List	5	VALIDTO	Valid To	decimal	15	0
TOPBank Customer Accounts
56	TBCA_US_R_HOLD	Refrence adjustment types that can be created	5	VALIDTO	Valid To Field	nvarchar	8	0
TOPBasic Data
57	VIBDAO	Architectural Object	7	VALIDTO	Date: Object Valid To	nvarchar	8	0
58	VIBDBE	Business Entity	20	VALIDTO	Date: Object Valid To	nvarchar	8	0
59	VIBDBU	Building	21	VALIDTO	Date: Object Valid To	nvarchar	8	0
60	VIBDCHARACT	Fixtures/Fittings	4	VALIDTO	Date: Valid To	nvarchar	8	0
61	VIBDMEAS	Measurement	4	VALIDTO	Date: Measurement Valid To	nvarchar	8	0
62	VIBDOBJASS	Object Assignment	6	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
63	VIBDOBJREL	Object Relationship A/U Object <-> A/U Object	4	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
64	VIBDOBJRELPART	Object Relationship A/U Object <-> A/U Object: Percent	4	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
65	VIBDPLANOCC	Planned Occupancy of Usage Objects	9	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
66	VIBDPR	Land	21	VALIDTO	Date: Object Valid To	nvarchar	8	0
67	VIBDRO	Rental Object	21	VALIDTO	Date: Object Valid To	nvarchar	8	0
TOPBusiness Partner
68	VIBPADDRREL	Addresses of RE Object	6	VALIDTO	Date: Valid To	nvarchar	8	0
69	VIBPOBJREL	Business Partner-Object Relationship	9	VALIDTO	Date of End of Relationship	nvarchar	8	0
TOPClaims Management
70	ICLITEM	Claim Item	31	VALIDTO	Claim Item: Valid To	nvarchar	8	0
71	ICLPAYI	Claim Payment Item	29	VALIDTO	Payment Item: Valid To	nvarchar	8	0
72	ICLPOL	Policy Snapshot	12	VALIDTO	Contract Version: Valid To Date	decimal	15	0
73	ICL_BENSPLIT_HDR	Benefit Split (Onetime)	10	VALIDTO	Benefit Split Valid To	nvarchar	8	0
74	ICL_BENSPLIT_ITM	Benefit Split Item (One-Time)	25	VALIDTO	Benefit Split Valid To	nvarchar	8	0
75	ICL_BENSPPER_HDR	Benefit Split (Periodic)	10	VALIDTO	Benefit Split Valid To	nvarchar	8	0
76	ICL_BENSPPER_ITM	Benefit Split Item (Periodic)	19	VALIDTO	Benefit Split Valid To	nvarchar	8	0
77	ICSITEM	Claim Item	31	VALIDTO	Claim Item: Valid To	nvarchar	8	0
78	ICSPAYI	Payment Item	29	VALIDTO	Payment Item: Valid To	nvarchar	8	0
79	ICSPOL	Policy Snapshot	12	VALIDTO	Contract Version: Valid To Date	decimal	15	0
80	ICS_BENSPLIT_HDR	Benefit Split (Shadow Table)	10	VALIDTO	Benefit Split Valid To	nvarchar	8	0
81	ICS_BENSPLIT_ITM	Benefit Split Item (Shadow Table)	25	VALIDTO	Benefit Split Valid To	nvarchar	8	0
82	ICS_BENSPPER_HDR	Benefit Split (Shadow Table)	10	VALIDTO	Benefit Split Valid To	nvarchar	8	0
83	ICS_BENSPPER_ITM	Benefit Split Item (Shadow Table)	19	VALIDTO	Benefit Split Valid To	nvarchar	8	0
TOPClinical System
84	TN2STAMPADM	IS-H*MED: Stamp Administration	5	VALIDTO	Valid To Stamp	nvarchar	8	0
TOPCommodity Pricing Engine
85	CPEC_CALCRULE	CPE Term - Calculation Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
86	CPEC_CONVERSION	CPE - Conversion Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
87	CPEC_FORMCONV	CPE Formula - Input for Conversion	5	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
88	CPEC_FORMROUND	CPE Formula - Input for Rounding	5	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
89	CPEC_FORMULA	CPE Formula	5	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
90	CPEC_PERIODDET	CPE Term - Period Determination Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
91	CPEC_QUANCONV	CPE - Quantity Conversion Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
92	CPEC_QUOTGROUP	Quotation Group	3	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
93	CPEC_QUOTGRPPOS	CPE Term - Position in Quotation Group	3	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
94	CPEC_ROUNDRULE	CPE - Rounding Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
95	CPEC_SURCHARGE	CPE Term - Surcharge Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
96	CPEC_TERM	CPE Term	5	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
97	CPEC_TERMCONV	CPE Term - Conversion	5	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
98	CPEC_TERMGRP	CPE Term - Grouping of Terms	6	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
99	CPEC_TERMROUND	CPE Term - Rounding	5	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
100	CPEC_TERMRULE	CPE Term - Term Rule	4	VALIDTO	CPE - 'Valid From' Time Stamp of Commodity Pricing Object	nvarchar	14	0
101	CPED_PRCQUOT_SIM	CPE - Price Quotation Simulation	7	VALIDTO	CPE - 'Valid To' Time Stamp of Commodity Pricing Object	nvarchar	14	0
102	CPED_PRICEQUOT	Price Quotation	7	VALIDTO	CPE - 'Valid To' Time Stamp of Commodity Pricing Object	nvarchar	14	0
TOPCondition
103	BKK82	Bank Condition Item	9	VALIDTO	Valid to	nvarchar	8	0
104	BKK83	Bank Condition Determination	14	VALIDTO	Valid to	nvarchar	8	0
105	BKK84	Bank Account - Individual Condition	6	VALIDTO	Valid to (Condition Header)	nvarchar	8	0
106	BKK85	Bank Account - Individual Condition Position	11	VALIDTO	Valid to	nvarchar	8	0
TOPConsumption-Based Planning See Also PP-MRP
107	WSAF_PROMO_DELTA	Change Information for Promotions	8	VALIDTO	Valid To	nvarchar	8	0
TOPCorporate Performance Monitor
108	UMR_RI120	RMS: Assignment of Risks	8	VALIDTO	End of Validity Period	nvarchar	7	0
109	UMR_RI121	RMS: Owner of Risk	6	VALIDTO	End of Validity Period	nvarchar	7	0
110	UMR_RI140	RMS: Risk-Reducing Activities (Master)	6	VALIDTO	End of Validity Period	nvarchar	7	0
TOPDFPS Authorized Infrastructure
111	/ISDFPS/T_RECAEX	RE: Extend Equipment Characteristics	4	VALIDTO	Date: Valid To	nvarchar	8	0
TOPFinancial Accounting
112	OFF_NUM_LV2	Assign Number Ranges to Document Class, Number Group, Date	6	VALIDTO	Valid To	nvarchar	8	0
TOPFlexible Real Estate Management
113	TIVCARECUR	Recurrence Rule	5	VALIDTO	End of a Recurring Appointment	nvarchar	8	0
114	VIBDARCOMPREL	OBSOLETE: Assignment of Architecture to Company Code	4	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
115	VIBDPMEQ	OBSOLETE: Link from RE Object to Equipment	4	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
116	VIBDPMFL	OBSOLETE: Link from RE Object to Functional Location	5	VALIDTO	Date: Relationship Valid To	nvarchar	8	0
117	VICAECPRECONV	RE-FX: Currency Conversion - Conditions Before Conversion	8	VALIDTO	Date up to when condition is valid	nvarchar	8	0
118	VICARECUR	Deadline Regulation	5	VALIDTO	End of a Recurring Appointment	nvarchar	8	0
119	VICARSRULE	Resubmission Rule for Object	7	VALIDTO	End Date of Reminder Rule	nvarchar	8	0
120	VIITTCBASE	Basis for Input Tax Correction	13	VALIDTO	Date: Valid To	nvarchar	8	0
121	VISCS_MEAS	OBSOLETE: Measurement Amount (Replaced by VISCSMEAS)	6	VALIDTO	Date: Measurement Valid To	nvarchar	8	0
122	VISCS_RECEIVE	OBSOLETE: Receivables (Replaced by VISCRECEIVABLE)	4	VALIDTO	Assignment Is Valid to This Date	nvarchar	8	0
123	VIXCAJOBJCH01	Contract/Rental Object: Adjustment Term Data CH01	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
124	VIXCAJSPECH01	Contract/Rental Object: Adjustment Rule CH01	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
TOPGenerated Enhancements Easy Enhancement Workbench
125	BUX_TDCHECK	Table containingdetails to construct entries for BUT_TDTRANS	6	VALIDTO	Field Name	nvarchar	30	0
TOPInput Tax Treatment
126	VIITOPTRATE	Option Rate per Object and Period	7	VALIDTO	Option Rate Valid To	nvarchar	8	0
TOPIntegration Customer Relationship Management
127	EPDESC	IS-U MD template description: header entries	10	VALIDTO	IS-U Master Data Template Description: Valid To	nvarchar	8	0
TOPInvoicing
128	ERDTS	Additional Charges and Taxes of a Print Document	10	VALIDTO	Entry valid until	nvarchar	8	0
TOPLand Use Management
129	VILMJL	Joint Liability	19	VALIDTO	Date: Valid To	nvarchar	8	0
130	VILMLR	Land Register	22	VALIDTO	Closure Date of Land Register	nvarchar	8	0
131	VILMNA	Notice of Assessment	19	VALIDTO	Notice of Assessment: Valid-To Date	nvarchar	8	0
132	VILMNAVAL	Notice of Assessment: Annual Values	4	VALIDTO	Assessed Value Valid To	nvarchar	8	0
133	VILMPE	Other Public Register	20	VALIDTO	Date: Valid To	nvarchar	8	0
134	VILMPL	Parcel of Land	21	VALIDTO	Date: Parcel Ceased to Exist On	nvarchar	8	0
135	VILMPLMAP	Parcel Maps	6	VALIDTO	Date: Valid To	nvarchar	8	0
136	VILMPLSL	Overlays and Classifications	10	VALIDTO	Date: Valid To	nvarchar	8	0
137	VILMPLUS	Usage and Development Planning	12	VALIDTO	Date: Valid To	nvarchar	8	0
138	VILMRC	Parcel Update	21	VALIDTO	Validity Date for Cadastral Area	nvarchar	8	0
TOPLocalization
139	J_1BTXCI1	Tax calc.: Complement of ICMS rules	6	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
140	J_1BTXCOF	Tax Calculation: COFINS	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
141	J_1BTXIC2	Tax calc.: ICMS rules	7	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
142	J_1BTXIC3	Grouped ICMS	10	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
143	J_1BTXISS	Tax Calculation: ISS	9	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
144	J_1BTXPIS	Tax Calculation: PIS	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
145	J_1BTXST1	Tax calc.: Sub.Trib. rules	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
146	J_1BTXST2	Tax calc.: Sub.Trib. rules (general)	7	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
147	J_1BTXST3	Dynamic Calculation of Substituição Tributária	11	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
148	J_1BTXWITH	Withholding Tax Calculation: Rates and Collection Codes	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
149	J_1IADDEXC	Additional Excise rate table	5	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
150	J_1IEXCTAX	Tax calc. - Excise tax rates	5	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
151	J_1IMATEXP	Exceptional materials excise rates	7	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
152	J_1IQEXCISE	Quantity based AED, NCCD and SED	6	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
153	OFF_NUM_ID	Settings for Official Document Numbering Indonesia	6	VALIDTO	Expiration Date	nvarchar	8	0
154	OFNUM_TW_2	Official Numbering by Business Places-enabled ranges(TW)	6	VALIDTO	Expiration Date	nvarchar	8	0
155	SAFTPT_ALT_ACCTS	SAFT_PT: Maintain Alternate Accounts	4	VALIDTO	Fiscal Year	nvarchar	4	0
156	TIVXCNLSUBSICAT	Define Categories for Subsidized Rent	4	VALIDTO	Date: Valid To	nvarchar	8	0
157	TIVXCNLSUBSICOND	Define Condition Types for Subsidized Rent	6	VALIDTO	Date: Valid To	nvarchar	8	0
158	VIXCJPFXDUNPRICE	Fixed Unit Prices for Service Charge Settlement	7	VALIDTO	End Date of Validity Interval	nvarchar	8	0
159	VIXCNLCHARACT	Fixtures/Fittings NL	4	VALIDTO	Date: Valid To	nvarchar	8	0
160	VIXCPTCASHF	IMI Cash flow data for the incoming payments	4	VALIDTO	Date: Valid To	nvarchar	8	0
TOPMaster Data
161	BCA_US_HLD2REL	Hold Records which have not been released - Dual Control	11	VALIDTO	Valid To Field	nvarchar	8	0
162	BCA_US_HOLD	Hold Amounts Which Affect Available Balance	10	VALIDTO	Valid To Field	nvarchar	8	0
163	BKKE1	Current Account: Limits	5	VALIDTO	Valid to	nvarchar	8	0
164	EPDPROD	IS-U Master Data Generator: Master Data Template	19	VALIDTO	IS-U Master Data Template Description: Valid To	nvarchar	8	0
165	EWATWASTESRVPROD	Service Products for Waste and Recycling	4	VALIDTO	Date until when service product Waste&Recycling is valid	nvarchar	8	0
166	JGTEUWVGEO	IS-M: Retailer - Geographical Unit Assignment	9	VALIDTO	Valid-To Date	nvarchar	8	0
TOPMedia Product Sales and Distribution
167	JKSD_ASORT_HEAD	IS-M: Contract Data - Contract for Assortment	4	VALIDTO	Contract end date	nvarchar	8	0
168	JPSEPRODCOMP	IS-M: Subscription Mix Type Definition	4	VALIDTO	Date of End of Relationship	nvarchar	8	0
169	JVSDDELIVCYCLESA	IS-M: Assignment of Media Prods to Delivery Cycle/Sales Area	8	VALIDTO	Valid-To Date	nvarchar	8	0
170	JVSDDELIVCYCLGRP	IS-M: Delivery Group per Cycle and Plant	6	VALIDTO	Valid-To Date	nvarchar	8	0
171	JVSDDELIVCYCPROD	IS-M: Assign Media Products to Delivery Cycle	6	VALIDTO	Valid-To Date	nvarchar	8	0
172	JVSDDELIVCYCVIPL	IS-M: Assign Visit Plans to Delivery Cycle	5	VALIDTO	Valid-To Date	nvarchar	8	0
173	JVSDPRODCOMP	IS-M: Media Product - Components	8	VALIDTO	Date of End of Relationship	nvarchar	8	0
174	JVSDTPVISITPLANS	IS-M: Assignment of Plant to Visit Plan	4	VALIDTO	Valid-To Date	nvarchar	8	0
TOPMedia Sales and Distribution
175	/NAM/ABC_DATES	Alternative ABC Categories for Specific Dates	5	VALIDTO	Valid-To Date	nvarchar	8	0
TOPMedical Patient Data Organization Patient Organizer
176	N1STRUCMEDRECCAT	IS-H*MED: Health Problems Catalog	5	VALIDTO	Health Problem Is Valid to (Date)	nvarchar	8	0
TOPMigration
177	VIMIMAPCNNR	Conversion Decisions: Contract Numbers	12	VALIDTO	Date: Valid To	nvarchar	8	0
TOPPeriodical Sales and Distribution
178	JKWWWTEMP_SERV	IS-M: Temporary Table for Changes from Internet	90	VALIDTO	Valid-To Date	nvarchar	8	0
179	JVSOH	IS-M/SD Shipping Order Header	12	VALIDTO	Valid-To Date	nvarchar	8	0
180	JVSOP	IS-M/SD Shipping Order Item	5	VALIDTO	Valid-To Date	nvarchar	8	0
181	JVSOPDV	IS-M/SD Delivery Viability Set for Shipping Order Item	6	VALIDTO	Valid-To Date	nvarchar	8	0
182	JVTPHMODELL	IS-M/SD: Phase Shipping - Model	9	VALIDTO	Valid-To Date	nvarchar	8	0
TOPPerishables Procurement
183	FIP_D_PROMO	Promotion data	8	VALIDTO	Valid To Date	nvarchar	8	0
TOPProcess Controls
184	GRPCCTRLPROPOSAL	GRPC:Control Proposal	24	VALIDTO	End Date	nvarchar	8	0
185	GRPCRULE	Rule	10	VALIDTO	Valid To	nvarchar	8	0
186	GRPCRULE_SNP	Rule for Snapshot	11	VALIDTO	Valid To	nvarchar	8	0
187	GRPCRULE_TEMP	Rule - Temporary table for installation	10	VALIDTO	Valid To	nvarchar	8	0
TOPReal Estate Contract
188	VICNMEASCN	Contract Measurement	5	VALIDTO	Date: Measurement Valid To	nvarchar	8	0
TOPReal Estate Management
189	VIMI01	Rental unit - Master data	95	VALIDTO	Date: Object Valid To	nvarchar	8	0
190	VIOB01	Business entities	50	VALIDTO	Date: Object Valid To	nvarchar	8	0
191	VIOB02	Property master data	68	VALIDTO	Date: Object Valid To	nvarchar	8	0
192	VIOB03	Real estate building master	81	VALIDTO	Date: Object Valid To	nvarchar	8	0
TOPRent Adjustment
193	VIAJAT	Adjustment Measure	18	VALIDTO	Adjustment Measure Valid To	nvarchar	8	0
194	VIAJCOMPGRP	Comparative Group of Apartments	8	VALIDTO	Valid To	nvarchar	8	0
195	VIAJOBJCOMP	Contract/Rental Object: COMP	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
196	VIAJOBJINDX	Contract/Rental Object: INDX	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
197	VIAJRULE	Contract/Rental Object: Adjustment Rule	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
198	VIAJSPECINDX	Contract/Rental Object: Adjustment Method INDX	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
199	VIAJTERM	Contract/Rental Object: Adjustment Term	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
TOPRental Accounting
200	TIVEXFITAXMAP	Tax Code Assignment per RE Tax Type/Group	6	VALIDTO	Date: Valid To	nvarchar	8	0
201	TIVEXFITAXTRKEY	Assignment of Tax Transaction Key	5	VALIDTO	Date: Valid To	nvarchar	8	0
202	TIVEXTAXCODEMAP	Assignment of RE Tax Type/Group per Tax Code	5	VALIDTO	Date: Valid To	nvarchar	8	0
203	VIRAADVPAY	OBSOLETE: Advance Payment	5	VALIDTO	Date: Valid To	nvarchar	8	0
204	VIRAADVPAYEXT	Advance Payment - Legacy Data Transfer	10	VALIDTO	Date: Valid To	nvarchar	8	0
205	VIRAADVPAYPROC	Advance Payments per Settlement	6	VALIDTO	Date: Valid To	nvarchar	8	0
206	VIRAADVPAYSPLIT	Split Advance Payments	7	VALIDTO	Date: Valid To	nvarchar	8	0
207	VITMOA	Term: Organizational Assignment	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
208	VITMPY	Term: Posting Rule	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
209	VITMPYSPLIT	Term: Split for Posting Rule	7	VALIDTO	Valid-To Date of Term	nvarchar	8	0
210	VITMRH	Terms: Frequency Rule	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
211	VITMWT	Term: Withholding Tax	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
TOPRoom Reservations and Seating Arrangements
212	VIORPO	Continuous Occupancy	8	VALIDTO	Occupancy Effective To	nvarchar	8	0
213	VIORRS	Reservation	8	VALIDTO	Reserved To	decimal	15	0
214	VIORRSCOST	Reservation - Costs	6	VALIDTO	Reserved To	decimal	15	0
215	VIORRSREC	Recurring Reservation	30	VALIDTO	End of a Recurring Appointment	nvarchar	8	0
TOPSales-Based Rent and Settlement
216	VISRCALCADVPAY	Reference to Advance Payment Used	7	VALIDTO	Date: Valid To	nvarchar	8	0
217	VISRREPORT	Sales Report	7	VALIDTO	End of Reporting Interval for Sales-Based Lease-Out	nvarchar	8	0
218	VISRTMRP	Reporting Rule	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
219	VISRTMSB	Sales Rule	6	VALIDTO	Valid-To Date of Term	nvarchar	8	0
TOPSecurity
220	STRUSTCAB	Central Address Book	10	VALIDTO	Validity End Date	nvarchar	8	0
TOPService Charge Settlement
221	VISCCC	Cost collector for SU (per settlement period)	5	VALIDTO	End of Settlement Period	nvarchar	8	0
222	VISCCNPART	Settlement Participation for Service Charge Settlement	5	VALIDTO	Assignment Is Valid to This Date	nvarchar	8	0
223	VISCMPPROP	Additional Characteristics of Meter	5	VALIDTO	Date: Valid To	nvarchar	8	0
224	VISCMPSUBOBJ	Subordinate Objects of Meter	6	VALIDTO	Date: Valid To	nvarchar	8	0
225	VISCPG	Participation Group	8	VALIDTO	Valid-To Date of Participation Group	nvarchar	8	0
226	VISCRECEIVABLE	Receivables from Settlement	5	VALIDTO	Assignment Is Valid to This Date	nvarchar	8	0
227	VISCSMEAS	Measurement Amount Used	9	VALIDTO	Date: Measurement Valid To	nvarchar	8	0
228	VISCSU	Settlement unit	22	VALIDTO	End of the Validity of Settlement Unit	nvarchar	8	0
229	VISCSUSE	Settings per Settlement Purpose	6	VALIDTO	Date: Valid To	nvarchar	8	0
TOPTariffs, Duties and Permits
230	OIH_J1B_ACSVAL	Brazil: Oil Access Values	6	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
231	OIH_J1B_ALC	Brazil: Percentage of alcohol in gasoline	5	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
232	OIH_J1B_APR	Brazil tax: Acquisition price table	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
233	OIH_J1B_CON	Brazil: Convenio application rules per state	6	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
234	OIH_J1B_COP	Brazil: Controled prices table	9	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
235	OIH_J1B_CPR	Brazil: Posting exceptions for ICMS complement	9	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
236	OIH_J1B_FAC	Brazil: Factor for calculation of PIS / COFINS ST	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
237	OIH_J1B_INC	Brazil: Incoming taxation table	12	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
238	OIH_J1B_PIC	Brazil: Printing exceptions for ICMS	10	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
239	OIH_J1B_PIS	Brazil: PIS/COFINS taxation table (exactly one entry)	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
240	OIH_J1B_PPR	Brazil Tax: Pondered average price table for final consume	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
241	OIH_J1B_RAF	Brazil: Refinery taxation table	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
242	OIH_J1B_SAL_2	Brazil: ICMS Deferment	13	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
243	OIH_J1B_ZFD	Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus	10	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
244	OIH_J_1BTXCI1	Tax calc.: Complement of ICMS rules	7	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
245	OIH_J_1BTXCI2	Tax calc.: Complement of ICMS rules INSIDE CALCULATION	10	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
246	OIH_J_1BTXIC2	Tax calc.: ICMS rules (exceptions)	8	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
247	OIH_J_1BTXIS1	Tax calc.: ISS rules for sales exeptions	7	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
248	OIH_J_1BTXIX1	Tax calc.: ISS rules for sales and purchasing exeptions	13	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
249	OIH_J_1BTXST1	Tax calc.: Sub.Trib. rules	10	VALIDTO	Date to which the tax rule is valid	nvarchar	8	0
TOPThird Party ManagementCOA
250	VIMMMN	Mandate	18	VALIDTO	Mandate Valid To	nvarchar	8	0
TOPTransaction Tax Engine
251	TTE2C_AGGREG	Country Specific Rule Assignments	3	VALIDTO	Valid To Date	nvarchar	8	0
252	TTE2C_CNTY_COMM	Country / Community Assignment	3	VALIDTO	Valid To Date	nvarchar	8	0
253	TTE2C_PROCED_DET	Tax Calculation Procedure Determination	4	VALIDTO	Valid To Date	nvarchar	8	0
254	TTEC_ACCUM_PER	Accumulation Period	4	VALIDTO	Valid To Date	nvarchar	8	0
255	TTEC_CURR	Tax Currencies per Country	4	VALIDTO	Valid To Date	nvarchar	8	0
256	TTEC_CURR_HDL	Tax Currency Handling	3	VALIDTO	Valid To Date	nvarchar	8	0
257	TTEC_CURR_HDL3	Tax Currency Handling	4	VALIDTO	Valid To Date	nvarchar	8	0
258	TTEC_DECTR_DET	Decision Tree Determination	4	VALIDTO	Valid To Date	nvarchar	8	0
259	TTEC_MAPACCVAL	Mapping Accumulated Values	5	VALIDTO	Valid To Date	nvarchar	8	0
260	TTEC_NEXUS	TTE: Nexus Data	5	VALIDTO	Valid To Date	nvarchar	8	0
261	TTEC_TAXBASECAL	Aggregation rules	5	VALIDTO	Valid To Date	nvarchar	8	0
262	TTEC_TAXCATAGGR	Aggregation rules	4	VALIDTO	Valid To Date	nvarchar	8	0
263	TTEC_TAXCATPAR	Tax Category Parameters	5	VALIDTO	Valid To Date	nvarchar	8	0
264	TTED_INEXEMP_COM	Exemptions	17	VALIDTO	Valid To	nvarchar	8	0
265	TTED_OEXEMP_COM	Output Exemptions	17	VALIDTO	Valid To	nvarchar	8	0
266	TTEPD3_EXEMP	Exemptions	17	VALIDTO	Valid To	nvarchar	8	0
267	TTEPDT_EXEMPT	Persistency TTE Document Output Exemptions	14	VALIDTO	Valid To	nvarchar	8	0
268	TTEPDT_EXEMPVALU	Persistency TTE Document Item Exemption Value	8	VALIDTO	Valid To	nvarchar	8	0
269	TTESDT_EXEMPT	Output Exemptions	14	VALIDTO	Valid To	nvarchar	8	0
270	TTESDT_EXEMPVALU	Document business partner exemption values for with. tax.	9	VALIDTO	Valid To	nvarchar	8	0
TOPUser Administration
271	BAPIUSW01	User ID Table for Internet Appplication Components	9	VALIDTO	User valid to	nvarchar	8	0
TOPWorkforce Management Core
272	WFDS_QUA_REQ	Qualification Requirements	5	VALIDTO	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

272 columns | ERP 6.0 | VALIDTO