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

46 columns | Print definition?ERP 6.0  | OPERAND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSSCR_CONDScrambling Condition Sets11OPERANDABAP: Selection option (EQ/BT/CP/...)nvarchar20
2CNV_20551_TSTRU2Intransparent fields: Condition for structure description5OPERANDDistinguishing characteristic / stringnvarchar200
3CNV_INTR_FLD_STPIntransparent fields: Condition for structure description5OPERANDDistinguishing characteristic / stringnvarchar200
4TNWCH_ADDCHARGELeistungsregel: Altersprüfung bei Zusatzentgelten11OPERANDIS-H CH: Operandnvarchar20
5T7PIQRLKEYFNOMVAKey Figure to Subrequirement Assignments4OPERANDRelational Operand for a Subrequirementnvarchar20
6T7PIQRLNOMVALAssign Subrequirements to Performance Indices4OPERANDRelational Operand for a Subrequirementnvarchar20
TOPBilling in Contract Accounts Receivable and Payable
7DFKKBIBILLACC_FHBilling Account Facts Header3OPERANDOperandnvarchar100
8TFK8009Operands of Billing Rate Items7OPERANDOperandnvarchar100
9TFK8015Operands2OPERANDOperandnvarchar100
10TFK8015TText Table for TFK80153OPERANDOperandnvarchar100
11TFK8030AOperands / Facts for Demand-Driven Billing2OPERANDOperandnvarchar100
12TFK8041Allocation of Billing Fact Check to Operand2OPERANDOperandnvarchar100
13TFK8042Select Operand for Fact Changes2OPERANDOperandnvarchar100
TOPBRFplus - ABAP-Based Business Rules
14FDT_EXPR_1302FDT: Expression - Boolean Logic (user defined)6OPERANDFDT: Universal Unique Identifiernvarchar320
15FDT_EXPR_1302AFDT: Expression - Boolean Logic (user defined)6OPERANDFDT: Universal Unique Identifiernvarchar320
16FDT_EXPR_1302SFDT: Expression - Boolean Logic (user defined)5OPERANDFDT: Universal Unique Identifiernvarchar320
17FDT_EXPR_1302TFDT: Expression - Boolean Logic (user defined)5OPERANDFDT: Universal Unique Identifiernvarchar320
TOPContract Billing
18DBERCHVConsumption History16OPERANDOperandnvarchar100
19EBASLOperation Type for Lighting Unit3OPERANDOperandnvarchar100
20EKDIRate Facts4OPERANDOperandnvarchar100
21ESOHZGSpecial Agreemts for Heating Installtn3OPERANDOperandnvarchar100
22ETRFRate (Head. Data)5OPERANDRegister operand in ratenvarchar100
23ETTAFRate Cat.Facts3OPERANDOperandnvarchar100
24ETTIFInstln Facts3OPERANDOperandnvarchar100
25ETTIFBInstallation Facts (Reference Values)3OPERANDOperandnvarchar100
26ETTIFNInstallation Facts (Normal)3OPERANDOperandnvarchar100
27KJCCSJ3DBI03Naming Convention for Operands for Installed Demand2OPERANDOperand for Installed Demandnvarchar100
28KJCCSJ3DBI03TNaming Convention for Operands for Installed Demand3OPERANDOperand for Installed Demandnvarchar100
29TE221Operands2OPERANDOperandnvarchar100
30TE221TOperands (Texts)3OPERANDOperandnvarchar100
31TEOPERFIELDAllocation Operand for Billing-Relevant Field2OPERANDOperandnvarchar100
32TEOPOUUse of Outline Contract Operands3OPERANDOperandnvarchar100
TOPEnergy Data Management
33EEDMPROFOPROLEOperand - Profile Role Allocation2OPERANDOperandnvarchar100
TOPMaster Data
34EVSTAlloc. of ARCR to Ref. Val.3OPERANDOperandnvarchar100
TOPRemaining Beverage - Obsolete Objects
35/BEV3/CHRGBTRGAmount Rule11OPERANDOperands ( =, <, >, <=, >= )nvarchar20
36/BEV3/CHRGDATUMPeriod Group Rule10OPERANDOperands ( =, <, >, <=, >= )nvarchar20
37/BEV3/CHRGKUNNRCustomer No. Rule10OPERANDOperands ( =, <, >, <=, >= )nvarchar20
38/BEV3/CHRGMNGEQuantity Rule11OPERANDOperands ( =, <, >, <=, >= )nvarchar20
39/BEV3/CHRGPRZNTPercent Rule10OPERANDOperands ( =, <, >, <=, >= )nvarchar20
40/BEV3/CHRGXXXXRule XXXX10OPERANDOperands ( =, <, >, <=, >= )nvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
41NTPKCH_AGEIS-H CH: Zuordng Leistungsstamm Schweiz (TARMED) => Alter5OPERANDIS-H CH: operandonvarchar20
TOPSAP Utilities
42TECONTYPConcession Type4OPERANDOperandnvarchar100
TOPStatistics
43EMDSTTSOPNotes for Future Changes to Stock Statistics4OPERANDOperandnvarchar100
44EMDSTTSOPLNotes for Future Changes to Stock Statistics4OPERANDOperandnvarchar100
TOPWaste Management
45EWAOBJHeader Data for Service Frequency6OPERANDOperandnvarchar100
46EWAOBJH_AAT_HISTHistory and Valution of WBCs for Service Freq. Service8OPERANDOperandnvarchar100