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  | EVER
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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
Industry Specific :: SAP Utilities :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EVER946IS-U Cont.Master Data
SQL:  selectupdate insert create

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

SELECT MANDT, VERTRAG, BUKRS, SPARTE, EIGENVERBR, KOFIZ, PORTION, ABSLANFO, ABSZYK, ABSMNANP, GEMFAKT, MANABR, ABRSPERR, ABRFREIG, BSTATUS, KOSTL, VBEZ, VBEGINN, EINZDAT_ALT, VENDE, KUENDDAT, KFRIST, KUENPER, VBISDAT, VERLAENG, VERPER, VABSCHLEVU, VABSCHLKND, VABSCHLKNDTI, PERSNR, VREFER, ERDAT, ERNAM, AEDAT, AENAM, BEGRU, LOEVM, TXJCD, MANOUTSORT, FAKTURIERT, AUFNR, PS_PSP_PNR, PRCTR, COPAKONT, AUSGRUP, OUTCOUNT, PYPLT, PYPLS, GSBER, SEGMENT, SERVICEID, SRVPRVREF, BILLMETHOD, STAGRUVER, PYPLA, BILLFINIT, BFA_DEB_STAT, BFA_CRED_STAT, SALESEMPLOYEE, SALESPARTNER, SALESDOCUMENT, PS_STARTDAT, SERVPROV_PAY, INVOICING_PARTY, COKEY, BUPLA, CONTRACTCLASS, CANCREASON, CANCREASON_NEW, EXTRAPOLWASTE, PPM_CONTRACT, OSB_GROUP, OUCONT, RULEGR, REGIOGROUP, CMGRP, STRAT, CPERS, ANLAGE, VKONTO, KZSONDEINZ, KZSONDAUSZ, AUTEIGEINZ, EINZDAT, AUSZDAT, ABSSTOPDAT, SCHLFAKT, MAHNV, MAHNVUMZ, MANSP, BEZUG, TRANSVER, SSWTCREASON, XVERA FROM EVER
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VERTRAGContractnvarchar100CHAR(N' ')NoVERTRAG Allow NULL? 
3BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
4SPARTEDivisionnvarchar20CHAR(N' ')YesTESPTSPARTE Allow NULL? 
5EIGENVERBRPlant or company consumptionchar10CHAR(N' ')YesEIGENVERBR Allow NULL? 
6KOFIZAccount determination ID for IS-U contractsnvarchar20CHAR(N' ')YesTE097E_KOFIZ Allow NULL? 
7PORTIONAlternative portionnvarchar80CHAR(N' ')YesTE420PORTIONABW Allow NULL? 
8ABSLANFOBudget billing request for debtorchar10CHAR(N' ')YesABSLANFO Allow NULL? 
9ABSZYKOverrriding BB cycle on contract levelnvarchar20CHAR(N' ')YesABSZYKV Allow NULL? 
10ABSMNANPDo not adjust budget billing amount automaticallychar10CHAR(N' ')YesABSMNANP Allow NULL? 
11GEMFAKTInvoice Contracts Jointly (Mandatory Contracts)char10CHAR(N' ')YesE_GEMFAKT Allow NULL? 
12MANABRBill contract manuallychar10CHAR(N' ')YesMANABR Allow NULL? 
13ABRSPERRReason for blocking billingnvarchar20CHAR(N' ')YesTE021ABRSPERR Allow NULL? 
14ABRFREIGReason for releasing billingnvarchar20CHAR(N' ')YesTE023ABRFREIG Allow NULL? 
15BSTATUSProcessing statusnvarchar20CHAR(N' ')YesTE643BEARKZ Allow NULL? 
16KOSTLCost Centernvarchar100CHAR(N' ')YesCSKSKOSTL Allow NULL? 
17VBEZText for contractnvarchar350CHAR(N' ')YesE_VBEZ Allow NULL? 
18VBEGINNStart of contractnvarchar80DATS(N'00000000')YesE_VBEGINN Allow NULL? 
19EINZDAT_ALTMove-in date from legacy systemnvarchar80DATS(N'00000000')YesEINZDAT_ALT Allow NULL? 
20VENDEEnd of contractnvarchar80DATS(N'00000000')YesE_VENDE Allow NULL? 
21KUENDDATCancellation date of contractnvarchar80DATS(N'00000000')YesKUENDAT Allow NULL? 
22KFRISTNumber of time units for cancellationnvarchar30NUMC(N'000')YesKUENZEIT Allow NULL? 
23KUENPERTime unit for cancellationchar10CHAR(N' ')YesKUENPER Allow NULL? 
24VBISDATRenewal date of contractnvarchar80DATS(N'00000000')YesE_VBISDAT Allow NULL? 
25VERLAENGNumber of time units for renewalnvarchar30NUMC(N'000')YesVERZEIT Allow NULL? 
26VERPERTime unit for renewalchar10CHAR(N' ')YesVERPER Allow NULL? 
27VABSCHLEVUDate on which utility concluded the contractnvarchar80DATS(N'00000000')YesE_VSCHLEVU Allow NULL? 
28VABSCHLKNDDate on which customer concluded the contractnvarchar80DATS(N'00000000')YesE_VSCHLKND Allow NULL? 
29VABSCHLKNDTITime at which customer signed contractnvarchar60TIMS(N'000000')YesE_VSCHLKNDTI Allow NULL? 
30PERSNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
31VREFERContract number from legacy systemnvarchar200CHAR(N' ')YesE_VREFER Allow NULL? 
32ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
33ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
34AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
35AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
36BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
37LOEVMDeletion Indicatorchar10CHAR(N' ')YesLOEVM Allow NULL? 
38TXJCDTax Jurisdictionnvarchar150CHAR(N' ')No*TXJCD Allow NULL? 
39MANOUTSORTReason for manual outsorting in billingnvarchar80CHAR(N' ')YesTE127MANOUTSORT Allow NULL? 
40FAKTURIERTContract has already been invoicedchar10CHAR(N' ')YesFAKTURIERT Allow NULL? 
41AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
42PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_PNR Allow NULL? 
43PRCTRProfit Centernvarchar100CHAR(N' ')YesCEPCPRCTR Allow NULL? 
44COPAKONTIndicator: Profitability segment assigned (CO-PA)char10CHAR(N' ')YesE_COPAKONT Allow NULL? 
45AUSGRUPOutsorting check group for billingnvarchar80CHAR(N' ')YesTE191AUSGRUP Allow NULL? 
46OUTCOUNTNumber of manual outsortings to be carried out yetnvarchar20NUMC(N'00')YesOUTCOUNT Allow NULL? 
47PYPLTPayment plan typenvarchar40CHAR(N' ')YesTE015E_PYPLT Allow NULL? 
48PYPLSStarting month of payment plannvarchar20NUMC(N'00')YesE_PYPLS Allow NULL? 
49GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
50SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')YesFAGL_SEGMSEGMT_KK Allow NULL? 
51SERVICEIDService Providernvarchar100CHAR(N' ')YesESERVPROVSERVICE_PROV Allow NULL? 
52SRVPRVREFReference number of service providernvarchar300CHAR(N' ')YesSRVPRVREF Allow NULL? 
53BILLMETHODBilling methodnvarchar20CHAR(N' ')YesBILLMETHOD Allow NULL? 
54STAGRUVERStatistics group for contractnvarchar20CHAR(N' ')YesTE770E_STGRUV Allow NULL? 
55PYPLAAlternative start month of payment plannvarchar20NUMC(N'00')YesE_PYPLA Allow NULL? 
56BILLFINITContract terminated for billing reasonschar10CHAR(N' ')YesBILLFINIT Allow NULL? 
57BFA_DEB_STATPayment plan - BF amount not released for receivablechar10CHAR(N' ')YesE_BFA_PROC_DEBIT Allow NULL? 
58BFA_CRED_STATPayment plan - BF amount not released for creditchar10CHAR(N' ')YesE_BFA_PROC_CREDIT Allow NULL? 
59SALESEMPLOYEESales employeenvarchar80NUMC(N'00000000')YesVRTNR Allow NULL? 
60SALESPARTNERSales partnersnvarchar100CHAR(N' ')YesKNA1ESALESPARTNER Allow NULL? 
61SALESDOCUMENTSales and Distribution Document Numbernvarchar100CHAR(N' ')YesVBUKVBELN Allow NULL? 
62PS_STARTDATStart Date of Payment Scheme (PS)nvarchar80DATS(N'00000000')YesPS_STARTDAT Allow NULL? 
63SERVPROV_PAYPayment Classnvarchar40CHAR(N' ')YesESERVPROV_PAYSERVPROV_PAY Allow NULL? 
64INVOICING_PARTYService Provider That Invoices the Contractnvarchar100CHAR(N' ')Yes*INVOICING_PARTY Allow NULL? 
65COKEYCO account assignment key, IS-U contractnvarchar100CHAR(N' ')YesTECOKCOKEY_EE2 Allow NULL? 
66BUPLABusiness Placenvarchar40CHAR(N' ')YesJ_1BBRANCHBUPLA Allow NULL? 
67CONTRACTCLASSContract Classnvarchar40CHAR(N' ')YesTECONTRACTCLASSCONTRACTCLASS Allow NULL? 
68CANCREASONReason for Cancellation of Contractnvarchar20CHAR(N' ')Yes*VKGRU_VEDA Allow NULL? 
69CANCREASON_NEWCancellation Reason (CRM)nvarchar40CHAR(N' ')Yes*ECRMT_SRV_CANCEL_REASON Allow NULL? 
70EXTRAPOLWASTECategory of Waste Disposal Budget Billing Extrapolationnvarchar20CHAR(N' ')YesEXTRAPOLWASTE Allow NULL? 
71PPM_CONTRACTIdentifies Contract as Prepayment Meter Contractchar10CHAR(N' ')YesE_PP_PPM_CONTRACT Allow NULL? 
72OSB_GROUPOn-Site Billing Groupnvarchar30CHAR(N' ')YesTE555E_OSB_GROUP Allow NULL? 
73OUCONTOutline Contractchar10CHAR(N' ')YesOUCONT Allow NULL? 
74RULEGRRule Group for Outline Agreementsnvarchar100CHAR(N' ')Yes*RULEGR Allow NULL? 
75REGIOGROUPRegional structure groupingnvarchar80CHAR(N' ')YesADRREGGRPREGIOGROUP Allow NULL? 
76CMGRPCollection Management: Master Data Groupnvarchar20CHAR(N' ')YesTFK041BCMGRP_CM_KK Allow NULL? 
77STRATCollection Strategynvarchar20CHAR(N' ')YesTFK047XSTRAT_CM_KK Allow NULL? 
78CPERSCollections Contact Personnvarchar100CHAR(N' ')Yes*CPERS_CM_KK Allow NULL? 
79ANLAGEInstallationnvarchar100CHAR(N' ')Yes*ANLAGE Allow NULL? 
80VKONTOContract Account Numbernvarchar120CHAR(N' ')YesFKKVKVKONT_KK Allow NULL? 
81KZSONDEINZMove-In Processing (Special Case)char10CHAR(N' ')YesKZSONDEINZ Allow NULL? 
82KZSONDAUSZSpecial move-out processing case existschar10CHAR(N' ')YesKZSONDAUSZ Allow NULL? 
83AUTEIGEINZAutomatic Owner Move-Inchar10CHAR(N' ')YesAUTEIGEINZ Allow NULL? 
84EINZDATMove-In Datenvarchar80DATS(N'00000000')YesEINZDAT Allow NULL? 
85AUSZDATMove-Out Datenvarchar80DATS(N'00000000')YesAUSZDAT Allow NULL? 
86ABSSTOPDATStop date for budget bill. requests in the case of move-outnvarchar80DATS(N'00000000')YesABSSTOPDAT Allow NULL? 
87SCHLFAKTJoint final billing for move-in/outchar10CHAR(N' ')YesSCHLFAKT Allow NULL? 
88MAHNVDunning Procedurenvarchar20CHAR(N' ')YesTFK047AMAHNV_KK Allow NULL? 
89MAHNVUMZMove-in/out dunning procedurenvarchar20CHAR(N' ')YesTFK047AMAHNV_UMZ Allow NULL? 
90MANSPDunning Lock Reasonchar10CHAR(N' ')YesTFK047SMANSP_KK Allow NULL? 
91BEZUGReferencechar10CHAR(N' ')YesBEZUG Allow NULL? 
92TRANSVERTransfer contractnvarchar100CHAR(N' ')YesEVERE_TRANSVER Allow NULL? 
93SSWTCREASONReasons for contract changenvarchar20CHAR(N' ')YesTE960SSWTCREASON Allow NULL? 
94XVERAContract created due to data transferchar10CHAR(N' ')YesXVERA Allow NULL? 
NamePrimaryUniqueTypeColumns
EVER~0YesYesCLUSTEREDVERTRAG, MANDT
EVER~ANLNoNoNONCLUSTEREDANLAGE, MANDT
EVER~PORNoNoNONCLUSTEREDPORTION, MANDT
EVER~SRPNoNoNONCLUSTEREDSERVICEID, MANDT
EVER~TVRNoNoNONCLUSTEREDTRANSVER, MANDT
EVER~VKONoNoNONCLUSTEREDVKONTO, 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