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
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
1ERP EHP76.0/1MD/MD______0A9562Z5 Check Table ZRECORD
SQL:  selectupdate insert create

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

SELECT MANDT, USMDKZ5ZRECORD, USMD_ACTIVE, /1MD/Z5ZRECORD, USMD_OBS_TCK, /1MD/Z5AIRDATEFR, /1MD/Z5BWCOLOR, /1MD/Z5CATALOGID, /1MD/Z5EARRELUSD, /1MD/Z5EDTYPE, /1MD/Z5EIDR, /1MD/Z5EPISODE, /1MD/Z5EPPART, /1MD/Z5FAMILY, /1MD/Z5FIRSTRELM, /1MD/Z5FISRELYR, /1MD/Z5FRANCHISE, /1MD/Z5IDTYPE, /1MD/Z5IMDBID, /1MD/Z5IMDBLINK, /1MD/Z5INITRELDT, /1MD/Z5ISANNUM, /1MD/Z5LIFECYCLE, /1MD/Z5MADEFMED, /1MD/Z5PDTTITLE, /1MD/Z5PDTTYPE, /1MD/Z5PRFTCNTR, /1MD/Z5PRODCOMP1, /1MD/Z5PRODTYPE, /1MD/Z5PRODUCT, /1MD/Z5PRORATING, /1MD/Z5PRUNTIME, /1MD/Z5RECTYPE, /1MD/Z5REFERENCE, /1MD/Z5REFID, /1MD/Z5SEASON, /1MD/Z5SOUNDFORM, /1MD/Z5SOURCE, /1MD/Z5TERRITORY, /1MD/Z5TITLENAME, /1MD/Z5TITLETYPE, /1MD/Z5TITLNTYPE, /1MD/Z5TITOTHER, /1MD/Z5ZACTORNAM, /1MD/Z5ZAIRLINES, /1MD/Z5ZCITY, /1MD/Z5ZDELTYPE, /1MD/Z5ZDIRECTOR, /1MD/Z5ZRENTALST, /1MD/Z5ZSTREAMIN, /1MD/Z5ZTIREGION, USMD_ENT_CRTD_AT, USMD_ENT_CRTD_BY, USMD_ENT_CHNG_AT, USMD_ENT_CHNG_BY, USMDKZ5HAS_REFER FROM /1MD/MD______0A9
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2USMDKZ5ZRECORDTechnical Keyint100INT4((0))NoUSMD_TECH_KEY Allow NULL? 
3USMD_ACTIVEActive/Inactive Data Recordchar10CHAR(N' ')NoUSMD_ACTIVE Allow NULL? 
4/1MD/Z5ZRECORDRecord IDnvarchar130CHAR(N' ')YesZRECORD_ID Allow NULL? 
5USMD_OBS_TCKObsolete Data Recordchar10CHAR(N' ')YesUSMD_OBSOLETE Allow NULL? 
6/1MD/Z5AIRDATEFRAir Date Frequencychar10CHAR(N' ')YesZAIRDATEFREQUENCY Allow NULL? 
7/1MD/Z5BWCOLORB/W Colornvarchar200CHAR(N' ')YesZBWCOLOR Allow NULL? 
8/1MD/Z5CATALOGIDCatalog IDnvarchar100CHAR(N' ')YesZCATALOGID Allow NULL? 
9/1MD/Z5EARRELUSDEarliest Release US Datenvarchar80DATS(N'00000000')YesZEARRELUSDAT Allow NULL? 
10/1MD/Z5EDTYPEEdition Typenvarchar20CHAR(N' ')YesZEDITIONTYPE Allow NULL? 
11/1MD/Z5EIDREIDRnvarchar1000CHAR(N' ')YesZEIDR Allow NULL? 
12/1MD/Z5EPISODEEpisodenvarchar30CHAR(N' ')YesZEPISODE Allow NULL? 
13/1MD/Z5EPPARTEpisode Partchar10CHAR(N' ')YesZEPISODEPART Allow NULL? 
14/1MD/Z5FAMILYFamily IDnvarchar130CHAR(N' ')YesZFAMILY_ID Allow NULL? 
15/1MD/Z5FIRSTRELMFirst Release Medianvarchar1000CHAR(N' ')YesZFIRSTRELMEDIA Allow NULL? 
16/1MD/Z5FISRELYRFiscal Release Yearnvarchar40CHAR(N' ')YesZFISCALRELEASEYEAR Allow NULL? 
17/1MD/Z5FRANCHISEFranchise Groupnvarchar500CHAR(N' ')YesZFRANCHISEGROUP Allow NULL? 
18/1MD/Z5IDTYPEIdentifier Typenvarchar300CHAR(N' ')YesZIDTYPE Allow NULL? 
19/1MD/Z5IMDBIDIMDB IDnvarchar100CHAR(N' ')YesZIMDBID Allow NULL? 
20/1MD/Z5IMDBLINKIMDB Linknvarchar1000CHAR(N' ')YesZIMDBLINK Allow NULL? 
21/1MD/Z5INITRELDTInitial Release Datenvarchar80DATS(N'00000000')YesZINITIALRELEASEDATE Allow NULL? 
22/1MD/Z5ISANNUMISAN Numbernvarchar400CHAR(N' ')YesZISANNUM Allow NULL? 
23/1MD/Z5LIFECYCLETitle Life Cycle Statusnvarchar200CHAR(N' ')YesZTITLELIFECYCLESTATUS Allow NULL? 
24/1MD/Z5MADEFMEDMade for Medianvarchar500CHAR(N' ')YesZMADEFORMEDIA Allow NULL? 
25/1MD/Z5PDTTITLEProduct Title - Primary Offical Titlenvarchar600CHAR(N' ')YesZPDTTITLE Allow NULL? 
26/1MD/Z5PDTTYPEProduct Typenvarchar20CHAR(N' ')YesZPDTTYPE Allow NULL? 
27/1MD/Z5PRFTCNTRProfit Centernvarchar100NUMC(N'0000000000')YesZPROFITCENTER Allow NULL? 
28/1MD/Z5PRODCOMP1Production Company 1nvarchar2000CHAR(N' ')YesZPRODCOMP1 Allow NULL? 
29/1MD/Z5PRODTYPEProduct Typenvarchar500CHAR(N' ')YesZPRODTYPE Allow NULL? 
30/1MD/Z5PRODUCTProduct IDnvarchar130CHAR(N' ')YesZPRODUCT_ID Allow NULL? 
31/1MD/Z5PRORATINGProduct Ratingnvarchar50CHAR(N' ')YesZPDTRATING Allow NULL? 
32/1MD/Z5PRUNTIMERun Time (min)nvarchar30NUMC(N'000')YesZRUNTIME Allow NULL? 
33/1MD/Z5RECTYPERecord Typenvarchar200CHAR(N' ')YesZRECTYPE Allow NULL? 
34/1MD/Z5REFERENCEReference Typenvarchar200CHAR(N' ')YesZREFERENCETYPE Allow NULL? 
35/1MD/Z5REFIDReference IDnvarchar500CHAR(N' ')YesZREFERENCEID Allow NULL? 
36/1MD/Z5SEASONSeasonnvarchar20CHAR(N' ')YesZSEASON Allow NULL? 
37/1MD/Z5SOUNDFORMSound Formatnvarchar500CHAR(N' ')YesZSOUNDFORMAT Allow NULL? 
38/1MD/Z5SOURCESourcenvarchar100CHAR(N' ')YesZSOURCE Allow NULL? 
39/1MD/Z5TERRITORYTerrirotynvarchar30CHAR(N' ')Yes*ZTERRITORY Allow NULL? 
40/1MD/Z5TITLENAMETitle Namenvarchar1500CHAR(N' ')YesZTITLENAME Allow NULL? 
41/1MD/Z5TITLETYPETitle Typenvarchar300CHAR(N' ')YesZTITLETYPE Allow NULL? 
42/1MD/Z5TITLNTYPETitle Name Typenvarchar500CHAR(N' ')YesZTITLENAMTYP Allow NULL? 
43/1MD/Z5TITOTHERProduct Title - Othernvarchar600CHAR(N' ')YesZPDTTITLEOTHER Allow NULL? 
44/1MD/Z5ZACTORNAMActornvarchar1000CHAR(N' ')YesZACTORNAME Allow NULL? 
45/1MD/Z5ZAIRLINESAirlinestinyint30INT1((0))YesZAIRLINES
46/1MD/Z5ZCITYCitynvarchar500CHAR(N' ')YesZCITY Allow NULL? 
47/1MD/Z5ZDELTYPEDelivery Typenvarchar500CHAR(N' ')YesZDELIVERYTYPE Allow NULL? 
48/1MD/Z5ZDIRECTORDirectornvarchar1000CHAR(N' ')YesZDIRECTOR Allow NULL? 
49/1MD/Z5ZRENTALSTRental Storestinyint30INT1((0))YesZRENTALSTORES
50/1MD/Z5ZSTREAMINStreamingtinyint30INT1((0))YesZSTREAMING
51/1MD/Z5ZTIREGIONTitle Regionnvarchar500CHAR(N' ')YesZTITLEREGION Allow NULL? 
52USMD_ENT_CRTD_ATCreated Ondecimal150DEC((0))YesUSMD_ENTITY_CREATED_AT
53USMD_ENT_CRTD_BYCreated Bynvarchar120CHAR(N' ')Yes*USMD_ENTITY_CREATED_BY Allow NULL? 
54USMD_ENT_CHNG_ATChanged Ondecimal150DEC((0))YesUSMD_ENTITY_CHANGED_AT
55USMD_ENT_CHNG_BYChanged Bynvarchar120CHAR(N' ')Yes*USMD_ENTITY_CHANGED_BY Allow NULL? 
56USMDKZ5HAS_REFERTechnical Keyint100INT4((0))YesUSMD_TECH_KEY Allow NULL? 
NamePrimaryUniqueTypeColumns
/1MD/MD______0A901NoYesNONCLUSTEREDUSMD_ACTIVE, /1MD/Z5ZRECORD, MANDT
/1MD/MD______0A9~0YesYesCLUSTEREDUSMD_ACTIVE, USMDKZ5ZRECORD, MANDT