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  | EDISCVAR
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: SAP Utilities :: Customer Service
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EDISCVAR741Disconn.Doc.: Processing VariantCustomer Service
SQL:  selectupdate insert create

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

SELECT MANDT, DISCPROCV, DISCREASON, NO_RELEASE, NO_AUTO_COMPLETE, BILLREL, ORD_CODE_D, ORD_WERK_D, ORD_CODE_R, ORD_WERK_R, CHARGE_DC, CHARGE_RC, BBP_D_MODE, BBP_R_MODE, BC_D_TYPE, BC_D_CLASS, BC_D_ACTVT, BC_R_TYPE, BC_R_CLASS, BC_R_ACTVT, DO_DATE_OFFSET, DE_DATE_OFFSET, DE_TIME, RO_DATE_OFFSET, RE_DATE_OFFSET, RE_TIME, COMPLETE_TECHN, CONTRACT_PROP, ORDSTATE_D, ORDSTATE_R, NOTIFICATION, NOT_CODE_D, NOT_WERK_D, NOT_CODE_R, NOT_WERK_R, RECN_REMOV, BONIG_KK, SEL_NOT_COUNT, INTERIM_BILLING, BBP_STOP, BBP_DISC_POPUP, MR_AUT_REVERSE, CHRG_AUT_REVERSE, AMI_CHARGE_DC, AMI_CHARGE_RC, AMI_DO_DATE_OFFS, AMI_DE_TIME, AMI_RO_DATE_OFFS, AMI_RE_TIME, AMI_MR_AUT_REVER, AMI_CHRG_AUT_REV, APRV_DC_REQD, APRV_RC_REQD, APRV_DC_MIN_STAR, APRV_DC_OFF_STAR, APRV_DC_OFF_DUE, APRV_DC_MAX_INTV, APRV_DC_INTERVAL, APRV_RC_MIN_STAR, APRV_RC_OFF_STAR, APRV_RC_OFF_DUE, APRV_RC_MAX_INTV, APRV_RC_INTERVAL, AMI_SCENARIO, DC_WI_CATEGORY, RC_WI_CATEGORY, AMI_BBP_DISC_POP, APRV_DC_OFF_STIM, APRV_RC_OFF_STIM, APRV_DC_OFF_DTIM, APRV_RC_OFF_DTIM, APRV_DC_MAX_AGRD, APRV_RC_MAX_AGRD, AMI_REMOTE_MR FROM EDISCVAR
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2DISCPROCVProcessing variant for disconnection/reconnectionnvarchar40CHAR(N' ')NoDISCPROCV Allow NULL? 
3DISCREASONDisconnection reasonnvarchar20CHAR(N' ')NoDISCREASON Allow NULL? 
4NO_RELEASERelease not requiredchar10CHAR(N' ')NoEDC_NORELEASE Allow NULL? 
5NO_AUTO_COMPLETEIndicator: explicit completion of disconnection doc requiredchar10CHAR(N' ')YesEDC_NOAUTOCOMPL Allow NULL? 
6BILLRELTake disconnection into account in billingchar10CHAR(N' ')YesEDC_BILLREL_P Allow NULL? 
7ORD_CODE_DOrder code for disconnection (service management)nvarchar40CHAR(N' ')NoTEWOCODESEDC_OC_D Allow NULL? 
8ORD_WERK_DPM Planning Plant for Disconnection Ordernvarchar40CHAR(N' ')Yes*EDC_OW_D Allow NULL? 
9ORD_CODE_ROrder code for reconnection (service management)nvarchar40CHAR(N' ')NoTEWOCODESEDC_OC_R Allow NULL? 
10ORD_WERK_RPlanning plant for reconnectionnvarchar40CHAR(N' ')Yes*EDC_OW_R Allow NULL? 
11CHARGE_DCDisconnection charge schemanvarchar20CHAR(N' ')YesTFK047ECHARGE_DC Allow NULL? 
12CHARGE_RCReconnection charge schemanvarchar20CHAR(N' ')YesTFK047ECHARGE_RC Allow NULL? 
13BBP_D_MODEType of budget billing amount adjustment for disconnectionnvarchar20CHAR(N' ')NoEDCBBDMODE Allow NULL? 
14BBP_R_MODEType of budget billing amount adjustment for reconnectionnvarchar20CHAR(N' ')NoEDCBBRMODE Allow NULL? 
15BC_D_TYPEBusiness partner contact for disconnection: type of contactnvarchar30CHAR(N' ')NoBCONTTBC_D_TYPE Allow NULL? 
16BC_D_CLASSBusiness partner contact for disconnection: contact classnvarchar40CHAR(N' ')NoBCONTCBC_D_CLASS Allow NULL? 
17BC_D_ACTVTBusiness partner contact for disconnection: contact activitynvarchar40CHAR(N' ')NoBCONTABC_D_ACTVT Allow NULL? 
18BC_R_TYPEBusiness partner contact for reconnection: type of contactnvarchar30CHAR(N' ')NoBCONTTBC_R_TYPE Allow NULL? 
19BC_R_CLASSBusiness partner contact for reconnection: contact classnvarchar40CHAR(N' ')NoBCONTCBC_R_CLASS Allow NULL? 
20BC_R_ACTVTBusiness partner contact for reconnection: contact activitynvarchar40CHAR(N' ')NoBCONTABC_R_ACTVT Allow NULL? 
21DO_DATE_OFFSETDisconnection order creation: difference to current datenvarchar20NUMC(N'00')NoEDC_DO_DATEOFF Allow NULL? 
22DE_DATE_OFFSETDisconnection entry: difference to current datenvarchar20NUMC(N'00')NoEDC_DE_DATEOFF Allow NULL? 
23DE_TIMEEntry of disconnection: default value for timenvarchar60TIMS(N'000000')NoEDC_DE_TIME Allow NULL? 
24RO_DATE_OFFSETReconnection order creation: difference to current datenvarchar20NUMC(N'00')NoEDC_RO_DATEOFF Allow NULL? 
25RE_DATE_OFFSETReconnection entry: difference to current datenvarchar20NUMC(N'00')NoEDC_RE_DATEOFF Allow NULL? 
26RE_TIMEEntry of reconnection: default value for timenvarchar60TIMS(N'000000')NoEDC_RE_TIME Allow NULL? 
27COMPLETE_TECHNTechnically complete service orderchar10CHAR(N' ')YesEDC_COMP_TECHN Allow NULL? 
28CONTRACT_PROPContract-related item proposalchar10CHAR(N' ')YesEDC_CONT_PROP Allow NULL? 
29ORDSTATE_DProposal for confirmation status of disconnectionnvarchar20NUMC(N'00')YesEDISCORDSTATEEDC_ORDSTATE_D Allow NULL? 
30ORDSTATE_RProposal for confirmation status of reconnectionnvarchar20NUMC(N'00')YesEDISCORDSTATEEDC_ORDSTATE_R Allow NULL? 
31NOTIFICATIONCreate service notificationchar10CHAR(N' ')YesEDC_NOTIFICATION Allow NULL? 
32NOT_CODE_DNotification code for disconnection (service managment)nvarchar40CHAR(N' ')YesTENOCODESEDC_NC_D Allow NULL? 
33NOT_WERK_DPM planning plant: disconnection notificationnvarchar40CHAR(N' ')Yes*EDC_NW_D Allow NULL? 
34NOT_CODE_RNotification code for reconnection (service management)nvarchar40CHAR(N' ')YesTENOCODESEDC_NC_R Allow NULL? 
35NOT_WERK_RPM planning plant: reconnection notificationnvarchar40CHAR(N' ')Yes*EDC_NW_R Allow NULL? 
36RECN_REMOVDevice removal despite disconnectionchar10CHAR(N' ')YesEDC_RECON_REMOV Allow NULL? 
37BONIG_KKCreditworthiness Weightingnvarchar20NUMC(N'00')NoEDC_BONIG_KK Allow NULL? 
38SEL_NOT_COUNTNon-Recording Devices Cannot be Disconnectedchar10CHAR(N' ')NoEDC_SEL_NOT_COUNT Allow NULL? 
39INTERIM_BILLINGCreate interim billing from disconnectionchar10CHAR(N' ')YesEDC_INTERIM_BILLING_FLAG Allow NULL? 
40BBP_STOPStop budget billing if installation disconnectedchar10CHAR(N' ')YesEDC_BBP_STOP_FLAG Allow NULL? 
41BBP_DISC_POPUPControl of Budget Billing Plan Items During Reconnectionchar10CHAR(N' ')YesBBP_DISC_POPUP Allow NULL? 
42MR_AUT_REVERSESupply Disconnection: Autom. Reversal of Meter Read. Resultschar10CHAR(N' ')YesEDC_MR_REVERSE Allow NULL? 
43CHRG_AUT_REVERSESupply Disconnection: Autom. Disconnection Charge Reversalchar10CHAR(N' ')YesEDC_CHRG_REVERSE Allow NULL? 
44AMI_CHARGE_DCCharge schema for AMI disconnectionsnvarchar20CHAR(N' ')YesTFK047EEDC_AMI_CHARGE_DC Allow NULL? 
45AMI_CHARGE_RCCharge schema for AMI reconnectionsnvarchar20CHAR(N' ')YesTFK047EEDC_AMI_CHARGE_RC Allow NULL? 
46AMI_DO_DATE_OFFSOffset used to calculate AMI disconnection order datenvarchar20NUMC(N'00')YesEDC_AMI_DO_DATEOFF Allow NULL? 
47AMI_DE_TIMEAMI disconnection order: Default timenvarchar60TIMS(N'000000')YesEDC_AMI_DE_TIME Allow NULL? 
48AMI_RO_DATE_OFFSOffset used to calculate AMI reconnection order datenvarchar20NUMC(N'00')YesEDC_AMI_RO_DATEOFF Allow NULL? 
49AMI_RE_TIMEAMI reconnection order: Default timenvarchar60TIMS(N'000000')YesEDC_AMI_RE_TIME Allow NULL? 
50AMI_MR_AUT_REVERAutomatic reversal of meter reading resultschar10CHAR(N' ')YesEDC_AMI_MR_RVRSE Allow NULL? 
51AMI_CHRG_AUT_REVAutomatic reversal of disconnection or reconnection chargeschar10CHAR(N' ')YesEDC_AMI_CHRG_RVRSE Allow NULL? 
52APRV_DC_REQDDisconnection: Customer notification requiredchar10CHAR(N' ')YesEDC_APRV_DC_REQD Allow NULL? 
53APRV_RC_REQDReconnection: Customer notification requiredchar10CHAR(N' ')YesEDC_APRV_RC_REQD Allow NULL? 
54APRV_DC_MIN_STARMinimum approval start datenvarchar20NUMC(N'00')YesEDC_APRV_DC_MINSTRT Allow NULL? 
55APRV_DC_OFF_STAROffset (in days) used to calculate notification start datenvarchar20NUMC(N'00')YesEDC_APRV_DC_OFFSTRT Allow NULL? 
56APRV_DC_OFF_DUEOffset (in days) used to calculate notification due datenvarchar20NUMC(N'00')YesEDC_APRV_DC_OFFDUE Allow NULL? 
57APRV_DC_MAX_INTVMaximum notification processing offset (disconnection)nvarchar20NUMC(N'00')YesEDC_APRV_DC_INTVL Allow NULL? 
58APRV_DC_INTERVALDisconnection: Rescheduling offsetnvarchar20NUMC(N'00')YesEDC_APRV_DC_INTRVL Allow NULL? 
59APRV_RC_MIN_STARMinimum processing interval for reconnectionnvarchar20NUMC(N'00')YesEDC_APRV_RC_MINSTRT Allow NULL? 
60APRV_RC_OFF_STAROffset (in days) used to calculate notification start datenvarchar20NUMC(N'00')YesEDC_APRV_RC_OFFSTRT Allow NULL? 
61APRV_RC_OFF_DUEOffset (in days) used to calculate notification due datenvarchar20NUMC(N'00')YesEDC_APRV_RC_OFFDUE Allow NULL? 
62APRV_RC_MAX_INTVMaximum notification processing offset (reconnection)nvarchar20NUMC(N'00')YesEDC_APRV_RC_INTVL Allow NULL? 
63APRV_RC_INTERVALReconnection: Rescheduling offsetnvarchar20NUMC(N'00')YesEDC_APRV_RC_INTRVL Allow NULL? 
64AMI_SCENARIODisconnection selection scenarionvarchar20CHAR(N' ')YesEDC_AMI_SCENARIO Allow NULL? 
65DC_WI_CATEGORYWork Item: Categorynvarchar20CHAR(N' ')YesTFK052BWLICAT_CM_KK Allow NULL? 
66RC_WI_CATEGORYWork Item: Categorynvarchar20CHAR(N' ')YesTFK052BWLICAT_CM_KK Allow NULL? 
67AMI_BBP_DISC_POPControl of budget billing plan items during AMI reconnectionchar10CHAR(N' ')YesEDC_AMI_BBP_DISC_POPUP Allow NULL? 
68APRV_DC_OFF_STIMDefault start time for disconnection notification work itemnvarchar60TIMS(N'000000')YesEDC_APRV_DC_OFFSTTIM Allow NULL? 
69APRV_RC_OFF_STIMDefault start time for reconnection notification work itemnvarchar60TIMS(N'000000')YesEDC_APRV_RC_OFFSTTIM Allow NULL? 
70APRV_DC_OFF_DTIMDefault due time for disconnection notification work itemnvarchar60TIMS(N'000000')YesEDC_APRV_DC_OFFDUTIM Allow NULL? 
71APRV_RC_OFF_DTIMDefault due time for reconnection notification work itemnvarchar60TIMS(N'000000')YesEDC_APRV_RC_OFFDUTIM Allow NULL? 
72APRV_DC_MAX_AGRDDisconnection: Maximum agreed date offsetnvarchar20NUMC(N'00')YesEDC_APRV_DC_MAX_AGRD Allow NULL? 
73APRV_RC_MAX_AGRDReconnection: Maximum agreed date offsetnvarchar20NUMC(N'00')YesEDC_APRV_RC_MAX_AGRD Allow NULL? 
74AMI_REMOTE_MRTrigger meter readingchar10NUMC(N'0')YesEDC_AMI_REMOTE_MR Allow NULL? 
NamePrimaryUniqueTypeColumns
EDISCVAR~0YesYesCLUSTEREDDISCPROCV, 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