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  | EABPS_CORR
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 Utilities :: Invoicing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EABPS_CORR551Sub Budget Billing Plan for Correspondence PrintInvoicing
SQL:  selectupdate insert create

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

SELECT MANDT, COKEY, CH_POS, LFDNR, OPBEL, VTREF, LOGNO, TVORG, FAEDN, FAEDS, SOLLDAT, VORAUSZAHL, XMARK, AUGST, ABWBL, ABWTP, ABWKT, MWSKZ, GRBBP, OPTXT, VERKZ, STUDT, SKTPZ, XMANL, BETRH, BETRW, BETR2, BETR3, SKFBT, SBETH, SBETW, SBET2, SBET3, PYMET, PERSL, XAESP, AUGDT, AUGBL, AUGBD, AUGRD, AUGWA, AUGBT, AUGBS, AUGSK, AUGVD, AUGOB, MAHNV, MANSP, ABRZU, ABRZO, AUGRS, EMBVT, IKEY, ERNAM, ERDAT FROM EABPS_CORR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2COKEYCorrespondence keynvarchar360CHAR(N' ')NoCOKEY_KK Allow NULL? 
3CH_POSBudget Billing Items After Changenvarchar30CHAR(N' ')NoCH_POS Allow NULL? 
4LFDNRSequence Numbernvarchar30CHAR(N' ')NoLFDNR Allow NULL? 
5OPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')No*OPBEL_KK Allow NULL? 
6VTREFReference Specifications from Contractnvarchar200CHAR(N' ')YesVTREF_KK Allow NULL? 
7LOGNOLine Number of Budget Billing Plannvarchar30CHAR(N' ')YesLOGNO Allow NULL? 
8TVORGSubtransaction for Document Itemnvarchar40CHAR(N' ')Yes*TVORG_KK Allow NULL? 
9FAEDNDue date for net paymentnvarchar80DATS(N'00000000')YesFAEDN_KK Allow NULL? 
10FAEDSDue Date for Cash Discountnvarchar80DATS(N'00000000')YesFAEDS_KK Allow NULL? 
11SOLLDATPrint date for BB requests or generation of partial billnvarchar80DATS(N'00000000')YesABSDAT Allow NULL? 
12VORAUSZAHLBudget Billing Plan Item Is Advance Paymentchar10CHAR(N' ')YesVORAUSZAHL Allow NULL? 
13XMARKIndicator: Line selectedchar10CHAR(N' ')YesXMARK Allow NULL? 
14AUGSTClearing statuschar10CHAR(N' ')YesAUGST_KK Allow NULL? 
15ABWBLNumber of the substitute FI-CA documentnvarchar120CHAR(N' ')YesABWBL_KK Allow NULL? 
16ABWTPCategory of substitute document in FI-CAchar10CHAR(N' ')YesABWTP_KK Allow NULL? 
17ABWKTAlternative contract account for collective billsnvarchar120CHAR(N' ')Yes*ABWVK_KK Allow NULL? 
18MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
19GRBBPBudget Billing: Grouping Key for Tax Determination Codenvarchar20CHAR(N' ')YesGRBBP Allow NULL? 
20OPTXTItem textnvarchar500CHAR(N' ')YesOPTXT_KK Allow NULL? 
21VERKZItem Can Only Be Clearedchar10CHAR(N' ')YesVERKZ_KK Allow NULL? 
22STUDTDeferral tonvarchar80DATS(N'00000000')YesSTUDT_KK Allow NULL? 
23SKTPZCash discount ratedecimal53DEC((0))YesSKTPZ_KK
24XMANLExclude Item from Dunning Runchar10CHAR(N' ')YesXMANL_KK Allow NULL? 
25BETRHAmount In Local Currency With +/- Signsdecimal132CURR((0))YesBETRH_KK
26BETRWAmount in Transaction Currency with +/- Signdecimal132CURR((0))YesBETRW_KK
27BETR2Amount in second parallel currency with +/- signdecimal132CURR((0))YesBETR2_KK
28BETR3Amount in third parallel currency with +/- signdecimal132CURR((0))YesBETR3_KK
29SKFBTAmount eligible for cash discount in document currencydecimal132CURR((0))YesSKFBT_KK
30SBETHTax Amount in Local Currency With +/- Signdecimal132CURR((0))YesSBETH_KK
31SBETWTax Amount in Transaction Currency with +/- Signdecimal132CURR((0))YesSBETW_KK
32SBET2Tax amount in second parallel currencydecimal132CURR((0))YesSBET2_KK
33SBET3Tax amount in third parallel currencydecimal132CURR((0))YesSBET3_KK
34PYMETPayment Methodchar10CHAR(N' ')Yes*PYMET_KK Allow NULL? 
35PERSLKey for Period Assignmentnvarchar40CHAR(N' ')Yes*PERSL_KK Allow NULL? 
36XAESPPrinting - No Changes Possiblechar10CHAR(N' ')YesXAESP_KK Allow NULL? 
37AUGDTClearing datenvarchar80DATS(N'00000000')YesAUGDT_KK Allow NULL? 
38AUGBLClearing Document or Printed Documentnvarchar120CHAR(N' ')YesAUGBL_KK Allow NULL? 
39AUGBDClearing document posting datenvarchar80DATS(N'00000000')YesAUGBD_KK Allow NULL? 
40AUGRDClearing Reasonnvarchar20CHAR(N' ')Yes*AUGRD_KK Allow NULL? 
41AUGWAClearing currencynvarchar50CUKY(N' ')Yes*AUGWA_KK Allow NULL? 
42AUGBTClearing amount in clearing currencydecimal132CURR((0))YesAUGBT_KK
43AUGBSTax amount in clearing currencydecimal132CURR((0))YesAUGBS_KK
44AUGSKCash Discount Granted/Surcharge Levied in Clearing Currencydecimal132CURR((0))YesAUGSK_KK
45AUGVDValue date for clearingnvarchar80DATS(N'00000000')YesAUGVD_KK Allow NULL? 
46AUGOBItem Canceledchar10CHAR(N' ')YesAUGOB_KK Allow NULL? 
47MAHNVDunning Procedurenvarchar20CHAR(N' ')Yes*MAHNV_KK Allow NULL? 
48MANSPDunning Lock Reasonchar10CHAR(N' ')Yes*MANSP_KK Allow NULL? 
49ABRZULower Limit of Settlement Periodnvarchar80DATS(N'00000000')YesABRZU_KK Allow NULL? 
50ABRZOUpper Limit of the Billing Periodnvarchar80DATS(N'00000000')YesABRZO_KK Allow NULL? 
51AUGRSClearing restrictionchar10CHAR(N' ')YesAUGRS_KK Allow NULL? 
52EMBVTBank Details ID of Payeenvarchar40CHAR(N' ')YesEMBVT_KK Allow NULL? 
53IKEYInterest Keynvarchar20CHAR(N' ')Yes*IKEY_KK Allow NULL? 
54ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
55ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
NamePrimaryUniqueTypeColumns
EABPS_CORR~0YesYesCLUSTEREDOPBEL, LFDNR, CH_POS, COKEY, 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