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

Home | ERP 6.0  | ESCHS
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: SAP Utilities :: Contract Billing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ESCHS511Billing Schema StepsContract Billing
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, SCHEMANR, SNO, LRATESTEP, TARIFNR, STEPINACT, BUCHREL, BETRSTREL, MENGESTREL, STGRAMT, STGRQNT, ERCHV_BW_REL, DISCON_FREE, PREISZUS, GROSSGROUP, GROSSPRICE, BRUTTOZEILE, TAXGROUP, LINE_CLASS, LINESORT1, LINESORT2, LINESORT3, LINESORT4, LINESORT5, BACKSTART, BACKONLY, BACKEXEC01, BACKEXEC02, BACKEXEC03, BACKEXEC04, BACKEXEC05, BACKCANC01, BACKCANC02, BACKCANC03, BACKCANC04, BACKCANC05, DYNSTART, DYNEXEC01, DYNEXEC02, DYNEXEC03, DYNEXEC04, DYNEXEC05, DYNCANC01, DYNCANC02, DYNCANC03, DYNCANC04, DYNCANC05, TIMESLICEGEN, BBINFOLINES, DELOPERAND, ADVCONTROL FROM ESCHS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SCHEMANRNumber of the billing schemanvarchar100CHAR(N' ')NoESCHSCHEMANR Allow NULL? 
3SNOSequence number of schema step in billing schemanvarchar40NUMC(N'0000')NoSNO Allow NULL? 
4LRATESTEPLogical Number of Rate Stepnvarchar100NUMC(N'0000000000')YesETRFVLRATESTEP Allow NULL? 
5TARIFNRRate keynvarchar100CHAR(N' ')YesETRFTARIFNR Allow NULL? 
6STEPINACTIndicator: schema step not activechar10CHAR(N' ')YesSTEPINACT Allow NULL? 
7BUCHRELBilling Line Item Relevant to Postingchar10CHAR(N' ')YesBUCHREL Allow NULL? 
8BETRSTRELAmount of billing line item is statistically relevantchar10CHAR(N' ')YesBETRSTREL Allow NULL? 
9MENGESTRELQuantity (billed value) is statistically relevantchar10CHAR(N' ')YesMENGESTREL Allow NULL? 
10STGRAMTAmount statistics groupnvarchar60CHAR(N' ')YesTE541STGRAMT Allow NULL? 
11STGRQNTQuantity statistics groupnvarchar60CHAR(N' ')YesTE540STGRQNT Allow NULL? 
12ERCHV_BW_RELNot Relevant for Consumption History in BWchar10CHAR(N' ')YesERCHV_BW_REL Allow NULL? 
13DISCON_FREEDisconnection Periods Not Valuatedchar10CHAR(N' ')YesDISCON_FREE Allow NULL? 
14PREISZUSIndicator: Price Summarynvarchar40CHAR(N' ')YesPREISZUS Allow NULL? 
15GROSSGROUPGross groupnvarchar40CHAR(N' ')YesGROSSGROUP Allow NULL? 
16GROSSPRICEGross Pricechar10CHAR(N' ')YesGROSSPRICE Allow NULL? 
17BRUTTOZEILEBlling line item is a gross line itemchar10CHAR(N' ')YesBRUTTOZEILE Allow NULL? 
18TAXGROUPCategorize Amounts for Tax Determinationnvarchar40CHAR(N' ')YesTAXGROUP Allow NULL? 
19LINE_CLASSClassification Criteria for Billing Linenvarchar40CHAR(N' ')YesTE552LINE_CLASS Allow NULL? 
20LINESORT1Presorting of billing line items in billing schemanvarchar40CHAR(N' ')YesTE530LINESORT1 Allow NULL? 
21LINESORT2Presorting of billing line items in billing schemanvarchar40CHAR(N' ')YesTE530LINESORT2 Allow NULL? 
22LINESORT3Presorting of billing line items in billing schemanvarchar40CHAR(N' ')YesTE530LINESORT3 Allow NULL? 
23LINESORT4Presorting of billing line items in billing schemanvarchar40CHAR(N' ')YesTE530LINESORT4 Allow NULL? 
24LINESORT5Presorting of billing line items in billing schemanvarchar40CHAR(N' ')YesTE530LINESORT5 Allow NULL? 
25BACKSTARTIndicator: execute backbillingnvarchar40CHAR(N' ')YesTE301BACKSTART Allow NULL? 
26BACKONLYIndicator: execute schema step for backbilling onlychar10CHAR(N' ')YesBACKONLY Allow NULL? 
27BACKEXEC01Indicator: Allocate Backbillingnvarchar40CHAR(N' ')YesTE301BACKEXEC01 Allow NULL? 
28BACKEXEC02Indicator: allocate backbillingnvarchar40CHAR(N' ')YesTE301BACKEXEC02 Allow NULL? 
29BACKEXEC03Indicator: allocate backbillingnvarchar40CHAR(N' ')YesTE301BACKEXEC03 Allow NULL? 
30BACKEXEC04Indicator: allocate backbillingnvarchar40CHAR(N' ')YesTE301BACKEXEC04 Allow NULL? 
31BACKEXEC05Indicator: allocate backbillingnvarchar40CHAR(N' ')YesTE301BACKEXEC05 Allow NULL? 
32BACKCANC01Indicator: reverse backbillingnvarchar40CHAR(N' ')YesTE301BACKCANC01 Allow NULL? 
33BACKCANC02Indicator: reverse backbillingnvarchar40CHAR(N' ')YesTE301BACKCANC02 Allow NULL? 
34BACKCANC03Indicator: reverse backbillingnvarchar40CHAR(N' ')YesTE301BACKCANC03 Allow NULL? 
35BACKCANC04Indicator: reverse backbillingnvarchar40CHAR(N' ')YesTE301BACKCANC04 Allow NULL? 
36BACKCANC05Indicator: reverse backbillingnvarchar40CHAR(N' ')YesTE301BACKCANC05 Allow NULL? 
37DYNSTARTExecute dynamic period controlnvarchar40CHAR(N' ')YesTE659DYNSTART Allow NULL? 
38DYNEXEC01Schema step for execution in dynamic period control 1nvarchar40CHAR(N' ')YesTE659DYNEXEC01 Allow NULL? 
39DYNEXEC02Schema step for execution in dyn. period control 2nvarchar40CHAR(N' ')YesTE659DYNEXEC02 Allow NULL? 
40DYNEXEC03Schema step for execution in dyn. period control 3nvarchar40CHAR(N' ')YesTE659DYNEXEC03 Allow NULL? 
41DYNEXEC04Schema step for execution in dyn. period control 4nvarchar40CHAR(N' ')YesTE659DYNEXEC04 Allow NULL? 
42DYNEXEC05Schema step for execution in dyn. period control 5nvarchar40CHAR(N' ')YesTE659DYNEXEC05 Allow NULL? 
43DYNCANC01Schema steps for reversal in dynamic period control 1nvarchar40CHAR(N' ')YesTE659DYNCANC01 Allow NULL? 
44DYNCANC02Reversal indicator, dynamic period control 2nvarchar40CHAR(N' ')YesTE659DYNCANC02 Allow NULL? 
45DYNCANC03Reversal indicator, dynamic period control 3nvarchar40CHAR(N' ')YesTE659DYNCANC03 Allow NULL? 
46DYNCANC04Reversal Indicator, Dynamic Period Control 4nvarchar40CHAR(N' ')YesTE659DYNCANC04 Allow NULL? 
47DYNCANC05Reversal indicator, dynamic period control 5nvarchar40CHAR(N' ')YesTE659DYNCANC05 Allow NULL? 
48TIMESLICEGENTime slice generatornvarchar40CHAR(N' ')YesTE543TIMESLICEGEN Allow NULL? 
49BBINFOLINESWrite Info Lines for Backbillingchar10CHAR(N' ')YesBBINFOLINES Allow NULL? 
50DELOPERANDDeletion operandnvarchar100CHAR(N' ')YesTE221DELOPERAND Allow NULL? 
51ADVCONTROLControl of Advance Billingchar10CHAR(N' ')YesADVCONTROL Allow NULL? 
NamePrimaryUniqueTypeColumns
ESCHS~0YesYesCLUSTEREDSNO, SCHEMANR, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy