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
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JKTWBZOUT501IS-M/SD: Clipboard for Processed WBZ RecordsPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, RZNR, DATUM, FILE_IN, ZAEHLER, WBZSATZART, VERLAGSNR, WBZKUNNR, VERTRKENNZ, RECHZENTNR, WBZVORGART, ABONR, WBZTERMIN, EXEMPLARE, HEFTANZAHL, ABOART, WERBKZSCHL, WERBKZBETR, PLZ, FILLER_15, LAND, ANREDE, NAME, ANSCHZUS, ANSCHZUSKZ, STRASSE, ORT, VERSANDART, VERTRETER, FEHLERNR, JAHR_HEFT, FILLER_27, VERTRBEGIN, PLZ_NEU, WBZABOKUNR, FILLER_31, AKTION, ANZ_MONATE, WBZTERMIN_2, NAMENSZUSATZ, WAEHRUNG, TITEL, VORNAME, NACHNAME, NAME_2, NAME_3, STRASSE_ZUSATZ, ORT_ZUSATZ, EMAIL, WBZVERSION FROM JKTWBZOUT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2RZNRIS-M: WBZ, Computer Center Numbernvarchar20CHAR(N' ')NoTJKW0JWBZRZNR Allow NULL? 
3DATUMIS-M: Date in file name of WBZ filenvarchar80DATS(N'00000000')NoJWBZDATUM Allow NULL? 
4FILE_INLogical file namenvarchar600CHAR(N' ')NoFILENAMECIFILEINTERN Allow NULL? 
5ZAEHLERIS-M: Consecutive Counter for Transfer of External Datanvarchar80NUMC(N'00000000')NoJFILE_CNT Allow NULL? 
6WBZSATZARTIS-M: WBZ, Record Typenvarchar30CHAR(N' ')YesTJKW1JWBZSTZART Allow NULL? 
7VERLAGSNRIS-M: VDZ Publisher Numbernvarchar50CHAR(N' ')YesJWBZVRLGNR Allow NULL? 
8WBZKUNNRIS-M: WBZ, VDZ Number of WBZ Companynvarchar60CHAR(N' ')YesJWBZKUNNR Allow NULL? 
9VERTRKENNZIS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)nvarchar50CHAR(N' ')YesTJKWEJWBZVKENNZ Allow NULL? 
10RECHZENTNRIS-M: WBZ, Computer Center Numbernvarchar20CHAR(N' ')YesTJKW0JWBZRZNR Allow NULL? 
11WBZVORGARTIS-M: WBZ, Operation Typenvarchar30CHAR(N' ')YesTJKW3JWBZVORART Allow NULL? 
12ABONRIS-M: WBZ, Subscription Numbernvarchar120CHAR(N' ')YesJWBZABONR Allow NULL? 
13WBZTERMINIS-M: WBZ, Date (Format: MMYYYYCCCC)nvarchar90CHAR(N' ')YesJWBZTERMIN Allow NULL? 
14EXEMPLAREIS-M: WBZ, Number of Copiesnvarchar20NUMC(N'00')YesJWBZEXEMPL Allow NULL? 
15HEFTANZAHLIS-M: WBZ, Number of Copiesnvarchar20CHAR(N' ')YesJWBZHFTANZ Allow NULL? 
16ABOARTIS-M: WBZ, Subscriber Typenvarchar30CHAR(N' ')YesJWBZABOART Allow NULL? 
17WERBKZSCHLIS-M: WBZ, Promotion Rebate Keychar10CHAR(N' ')YesTJKW9JWBZWKZSCH Allow NULL? 
18WERBKZBETRIS-M: WBZ, Promotion Rebate Amountnvarchar50CHAR(N' ')YesJWBZWKZBTR Allow NULL? 
19PLZIS-M: WBZ, Postal Codenvarchar80CHAR(N' ')YesJWBZPLZ Allow NULL? 
20FILLER_15IS-M: WBZ, data transfer structure field 15 (remains blank)nvarchar30CHAR(N' ')YesJWBZFELD15 Allow NULL? 
21LANDVehicle country keynvarchar30CHAR(N' ')YesLANDK Allow NULL? 
22ANREDEIS-M: WBZ, Form-of-Address Keychar10CHAR(N' ')YesTJKW5JWBZANREDE Allow NULL? 
23NAMEIS-M: WBZ, Last and First Namenvarchar300CHAR(N' ')YesJWBZNAME Allow NULL? 
24ANSCHZUSIS-M: WBZ, Address Affixnvarchar300CHAR(N' ')YesJWBZANSZUS Allow NULL? 
25ANSCHZUSKZIS-M: WBZ, indicator for address affixchar10CHAR(N' ')YesJWBZANSZKZ Allow NULL? 
26STRASSEIS-M: WBZ, streetnvarchar300CHAR(N' ')YesJWBZSTRASS Allow NULL? 
27ORTIS-M: WBZ, citynvarchar250CHAR(N' ')YesJWBZORT Allow NULL? 
28VERSANDARTIS-M: WBZ, Shipping Typenvarchar20CHAR(N' ')YesJWBZVSART Allow NULL? 
29VERTRETERIS-M: WBZ, representative indicatornvarchar70CHAR(N' ')YesJWBZVERTR Allow NULL? 
30FEHLERNRIS-M: WBZ, error numbernvarchar30CHAR(N' ')YesTJKW7JWBZFEHLNR Allow NULL? 
31JAHR_HEFTIS-M: Year and Copy Numbernvarchar70CHAR(N' ')YesJWBZJHRHFT Allow NULL? 
32FILLER_27Character Field with Length 5nvarchar50CHAR(N' ')YesCHAR05 Allow NULL? 
33VERTRBEGINIS-M: WBZ, Contract Date (DDMMYY)nvarchar60CHAR(N' ')YesJWBZVERTBG Allow NULL? 
34PLZ_NEUIS-M: WBZ, new postal code (to July 1st 1994)nvarchar50CHAR(N' ')YesJWBZPLZNEU Allow NULL? 
35WBZABOKUNRIS-M: Subscription Customer Numbernvarchar90CHAR(N' ')YesJWBZABOKNR Allow NULL? 
36FILLER_31IS-M: Character Field 7 Chars in Lengthnvarchar70CHAR(N' ')YesCHAR007 Allow NULL? 
37AKTIONIS-M/SD: WBZ, Sales Promotion/Condition Keynvarchar30NUMC(N'000')YesJWBZAKTION Allow NULL? 
38ANZ_MONATEIS-M/SD: WBZ, Number of Months for Scaled Promotion Rebatenvarchar30NUMC(N'000')YesJWBZANZ_MONATE Allow NULL? 
39WBZTERMIN_2IS-M/SD: WBZ, Second Date Field (YYYYNNN)nvarchar70NUMC(N'0000000')YesJWBZTERMIN_2 Allow NULL? 
40NAMENSZUSATZIS-M/SD: WBZ, Name Affixnvarchar300CHAR(N' ')YesJWBZNAMENSZUSATZ Allow NULL? 
41WAEHRUNGIS-M/SD: WBZ, Currencynvarchar30CHAR(N' ')YesJWBZWAEHRUNG Allow NULL? 
42TITELIS-M/SD: WBZ, Titlenvarchar150CHAR(N' ')YesJWBZTITEL Allow NULL? 
43VORNAMEIS-M: WBZ, First Namenvarchar300CHAR(N' ')YesJWBZVORNAME Allow NULL? 
44NACHNAMEIS-M: WBZ, Last Namenvarchar300CHAR(N' ')YesJWBZNACHNAME Allow NULL? 
45NAME_2IS-M: WBZ, Second Line for Namenvarchar300CHAR(N' ')YesJWBZNAME_2 Allow NULL? 
46NAME_3IS-M: WBZ, Third Line for Namenvarchar300CHAR(N' ')YesJWBZNAME_3 Allow NULL? 
47STRASSE_ZUSATZIS-M/SD: WBZ, Additional Data for Streetnvarchar300CHAR(N' ')YesJWBZSTRASS_ZUSATZ Allow NULL? 
48ORT_ZUSATZIS-M/SD: WBZ, Affix for Citynvarchar300CHAR(N' ')YesJWBZORT_ZUSATZ Allow NULL? 
49EMAILIS-M/SD: WBZ, E-Mail Addressnvarchar500CHAR(N' ')YesJWBZEMAIL Allow NULL? 
50WBZVERSIONIS-M/SD: WBZ, WBZ Versionnvarchar30CHAR(N' ')YesJWBZVERSION Allow NULL? 
NamePrimaryUniqueTypeColumns
JKTWBZOUT~0YesYesCLUSTEREDZAEHLER, FILE_IN, DATUM, RZNR, MANDT