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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2LAUFDDate IDnvarchar80 Allow NULL? 
3LAUFIRun ID for Transferring Electronic Acct Statement to FI-CAnvarchar60 Allow NULL? 
4STATStatus of transfer run of an electronic account statementchar10 Allow NULL? 
5XPROCNORMAcct statement transfer processing mode: Normal runchar10 Allow NULL? 
6XPROCRESTProcessing Mode Account Statement Transfer: Restartchar10 Allow NULL? 
7XPROCERRProcessing Mode Acct Statement Transfer: Error Processingchar10 Allow NULL? 
8KUKEYBSKey of the Acct Statement Transferred to FI-CAnvarchar80 Allow NULL? 
9ESNUMBSKey of Account Statement Item Transferred to FI-CAnvarchar50 Allow NULL? 
10KEYZ1Last Payment Lot to Which Data was Transferred (Restart)nvarchar120 Allow NULL? 
11PLPOSFINLast payment lot itemint100 Allow NULL? 
12PLERRNumber of Errors in Payment Lot Transferint100 Allow NULL? 
13KEYR1Returns Lot to Which Data From Acct Statement is Transferrednvarchar120 Allow NULL? 
14RLPOSFINLast Returns Lot Itemint100 Allow NULL? 
15RLERRNumber of errors during returns lot transferint100 Allow NULL? 
16XCREACreate Payment Lot Directly (Transfer from Memory)char10 Allow NULL? 
17XCLOSClose Payment Lotchar10 Allow NULL? 
18XBUCHPost Payment Lotchar10 Allow NULL? 
19XFILCreation of transfer file for payment lotchar10 Allow NULL? 
20APPLKApplication areachar10 Allow NULL? 
21UNAMEUser Namenvarchar120 Allow NULL? 
22DATUMDatenvarchar80 Allow NULL? 
23UZEITTimenvarchar60 Allow NULL? 
24PLFNAMFile name (payment lot transfer)nvarchar2500 Allow NULL? 
25RLFNAMFile name (returns lot transfer)nvarchar2500 Allow NULL? 
26PLKEYName of Payment Lot to be Creatednvarchar120 Allow NULL? 
27RLKEYName of Returns Lot to be Creatednvarchar120 Allow NULL? 
28XNOSPLITAcct Statement Transfer: Do Not Split "Payment/Returns Lot"char10 Allow NULL? 
29XSPLITAcct Statement Transfer: "Split Payment/Returns Lot"char10 Allow NULL? 
30BLKSIZEAcct Statement Transfer: Maximum Lot Size for Distributionnvarchar60 Allow NULL? 
31XPROCCOMPLAll Data Files Read For Transferchar10 Allow NULL? 
32APPLBSTransfer Account Statement/MultiCash File to FI-CA: Applictnnvarchar20 Allow NULL? 
33AUSZFNAMStatement filenvarchar1280 Allow NULL? 
34UMSFNAMLine item filenvarchar1280 Allow NULL? 
35XWSUPLDPC Uploadchar10 Allow NULL? 
36SKIP_CNTAccount Statement Transfer: No. of Acct Statements Skippedint100 Allow NULL? 
37LOTKEYID of Keynvarchar80 Allow NULL? 
38KEYZ1_POLast Payment Lot to Which Data was Transferred (Restart)nvarchar120 Allow NULL? 
39POPOSFINLast Payment Order Itemint100 Allow NULL? 
40POERRNumber of Erros during Transfer of Payment Order Lotsint100 Allow NULL? 
41POFNAMTransfer Account Statement: Name of Output File for Pymt/Retnvarchar1280 Allow NULL? 
42FIKEY_CHLast Reconciliation Key for Check Encashments (Restart)nvarchar120 Allow NULL? 
43CHPOSFINLast Check Item Cashedint100 Allow NULL? 
44CHERRNumber of Errors on Transferring Check Encashmentsint100 Allow NULL? 
45CHFNAMTransfer Account Statement: Name of Output File for Pymt/Retnvarchar1280 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