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  | FKKBSTMV
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
Financial Accounting :: Contract Accounts Receivable and Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FKKBSTMV452Acct Statement Transfer: Admin. RecordsContract Accounts Receivable and Payable
SQL:  selectupdate insert create

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

SELECT MANDT, LAUFD, LAUFI, STAT, XPROCNORM, XPROCREST, XPROCERR, KUKEYBS, ESNUMBS, KEYZ1, PLPOSFIN, PLERR, KEYR1, RLPOSFIN, RLERR, XCREA, XCLOS, XBUCH, XFIL, APPLK, UNAME, DATUM, UZEIT, PLFNAM, RLFNAM, PLKEY, RLKEY, XNOSPLIT, XSPLIT, BLKSIZE, XPROCCOMPL, APPLBS, AUSZFNAM, UMSFNAM, XWSUPLD, SKIP_CNT, LOTKEY, KEYZ1_PO, POPOSFIN, POERR, POFNAM, FIKEY_CH, CHPOSFIN, CHERR, CHFNAM FROM FKKBSTMV
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2LAUFDDate IDnvarchar80DATS(N'00000000')NoLAUFD_KK Allow NULL? 
3LAUFIRun ID for Transferring Electronic Acct Statement to FI-CAnvarchar60CHAR(N' ')NoRUNIDBS_KK Allow NULL? 
4STATStatus of transfer run of an electronic account statementchar10CHAR(N' ')YesSTATBS_KK Allow NULL? 
5XPROCNORMAcct statement transfer processing mode: Normal runchar10CHAR(N' ')YesXNORMBS_KK Allow NULL? 
6XPROCRESTProcessing Mode Account Statement Transfer: Restartchar10CHAR(N' ')YesXRESTBS_KK Allow NULL? 
7XPROCERRProcessing Mode Acct Statement Transfer: Error Processingchar10CHAR(N' ')YesXERRBS_KK Allow NULL? 
8KUKEYBSKey of the Acct Statement Transferred to FI-CAnvarchar80NUMC(N'00000000')YesKUKEYBS_KK Allow NULL? 
9ESNUMBSKey of Account Statement Item Transferred to FI-CAnvarchar50NUMC(N'00000')YesESNUMBS_KK Allow NULL? 
10KEYZ1Last Payment Lot to Which Data was Transferred (Restart)nvarchar120CHAR(N' ')YesKEYZ1BS_KK Allow NULL? 
11PLPOSFINLast payment lot itemint100INT4((0))YesPFIN_KK Allow NULL? 
12PLERRNumber of Errors in Payment Lot Transferint100INT4((0))YesERRZE_KK Allow NULL? 
13KEYR1Returns Lot to Which Data From Acct Statement is Transferrednvarchar120CHAR(N' ')YesKEYR1BS_KK Allow NULL? 
14RLPOSFINLast Returns Lot Itemint100INT4((0))YesPFINRL_KK Allow NULL? 
15RLERRNumber of errors during returns lot transferint100INT4((0))YesERRRL_KK Allow NULL? 
16XCREACreate Payment Lot Directly (Transfer from Memory)char10CHAR(N' ')YesXCREAZE_KK Allow NULL? 
17XCLOSClose Payment Lotchar10CHAR(N' ')YesXCLOSZE_KK Allow NULL? 
18XBUCHPost Payment Lotchar10CHAR(N' ')YesXBUCHZE_KK Allow NULL? 
19XFILCreation of transfer file for payment lotchar10CHAR(N' ')YesXCRFILZE_KK Allow NULL? 
20APPLKApplication areachar10CHAR(N' ')YesAPPLK_KK Allow NULL? 
21UNAMEUser Namenvarchar120CHAR(N' ')YesUNAME Allow NULL? 
22DATUMDatenvarchar80DATS(N'00000000')YesDATUMW Allow NULL? 
23UZEITTimenvarchar60TIMS(N'000000')YesUZEIT Allow NULL? 
24PLFNAMFile name (payment lot transfer)nvarchar2500CHAR(N' ')YesFNAMEZE_KK Allow NULL? 
25RLFNAMFile name (returns lot transfer)nvarchar2500CHAR(N' ')YesFNAMERL_KK Allow NULL? 
26PLKEYName of Payment Lot to be Creatednvarchar120CHAR(N' ')YesPLKEYBS_KK Allow NULL? 
27RLKEYName of Returns Lot to be Creatednvarchar120CHAR(N' ')YesRLKEYBS_KK Allow NULL? 
28XNOSPLITAcct Statement Transfer: Do Not Split "Payment/Returns Lot"char10CHAR(N' ')YesXNOSPLITBS_KK Allow NULL? 
29XSPLITAcct Statement Transfer: "Split Payment/Returns Lot"char10CHAR(N' ')YesXSPLITBS_KK Allow NULL? 
30BLKSIZEAcct Statement Transfer: Maximum Lot Size for Distributionnvarchar60NUMC(N'000000')YesBLKSIZEBS_KK Allow NULL? 
31XPROCCOMPLAll Data Files Read For Transferchar10CHAR(N' ')YesXPROCCOMPL_KK Allow NULL? 
32APPLBSTransfer Account Statement/MultiCash File to FI-CA: Applictnnvarchar20CHAR(N' ')YesAPPLBS_KK Allow NULL? 
33AUSZFNAMStatement filenvarchar1280CHAR(N' ')YesFEBAUSZF Allow NULL? 
34UMSFNAMLine item filenvarchar1280CHAR(N' ')YesFEBUMSF Allow NULL? 
35XWSUPLDPC Uploadchar10CHAR(N' ')YesFEBPCUPLD Allow NULL? 
36SKIP_CNTAccount Statement Transfer: No. of Acct Statements Skippedint100INT4((0))YesSKIPCNTBS_KK Allow NULL? 
37LOTKEYID of Keynvarchar80CHAR(N' ')YesUNIKEYBS_KK Allow NULL? 
38KEYZ1_POLast Payment Lot to Which Data was Transferred (Restart)nvarchar120CHAR(N' ')YesKEYZ1BS_KK Allow NULL? 
39POPOSFINLast Payment Order Itemint100INT4((0))YesPOFIN_KK Allow NULL? 
40POERRNumber of Erros during Transfer of Payment Order Lotsint100INT4((0))YesERRPO_KK Allow NULL? 
41POFNAMTransfer Account Statement: Name of Output File for Pymt/Retnvarchar1280CHAR(N' ')YesFNAMEBS_KK Allow NULL? 
42FIKEY_CHLast Reconciliation Key for Check Encashments (Restart)nvarchar120CHAR(N' ')Yes*FIKEYCHBS_KK Allow NULL? 
43CHPOSFINLast Check Item Cashedint100INT4((0))YesCHFIN_KK Allow NULL? 
44CHERRNumber of Errors on Transferring Check Encashmentsint100INT4((0))YesERRCH_KK Allow NULL? 
45CHFNAMTransfer Account Statement: Name of Output File for Pymt/Retnvarchar1280CHAR(N' ')YesFNAMEBS_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
FKKBSTMV~0YesYesCLUSTEREDLAUFI, LAUFD, MANDT
FKKBSTMV~BSTNoNoNONCLUSTEREDKUKEYBS, 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