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  | /ECRS/WLEN
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
Global Trade Services :: Electronic Compliance Reporting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/ECRS/WLEN772Worklist for Intrastat DeclarationElectronic Compliance Reporting
SQL:  selectupdate insert create

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

SELECT MANDT, GUID_WLEN, GDSRC, GDOBT, GDOBK, GDOBI, IDSRC, IDOBT, IDOBK, IDOBI, CDSRC, CDOBT, CDOBK, CDOBI, CNSRC, CNOBT, CNOBK, CNOBI, RPYEA, RPMON, GFLOW, ENTYP, GDDAT, IDDAT, CDDAT, ODSRC, ODOBT, ODOBK, ODOBI, POIVA, POIAD, GFPIC, GFPIR, VFPTT, VFPTV, VFPTC, VFPTN, GFPTC, GFPTR, GFPTN, RETFL, TGLFL, COMCD, PRNUM, PRDES, CTYOO, REGOO, GUID_PR, RPCTI, BTTYP, PRCDR, MOTAB, NAOTV, PORTI, INCTM, SPMCO, ORPYE, ORPMO, INVAL, INCUR, STVAL, STCUR, NTWEI, NWUOM, SPQUA, SPUOM, DOQUA, DOUOM, BMQUA, BMUOM, ADDF1, ADDF2, ADDF3, CRTBY, CRTTS, LCHBY, LCHTS FROM /ECRS/WLEN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2GUID_WLENGUID in 'RAW' formatvarbinary160RAWNo/ECRS/GUID_16
3GDSRCGoods Movement: Source Systemnvarchar100CHAR(N' ')YesTBDLS/ECRS/GDSRC Allow NULL? 
4GDOBTGoods Movement: Object Typenvarchar100CHAR(N' ')Yes/ECRS/GDOBT Allow NULL? 
5GDOBKGoods Movement: Object Key/Document Numbernvarchar400CHAR(N' ')Yes/ECRS/GDOBK Allow NULL? 
6GDOBIGoods Movement: Item Numbernvarchar100CHAR(N' ')Yes/ECRS/GDOBI Allow NULL? 
7IDSRCInvoice for Goods Movement: Source Systemnvarchar100CHAR(N' ')YesTBDLS/ECRS/IDSRC Allow NULL? 
8IDOBTInvoice for Goods Movement: Object Typenvarchar100CHAR(N' ')Yes/ECRS/IDOBT Allow NULL? 
9IDOBKInvoice for Goods Movement: Object Key/Document Numbernvarchar400CHAR(N' ')Yes/ECRS/IDOBK Allow NULL? 
10IDOBIInvoice for Goods Movement: Item Numbernvarchar100CHAR(N' ')Yes/ECRS/IDOBI Allow NULL? 
11CDSRCCorrection: Source Systemnvarchar100CHAR(N' ')YesTBDLS/ECRS/CDSRC Allow NULL? 
12CDOBTCorrection: Object Typenvarchar100CHAR(N' ')Yes/ECRS/CDOBT Allow NULL? 
13CDOBKCorrection: Object Key/Document Numbernvarchar400CHAR(N' ')Yes/ECRS/CDOBK Allow NULL? 
14CDOBICorrection: Item Numbernvarchar100CHAR(N' ')Yes/ECRS/CDOBI Allow NULL? 
15CNSRCCancellation: Source Systemnvarchar100CHAR(N' ')YesTBDLS/ECRS/CNSRC Allow NULL? 
16CNOBTCancellation: Object Typenvarchar100CHAR(N' ')Yes/ECRS/CNOBT Allow NULL? 
17CNOBKCancellation: Object Key/Document Numbernvarchar400CHAR(N' ')Yes/ECRS/CNOBK Allow NULL? 
18CNOBICancellation: Item Numbernvarchar100CHAR(N' ')Yes/ECRS/CNOBI Allow NULL? 
19RPYEADeclaration Yearnvarchar40NUMC(N'0000')Yes/ECRS/RPYEA Allow NULL? 
20RPMONDeclaration Monthnvarchar20CHAR(N' ')Yes/ECRS/RPMON Allow NULL? 
21GFLOWFlow of Goodschar10CHAR(N' ')Yes/ECRS/GFLOW Allow NULL? 
22ENTYPType of Entry in Worklistchar10CHAR(N' ')Yes/ECRS/ENTYP Allow NULL? 
23GDDATDate of Goods Movementnvarchar80DATS(N'00000000')Yes/ECRS/GDDAT Allow NULL? 
24IDDATDate of Invoice for Goods Movementnvarchar80DATS(N'00000000')Yes/ECRS/IDDAT Allow NULL? 
25CDDATDate of Correction or Cancellationnvarchar80DATS(N'00000000')Yes/ECRS/CDDAT Allow NULL? 
26ODSRCSales/Purchasing Document: Source Systemnvarchar100CHAR(N' ')YesTBDLS/ECRS/ODSRC Allow NULL? 
27ODOBTSales/Purchasing Document: Object Typenvarchar100CHAR(N' ')Yes/ECRS/ODOBT Allow NULL? 
28ODOBKSales/Purchasing Document: Object Key/Document Numbernvarchar400CHAR(N' ')Yes/ECRS/ODOBK Allow NULL? 
29ODOBISales/Purchasing Document: Item Numbernvarchar100CHAR(N' ')Yes/ECRS/ODOBI Allow NULL? 
30POIVAVAT Registration Number of Provider of Informationnvarchar200CHAR(N' ')Yes/ECRS/POIVA Allow NULL? 
31POIADAdditional Number of Provider of Informationnvarchar50CHAR(N' ')Yes/ECRS/POIAD Allow NULL? 
32GFPICCountry of Provider of Information (Flow of Goods) (Int.SAP)nvarchar30CHAR(N' ')YesT005/ECRS/GFPIC Allow NULL? 
33GFPIRRegion of Provider of Information (Flow of Goods) (Int. SAP)nvarchar30CHAR(N' ')YesT005S/ECRS/GFPIR Allow NULL? 
34VFPTTPartner Type (Value Flow)char10CHAR(N' ')Yes/ECRS/VFPTT Allow NULL? 
35VFPTVPartner VAT Registration Number (Value Flow)nvarchar200CHAR(N' ')Yes/ECRS/VFPTV Allow NULL? 
36VFPTCPartner Country (Value Flow) (Internal SAP Code)nvarchar30CHAR(N' ')YesT005/ECRS/VFPTC Allow NULL? 
37VFPTNPartner Number (Value Flow)nvarchar100CHAR(N' ')Yes*/ECRS/VFPTN Allow NULL? 
38GFPTCPartner Country (Flow of Goods) (Internal SAP Code)nvarchar30CHAR(N' ')YesT005/ECRS/GFPTC Allow NULL? 
39GFPTRRegion in Partner Country (Flow of Goods) (Int. SAP Code)nvarchar30CHAR(N' ')YesT005S/ECRS/GFPTR Allow NULL? 
40GFPTNPartner Number (Flow of Goods)nvarchar100CHAR(N' ')Yes*/ECRS/GFPTN Allow NULL? 
41RETFLIndicator: Returnschar10CHAR(N' ')Yes/ECRS/RETFL Allow NULL? 
42TGLFLIndicator: Triangular Transaction Within the EUchar10CHAR(N' ')Yes/ECRS/TGLFL Allow NULL? 
43COMCDCommodity Codenvarchar300CHAR(N' ')Yes/ECRS/COMCD Allow NULL? 
44PRNUMProduct IDnvarchar400CHAR(N' ')YesCOMT_PRODUCT_ID Allow NULL? 
45PRDESProduct Descriptionnvarchar600CHAR(N' ')Yes/ECRS/PRDES Allow NULL? 
46CTYOOCountry of Origin (Internal SAP Code)nvarchar30CHAR(N' ')YesT005/ECRS/CTYOO Allow NULL? 
47REGOORegion of Origin (Internal SAP Code)nvarchar30CHAR(N' ')YesT005S/ECRS/REGOO Allow NULL? 
48GUID_PRGUID in 'RAW' formatvarbinary160RAWYes/ECRS/GUID_16
49RPCTICountry of Declaration (ISO Code)nvarchar20CHAR(N' ')Yes/ECRS/TRPC/ECRS/RPCTI Allow NULL? 
50BTTYPBusiness Transaction Type (Intrastat Code)nvarchar20CHAR(N' ')Yes/ECRS/TBTT/ECRS/BTTYP Allow NULL? 
51PRCDRProcedure (Intrastat Code)nvarchar50CHAR(N' ')Yes/ECRS/TPRC/ECRS/PRCDR Allow NULL? 
52MOTABMode of Transport at the Border (Intrastat Code)char10CHAR(N' ')Yes/ECRS/TMOT/ECRS/MOTAB Allow NULL? 
53NAOTVCountry of Means of Transportnvarchar30CHAR(N' ')Yes*/ECRS/NAOTV Allow NULL? 
54PORTIPort/Airport (Intrastat Code)nvarchar40CHAR(N' ')Yes/ECRS/TPRT/ECRS/PORTI Allow NULL? 
55INCTMIncotermsnvarchar30CHAR(N' ')Yes/ECRS/INCTM Allow NULL? 
56SPMCOSpecial Movement Code (Intrastat Code)nvarchar20CHAR(N' ')Yes/ECRS/TSMC/ECRS/SPMCO Allow NULL? 
57ORPYEDeclaration Year of Original Entrynvarchar40NUMC(N'0000')Yes/ECRS/ORPYE Allow NULL? 
58ORPMODeclaration Month of Original Entrynvarchar20CHAR(N' ')Yes/ECRS/ORPMO Allow NULL? 
59INVALInvoice Valuedecimal152CURR((0))Yes/ECRS/INVAL
60INCURCurrency Key for Invoice Valuenvarchar50CUKY(N' ')YesTCURC/ECRS/INCUR Allow NULL? 
61STVALStatistical Valuedecimal152CURR((0))Yes/ECRS/STVAL
62STCURCurrency Key for Statistical Valuenvarchar50CUKY(N' ')YesTCURC/ECRS/STCUR Allow NULL? 
63NTWEINet Weightdecimal133QUAN((0))Yes/ECRS/NTWEI
64NWUOMUnit of Measure for Net Weightnvarchar30UNIT(N' ')YesT006/ECRS/NWUOM Allow NULL? 
65SPQUAQuantity in Supplementary Unitdecimal133QUAN((0))Yes/ECRS/SPQUA
66SPUOMSupplementary Unitnvarchar30UNIT(N' ')YesT006/ECRS/SPUOM Allow NULL? 
67DOQUAQuantity in Document Unit of Measuredecimal133QUAN((0))Yes/ECRS/DOQUA
68DOUOMDocument Unit of Measurenvarchar30UNIT(N' ')YesT006/ECRS/DOUOM Allow NULL? 
69BMQUAQuantity in Base Unit of Measuredecimal133QUAN((0))Yes/ECRS/BMQUA
70BMUOMBase Unit of Measurenvarchar30UNIT(N' ')YesT006/ECRS/BMUOM Allow NULL? 
71ADDF1Additional Field 1nvarchar50CHAR(N' ')Yes/ECRS/ADDF1 Allow NULL? 
72ADDF2Additional Field 2nvarchar100CHAR(N' ')Yes/ECRS/ADDF2 Allow NULL? 
73ADDF3Additional Field 3nvarchar150CHAR(N' ')Yes/ECRS/ADDF3 Allow NULL? 
74CRTBYName of User Who Added Objectnvarchar120CHAR(N' ')YesUSR02/ECRS/CRTBY Allow NULL? 
75CRTTSUTC Time Stamp When Object Was Addeddecimal150DEC((0))Yes/ECRS/CRTTS
76LCHBYName of User Who Changed Objectnvarchar120CHAR(N' ')YesUSR02/ECRS/LCHBY Allow NULL? 
77LCHTSUTC Time Stamp When Object Was Changeddecimal150DEC((0))Yes/ECRS/LCHTS
NamePrimaryUniqueTypeColumns
/ECRS/WLEN~0YesYesCLUSTEREDGUID_WLEN, MANDT
/ECRS/WLEN~I1NoNoNONCLUSTEREDPOIAD, GFLOW, RPMON, RPYEA, POIVA, 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