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  | EABP
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.0EABP616Budget Billing PlanInvoicing
SQL:  selectupdate insert create

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

SELECT MANDT, OPBEL, VERTRAG, GPART, VKONTO, BEGPERIODE, ENDPERIODE, ERCHZBELNR, INVOPBEL, PORTION, SAMMELNR, KZABSVER, LETZTEFAKZ, MANUELLVKZ, MASCHNIANP, VORAUSZDAT, ABSCHLDAT, ABSTOPDAT, ABSPERDAT, ABSZYK, ANPDAT, DEAKTIV, SOLHAB_KZ, WAERS, ART, ERDAT, ERNAM, AEDAT, AENAM, EINZBETR, TAGBETR, VTEILKZ, VOR_OPBEL, BBP_EXTEND, PYPLT, ARCHIVE, DEBID, DELKZ, D_BETRAG, ABSBETRW, COUNT_KZ, COUNTER, USE_HKONT, BBP_OLD, ABP_TYP, BS_DAT, ANP_ERCHZ, VSPERRE, EXITS_USED, INVOICING_PARTY, PSSTATUS, PSACTIV, PSTERMDAT, TERMREASON, KUMBETRW, VTRBETRW, INTANPDAT, INTANPNUM, CHGRSN, INCLCAITEMS, UNMSRD FROM EABP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2OPBELBudget billing plannvarchar120CHAR(N' ')NoDFKKKOABPLANNR Allow NULL? 
3VERTRAGContractnvarchar100CHAR(N' ')NoEVERVERTRAG Allow NULL? 
4GPARTBusiness Partner Numbernvarchar100CHAR(N' ')YesBUT000GPART_KK Allow NULL? 
5VKONTOContract Account Numbernvarchar120CHAR(N' ')YesFKKVKVKONT_KK Allow NULL? 
6BEGPERIODEStart of budget billing periodnvarchar80DATS(N'00000000')YesABPABDAT Allow NULL? 
7ENDPERIODEEnd of budget billing periodnvarchar80DATS(N'00000000')YesABPBISDAT Allow NULL? 
8ERCHZBELNRNumber of billing document for budget billing basisnvarchar120CHAR(N' ')YesE_ABRBELNRA Allow NULL? 
9INVOPBELNumber of the Print Document that Generated the BB Plannvarchar120CHAR(N' ')YesERDKOPBEL_INV Allow NULL? 
10PORTIONPortionnvarchar80CHAR(N' ')YesTE420PORTION Allow NULL? 
11SAMMELNRAlternative contract account for collective billsnvarchar120CHAR(N' ')YesFKKVKABWVK_KK Allow NULL? 
12KZABSVERActivate Budget Billing Procedurechar10CHAR(N' ')YesKZABSVER Allow NULL? 
13LETZTEFAKZBudget Billing Plan Item - Payment in Advancechar10CHAR(N' ')YesLETZTEFAKZ Allow NULL? 
14MANUELLVKZBudget Billing Plan Changed Manuallychar10CHAR(N' ')YesMANVELLVKZ Allow NULL? 
15MASCHNIANPDo not Adjust Budget Billing Plan Automaticallychar10CHAR(N' ')YesMASCHNIANP Allow NULL? 
16VORAUSZDATStart date of advance paymentnvarchar80DATS(N'00000000')YesVORAUSZDAT Allow NULL? 
17ABSCHLDATStart date for budget billing paymentnvarchar80DATS(N'00000000')YesABSCHLDAT Allow NULL? 
18ABSTOPDATStop date of budget billing paymentnvarchar80DATS(N'00000000')YesABSTOPDAT Allow NULL? 
19ABSPERDATBlock date of budget billing paymentnvarchar80DATS(N'00000000')YesABSPERDAT Allow NULL? 
20ABSZYKBudget billing cyclenvarchar20NUMC(N'00')YesABSZYK Allow NULL? 
21ANPDATBudget billing plan adjustment datenvarchar80DATS(N'00000000')YesANPDAT Allow NULL? 
22DEAKTIVDeactivation of Budget Billing Plan via Invoicingnvarchar120CHAR(N' ')Yes*DEAKTIV Allow NULL? 
23SOLHAB_KZDebit and credit sub-transactions together in contractchar10CHAR(N' ')YesE_SOLHABTV Allow NULL? 
24WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
25ARTCreation type: budget billing planchar10NUMC(N'0')YesBBP_CREATE Allow NULL? 
26ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
27ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
28AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
29AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
30EINZBETRAmount that is entered in move-in/outdecimal132CURR((0))YesEINZBETR
31TAGBETRBudget billing amount per daydecimal132CURR((0))YesTAGBETR
32VTEILKZRemaining Amountchar10NUMC(N'0')YesVTEILKZ Allow NULL? 
33VOR_OPBELNo. of inv. doc. that selects adv.pmt.plan for trans.postingnvarchar120CHAR(N' ')YesDFKKKOVOR_OPBEL Allow NULL? 
34BBP_EXTENDBudget billing plan is extendedchar10CHAR(N' ')YesEXTEND Allow NULL? 
35PYPLTPayment plan typenvarchar40CHAR(N' ')YesTE015E_PYPLT Allow NULL? 
36ARCHIVEObject can be archivedchar10CHAR(N' ')YesARCHIVE_OBJ Allow NULL? 
37DEBIDBudget billing plan deactivated by customer changechar10CHAR(N' ')YesDEBID Allow NULL? 
38DELKZBudget Billing Plan Deactivated Through Deletionchar10CHAR(N' ')YesE_DELKZ Allow NULL? 
39D_BETRAGStanding Budget Billing Amountdecimal132CURR((0))YesD_BETRAG
40ABSBETRWBudget billing amount in transaction currencydecimal132CURR((0))YesABSBETRW
41COUNT_KZCounter for Active Standing Budget Billing Amountchar10CHAR(N' ')YesCOUNT_BBP_KZ Allow NULL? 
42COUNTERCounter for Standing Budget Billing Amountnvarchar20NUMC(N'00')YesCOUNTER_BBP Allow NULL? 
43USE_HKONTGeneral Ledger Account Used as Summarization Criteriachar10CHAR(N' ')YesUSE_HKONT Allow NULL? 
44BBP_OLDPrevious Payment Plannvarchar120CHAR(N' ')Yes*BBP_OLD Allow NULL? 
45ABP_TYPBudget Billing Plan Category, Internalchar10CHAR(N' ')YesABP_TYP Allow NULL? 
46BS_DATNotification Date for Charges Plannvarchar80DATS(N'00000000')YesBS_DAT Allow NULL? 
47ANP_ERCHZNumber of Billing Doc. as Basis of BB Amounts for Adjustmentnvarchar120CHAR(N' ')YesANP_ABR_BEL Allow NULL? 
48VSPERREExtension Block for Budget Billing Planschar10CHAR(N' ')YesVSPERRE Allow NULL? 
49EXITS_USEDEvents Used in Budget Billing Plannvarchar300CHAR(N' ')YesEXITS_USED Allow NULL? 
50INVOICING_PARTYService Provider That Invoices the Contractnvarchar100CHAR(N' ')Yes*INVOICING_PARTY Allow NULL? 
51PSSTATUSPayment Scheme Statusnvarchar20CHAR(N' ')YesE_PSSTATUS Allow NULL? 
52PSACTIVDate of Payment Scheme Activationnvarchar80DATS(N'00000000')YesE_PSACTIV Allow NULL? 
53PSTERMDATExpiry Date of Payment Schemenvarchar80DATS(N'00000000')YesE_PSTERMDAT Allow NULL? 
54TERMREASONPayment Scheme: Cancellation Reasonnvarchar30CHAR(N' ')YesE_TERMREASON Allow NULL? 
55KUMBETRWCumulated Budget Billing Amountdecimal132CURR((0))YesKUMBETRW
56VTRBETRWBudget Billing Amount at Contract Leveldecimal132CURR((0))YesACTBETRW
57INTANPDATLast Internet Adjustmentnvarchar80DATS(N'00000000')YesINTANPDAT Allow NULL? 
58INTANPNUMCounter for Internet Adjustmentsnvarchar30NUMC(N'000')YesINTANPNUM Allow NULL? 
59CHGRSNReason for Change to Budget Billing Amountnvarchar20CHAR(N' ')Yes*ECHGRSN Allow NULL? 
60INCLCAITEMSInclude Contract Account Itemschar10CHAR(N' ')YesE_INCLCAITEMS Allow NULL? 
61UNMSRDPS Unmeasured Customers: Checkboxchar10CHAR(N' ')YesPS_UNMSRD Allow NULL? 
NamePrimaryUniqueTypeColumns
EABP~0YesYesCLUSTEREDVERTRAG, OPBEL, MANDT
EABP~ABDNoNoNONCLUSTEREDANPDAT, MANDT
EABP~GPTNoNoNONCLUSTEREDGPART, MANDT
EABP~INVNoNoNONCLUSTEREDKZABSVER, PORTION, VKONTO, MANDT
EABP~SVKNoNoNONCLUSTEREDSAMMELNR, MANDT
EABP~VERNoNoNONCLUSTEREDVERTRAG, 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