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

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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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

51 columns | Print definition?ERP 6.0  | PROCESSED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVA_CCD_ANA_CNTCount table for the scanned objects in CNVA_CCD_ANA packag11PROCESSEDnvarchar10
2CNV_20100_T011Balance sheet/p&l structures for conversion8PROCESSEDFin. Statem. Version processed?nvarchar10
3CNV_20551_RESULTFound relevant objects for deletion (statistics)11PROCESSEDIndicator (active, inactive)nvarchar10
4CNV_40305_POST_AAggregated amount to be reposted20PROCESSEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
5CNV_40305_SIM_PAAggregated amount to be reposted21PROCESSEDBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
6DRP_SMTC_DEVCLDEV Reporting (SE28): Control Table for Current Run3PROCESSEDDEV Reporting (SE28): Devclass Processednvarchar10
7FKKID_EXP_HDR_ACr.Mem.&Exp.Conf.: Export Confirmation Header18PROCESSEDItem Was Processed By Mass Activitynvarchar10
8IUUC_INCR_COUNTIUUC: Persitenz for incremental count6PROCESSEDint100
9IUUC_TRACKIUUC: Tracking for Delta Replay6PROCESSEDMWB: Number of Recordsdecimal120
10IUUC_TRACK_HDRIUUC: Tracking for Delta Replay5PROCESSEDMWB: Number of Recordsdecimal120
11LXE_WRK_LOGWorklist Run Log17PROCESSEDNatural Numberint100
12REFXCN_CD_ADJCondition Adjustment9PROCESSEDProessed or not ( X = Processed )nvarchar10
13REFXCN_IDOCREFX POS IDOC Inbound data11PROCESSEDProessed or not ( X = Processed )nvarchar10
14REFXCN_IDOCTABREFX POS IDOC Inbound data12PROCESSEDProessed or not ( X = Processed )nvarchar10
15REFXCN_SALESSales Data18PROCESSEDProessed or not ( X = Processed )nvarchar10
16REFXCN_STATESale Satement Data12PROCESSEDProessed or not ( X = Processed )nvarchar10
17RSCRMMONRSCRM: Monitoring for Batch3PROCESSEDPercentage Completed in Batchnvarchar30
18UCONSTATETRANSWLRFC State transport Worklist2PROCESSEDSingle-Character Indicatornvarchar10
19ZPHTRIALTABIBS Pharma: Randomization table for clinical trials7PROCESSEDPharma CTSM: Flag for processed itemsnvarchar10
TOPALE Integration Technology
20EDIQOIDoc: Outbound Queue for qRFC6PROCESSEDnvarchar10
21TBD74ALE Customizing Distribution: Inbound Log9PROCESSEDProcessing status of ALE Customizing Distributionnvarchar10
TOPBilling in Contract Accounts Receivable and Payable
22DFKKBIEDRWOATPermanently Rejected EDRs (Payments, Receivables, Credit)20PROCESSEDPermanently Rejected EDR was Processednvarchar10
23DFKKBIEDRWOTCPermanently Rejected EDRs13PROCESSEDPermanently Rejected EDR was Processednvarchar10
24DFKKBIEDRWOZ01Test Data: Permanently Rejected EDRs fr. Category ZTCSERVICE17PROCESSEDPermanently Rejected EDR was Processednvarchar10
TOPClaims Management
25ICLCAREREP1Data on Care Request8PROCESSEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
26ICLCAREREP2Data on Caregiver9PROCESSEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPEquipment
27IEQT_WL_ITEMSInterim Statuses - Items13PROCESSEDCheckboxnvarchar10
28IEQT_WL_ITM_BACInterim Statuses - Items (Backup)14PROCESSEDCheckboxnvarchar10
TOPFinancial Accounting
29/CCEE/SIFIDDVSpecial Tax Table25PROCESSEDGeneral Flagnvarchar10
30KONH_CONV_TRGTrigger table for KONH7PROCESSEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPGRC Access Control Plug-In
31/VIRSA/INT_TRIGHR Triggers - Trigger Information4PROCESSEDSingle-Character Indicatornvarchar10
TOPGreat Britain
32T5GEF01HR-GB: filing - Store parsed recording coming in from GG23PROCESSEDRecord Processednvarchar10
TOPHR Information Systems
33HRLDAP_PERNRPers. Nos to Be Sent to LDAP4PROCESSEDGeneral Flagnvarchar10
TOPIncentive and Commission Management ICM
34CACS_LCC_STATUSLCC: Control Table for Internal Process in Matching Programs10PROCESSEDCompleted indicatornvarchar10
TOPInformix
35INFREQ4USParallel Upd. Stat. Request Table (sapdbainf <-> child4us)10PROCESSEDnvarchar10
TOPJoint Venture und Production Sharing Accounting
36T8J6NJV EDI Processed Partners/Ventures8PROCESSEDProcessing completed flagnvarchar10
TOPLanguage Transport
37TLANSUPTALanguage Transport: Tables to Be Supplemented5PROCESSEDProcessed Table Linesnvarchar80
TOPLocal Currency Changeover
38EWUCLSTATEMU Cnv: Status Table for Conversion with Clusters30PROCESSEDCompleted indicatornvarchar10
TOPLocalization
39J_3RFCAPREPNet book value increase of assets as a result of repairs10PROCESSEDProcessing status of a line in repair tablenvarchar10
TOPLogistics Basic Data
40DMF_D_MATKLRelevant Merchandise Categories5PROCESSEDProcessing Indicatornvarchar10
41DMF_D_MTARTRelevant Article Types5PROCESSEDProcessing Indicatornvarchar10
TOPOLAP Technology
42RSCDSMVREFORAControl Table for Conversion of ICs with ncumtim = parttim2PROCESSEDnvarchar10
TOPOverhead Cost Controlling
43COINT_TPOST_ITControlling Integration: Reposting: Line Items16PROCESSEDProcessing Flagnvarchar10
TOPPackage Tools
44AKB_JOBSTATEObsolete: Job Status4PROCESSEDNatural Numberint100
TOPPersonnel Management
45/OTEI/PF_TERRATTErroneous processed attachments (only EFM related)4PROCESSEDGeneral Flagnvarchar10
TOPRetail Enterprise Services
46WESD_WINDSAddtional Status for Table WIND6PROCESSEDProcessing Indicatornvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
47NWCH_BOA_ARCHProtokoll-Archiv für die Massendeckungsabfrage29PROCESSEDMassendeckungsabfrage: Kennzeichen "bearbeitet"nvarchar10
48NWCH_BOA_PROTProtokoll für die Massendeckungsabfrage29PROCESSEDMassendeckungsabfrage: Kennzeichen "bearbeitet"nvarchar10
TOPStock Visibility
49/DSD/SV_RLDSD SV Final Unloading Documents4PROCESSEDCheckboxnvarchar10
TOPUpgrade Tools
50CRR_ACCESS_PLANPackage delimitation for initial transfer7PROCESSEDGeneral Flagnvarchar10
TOPWithout Description
51RSDMTU_AWB_MONMonitoring AWB3PROCESSEDPercentage Completed in Batchnvarchar30