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
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 Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JKAPCC442Sales Order: Payment Card DataPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, CCACT, CCINS, CCNUM, CCFOL, DATAB, DATBI, CCNAME, CSOUR, AUTWR, CCWAE, SETTL, AUNUM, AUTRA, AUDAT, AUTIM, MERCH, LOCID, TRMID, CCBTC, CCTYP, CCARD_GUID, CCAUA, CCALL, REACT, AUTWV, CCOLD, CCVAL, CCPRE, UELTR_A, RCAVR, RCAVA, RCAVZ, RCRSP, RTEXT, XPAYMODE_SYNC, ISM_CVVAL, ISM_CVVCT, ISM_CVVST, ISM_RCCVV, CGUID, ENCTP FROM JKAPCC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNIS-M/SD: Publishing Sales Ordernvarchar100CHAR(N' ')NoJKAKAVNR Allow NULL? 
3POSNRSales Order Itemnvarchar60NUMC(N'000000')NoJKAPAPNR Allow NULL? 
4CCACTG/L Account Number for Payment Card Receivablesnvarchar100CHAR(N' ')YesSKA1CCACT Allow NULL? 
5CCINSPayment cards: Card typenvarchar40CHAR(N' ')YesTVCINCCINS Allow NULL? 
6CCNUMPayment cards: Card numbernvarchar250CHAR(N' ')Yes*CCNUM Allow NULL? 
7CCFOLPayment cards: Payment card suffixnvarchar100CHAR(N' ')YesCCFOL Allow NULL? 
8DATABPayment cards: Valid fromnvarchar80DATS(N'00000000')YesDATAB_CC Allow NULL? 
9DATBIPayment Cards: Valid Tonvarchar80DATS(N'00000000')YesDATBI_CC Allow NULL? 
10CCNAMEPayment cards: Name of cardholdernvarchar400CHAR(N' ')YesCCNAME Allow NULL? 
11CSOURPayment cards: Entry modechar10CHAR(N' ')YesCSOUR Allow NULL? 
12AUTWRPayment cards: Authorized amountdecimal152CURR((0))YesAUTWR
13CCWAECurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
14SETTLPayment cards: Settlement carried outchar10CHAR(N' ')YesSETTL Allow NULL? 
15AUNUMPayment cards: Authorization numbernvarchar100CHAR(N' ')YesAUNUM Allow NULL? 
16AUTRAPayment cards: Authoriz. reference code of clearing housenvarchar150CHAR(N' ')YesAUTRA Allow NULL? 
17AUDATPayment cards: Authorization datenvarchar80DATS(N'00000000')YesAUDAT_CC Allow NULL? 
18AUTIMPayment cards: Authorization timenvarchar60TIMS(N'000000')YesAUTIM Allow NULL? 
19MERCHPayment cards: Merchant ID at the clearing housenvarchar150CHAR(N' ')YesTCCMMERCH Allow NULL? 
20LOCIDPayment cards: Point of receipt for the transactionnvarchar100CHAR(N' ')YesTCCLLOCID_CC Allow NULL? 
21TRMIDPayment cards: Terminalnvarchar100CHAR(N' ')YesTRMID Allow NULL? 
22CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
23CCTYPPayment cards: Card categorynvarchar20CHAR(N' ')YesTVCTYCCTYP Allow NULL? 
24CCARD_GUIDReference to Encrypted Payment Card Datanvarchar320CHAR(N' ')YesCCARDEC_GUID Allow NULL? 
25CCAUAPayment cards: Authorization typechar10CHAR(N' ')YesCCAUA Allow NULL? 
26CCALLPayment cards: Status when external system is called?char10CHAR(N' ')YesCCALL Allow NULL? 
27REACTPayment cards: Response to authorization checkschar10CHAR(N' ')YesREACT_SD Allow NULL? 
28AUTWVPayment cards: Amount to be authorizeddecimal152CURR((0))YesAUTWV
29CCOLDPayment cards: Authorization has expiredchar10CHAR(N' ')YesCCOLD Allow NULL? 
30CCVALPayment cards: Amount changedchar10CHAR(N' ')YesCCVAL Allow NULL? 
31CCPREPayment cards: Preauthorizationchar10CHAR(N' ')YesCCPRE Allow NULL? 
32UELTR_AHigher-level authorization for billing plannvarchar60NUMC(N'000000')YesFPLTUELTR_A Allow NULL? 
33RCAVRPayment Cards: Result of Address Check (Address Result)nvarchar40CHAR(N' ')YesTCCRCRCAVR_CC Allow NULL? 
34RCAVAPayment Cards: Result of Address Check (Address Approval)nvarchar40CHAR(N' ')YesTCCRCRCAVA_CC Allow NULL? 
35RCAVZPayment Cards: Result of Address Check (ZIP Code Result)nvarchar40CHAR(N' ')YesTCCRCRCAVZ_CC Allow NULL? 
36RCRSPPayment cards: Result of card check (response code)nvarchar40CHAR(N' ')YesTCCRCRCRSP_CC Allow NULL? 
37RTEXTPayment cards: Result textnvarchar400CHAR(N' ')YesRTEXT_CC Allow NULL? 
38XPAYMODE_SYNCchar10(N' ')Yes Allow NULL? 
39ISM_CVVALCard Verification Valuenvarchar60CHAR(N' ')YesISM_CVVAL Allow NULL? 
40ISM_CVVCTControl Field for Card Verification Valuechar10CHAR(N' ')YesISM_CVVCT Allow NULL? 
41ISM_CVVSTUsage Status of Card Verification Valuechar10CHAR(N' ')YesISM_CVVST Allow NULL? 
42ISM_RCCVVResults Check for Card Verification Valuenvarchar40CHAR(N' ')YesTCCRCISM_RCCVV_CC Allow NULL? 
43CGUIDGUID of a Payment Cardvarbinary160RAWYesCARD_GUID
44ENCTPType of Encryptionchar10CHAR(N' ')YesCCSECA_ENCTYPE Allow NULL? 
NamePrimaryUniqueTypeColumns
JKAPCC~0YesYesCLUSTEREDPOSNR, VBELN, MANDT
JKAPCC~1NoNoNONCLUSTEREDDATBI