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  | EDIDC
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
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Basis Components :: Middleware :: ALE Integration Technology
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EDIDC495Control record (IDoc)ALE Integration Technology
SQL:  selectupdate insert create

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

SELECT MANDT, DOCNUM, DOCREL, STATUS, DOCTYP, DIRECT, RCVPOR, RCVPRT, RCVPRN, RCVSAD, RCVSMN, RCVSNA, RCVSCA, RCVSDF, RCVSLF, RCVLAD, STD, STDVRS, STDMES, MESCOD, MESFCT, OUTMOD, TEST, SNDPOR, SNDPRT, SNDPRN, SNDSAD, SNDSMN, SNDSNA, SNDSCA, SNDSDF, SNDSLF, SNDLAD, REFINT, REFGRP, REFMES, ARCKEY, CREDAT, CRETIM, MESTYP, IDOCTP, CIMTYP, RCVPFC, SNDPFC, SERIAL, EXPRSS, UPDDAT, UPDTIM, MAXSEGNUM FROM EDIDC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOCNUMIDoc numbernvarchar160NUMC(N'0000000000000000')NoEDI_DOCNUM Allow NULL? 
3DOCRELSAP Release for IDocnvarchar40CHAR(N' ')YesEDI_DOCREL Allow NULL? 
4STATUSStatus of IDocnvarchar20CHAR(N' ')YesTEDS1EDI_STATUS Allow NULL? 
5DOCTYPIDoc Typenvarchar80CHAR(N' ')YesEDI_DOCTYP Allow NULL? 
6DIRECTDirection for IDocchar10CHAR(N' ')YesEDI_DIRECT Allow NULL? 
7RCVPORReceiver port (SAP System, EDI subsystem)nvarchar100CHAR(N' ')YesEDI_RCVPOR Allow NULL? 
8RCVPRTPartner Type of Receivernvarchar20CHAR(N' ')YesEDI_RCVPRT Allow NULL? 
9RCVPRNPartner Number of Receivernvarchar100CHAR(N' ')Yes*EDI_RCVPRN Allow NULL? 
10RCVSADRecipient address (SADR)nvarchar100CHAR(N' ')YesEDI_RCVSAD Allow NULL? 
11RCVSMNSADR client (recipient)nvarchar30CLNT(N'000')YesEDI_RCVSMN Allow NULL? 
12RCVSNASADR flag for international recipient addresschar10CHAR(N' ')YesEDI_RCVSNA Allow NULL? 
13RCVSCACommunication type (SADR) of recipientnvarchar30CHAR(N' ')YesEDI_RCVSCA Allow NULL? 
14RCVSDFSADR default flag for recipient addresschar10CHAR(N' ')YesEDI_RCVSDF Allow NULL? 
15RCVSLFSequential Number of Recipient Address (SADR)nvarchar30CHAR(N' ')YesEDI_RCVSLF Allow NULL? 
16RCVLADLogical address of recipientnvarchar700CHAR(N' ')YesEDI_RCVLAD Allow NULL? 
17STDEDI Standardchar10CHAR(N' ')YesEDI_STD Allow NULL? 
18STDVRSVersion of EDI standardnvarchar60CHAR(N' ')YesEDI_STDVRS Allow NULL? 
19STDMESEDI message typenvarchar60CHAR(N' ')YesEDI_STDMES Allow NULL? 
20MESCODLogical Message Variantnvarchar30CHAR(N' ')YesEDI_MESCOD Allow NULL? 
21MESFCTLogical message functionnvarchar30CHAR(N' ')YesEDI_MESFCT Allow NULL? 
22OUTMODOutput Modechar10CHAR(N' ')YesEDI_OUTMOD Allow NULL? 
23TESTTest Flagchar10CHAR(N' ')YesEDI_TEST Allow NULL? 
24SNDPORSender port (SAP System, EDI subsystem)nvarchar100CHAR(N' ')YesEDI_SNDPOR Allow NULL? 
25SNDPRTPartner type of sendernvarchar20CHAR(N' ')YesEDI_SNDPRT Allow NULL? 
26SNDPRNPartner Number of Sendernvarchar100CHAR(N' ')Yes*EDI_SNDPRN Allow NULL? 
27SNDSADSender address (SADR)nvarchar100CHAR(N' ')YesEDI_SNDSAD Allow NULL? 
28SNDSMNSADR client (sender)nvarchar30CLNT(N'000')YesEDI_SNDSMN Allow NULL? 
29SNDSNASADR flag for international sender addresschar10CHAR(N' ')YesEDI_SNDSNA Allow NULL? 
30SNDSCACommunication type (SADR) of sendernvarchar30CHAR(N' ')YesEDI_SNDSCA Allow NULL? 
31SNDSDFSADR default flag for sender addresschar10CHAR(N' ')YesEDI_SNDSDF Allow NULL? 
32SNDSLFSequential Number of the Sender Address (SADR)nvarchar30CHAR(N' ')YesEDI_SNDSLF Allow NULL? 
33SNDLADLogical address of sendernvarchar700CHAR(N' ')YesEDI_SNDLAD Allow NULL? 
34REFINTReference to interchange filenvarchar140CHAR(N' ')YesIDOCCRFINT Allow NULL? 
35REFGRPReference to message groupnvarchar140CHAR(N' ')YesIDOCCRFGRP Allow NULL? 
36REFMESReference to messagenvarchar140CHAR(N' ')YesIDOCCRFMES Allow NULL? 
37ARCKEYEDI archive keynvarchar700CHAR(N' ')YesIDOCCARKEY Allow NULL? 
38CREDATIDoc Created Onnvarchar80DATS(N'00000000')YesEDI_CCRDAT Allow NULL? 
39CRETIMIDoc Created atnvarchar60TIMS(N'000000')YesEDI_CCRTIM Allow NULL? 
40MESTYPMessage Typenvarchar300CHAR(N' ')YesEDMSGEDI_MESTYP Allow NULL? 
41IDOCTPBasic typenvarchar300CHAR(N' ')YesEDBASEDI_IDOCTP Allow NULL? 
42CIMTYPExtensionnvarchar300CHAR(N' ')YesEDCIMEDI_CIMTYP Allow NULL? 
43RCVPFCPartner Function of Receivernvarchar20CHAR(N' ')YesEDI_RCVPFC Allow NULL? 
44SNDPFCPartner Function of Sendernvarchar20CHAR(N' ')YesEDI_SNDPFC Allow NULL? 
45SERIALSerialization fieldnvarchar200CHAR(N' ')YesEDI_SERIAL Allow NULL? 
46EXPRSSOverriding in inbound processingchar10CHAR(N' ')YesEDI_EXPRSS Allow NULL? 
47UPDDATDate on which control record was last changednvarchar80DATS(N'00000000')YesEDI_UPDDAT Allow NULL? 
48UPDTIMTime at which control record was last changednvarchar60TIMS(N'000000')YesEDI_UPDTIM Allow NULL? 
49MAXSEGNUMNumber of data recordsnvarchar60NUMC(N'000000')YesANZEDIDD Allow NULL? 
NamePrimaryUniqueTypeColumns
EDIDC~0YesYesCLUSTEREDDOCNUM, MANDT
EDIDC~1NoNoNONCLUSTEREDSTATUS, MANDT
EDIDC~2NoNoNONCLUSTEREDUPDTIM, UPDDAT, MANDT
EDIDC~3NoNoNONCLUSTEREDMESTYP, MANDT
EDIDC~4NoNoNONCLUSTEREDMESTYP, STATUS, 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