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  | FKKMAKO
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Contract Accounts Receivable and Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FKKMAKO735Dunning History HeaderContract 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, GPART, VKONT, MAZAE, AUSDT, MDRKD, MAHNV, MGRUP, VKONTGRP, VTREFGRP, ITEMGRP, ITEMGRP_LAST, GRPFIELD, GRPFIELD_LAST, STRAT, STEP, STEP_LAST, STEP_REPLACED, STRAT_CHAMP, TESTS, LIMITED, RELEA, RELDATE, RELGROUP, NEXDT, OPBUK, STDBK, GSBER, SPART, VTREF, SUBAP, VKNT1, ABWMA, MAHNS, MSTYP, WAERS, MSALM, MSALH, RSALM, CHGID, MGE1M, MG1BL, MG1TY, POST1, MGE2M, MG2BL, MG2TY, POST2, MGE3M, MG3BL, MG3TY, POST3, MINTM, MIBEL, BONIT, XMSTO, NRZAS, XINFO, FRDAT, COKEY, XCOLL, RFZAS, TODAT, STAKZ, CHECKBOX, SUCPC, ABWTP, ABWBL, STUDT, SUCDT, SCDST FROM FKKMAKO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2LAUFDDate IDnvarchar80DATS(N'00000000')NoLAUFD_KK Allow NULL? 
3LAUFIAdditional Identification Characteristicnvarchar60CHAR(N' ')NoMLFID_KK Allow NULL? 
4GPARTBusiness Partner Numbernvarchar100CHAR(N' ')NoBUT000GPART_KK Allow NULL? 
5VKONTContract Account Numbernvarchar120CHAR(N' ')No*VKONT_KK Allow NULL? 
6MAZAECounter for several dunning notices to a business partnernvarchar60NUMC(N'000000')NoMAZAE_KK Allow NULL? 
7AUSDTDate of issuenvarchar80DATS(N'00000000')YesAUSDT_KK Allow NULL? 
8MDRKDExecution Date of Dunning Noticenvarchar80DATS(N'00000000')YesMDRKD_KK Allow NULL? 
9MAHNVDunning Procedurenvarchar20CHAR(N' ')No*MAHNV_KK Allow NULL? 
10MGRUPGrouping fur Dunning Noticesnvarchar20CHAR(N' ')Yes*MGRUP_KK Allow NULL? 
11VKONTGRPCollection Management: Contract Account Groupnvarchar120CHAR(N' ')YesVKGRP_CM_KK Allow NULL? 
12VTREFGRPCollection Management: Contract Groupnvarchar200CHAR(N' ')YesVTGRP_CM_KK Allow NULL? 
13ITEMGRPClosed Item Group for Dunningdecimal150DEC((0))YesITEMGRP_CM_KK
14ITEMGRP_LASTItem Group in Last Dunning Noticedecimal150DEC((0))YesITEMGRP_LAST_CM_KK
15GRPFIELDGrouping Field for Dunningnvarchar120CHAR(N' ')YesGRPFIELD_CM_KK Allow NULL? 
16GRPFIELD_LASTGrouping Field in Last Dunning Noticenvarchar120CHAR(N' ')YesGRPFIELD_LAST_CM_KK Allow NULL? 
17STRATCollection Strategynvarchar20CHAR(N' ')YesTFK047XSTRAT_CM_KK Allow NULL? 
18STEPCollection Stepnvarchar40CHAR(N' ')YesTFK047USTEP_CM_KK Allow NULL? 
19STEP_LASTCollection Step of Last Dunningnvarchar40CHAR(N' ')YesTFK047USTEP_LAST_CM_KK Allow NULL? 
20STEP_REPLACEDReplaced Collection Step (Capacity Restriction)nvarchar40CHAR(N' ')YesTFK047USTEP_REPL_CM_KK Allow NULL? 
21STRAT_CHAMPChampion Collection Strategynvarchar20CHAR(N' ')Yes*STRAT_CHAMP_CM_KK Allow NULL? 
22TESTSCollection Management: Test Series for Collection Strategiesnvarchar100CHAR(N' ')YesTESTS_CM_KK Allow NULL? 
23LIMITEDCapacity for Dunning Activity Restrictedchar10CHAR(N' ')YesLIMITED_CM_KK Allow NULL? 
24RELEARelease Dunningchar10CHAR(N' ')YesRELEA_CM_KK Allow NULL? 
25RELDATELatest Release Datenvarchar80DATS(N'00000000')YesRELDATE_CM_KK Allow NULL? 
26RELGROUPRelease Groupnvarchar40CHAR(N' ')YesRELGROUP_CM_KK Allow NULL? 
27NEXDTDate of Next Dunningnvarchar80DATS(N'00000000')YesNEXDT_CM_KK Allow NULL? 
28OPBUKCompany Code Groupnvarchar40CHAR(N' ')Yes*OPBUK_KK Allow NULL? 
29STDBKCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
30GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
31SPARTDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
32VTREFReference Specifications from Contractnvarchar200CHAR(N' ')YesVTREF_KK Allow NULL? 
33SUBAPSubapplication in Contract Accounts Receivable and Payablechar10CHAR(N' ')YesSUBAP_KK Allow NULL? 
34VKNT1Leading Contract Account in Dunningnvarchar120CHAR(N' ')Yes*VKNT1_KK Allow NULL? 
35ABWMAAlternative dunning recipientnvarchar100CHAR(N' ')Yes*ABWMA_KK Allow NULL? 
36MAHNSDunning Levelnvarchar20NUMC(N'00')Yes*MAHNS_KK Allow NULL? 
37MSTYPDunning Level Categorynvarchar20CHAR(N' ')YesTFK047GMSTYP_KK Allow NULL? 
38WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
39MSALMDunning Balancedecimal132CURR((0))YesMSALM_KK
40MSALHNot used (formerly dunned amount in local currency)decimal132DEC((0))YesUNUSED_KK
41RSALMTotal of Dunning Reductionsdecimal132CURR((0))YesRSALM_KK
42CHGIDCharges Schedulenvarchar20CHAR(N' ')Yes*CHGID_KK Allow NULL? 
43MGE1MDun. charge 1decimal132CURR((0))YesMGE1M_KK
44MG1BLDoc no. for charge 1nvarchar120CHAR(N' ')Yes*MG1BL_KK Allow NULL? 
45MG1TYCharge type f. charge 1nvarchar20CHAR(N' ')Yes*MG1TY_KK Allow NULL? 
46POST1Posting Key for Chargeschar10CHAR(N' ')YesCPOST_KK Allow NULL? 
47MGE2MDun.charge 2decimal132CURR((0))YesMGE2M_KK
48MG2BLDoc number for charge 2nvarchar120CHAR(N' ')Yes*MG2BL_KK Allow NULL? 
49MG2TYCharge type f. charge 2nvarchar20CHAR(N' ')Yes*MG2TY_KK Allow NULL? 
50POST2Posting Key for Chargeschar10CHAR(N' ')YesCPOST_KK Allow NULL? 
51MGE3MDun.charge 3decimal132CURR((0))YesMGE3M_KK
52MG3BLDoc number for charge 3nvarchar120CHAR(N' ')Yes*MG3BL_KK Allow NULL? 
53MG3TYCharge type f. charge 3nvarchar20CHAR(N' ')Yes*MG3TY_KK Allow NULL? 
54POST3Posting Key for Chargeschar10CHAR(N' ')YesCPOST_KK Allow NULL? 
55MINTMDunning interest in transaction currencydecimal132CURR((0))YesMINTM_KK
56MIBELDoc no. of interest postingnvarchar120CHAR(N' ')Yes*MIBEL_KK Allow NULL? 
57BONITCreditworthinessnvarchar40NUMC(N'0000')YesBONDU_KK Allow NULL? 
58XMSTODunning Notice Reversedchar10CHAR(N' ')YesXMSTO_KK Allow NULL? 
59NRZASPayment Form Numbernvarchar120CHAR(N' ')YesNRZAS_KK Allow NULL? 
60XINFOGroup Not Due For Dunning/Information Onlychar10CHAR(N' ')YesXINFG_KK Allow NULL? 
61FRDATPayment Target in Dunning Noticenvarchar80DATS(N'00000000')NoFRDAT_KK Allow NULL? 
62COKEYCorrespondence keynvarchar360CHAR(N' ')YesCOKEY_KK Allow NULL? 
63XCOLLSubmission to Collection Agencychar10CHAR(N' ')YesXCOLL_KK Allow NULL? 
64RFZASExternal key payment formnvarchar300CHAR(N' ')YesRFZAS_KK Allow NULL? 
65TODATDate Up to Which Payments Were Considered (Dunning)nvarchar80DATS(N'00000000')YesTODAT_KK Allow NULL? 
66STAKZType of statistical itemchar10CHAR(N' ')YesSTAKZ_KK Allow NULL? 
67CHECKBOXTechnical Checkboxchar10CHAR(N' ')YesCKBOX_KK Allow NULL? 
68SUCPCSuccess Percentage Rate Determined for Dunningdecimal52DEC((0))YesSUCPC_KK
69ABWTPCategory of substitute document in FI-CAchar10CHAR(N' ')YesABWTP_KK Allow NULL? 
70ABWBLNumber of the substitute FI-CA documentnvarchar120CHAR(N' ')YesABWBL_KK Allow NULL? 
71STUDTMaximum Deferral Date for Related Itemsnvarchar80DATS(N'00000000')YesSTUDT_MAX_KK Allow NULL? 
72SUCDTDate of Success Valuationnvarchar80DATS(N'00000000')YesSUCDT_KK Allow NULL? 
73SCDSTStatus of Success Valuationchar10CHAR(N' ')YesSCDST_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
FKKMAKO~0YesYesCLUSTEREDMAZAE, VKONT, GPART, LAUFI, LAUFD, MANDT
FKKMAKO~001NoNoNONCLUSTEREDGPART, MANDT
FKKMAKO~002NoNoNONCLUSTEREDVTREF, MANDT
FKKMAKO~004NoNoNONCLUSTEREDSUCDT, GPART, SCDST, MANDT
FKKMAKO~005NoNoNONCLUSTEREDMDRKD, 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