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.0JITCIRCBOOK764IS-M/SD: Circulation Book with Delivery QuantitiesPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, JCBKEY, CIRC_ORIGIN, ISSUE, PUBL_ORDER, EDITION_ORDER, DELIV_RETRN_DATE, DLVRYDOCTYPE, AUDITCAT, NRMLCOUNTRY, CUKY_SDOC, MIXTYPE, BILLFREQ, PRICEPER, PRCGRPCUST, RATE_CODE, CT_SPRICE, SUBS_PRICE, TAX_CODE, CUKY_SPRICE, CUST_GROUP, SALES_ORG, DISTR_CHAN, PYMT_METH, SDOC_TYPE, ITEM_TYPE, DELIVTYPE_ORDER, DELIVTYPE_LOG, ACT_COUNTRY, POSTAL_CODE, POSTAL_ZONE, PLANT, CFIELD1, CFIELD2, CFIELD3, CFIELD4, CFIELD5, CFIELD6, MEDIAISSUE, MEDPRODFAM_SOLD, MEDIAPROD_SOLD, SDOC_TYPE_SD, ITEM_TYPE_SD, KREISG_SCH, REGIO, COUNC, POSTEINORT, NDM_ABC_ZONE, TRAD_ABC_ZONE, BEZPER, WEEKDAY, WERBEAKT, CAID_ED_ORDER, PUBL_DELIV, EDITION_DELIV, MEDIAPRODUCTFAM, MEDIAPRODUCT, PUBL_DATE, IPER_DATE, COPY_NO_ISSUE, CAID_ED_DELIV, DIVI_PUBLCTN, CIRC_FIGURE, CIRC_FIG_INSERT, CIRC_FIG_COMB, SALES_UNIT, AUFMELDART, PZVARCB, ERFUSER, ERFDATE, ERFTIME, ERFPROG, AENUSER, AENDATE, AENTIME, AENPROG FROM JITCIRCBOOK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2JCBKEYTechnical surrogate key for circulation booknvarchar200NUMC(N'00000000000000000000')NoJCBKEY Allow NULL? 
3CIRC_ORIGINTechnical data origin of circulationchar10CHAR(N' ')YesJ_CIRC_ORIGIN Allow NULL? 
4ISSUEIssuenvarchar100CHAR(N' ')Yes*VAUSGB Allow NULL? 
5PUBL_ORDEROrder Publicationnvarchar80CHAR(N' ')Yes*DRERZAUFTR Allow NULL? 
6EDITION_ORDEROrder-related editionnvarchar80CHAR(N' ')Yes*PVAAUFTR Allow NULL? 
7DELIV_RETRN_DATEShipping date or return date of delivered/returned issuesnvarchar80DATS(N'00000000')YesVERSREMIDAT Allow NULL? 
8DLVRYDOCTYPEType of Deliverychar10CHAR(N' ')YesLFNGART Allow NULL? 
9AUDITCATCirculation Audit Report Category IDnvarchar80CHAR(N' ')YesTJI01IVWKN Allow NULL? 
10NRMLCOUNTRYNormal delivery countrynvarchar30CHAR(N' ')Yes*LAND1_ISP Allow NULL? 
11CUKY_SDOCSD Document Currencynvarchar50CUKY(N' ')Yes*WAERK Allow NULL? 
12MIXTYPEMix Typenvarchar20CHAR(N' ')YesJDTBEZTYPBEZUGSTYP_JE_PVA Allow NULL? 
13BILLFREQBilling Frequencynvarchar20CHAR(N' ')Yes*FKPER Allow NULL? 
14PRICEPERIS-M: Price Frequencynvarchar20CHAR(N' ')Yes*PRSPER Allow NULL? 
15PRCGRPCUSTPrice group (customer)nvarchar20CHAR(N' ')Yes*KONDA Allow NULL? 
16RATE_CODEIS-M/SD: Rate Codenvarchar40CHAR(N' ')Yes*RATE_CODE Allow NULL? 
17CT_SPRICECondition Type for Purchase Pricenvarchar40CHAR(N' ')Yes*CTYPE_SPRICE Allow NULL? 
18SUBS_PRICEPurchase pricenvarchar130CHAR(N' ')YesJBEZPRS Allow NULL? 
19TAX_CODETax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
20CUKY_SPRICECurrency key for purchase pricenvarchar50CUKY(N' ')Yes*JCURRBEZPRS Allow NULL? 
21CUST_GROUPCustomer groupnvarchar20CHAR(N' ')Yes*KDGRP Allow NULL? 
22SALES_ORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
23DISTR_CHANDistribution Channelnvarchar20CHAR(N' ')Yes*VTWEG Allow NULL? 
24PYMT_METHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
25SDOC_TYPEIS-M/SD: Sales Document Typesnvarchar40CHAR(N' ')YesTJAKAUART_ISP Allow NULL? 
26ITEM_TYPEInternal Item Type for Sales Ordernvarchar20CHAR(N' ')Yes*POART_ISP Allow NULL? 
27DELIVTYPE_ORDERDelivery Type for Order Delivery Viability Setnvarchar20CHAR(N' ')Yes*LFARTAUFTR Allow NULL? 
28DELIVTYPE_LOGLogistical delivery typenvarchar20CHAR(N' ')Yes*LFARTLOG Allow NULL? 
29ACT_COUNTRYCurrent country being suppliednvarchar30CHAR(N' ')Yes*LANDE_ISP Allow NULL? 
30POSTAL_CODEIS-M: Postal Codenvarchar100CHAR(N' ')YesPLZ_ISP Allow NULL? 
31POSTAL_ZONEPostal code evaluation areanvarchar60CHAR(N' ')Yes*JPLZAWGEB Allow NULL? 
32PLANTPlantnvarchar40CHAR(N' ')Yes*JWERK Allow NULL? 
33CFIELD1Field 1 for definition by customer (max. 10 characters)nvarchar100CHAR(N' ')NoJICFIELD1 Allow NULL? 
34CFIELD2Customer field 2 (max. 10 characters)nvarchar100CHAR(N' ')NoJICFIELD2 Allow NULL? 
35CFIELD3Customer field 3 (max. 18 characters)nvarchar180CHAR(N' ')NoJICFIELD3 Allow NULL? 
36CFIELD4Customer Field 4 (Max. 18 Characters)nvarchar180CHAR(N' ')NoJICFIELD4 Allow NULL? 
37CFIELD5Customer Field 5 (Max. 18 Characters)nvarchar180CHAR(N' ')YesJICFIELD5 Allow NULL? 
38CFIELD6Customer Field 5 (Max. 18 Characters)nvarchar180CHAR(N' ')YesJICFIELD5 Allow NULL? 
39MEDIAISSUEMedia Issuenvarchar180CHAR(N' ')Yes*ISMMATNR_ISSUE Allow NULL? 
40MEDPRODFAM_SOLDMedia product family soldnvarchar180CHAR(N' ')Yes*MEDIAPRODUCTFAM_SOLD Allow NULL? 
41MEDIAPROD_SOLDMedia product soldnvarchar180CHAR(N' ')Yes*MEDIAPRODUCT_SOLD Allow NULL? 
42SDOC_TYPE_SDSales Document Typenvarchar40CHAR(N' ')Yes*AUART Allow NULL? 
43ITEM_TYPE_SDSales document item categorynvarchar40CHAR(N' ')Yes*PSTYV Allow NULL? 
44KREISG_SCHIS-M: District municipality key of ship-to partynvarchar150CHAR(N' ')Yes*KGS_ORDER Allow NULL? 
45REGIORegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
46COUNCCounty Codenvarchar30CHAR(N' ')Yes*COUNC Allow NULL? 
47POSTEINORTIS-M: City Number (Unique)nvarchar80CHAR(N' ')Yes*JALORT Allow NULL? 
48NDM_ABC_ZONENewspaper Designated Market Zone for ABCchar10CHAR(N' ')YesNDM_ABC_ZONE Allow NULL? 
49TRAD_ABC_ZONEZone According to CTZ, RTZ, OTZ for ABCchar10CHAR(N' ')YesTRAD_ABC_ZONE Allow NULL? 
50BEZPERService Typenvarchar50CHAR(N' ')Yes*BEZPER Allow NULL? 
51WEEKDAYIS-M: Number of Weekdaychar10NUMC(N'0')YesTJPWEEKDAYISM_WEEKDAY Allow NULL? 
52WERBEAKTSales Promotionnvarchar80CHAR(N' ')Yes*WERBEAKT Allow NULL? 
53CAID_ED_ORDERAudit Report ID of Edition Purchased in Ordernvarchar100NUMC(N'0000000000')YesCIRCAUD_ID_EO Allow NULL? 
54PUBL_DELIVActual Publication Deliverednvarchar80CHAR(N' ')Yes*DRERZTAT Allow NULL? 
55EDITION_DELIVActual edition deliverednvarchar80CHAR(N' ')Yes*PVATAT Allow NULL? 
56MEDIAPRODUCTFAMMedia Product Familynvarchar180CHAR(N' ')Yes*MEDIAPRODUCTFAM Allow NULL? 
57MEDIAPRODUCTMedia Productnvarchar180CHAR(N' ')Yes*ISMMATNR_PRODUCT Allow NULL? 
58PUBL_DATEPublication Datenvarchar80DATS(N'00000000')YesERSCHDAT Allow NULL? 
59IPER_DATEIS-M: Starting Date of Individual Periodnvarchar80DATS(N'00000000')YesEPERDATUM Allow NULL? 
60COPY_NO_ISSUECopy Number of Issuenvarchar90CHAR(N' ')YesHEFTNUM_VA Allow NULL? 
61CAID_ED_DELIVAudit Report ID for Edition Deliverednvarchar100NUMC(N'0000000000')YesCIRCAUD_ID_ED Allow NULL? 
62DIVI_PUBLCTNDivision for publicationnvarchar20CHAR(N' ')Yes*SPARTDRERZ Allow NULL? 
63CIRC_FIGURECirculation Figuredecimal100QUAN((0))YesCIRC_FIGURE
64CIRC_FIG_INSERTInserted Proportion of Circulationdecimal100QUAN((0))YesCIRC_FIG_INSERT
65CIRC_FIG_COMBCombined Proportion of Circulationdecimal100QUAN((0))YesCIRC_FIG_COMB
66SALES_UNITIS-M: Sales Unit for Sales Ordernvarchar30UNIT(N' ')Yes*ETMEINS Allow NULL? 
67AUFMELDARTAudit Report Type for Editionnvarchar20CHAR(N' ')Yes*AUFMELDART Allow NULL? 
68PZVARCBPostal code area variant for circulation booknvarchar30CHAR(N' ')Yes*JPZVARCB Allow NULL? 
69ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
70ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
71ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
72ERFPROGProgram Used to Create Objectnvarchar400CHAR(N' ')Yes*ERFPROG Allow NULL? 
73AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
74AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
75AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
76AENPROGProgram that Made Last Changenvarchar400CHAR(N' ')Yes*AENPROG Allow NULL? 
NamePrimaryUniqueTypeColumns
JITCIRCBOOK~0YesYesCLUSTEREDJCBKEY, MANDT
JITCIRCBOOK~1NoNoNONCLUSTEREDAUDITCAT, DLVRYDOCTYPE, DELIV_RETRN_DATE, EDITION_ORDER, PUBL_ORDER, ISSUE
JITCIRCBOOK~2NoNoNONCLUSTEREDEDITION_DELIV, PUBL_DELIV, DELIV_RETRN_DATE, MANDT
JITCIRCBOOK~3NoNoNONCLUSTEREDEDITION_DELIV, PUBL_DELIV, PUBL_DATE, MANDT