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  | VBKA
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
Sales and Distribution :: Sales Support :: Sales Activities
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VBKA583Sales ActivitiesSales Activities
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, ERDAT, ERZET, ERNAM, AEDAT, AEZET, AENAM, KTAAR, VBTYP, TRVOG, VKORG, VTWEG, SPART, VKBUR, VKGRP, KTABG, KTAEN, KTABT, KTAET, KTAGR, KTAST, KTAER, KTAEB, KTARE, KTAVA, KTANR, KTAFK, KTADA, ADRNR, KTARA, VGBEL, KTEXT, SUBMI, VBKLA, VBKLT, KTA01, KTA02, KTA03, KTA04, KTA05, KTA06, KTA07, KTA08, KTA09, KTA10, KUNNR, GBSTK, JOBCOUNT, PARVW, TXT_KONSE, STAFO, STR_HAS_PRI, DIRECTION, KTAAR_CLASS, KALE, KTEXT_MC, KTEXT_MC_LANGU FROM VBKA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNSD document no. of a sales activity in sales supportnvarchar100CHAR(N' ')NoVBUKCAS_VBELN Allow NULL? 
3ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
4ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
5ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
6AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
7AEZETTime last change was madenvarchar60TIMS(N'000000')YesAEZET Allow NULL? 
8AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
9KTAARSales Activity Type for Sales Supportnvarchar40CHAR(N' ')YesTVKKKTAAR Allow NULL? 
10VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
11TRVOGTransaction groupchar10CHAR(N' ')YesTRVOG Allow NULL? 
12VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
13VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVKOVVTWEG Allow NULL? 
14SPARTDivisionnvarchar20CHAR(N' ')YesTVTASPART Allow NULL? 
15VKBURSales Officenvarchar40CHAR(N' ')YesTVKBZVKBUR Allow NULL? 
16VKGRPSales Groupnvarchar30CHAR(N' ')YesTVBVKVKGRP Allow NULL? 
17KTABGStart of sales activity (date)nvarchar80DATS(N'00000000')YesKTABG Allow NULL? 
18KTAENEnd of sales activity (date)nvarchar80DATS(N'00000000')YesKTAEN Allow NULL? 
19KTABTStart of sales activitynvarchar60TIMS(N'000000')YesKTABT Allow NULL? 
20KTAETEnd of sales activity (time)nvarchar60TIMS(N'000000')YesKTAET Allow NULL? 
21KTAGRReason for sales activitynvarchar30CHAR(N' ')YesTVC2KTAGR Allow NULL? 
22KTASTStatus of sales activitychar10CHAR(N' ')YesTVC3KTAST Allow NULL? 
23KTAEROutcome of sales activitiesnvarchar30CHAR(N' ')YesTVC1KTAER Allow NULL? 
24KTAEBAnalysis of sales activity outcomenvarchar30CHAR(N' ')YesTVC7KTAEB Allow NULL? 
25KTAREnot usednvarchar80CHAR(N' ')YesUNUSEDC8 Allow NULL? 
26KTAVAnot usednvarchar140CHAR(N' ')YesUNUSEDC14 Allow NULL? 
27KTANRNumber of the Address Listnvarchar100CHAR(N' ')YesKTANR Allow NULL? 
28KTAFKType of follow-up activitynvarchar40CHAR(N' ')YesTVKKKTAFK Allow NULL? 
29KTADADate of follow-up sales activitynvarchar80DATS(N'00000000')YesKTADA Allow NULL? 
30ADRNRAddresses: Address number of company addressnvarchar100CHAR(N' ')Yes*CADRNR Allow NULL? 
31KTARADescription of where sales activity took placenvarchar200CHAR(N' ')YesKTARA Allow NULL? 
32VGBELDocument number of the reference documentnvarchar100CHAR(N' ')YesVBUKVGBEL Allow NULL? 
33KTEXTShort text for a sales activitynvarchar400CHAR(N' ')YesKTEXT_CAS Allow NULL? 
34SUBMICollective Numbernvarchar100CHAR(N' ')YesSUBMI Allow NULL? 
35VBKLAOriginal system with release and transaction controlnvarchar90CHAR(N' ')YesVBKLA Allow NULL? 
36VBKLTSD document indicatorchar10CHAR(N' ')YesVBKLT Allow NULL? 
37KTA01Sales activity description 01nvarchar20CHAR(N' ')YesTVCAKTA01 Allow NULL? 
38KTA02Sales activity description 02nvarchar20CHAR(N' ')YesTVCBKTA02 Allow NULL? 
39KTA03Sales activity description 03nvarchar20CHAR(N' ')YesTVCCKTA03 Allow NULL? 
40KTA04Sales activity description 04nvarchar20CHAR(N' ')YesTVCDKTA04 Allow NULL? 
41KTA05Sales activity description 05nvarchar20CHAR(N' ')YesTVCEKTA05 Allow NULL? 
42KTA06Sales activity description 06nvarchar30CHAR(N' ')YesTVCFKTA06 Allow NULL? 
43KTA07Sales activity description 07nvarchar30CHAR(N' ')YesTVCGKTA07 Allow NULL? 
44KTA08Sales activity description 08nvarchar30CHAR(N' ')YesTVCHKTA08 Allow NULL? 
45KTA09Sales activity description 09nvarchar30CHAR(N' ')YesTVCIKTA09 Allow NULL? 
46KTA10Sales activity description 10nvarchar30CHAR(N' ')YesTVCJKTA10 Allow NULL? 
47KUNNRPartner number (KUNNR, LIFNR, or PERNR)nvarchar100CHAR(N' ')YesKUNDE_D Allow NULL? 
48GBSTKOverall processing status of documentchar10CHAR(N' ')YesGBSTK Allow NULL? 
49JOBCOUNTJob IDnvarchar80CHAR(N' ')YesBTCJOBCNT Allow NULL? 
50PARVWPartner Functionnvarchar20CHAR(N' ')YesTPARPARVW Allow NULL? 
51TXT_KONSEText entered in documentchar10CHAR(N' ')YesTXT_KONSE Allow NULL? 
52STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')Yes*STAFO Allow NULL? 
53STR_HAS_PRIFlag: Street has priority over PO boxchar10CHAR(N' ')YesAD_STRPRIO Allow NULL? 
54DIRECTIONDirection of sales activity: Inbound / outboundchar10CHAR(N' ')YesACT_DIRECTION Allow NULL? 
55KTAAR_CLASSCAS: Classify sales activity typeschar10CHAR(N' ')YesKTAAR_CLASS Allow NULL? 
56KALEMaintain appointments in calendarchar10CHAR(N' ')YesKALE Allow NULL? 
57KTEXT_MCShort Text for a Sales Activity in Uppercase Lettersnvarchar400CHAR(N' ')YesKTEXT_CAS_MC Allow NULL? 
58KTEXT_MC_LANGULanguage Key for Short Textchar10LANG(N' ')Yes*KTEXT_CAS_MC_LANG Allow NULL? 
NamePrimaryUniqueTypeColumns
VBKA~0YesYesCLUSTEREDMANDT, VBELN
VBKA~ANoNoNONCLUSTEREDMANDT, VKBUR, VKGRP, GBSTK
VBKA~BNoNoNONCLUSTEREDMANDT, KTEXT_MC

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