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  | ERCH
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 :: Contract Billing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ERCH933Billing Doc. DataContract Billing
SQL:  selectupdate insert create

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

SELECT MANDT, BELNR, BUKRS, SPARTE, GPARTNER, VKONT, VERTRAG, BEGABRPE, ENDABRPE, ABRDATS, ADATSOLL, PTERMTDAT, BELEGDAT, ABWVK, BELNRALT, STORNODAT, ABRVORG, HVORG, KOFIZ, PORTION, FORMULAR, SIMULATION, BELEGART, BERGRUND, BEGNACH, TOBRELEASD, TXJCD, KONZVER, EROETIM, ERCHO_V, ERCHZ_V, ERCHU_V, ERCHR_V, ERCHC_V, ERCHV_V, ERCHT_V, ERCHP_V, ERCHE_V, ABRVORG2, ABLEINH, ENDPRIO, ERDAT, ERNAM, AEDAT, AENAM, BEGRU, LOEVM, ABRDATSU, ABRVORGU, N_INVSEP, ABPOPBEL, MANBILLREL, BACKBI, PERENDBI, NUMPERBB, BEGEND, ENDOFBB, ENDOFPEB, NUMPERPEB, SC_BELNR_H, SC_BELNR_N, ZUORDDAA, BILLINGRUNNO, SIMRUNID, KTOKLASSE, ORIGDOC, NOCANC, ABSCHLPAN, MEM_OPBEL, MEM_BUDAT, EXBILLDOCNO, BCREASON, NINVOICE, NBILLREL, CORRECTION_DATE, BASDYPER, ESTINBILL, ESTINBILLU, ESTINBILL_SAV, ESTINBILL_USAV, ACTPERIOD, ACTPERORG, EZAWE, DAUBUCH, FDGRP, BILLING_PERIOD, OSB_GROUP, BP_BILL, MAINDOCNO, INSTGRTYPE, INSTROLE, MDUSREQUESTID, ASBACH_REL FROM ERCH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BELNRNumber of a billing documentnvarchar120CHAR(N' ')NoE_BELNR Allow NULL? 
3BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
4SPARTEDivisionnvarchar20CHAR(N' ')NoTSPASPARTE Allow NULL? 
5GPARTNERBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
6VKONTContract Account Numbernvarchar120CHAR(N' ')No*VKONT_KK Allow NULL? 
7VERTRAGContractnvarchar100CHAR(N' ')No*VERTRAG Allow NULL? 
8BEGABRPEStart of billing periodnvarchar80DATS(N'00000000')NoBEGABRPE Allow NULL? 
9ENDABRPEEnd of billing periodnvarchar80DATS(N'00000000')NoENDABRPE Allow NULL? 
10ABRDATSScheduled Billing Datenvarchar80DATS(N'00000000')NoABRDATS Allow NULL? 
11ADATSOLLScheduled meter reading datenvarchar80DATS(N'00000000')NoADATSOLL Allow NULL? 
12PTERMTDATEnd of billing period from schedule record of portionnvarchar80DATS(N'00000000')YesPTERMTDAT Allow NULL? 
13BELEGDATCreation date of billing documentnvarchar80DATS(N'00000000')NoBELEGDAT Allow NULL? 
14ABWVKAlternative contract account for collective billsnvarchar120CHAR(N' ')No*ABWVK_KK Allow NULL? 
15BELNRALTNumber of previous documentnvarchar120CHAR(N' ')NoBELNRALT Allow NULL? 
16STORNODATReversal datenvarchar80DATS(N'00000000')NoSTORNODAT Allow NULL? 
17ABRVORGBilling Transactionnvarchar20CHAR(N' ')NoABRVORG Allow NULL? 
18HVORGMain Transaction for Line Itemnvarchar40CHAR(N' ')NoTFKHVOHVORG_KK Allow NULL? 
19KOFIZAccount determination ID for IS-U contractsnvarchar20CHAR(N' ')NoTE097E_KOFIZ Allow NULL? 
20PORTIONPortionnvarchar80CHAR(N' ')NoTE420PORTION Allow NULL? 
21FORMULARForm Namenvarchar160CHAR(N' ')NoTDFORM Allow NULL? 
22SIMULATIONIndicator: billing simulationnvarchar20CHAR(N' ')NoSIMULATION Allow NULL? 
23BELEGARTDocument typenvarchar20CHAR(N' ')NoTE093E_BELART Allow NULL? 
24BERGRUNDReason for credit memo/backbillingnvarchar20CHAR(N' ')NoBERGRUND Allow NULL? 
25BEGNACHStart of backbilling periodnvarchar80DATS(N'00000000')NoBEGNACH Allow NULL? 
26TOBRELEASDIndicator: document not released yetchar10CHAR(N' ')NoTOBRELEASD Allow NULL? 
27TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
28KONZVERFranchise contractnvarchar100CHAR(N' ')No*KONZVER Allow NULL? 
29EROETIMTime of day billing document was creatednvarchar40CHAR(N' ')NoEROETIM Allow NULL? 
30ERCHO_VERCHO exists for ERCHchar10CHAR(N' ')YesERCHO_V Allow NULL? 
31ERCHZ_VERCHZ exists for ERCHchar10CHAR(N' ')NoERCHZ_V Allow NULL? 
32ERCHU_VERCHU exists for ERCHchar10CHAR(N' ')NoERCHU_V Allow NULL? 
33ERCHR_VERCHR exists for ERCHchar10CHAR(N' ')NoERCHR_V Allow NULL? 
34ERCHC_VERCHC exists for ERCHchar10CHAR(N' ')YesERCHC_V Allow NULL? 
35ERCHV_VERCHV exists for ERCHchar10CHAR(N' ')YesERCHV_V Allow NULL? 
36ERCHT_VERCHT exists for ERCHchar10CHAR(N' ')YesERCHT_V Allow NULL? 
37ERCHP_VERCHP exists for ERCHchar10CHAR(N' ')YesERCHP_V Allow NULL? 
38ERCHE_VERCHE Available for ERCHchar10CHAR(N' ')YesERCHE_V Allow NULL? 
39ABRVORG2Billing Transaction that Triggered Period-End Billingnvarchar20CHAR(N' ')NoABRVORG2 Allow NULL? 
40ABLEINHMeter Reading Unitnvarchar80CHAR(N' ')No*ABLEINHEIT Allow NULL? 
41ENDPRIOPriority of Period-End Billingchar10CHAR(N' ')NoENDPRIO Allow NULL? 
42ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
43ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
44AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
45AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
46BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
47LOEVMDeletion Indicatorchar10CHAR(N' ')YesLOEVM Allow NULL? 
48ABRDATSUScheduled billing date for suppressed billing ordernvarchar80DATS(N'00000000')NoABRDATSU Allow NULL? 
49ABRVORGUBilling Transaction for a Suppressed Billing Ordernvarchar20CHAR(N' ')NoABRVORGU Allow NULL? 
50N_INVSEPOnly invoice document jointly with automatic documentchar10CHAR(N' ')YesN_INVSEP Allow NULL? 
51ABPOPBELBudget billing plannvarchar120CHAR(N' ')Yes*ABPLANNR Allow NULL? 
52MANBILLRELManual Document Released for Invoicingchar10CHAR(N' ')YesMANBILLREL Allow NULL? 
53BACKBIType of backbillingchar10CHAR(N' ')YesBACKBI Allow NULL? 
54PERENDBIType of period-end billingchar10CHAR(N' ')YesPERENDBI Allow NULL? 
55NUMPERBBNumber of periods for backbillingtinyint30INT1((0))YesNUMPERBB
56BEGENDStart of period-end billing periodnvarchar80DATS(N'00000000')YesBEGEND Allow NULL? 
57ENDOFBBIndicator: end of backbilling periodchar10CHAR(N' ')YesENDOFBB Allow NULL? 
58ENDOFPEBIndicator: end of period-end billing periodchar10CHAR(N' ')YesENDOFPEB Allow NULL? 
59NUMPERPEBNumber of periods for period-end billingtinyint30INT1((0))YesNUMPERPEB
60SC_BELNR_HNumber of billing document in adjustment reversalnvarchar120CHAR(N' ')YesSC_BELNR Allow NULL? 
61SC_BELNR_NNew billing document number in adjustment reversalnvarchar120CHAR(N' ')YesSC_BEL_N Allow NULL? 
62ZUORDDAAAllocation date for billingnvarchar80DATS(N'00000000')YesE_ZUORDDATABR Allow NULL? 
63BILLINGRUNNONumber of Billing Runnvarchar120CHAR(N' ')YesBILLINGRUNNO Allow NULL? 
64SIMRUNIDSimulation Period IDnvarchar80CHAR(N' ')Yes*SIMRUNID Allow NULL? 
65KTOKLASSEAccount classnvarchar40CHAR(N' ')Yes*KTOKLASSE Allow NULL? 
66ORIGDOCOrigin of Billing Documentnvarchar20CHAR(N' ')YesORIGDOC Allow NULL? 
67NOCANCIndicator: do not execute billing reversalchar10CHAR(N' ')YesNOCANC Allow NULL? 
68ABSCHLPANAdjust budget billing planchar10CHAR(N' ')YesABSCHLPAN Allow NULL? 
69MEM_OPBELReversed invoicing document no. for new billing/invoicingnvarchar120CHAR(N' ')YesMEM_OPBEL Allow NULL? 
70MEM_BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesMEM_BUDAT Allow NULL? 
71EXBILLDOCNOExternal document numbernvarchar200CHAR(N' ')YesEXBILLDOCNO Allow NULL? 
72BCREASONReason for Reversalnvarchar20CHAR(N' ')YesTE272BCREASON Allow NULL? 
73NINVOICEBilling document without invoicingchar10CHAR(N' ')YesNINVOICE Allow NULL? 
74NBILLRELNot relevant to billingchar10CHAR(N' ')YesNBILLREL Allow NULL? 
75CORRECTION_DATEDate when the Error Was Detectednvarchar80DATS(N'00000000')YesISU_CORRECTION_DATE Allow NULL? 
76BASDYPERBasic category of dynamic period controlnvarchar20CHAR(N' ')YesBASDYPER Allow NULL? 
77ESTINBILLMeter Reading Results are Estimated in Billingnvarchar20CHAR(N' ')YesESTINBILL Allow NULL? 
78ESTINBILLUESTINBILL of a Suppressed Billing Ordernvarchar20CHAR(N' ')YesESTINBILLU Allow NULL? 
79ESTINBILL_SAVOriginal Value from ESTINBILLnvarchar20CHAR(N' ')YesESTINBILL_SAV Allow NULL? 
80ESTINBILL_USAVESTINBILL_SAV of a Suppressed Billing Ordernvarchar20CHAR(N' ')YesESTINBILL_USAV Allow NULL? 
81ACTPERIODCategory of a period for current billingnvarchar40CHAR(N' ')Yes*ACTPERIOD Allow NULL? 
82ACTPERORGOriginal Category of a Current Period to be Billednvarchar40CHAR(N' ')Yes*ACTPERORG Allow NULL? 
83EZAWEIncoming Payment Methodchar10CHAR(N' ')YesEZAWE_KK Allow NULL? 
84DAUBUCHStanding orderchar10CHAR(N' ')YesDAUBUCH Allow NULL? 
85FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP_KK Allow NULL? 
86BILLING_PERIODBilling Key Date (For Example January 2002)nvarchar100CHAR(N' ')YesE_BILLING_PERIOD Allow NULL? 
87OSB_GROUPOn-Site Billing Groupnvarchar30CHAR(N' ')YesTE555E_OSB_GROUP Allow NULL? 
88BP_BILLResulting Billing Periodchar10CHAR(N' ')YesBP_BILL Allow NULL? 
89MAINDOCNOBilling Document Number of Primary Installationnvarchar120CHAR(N' ')YesMAINDOCNO Allow NULL? 
90INSTGRTYPEGrouping Type for Installation Groupnvarchar40CHAR(N' ')Yes*INSTGRTYPE Allow NULL? 
91INSTROLERole of an Installation Within the Installation Groupnvarchar40CHAR(N' ')Yes*INSTROLE Allow NULL? 
92MDUSREQUESTIDMDUS Request IDnvarchar220CHAR(N' ')YesEMDUSDRQHEADE_MDUSREQUESTID Allow NULL? 
93ASBACH_RELChange to Assessment Basic Relevantchar10CHAR(N' ')YesASBACH_REL Allow NULL? 
NamePrimaryUniqueTypeColumns
ERCH~0YesYesCLUSTEREDBELNR, MANDT
ERCH~003NoNoNONCLUSTEREDENDABRPE, STORNODAT, SIMULATION, VERTRAG, MANDT
ERCH~BRNNoNoNONCLUSTEREDBILLINGRUNNO, 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