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  | TVFSCB
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Logistics Execution :: Transportation :: Freight Processing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TVFSCB571Scale BasesFreight Processing
SQL:  selectupdate insert create

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

SELECT KAPPL, SCABAS, TABNAME, ASS_FIELD, REF_FIELD, REF_TAB, COMMSTR, FLDNAME1, UNITNAME1, FLDNAME2, UNITNAME2, FLDNAME3, UNITNAME3, VARLEN, BEZGR, UEXFLG, VFSCBF, VFCTYF, USE_FLAG, UNIT_CHECK, DIMID, TAB_CONTROL, SCR_PROG, SCR_NR, SCTEXT, SCSORT, RNDRL_CHECK, INTGEN, CATYP_0, CATYP_1, CATYP_2, CATYP_3, CATYP_4, SCATYP_0, SCATYP_1, SCATYP_2, SCATYP_3, SCATYP_4, SCATYP_5, SCATYP_6, SCATYP_7, SCATYP_8, SCATYP_9, BERGL_0, BERGL_1, BERGL_2, BERGL_3, BERGL_4, BERGL_5, BERGL_6, BERGL_7, BERGL_8, BERGL_9, PROG_MAINT, FORM_MAINT, PROG_COND, FORM_COND FROM TVFSCB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1KAPPLApplicationnvarchar20CHAR(N' ')NoT681AKAPPL Allow NULL? 
2SCABASScale basisnvarchar20CHAR(N' ')NoTVFRFQREFQUAN Allow NULL? 
3TABNAMETable Name (Database) for Scale Itemsnvarchar300CHAR(N' ')Yes*SB_TABNAME Allow NULL? 
4ASS_FIELDInternal field assignment of scale basis re: struct VFSCAIYYnvarchar300CHAR(N' ')Yes*SB_ASSIGN_FIELD Allow NULL? 
5REF_FIELDReference field name for F1 or F4 help for scale basisnvarchar300CHAR(N' ')Yes*SB_REF_FIELD Allow NULL? 
6REF_TABReference table for F1 and F4 help for scale basisnvarchar300CHAR(N' ')Yes*SB_REF_TAB Allow NULL? 
7COMMSTRRef. to communication structurechar10CHAR(N' ')YesCT_COMMSTR Allow NULL? 
8FLDNAME1Reference field 1 for scale or for calculation typenvarchar300CHAR(N' ')Yes*CT_FLDNAME Allow NULL? 
9UNITNAME1Name of unit-of-measure field for reference field 1nvarchar300CHAR(N' ')Yes*CT_FLDNAME_UNIT Allow NULL? 
10FLDNAME2Reference field 2 for scale or for calculation typenvarchar300CHAR(N' ')Yes*CT_FLDNAME2 Allow NULL? 
11UNITNAME2Name of unit-of-measure field for reference field 2nvarchar300CHAR(N' ')Yes*CT_FLDNAME_UNIT2 Allow NULL? 
12FLDNAME3Reference field for calculation using EXIT routinesnvarchar300CHAR(N' ')Yes*CT_FLDNAME3 Allow NULL? 
13UNITNAME3Name of unit-of-measure field for reference field (EXIT)nvarchar300CHAR(N' ')Yes*CT_FLDNAME_UNIT3 Allow NULL? 
14VARLENIndicator for variable input length for scale valueschar10CHAR(N' ')YesSB_LENMOD Allow NULL? 
15BEZGRScale basis corresponding to standard pricing (KZBZG)char10CHAR(N' ')YesVF_KZBZG Allow NULL? 
16UEXFLGIndicator for handling user exitschar10CHAR(N' ')YesVFUEXFLG Allow NULL? 
17VFSCBFFormula for scale base valuenvarchar30NUMC(N'000')YesVFSCBF Allow NULL? 
18VFCTYFCondition formula for condition base valuenvarchar30NUMC(N'000')YesVFCTYF Allow NULL? 
19USE_FLAGIndicator for usage as calculation typechar10CHAR(N' ')YesSB_KRECH Allow NULL? 
20UNIT_CHECKCheck unit of measure for a scale basischar10CHAR(N' ')YesSB_UNITCHECK Allow NULL? 
21DIMIDDimension keynvarchar60CHAR(N' ')YesT006DDIMID Allow NULL? 
22TAB_CONTROLName of the scale items controlnvarchar300CHAR(N' ')Yes*SB_CONTROL Allow NULL? 
23SCR_PROGProgram for scale item screennvarchar400CHAR(N' ')YesSB_PROGNAME Allow NULL? 
24SCR_NRNumber of screen for scale itemsnvarchar40CHAR(N' ')YesSB_DYNNR Allow NULL? 
25SCTEXTIndicator for usage of texts for scale valueschar10CHAR(N' ')YesSCTEXT Allow NULL? 
26SCSORTIndicator for sorting a scalechar10CHAR(N' ')YesSCSORT Allow NULL? 
27RNDRL_CHECKIndicator rounding rule allowedchar10CHAR(N' ')YesSB_RNDRL Allow NULL? 
28INTGENIndicator for generating scale valueschar10CHAR(N' ')YesSB_INTG Allow NULL? 
29CATYP_0Calculation Typechar10CHAR(N' ')YesCATYP Allow NULL? 
30CATYP_1Calculation Typechar10CHAR(N' ')YesCATYP Allow NULL? 
31CATYP_2Calculation Typechar10CHAR(N' ')YesCATYP Allow NULL? 
32CATYP_3Calculation Typechar10CHAR(N' ')YesCATYP Allow NULL? 
33CATYP_4Calculation Typechar10CHAR(N' ')YesCATYP Allow NULL? 
34SCATYP_0Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
35SCATYP_1Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
36SCATYP_2Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
37SCATYP_3Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
38SCATYP_4Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
39SCATYP_5Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
40SCATYP_6Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
41SCATYP_7Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
42SCATYP_8Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
43SCATYP_9Scale typechar10CHAR(N' ')YesSCATYP Allow NULL? 
44BERGL_0Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
45BERGL_1Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
46BERGL_2Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
47BERGL_3Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
48BERGL_4Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
49BERGL_5Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
50BERGL_6Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
51BERGL_7Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
52BERGL_8Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
53BERGL_9Calculation Basechar10CHAR(N' ')YesBERGL Allow NULL? 
54PROG_MAINTProgram name for scale checksnvarchar400CHAR(N' ')YesSB_CHECK_PROG Allow NULL? 
55FORM_MAINTForm name for scale checksnvarchar300CHAR(N' ')YesSB_CHECK_FORM Allow NULL? 
56PROG_CONDProgram name for scale checksnvarchar400CHAR(N' ')YesSB_CHECK_PROG Allow NULL? 
57FORM_CONDForm name for scale checksnvarchar300CHAR(N' ')YesSB_CHECK_FORM Allow NULL? 
NamePrimaryUniqueTypeColumns
TVFSCB~0YesYesCLUSTEREDKAPPL, SCABAS

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