SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

194 columns | Print definition?ERP 6.0  | KVEWE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000470T6855KVEWEnvarchar10
2/1CADMC/00000471T685T6KVEWEnvarchar10
3CNV_20305_CEPCSAP LT: Backup table of CEPC42KVEWECNV Usage of the condition tablenvarchar10
4CNV_20551_KNUMHCondition record numbers selected for deletion (Dom. KNUMB3KVEWEUsage of the condition tablenvarchar10
5FSH_CT_LISTFSH : Table for Determ.Procedure search help view3KVEWEFSH: Usage for Condition Technique [VASS]nvarchar20
6J_1BPISCOF_BASEDefinition of a configurable base for PIS / COFINS2KVEWEUsage of the condition tablenvarchar10
7T161NMessage Determination Schemas: Assignment2KVEWEUsage of the condition tablenvarchar10
8T672Conditions: View Sequence2KVEWEUsage of the condition tablenvarchar10
9T681UParameters for creating pricing reports1KVEWEUsage of the condition tablenvarchar10
10T681XCondition tables for lists1KVEWEUsage of the condition tablenvarchar10
11T681ZConditions: Dependent Data for Application/Usage1KVEWEUsage of the condition tablenvarchar10
12T682IAConditions: Access Sequences (Generated Form)1KVEWEUsage of the condition tablenvarchar10
13T682VConditions: Condition Type/Access (Execute Header Check)2KVEWEUsage of the condition tablenvarchar10
14T682VAConditions: Condition Type/Access (Execute Header Check)2KVEWEUsage of the condition tablenvarchar10
15T682ZAConditions: Access Sequences (Fields)1KVEWEUsage of the condition tablenvarchar10
16T683S_VARIANTProcessing Variant Definition of a Procedure (Pricing,...)2KVEWEUsage of the condition tablenvarchar10
17T684GCondition Exclusion Groups: Condition Types2KVEWEUsage of the condition tablenvarchar10
18T684SCondition Exclusion: Procedure Assignment2KVEWEUsage of the condition tablenvarchar10
19T688Condition: Copying Rules for Condition Tables2KVEWEUsage of the condition tablenvarchar10
20T688KCondition: Copying Rules for Condition Types2KVEWEUsage of the condition tablenvarchar10
21T688TCondition: Copying Rules for Condition Tables3KVEWEUsage of the condition tablenvarchar10
22TKALSM_VARIANTProcessing Variants of a Procedure (Pricing,...)2KVEWEUsage of the condition tablenvarchar10
23TKALSM_VARIANTTProcessing Variants of a Procedure (Pricing,...) Text2KVEWEUsage of the condition tablenvarchar10
24VFPRCC_QTY_REFAssign Adjusted Quantity and Adjustment Factor2KVEWEUsage of the condition tablenvarchar10
TOPActivity-Based Costing
25COTPLFCO-ABC Find Template4KVEWEUsage of the condition tablenvarchar10
TOPAdvertising Management
26TJH13IS-M/AM: Conversion of Condition Types2KVEWEUsage of the condition tablenvarchar10
27TJJ97IS-M/AM: Conditions Grouping2KVEWEUsage of the condition tablenvarchar10
28TJJ98IS-M/AM: Conditions Grouping - Texts3KVEWEUsage of the condition tablenvarchar10
29TJJ99IS-M/AM: Control Dynamic Condition Maintenance2KVEWEUsage of the condition tablenvarchar10
30TJJA7IS-M/AM: Dynamic Maintenance of Conditions2KVEWEUsage of the condition tablenvarchar10
31TJJA8IS-M/AM: Dynamic Maintenance of Conditions - Text3KVEWEUsage of the condition tablenvarchar10
32TJJA9IS-M/AM: Work Area for Conditions2KVEWEUsage of the condition tablenvarchar10
33TJJAAIS-M/AM: Work Area for Conditions - Texts3KVEWEUsage of the condition tablenvarchar10
TOPBasic Functions
34T180Screen Sequence Control: Transaction Default Values8KVEWEUsage of the condition tablenvarchar10
TOPBusiness Application Support
35CNVKONDITIONENConversion: Auxiliary table for fields of condition tables8KVEWEUsage of the condition tablenvarchar10
TOPCondition Technique
36/SAPCND/CONDINDXIndex for Condition Records (Reference Book)5KVEWEUsage for Condition Techniquenvarchar20
37/SAPCND/CTLISTDet. Procedure3KVEWEUsage for Condition Techniquenvarchar20
38/SAPCND/CTLISTIElements in Determ. Procedure3KVEWEUsage for Condition Techniquenvarchar20
39/SAPCND/CTLISTTTexts for Condition Type Lists3KVEWEUsage for Condition Techniquenvarchar20
40/SAPCND/GROUP_ICondtion Maintenance Definition5KVEWEUsage for Condition Techniquenvarchar20
41/SAPCND/R3COMPATR/3 Compatibility Settings3KVEWEUsage for Condition Techniquenvarchar20
42/SAPCND/REQUIRMImplementaion Number for Requirement2KVEWEUsage for Condition Techniquenvarchar20
43/SAPCND/REQUIRMTText Table - Implementation Number for Requirement2KVEWEUsage for Condition Techniquenvarchar20
44/SAPCND/S681Definition of a Condition Table for Transport3KVEWEUsage for Condition Techniquenvarchar20
45/SAPCND/T681Condition Table Structure2KVEWEUsage for Condition Techniquenvarchar20
46/SAPCND/T681ECondition Table Structure Field2KVEWEUsage for Condition Techniquenvarchar20
47/SAPCND/T681FVFields for Usage3KVEWEUsage for Condition Techniquenvarchar20
48/SAPCND/T681HControl Table for Archiving (Residence Times)3KVEWEUsage for Condition Techniquenvarchar20
49/SAPCND/T681MCondition Type - Cond. Change System3KVEWEUsage for Condition Techniquenvarchar20
50/SAPCND/T681TGeneratable Condition Tables - Texts2KVEWEUsage for Condition Techniquenvarchar20
51/SAPCND/T681VCondition Technique - Usage1KVEWEUsage for Condition Techniquenvarchar20
52/SAPCND/T681VLINVariable Part of Scale (LIN): Detail1KVEWEUsage for Condition Techniquenvarchar20
53/SAPCND/T681VSPossible Scale Basis per Application1KVEWEUsage for Condition Techniquenvarchar20
54/SAPCND/T681VSCLData Part of Scale: Fixed and Variable Part1KVEWEUsage for Condition Techniquenvarchar20
55/SAPCND/T681VSTTexts for Possible Scale Bases per Application1KVEWEUsage for Condition Techniquenvarchar20
56/SAPCND/T681VTConditions: Usage: Texts1KVEWEUsage for Condition Techniquenvarchar20
57/SAPCND/T681ZCondition Technique - Task2KVEWEUsage for Condition Techniquenvarchar20
58/SAPCND/T681ZSCondition technique - Signature for Task3KVEWEUsage for Condition Techniquenvarchar20
59/SAPCND/T681ZTCaller for Condition Technique2KVEWEUsage for Condition Techniquenvarchar20
60/SAPCND/T682Condition access sequence2KVEWEUsage for Condition Techniquenvarchar20
61/SAPCND/T682ICondition access2KVEWEUsage for Condition Techniquenvarchar20
62/SAPCND/T682TAccess Sequences - Texts2KVEWEUsage for Condition Techniquenvarchar20
63/SAPCND/T682VPermitted Combinations of Condition Types and Access Seq.3KVEWEUsage for Condition Techniquenvarchar20
64/SAPCND/T682ZCondition Access Characteristic2KVEWEUsage for Condition Techniquenvarchar20
65/SAPCND/T685Condition Types3KVEWEUsage for Condition Techniquenvarchar20
66/SAPCND/T685TCondition Types - Texts3KVEWEUsage for Condition Techniquenvarchar20
67/SAPCND/T688CFields from Condition Tables Sorted Acc. To Dependency2KVEWEUsage for Condition Techniquenvarchar20
68/SAPCND/T688FVPresorted Usage-Specific Fields According to Dependency1KVEWEUsage for Condition Techniquenvarchar20
69/SAPCND/UEAATTRelevant Formula Attributes(application specific assignment)2KVEWEUsage for Condition Techniquenvarchar20
70/SAPCND/UEAIMPUserexit Formula (application specific assignment)2KVEWEUsage for Condition Techniquenvarchar20
71/SAPCND/UELATTRelevant Attribute Names of a Userexit Formula1KVEWEUsage for Condition Techniquenvarchar20
72/SAPCND/UELATT_TDescriptions for Relevant Attributes of a Userexit Formula1KVEWEUsage for Condition Techniquenvarchar20
73/SAPCND/UELIMPDefinition of a Userexit Formula (Formula Library)1KVEWEUsage for Condition Techniquenvarchar20
74/SAPCND/UELIMP_TUserexit Formula Texts (Formula Library)1KVEWEUsage for Condition Techniquenvarchar20
75/SAPCND/UE_RANGEUserexit Formula Number Range2KVEWEUsage for Condition Techniquenvarchar20
76/SAPCND/UE_TYPUser Exit Types1KVEWEUsage for Condition Techniquenvarchar20
77/SAPCND/UE_TYP_TTexts for Userexit types1KVEWEUsage for Condition Techniquenvarchar20
TOPConditions
78CND_MAP_KNUMHConversion Table VARNUMH CRM <> KNUMH ... DATBI3KVEWEUsage of the condition tablenvarchar10
79CND_MEM_INF_UPLLock Table for Initial Load3KVEWEUsage of the condition tablenvarchar10
80CND_MEM_INITIALConditions: Buffer for Initial Upload2KVEWEUsage of the condition tablenvarchar10
81CND_TABNAM_USAGEUsage per TABNAME (in BAPIMTCS)2KVEWEUsage of the condition tablenvarchar10
82CND_USAGE_PREFIXPrefix for Every Usage1KVEWEUsage of the condition tablenvarchar10
83KONDINDGeneral Document Index for Conditions5KVEWEUsage of the condition tablenvarchar10
84KONDNConditions: Free goods - Data section15KVEWEUsage of the condition tablenvarchar10
85KONHConditions (Header)5KVEWEUsage of the condition tablenvarchar10
86LFMCVendor master (short texts for condition types)2KVEWEUsage of the condition tablenvarchar10
87T671Conditions: Views2KVEWEUsage of the condition tablenvarchar10
88T671TConditions: Views (Text)3KVEWEUsage of the condition tablenvarchar10
89T680MCondition: Tree Control: Features1KVEWEUsage of the condition tablenvarchar10
90T680MTCondition: Tree Control: Features: Texts?2KVEWEUsage of the condition tablenvarchar10
91T680NCondition: Tree Control: Nodes1KVEWEUsage of the condition tablenvarchar10
92T680NFCondition: Tree Control: Nodes: Fields1KVEWEUsage of the condition tablenvarchar10
93T680VCondition: Tree Control: Variants1KVEWEUsage of the condition tablenvarchar10
94T680VLCondition: Tree Control: Tree Variants1KVEWEUsage of the condition tablenvarchar10
95T680VTCondition: Tree Control: Variants: Texts2KVEWEUsage of the condition tablenvarchar10
96T680VUCondition: Tree Control: User-dependent Variants1KVEWEUsage of the condition tablenvarchar10
97T681Conditions: Structures1KVEWEUsage of the condition tablenvarchar10
98T681COMPCond.: Fig. (KVEWE, KAPPL) --> DF14L (Component Hierarchy)1KVEWEUsage of the condition tablenvarchar10
99T681DCondition: Tables used per Application1KVEWEUsage of the condition tablenvarchar10
100T681EConditions: Fast-Entry Fields1KVEWEUsage of the condition tablenvarchar10
101T681FConditions: Allowed Fields Per Usage and Application1KVEWEUsage of the condition tablenvarchar10
102T681HConditions: Usage/Application with Client2KVEWEUsage of the condition tablenvarchar10
103T681SConditions: Fast Entry Types1KVEWEUsage of the condition tablenvarchar10
104T681TConditions: Fast Entry: Texts2KVEWEUsage of the condition tablenvarchar10
105T681VConditions: Usages1KVEWEUsage of the condition tablenvarchar10
106T681WConditions: Usage: Texts2KVEWEUsage of the condition tablenvarchar10
107T681YConditions: List Variants1KVEWEUsage of the condition tablenvarchar10
108T681YFPricing Report: Fields Used1KVEWEUsage of the condition tablenvarchar10
109T681YTPricing Report: Texts2KVEWEUsage of the condition tablenvarchar10
110T682Conditions: Access Sequences1KVEWEUsage of the condition tablenvarchar10
111T682IConditions: Access Sequences (Generated Form)1KVEWEUsage of the condition tablenvarchar10
112T682TConditions: Access Sequences: Texts2KVEWEUsage of the condition tablenvarchar10
113T682ZConditions: Access Sequences (Fields)1KVEWEUsage of the condition tablenvarchar10
114T683Pricing procedures2KVEWEUsage of the condition tablenvarchar10
115T683SPricing Procedure: Data2KVEWEUsage of the condition tablenvarchar10
116T683TPricing Procedures: Texts3KVEWEUsage of the condition tablenvarchar10
117T683UConditions: Procedure (Text)3KVEWEUsage of the condition tablenvarchar10
118T685Conditions: Types2KVEWEUsage of the condition tablenvarchar10
119T685TConditions: Types: Texts3KVEWEUsage of the condition tablenvarchar10
TOPConstruction Equipment Management
120J_3GPRLHDCEM Price Lists Condition Header5KVEWEUsage of the condition tablenvarchar10
TOPControlling
121CSKSCost Center Master Data30KVEWEUsage of the condition tablenvarchar10
TOPCost Center Accounting
122TKRSTRTransport Resource Prices13KVEWEUsage of the condition tablenvarchar10
TOPCost Object
123TKKP1Cost Object ID Control: General Default Values7KVEWEUsage of the condition tablenvarchar10
TOPCross-Application Components
124AAUUFKOrder master data39KVEWEUsage of the condition tablenvarchar10
TOPData Collection
125S111Index: Subsequent Settlement5KVEWEUsage of the condition tablenvarchar10
126S111ES111 - Structure Information4KVEWEUsage of the condition tablenvarchar10
TOPIncentive and Commission Management ICM
127TCACS_SD01Parameter Condition Technique by Category (Application)7KVEWEUsage of the condition tablenvarchar10
TOPInventory Management
128WRMA_CONDAssign Meaning to Condition Types2KVEWEUsage of the condition tablenvarchar10
129WRMA_FI_CDDefine FI Update Condition Type2KVEWEUsage of the condition tablenvarchar10
130WRMA_LINKLinking of BI and ERP Condition Type2KVEWEUsage of the condition tablenvarchar10
TOPLocalization
131IDMX_VATMexico : Identifiable and Non-Identifiable VAT conditions2KVEWEUsage of the condition tablenvarchar10
132J_1BCBTAXPROCCalculation Procedures for Condition Based Tax Calculation2KVEWEUsage of the condition tablenvarchar10
133J_1BIM01MM-IM: Tax posting strings for inventory management3KVEWEUsage of the condition tablenvarchar10
134J_1BMMKON0MM: Value transfer from pricing to Nota Fiscal2KVEWEUsage of the condition tablenvarchar10
135J_1BNFLWCONDTax Law Conditions Interface for Notas Fiscais2KVEWEUsage of the condition tablenvarchar10
136J_1BNFTXCONDTax Condition Interface for Notas Fiscais2KVEWEUsage of the condition tablenvarchar10
137J_1BSDKON0SD: Value transfer from pricing to Nota Fiscal2KVEWEUsage of the condition tablenvarchar10
TOPLogistics - General
138CND_MAPC_FIL_UAFilter Table for Condition Usage and Application2KVEWEUsage of the condition tablenvarchar10
139CND_MAPC_PASS_UAFilter Table for Condition Usage, Application and Cond. Type3KVEWEUsage of the condition tablenvarchar10
140MNTCNTMaintenance Control in Distributed Systems2KVEWEUsage of the condition tablenvarchar10
TOPLogistics Execution
141/DSD/PE_KALSMPricing: Pricing Step Used Key2KVEWEUsage of the condition tablenvarchar10
142/DSD/PE_PROCEPricing: Sales Area dependant Pricing Procedure5KVEWEUsage of the condition tablenvarchar10
TOPOperative Structures
143PRPSWBS (Work Breakdown Structure) Element Master Data28KVEWEUsage of the condition tablenvarchar10
144TCJ41Default Values for Work Breakdown Structure17KVEWEUsage of the condition tablenvarchar10
TOPOutput Determination
145NACHDetailed output data5KVEWEUsage of the condition tablenvarchar10
TOPOverhead Cost Controlling
146COKLCO Object: Control Data for Activity Types33KVEWEUsage of the condition tablenvarchar10
147KONRResource Prices: Help Table for Variable Fields20KVEWEUsage of the condition tablenvarchar10
148KONR1Resource Prices: Help Table for Variable Fields20KVEWEUsage of the condition tablenvarchar10
TOPOverhead Cost Orders
149AUFKOrder master data39KVEWEUsage of the condition tablenvarchar10
150KONXOverhead Rates: Help Table for Variable Fields17KVEWEUsage of the condition tablenvarchar10
151KONX1Overhead Rates: Help Table for Variable Fields17KVEWEUsage of the condition tablenvarchar10
152TKZUTRTransport Overhead Records13KVEWEUsage of the condition tablenvarchar10
TOPPeriodical Sales and Distribution
153JLTPST1IS-M/SD: Header Data for Batch Input Postal Charges5KVEWEUsage of the condition tablenvarchar10
154TJ180Initial Values of Transaction in IS-M9KVEWEUsage of the condition tablenvarchar10
155TJY02IS-M/SD: Output Det.Proc.for Sys.Resubmission/Address Change2KVEWEUsage of the condition tablenvarchar10
156TJY03IS-M/SD: Application and Usage in IS-M1KVEWEUsage of the condition tablenvarchar10
157TJY04IS-M/SD: Dyn.Menu Entries for Master Data Maint.Cond.(Texts)2KVEWEUsage of the condition tablenvarchar10
158TJY05IS-M/SD: Dyn.Menu Entries for Master Data Maint.for Cond.2KVEWEUsage of the condition tablenvarchar10
159TJY06IS-M/SD: Text Table for Usage and Application2KVEWEUsage of the condition tablenvarchar10
160TJY17IS-M/SD: Condition Class for Usage and Application2KVEWEUsage of the condition tablenvarchar10
161TJY18IS-M/SD: Texts for Condition Class3KVEWEUsage of the condition tablenvarchar10
TOPPOS Interface
162TWPEKPOS outbound: Condition types5KVEWEUsage of the condition tablenvarchar10
TOPPosition Management
163KONHMPortfolio Determination - Data Part7KVEWEUsage of the condition tablenvarchar10
TOPPricing
164PRCC_COND_PPPricing Procedure Data (T683S)11KVEWEUsage for Condition Techniquenvarchar20
165PRCD_CONDPrice Condition - Item - Condition (KONV)10KVEWEUsage for Condition Techniquenvarchar20
166PRCD_HEADPrice Condition Set (Header)14KVEWEUsage for Condition Techniquenvarchar20
TOPPricing and Conditions
167T684Condition Exclusion Groups2KVEWEUsage of the condition tablenvarchar10
168T684TCondition exclusion: Texts3KVEWEUsage of the condition tablenvarchar10
169T689Download Profile for the Conditions1KVEWEUsage of the condition tablenvarchar10
170T689KReference: Download Profile - Pricing Procedures1KVEWEUsage of the condition tablenvarchar10
171T689TText Table for T6892KVEWEUsage of the condition tablenvarchar10
TOPProduct Cost by Period
172CKPHMaster Record: Cost Object ID Number23KVEWEUsage of the condition tablenvarchar10
TOPProfit Center Accounting
173CEPCProfit Center Master Data Table42KVEWEUsage of the condition tablenvarchar10
TOPPurchase Orders
174T6I1Document Index: Allowed Condition Types/Tables3KVEWEUsage of the condition tablenvarchar10
175WINDDocument Index: Conditions for Automatic Document Adjustment9KVEWEUsage of the condition tablenvarchar10
TOPPurchasing
176T161MFine-Tuned Control: Message Types2KVEWEUsage of the condition tablenvarchar10
TOPRecycling Administration Core Functions
177J_7LBDCMSGREA Conditions: Error Messages BDC Condition Adjustment21KVEWEUsage of the condition tablenvarchar10
178J_7LC09REA Customizing: General Controls3KVEWEUsage of the condition tablenvarchar10
179J_7LE01REA Partner Master Record: General Data (Country-Dependent)44KVEWEUsage of the condition tablenvarchar10
TOPRemaining Beverage - Obsolete Objects
180/BEV1/RPT685Permissible Terms of Delivery: Types for R/3 Beverage2KVEWEUsage of the condition tablenvarchar10
TOPRetail Pricing
181TWLFESales price calculation: schema/list field5KVEWEUsage of the condition tablenvarchar10
182TWVKSales Price Calculation: Allowed pricing levels3KVEWEUsage of the condition tablenvarchar10
183WELPCompetitor: Price Entry Document (Item)11KVEWEUsage of the condition tablenvarchar10
TOPSimulation
184VSAUFK_CNVersion: Order master data40KVEWEUsage of the condition tablenvarchar10
185VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data29KVEWEUsage of the condition tablenvarchar10
TOPSubsequent Settlement
186T6B5User Parameters Subsequent Settlement3KVEWEUsage of user groupnvarchar10
187TMUSERGUser Groups3KVEWEUsage of user groupnvarchar10
188TMUSERG1Assignment of Users to User Groups3KVEWEUsage of user groupnvarchar10
189TMUSERGTText for User Group4KVEWEUsage of user groupnvarchar10
TOPTaxes
190TTXFstatus transition diagram for tax document during pricing2KVEWEUsage of the condition tablenvarchar10
TOPTemplates
191PRPSSStandard WBS Element (WBS element) - Master Data28KVEWEUsage of the condition tablenvarchar10
TOPValuated Delivery Note
192/BEV1/VDT685Permissible Terms of Delivery: Types for R/3 Beverage2KVEWEUsage of the condition tablenvarchar10
TOPVisit Control
193/DSD/VC_MSGTYPDSD - Message Types for Print and Download Control2KVEWEUsage of the condition tablenvarchar10
TOPWarranties
194T790GWarranty Type8KVEWEUsage of the condition tablenvarchar10