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
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
Industry Specific :: SAP Media :: Media Sales and Distribution :: Periodical Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TJY00891IS-M: Central Parameters for IS-MPeriodical Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, XUSERSPEZ, EXCL_DAUER, UNTR_DAUER, ANZ_TAG_AE, ANZ_TAG_AN, ANZ_TAG_TA, WDVLTEXTID, WDVLTXTOBJ, DEFLAND1, BASISSPR, ISP_MM_KNZ, MAXEXCEPT, XLAUFLIST, ANZ_TAGE_W, ANZTAGEGPP, XZUSTELLER, XINKASSO, XRECHERCHE, XSDTRANS, XALTDGP, XDEZENTRAL, DBEZRND, DTXTBEZRND, MAXKNOTEN, MAXAENDNR, MAXBEZIRK, MAXGEOEINH, X_REGION_A, XPKTWEIGHT, XJKZDRERZ, XJKZPVA, MAXZUORD, XKZPAM, XKZPSD, XANNPROSTP, XJKZBEZIRK, XJKZBEZLIF, FB_ABLRGLI, FB_ABLRGL, FBAND_ORDR, MANDT_POST, RFCDEST_POST, XABLADVERD, XABLRGL_E, XKZPAMSI, XADRCOPY, XPOSTUPGRA, FORM_ZBUCH, XGPDUPLETT, XKZPAMVRTL, XADRUPPERCASE, XTRANSFERTECH, ANZ_SAETZE, XENQORDREL_G, XMAMBWACTIVE, XMSDBWACTIVE, MAXORDERS, MAXMEDISSUES, COPYNR_SET_FUNC, MATNR_SET_FUNC, XSAPGPACTIVE, XSAPGPACTIVE_EW, XCPACTIVE, XCPVVACTIVE, XSDCPACTIVE, XBANKSALESAREA, ISSNIDCODETYPE, VDZVKIDCODETYPE, PVKIDCODETYPE, XVASAKTIV, VKTYP_MSD, XSDIACTIVE, XFICA_SM_ACTIVE, XJVTANN00_INACTI, XTMC_ACTIVE, TMC_ORDER_TYPE, TMC_GPAG, XINCPAYMENT_AS_S, XINTERFACE_SETL, XCLOSING_DATE_FO, XNAE_ACTIVE, XSHIPORD_VIAB, XSDSHIPORD_VIAB, XWORKLISTENQUE, XWORKLISTPUBLDAT, XWORKLISTSELVAR, XMAMBWORDER, XPDUCHVERS2 FROM TJY00
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2XUSERSPEZChange Number is User-Specificchar10 Allow NULL? 
3EXCL_DAUERIS-M: Validity Period (Days) for Exclusive Assignmentsnvarchar30 Allow NULL? 
4UNTR_DAUERIS-M: Maximum duration of a suspension (in days)nvarchar30 Allow NULL? 
5ANZ_TAG_AEIS-M: Number of Days Before Release Run (RJSWATCH)nvarchar30 Allow NULL? 
6ANZ_TAG_ANIS-M: Number of Days to Valid-From Date of Change Numbernvarchar30 Allow NULL? 
7ANZ_TAG_TAIS-M: Number of Days for Daily Change Numbernvarchar30 Allow NULL? 
8WDVLTEXTIDIS-M: Resubmission text IDnvarchar40 Allow NULL? 
9WDVLTXTOBJIS-M: SAPscript text object for resubmissionnvarchar100 Allow NULL? 
10DEFLAND1IS-M: Default Setting for Country Key in Structuresnvarchar30 Allow NULL? 
11BASISSPRBasic Language for Text Displaychar10 Allow NULL? 
12ISP_MM_KNZIS-M: Material in Standard Tableschar10 Allow NULL? 
13MAXEXCEPTIS-M: Planned - not in use!nvarchar30 Allow NULL? 
14XLAUFLISTIS-M: Generate carrier round sequence during releasechar10 Allow NULL? 
15ANZ_TAGE_WIS-M: No.Days for Which Del.Rd-BP Assgts Must be Maintainednvarchar30 Allow NULL? 
16ANZTAGEGPPIS-M: No. Days BP Assgmt to be Maintained Retroactivelynvarchar30 Allow NULL? 
17XZUSTELLERIS-M: Parameter used to control existence of carrierschar10 Allow NULL? 
18XINKASSOIS-M: Field collectors existchar10 Allow NULL? 
19XRECHERCHEIS-M: Parameter to control existence of researcherschar10 Allow NULL? 
20XSDTRANSIS-M: SD transaction for BP set up in BDCchar10 Allow NULL? 
21XALTDGPIS-M: Old data transfer for bus.partner active (obsolete)char10 Allow NULL? 
22XDEZENTRALIS-M: Store master data decentrally (in sales area)char10 Allow NULL? 
23DBEZRNDDefault Delivery Roundnvarchar100 Allow NULL? 
24DTXTBEZRNDDefault Text for Delivery Roundnvarchar150 Allow NULL? 
25MAXKNOTENIS-M: Maximum number of nodes in geographical structuresint100 Allow NULL? 
26MAXAENDNRIS-M: Max.no.of change numbers in geo.structure maintenanceint100 Allow NULL? 
27MAXBEZIRKIS-M: Maximum number of carrier routes in geo.structuresint100 Allow NULL? 
28MAXGEOEINHIS-M: Maximum number of geo.units in geo.structuresint100 Allow NULL? 
29X_REGION_AIS-M: Copy region automatically (if maintained)char10 Allow NULL? 
30XPKTWEIGHTIS-M: Bundling rules depend on weightchar10 Allow NULL? 
31XJKZDRERZIS-M: Indicator: Summarize items at publication levelchar10 Allow NULL? 
32XJKZPVAIS-M: Summarize at edition levelchar10 Allow NULL? 
33MAXZUORDIS-M: Maximum number of assignmentsint100 Allow NULL? 
34XKZPAMIS-M: IS-M/AM activechar10 Allow NULL? 
35XKZPSDIS-M: IS-M/SD activechar10 Allow NULL? 
36XANNPROSTPIS-M: Ad pre-print order deadline as dailychar10 Allow NULL? 
37XJKZBEZIRKIS-M: Carrier Route Flat Rate Depends on Carrier Routechar10 Allow NULL? 
38XJKZBEZLIFIS-M: Car.Route Flat Rate Depends on Car.Route and Del.Typechar10 Allow NULL? 
39FB_ABLRGLIIS-M: Function Module for Interpreting Unloading Rulenvarchar300 Allow NULL? 
40FB_ABLRGLIS-M: Function Module for Reading Unloading Rulenvarchar300 Allow NULL? 
41FBAND_ORDRIS-M: Function Module for Modifying Orders from Releasenvarchar300 Allow NULL? 
42MANDT_POSTIS-M: Client for maintaining postal datanvarchar30 Allow NULL? 
43RFCDEST_POSTIS-M: RFC Destination for Client Containing Postal Datanvarchar320 Allow NULL? 
44XABLADVERDIS-M: Summarized maintenance of unloading viability setchar10 Allow NULL? 
45XABLRGL_EIS-M: Exceptions to unloading rules possiblechar10 Allow NULL? 
46XKZPAMSIIS-M: IS-M/AM ad insert insertion activechar10 Allow NULL? 
47XADRCOPYIS-M: Address Management - Propose Addresschar10 Allow NULL? 
48XPOSTUPGRAPostal upgrade procedure still activechar10 Allow NULL? 
49FORM_ZBUCHIS-M: Form for Carrier Listnvarchar160 Allow NULL? 
50XGPDUPLETTIS-M: Duplicate Check Active for BP Addresseschar10 Allow NULL? 
51XKZPAMVRTLIS-M: IS-M/AM ad insert distribution activechar10 Allow NULL? 
52XADRUPPERCASEIS-M: Indicator for address printing in capital letterschar10 Allow NULL? 
53XTRANSFERTECHIS-M: FI/CO interface used for transferchar10 Allow NULL? 
54ANZ_SAETZEIS-M: Maximum Number of Records Selected in Central Accessnvarchar40 Allow NULL? 
55XENQORDREL_GIS-M/SD: Allow Detailed Block Between Order and Releasechar10 Allow NULL? 
56XMAMBWACTIVEBusiness Information Warehouse Active for IS-M/AMchar10 Allow NULL? 
57XMSDBWACTIVEBusiness Information Warehouse Active for IS-M/SDchar10 Allow NULL? 
58MAXORDERSIS-M/SD: Maximum Number of Orders in Releaseint100 Allow NULL? 
59MAXMEDISSUESIS-M: Max.No.of Media Issues for Creation in Dialognvarchar30 Allow NULL? 
60COPYNR_SET_FUNCFunction Module for Default Copy Number in Issue Seq.nvarchar300 Allow NULL? 
61MATNR_SET_FUNCFunction Module for Default Material Number in Issue Seq.nvarchar300 Allow NULL? 
62XSAPGPACTIVEIS-M: SAP Business Partner Activechar10 Allow NULL? 
63XSAPGPACTIVE_EWIS-M: SAP Business Partner Activechar10 Allow NULL? 
64XCPACTIVEIS-M: Contact Person as SAP BP with Active Relationshipchar10 Allow NULL? 
65XCPVVACTIVEIS-M: SAP BP with Relnship Active in Sales Support (if 'X')char10 Allow NULL? 
66XSDCPACTIVEIS-M: SD Contact Person Integration Activechar10 Allow NULL? 
67XBANKSALESAREAIS-M: Bank details valid on sales area levelchar10 Allow NULL? 
68ISSNIDCODETYPEID Code Type for ISSN Numbernvarchar40 Allow NULL? 
69VDZVKIDCODETYPEID Code Type for VDZ Sales Indicatornvarchar40 Allow NULL? 
70PVKIDCODETYPEID Code Type for Postal Distribution Indicatornvarchar40 Allow NULL? 
71XVASAKTIVIndicator: Media issue mix synchronization activechar10 Allow NULL? 
72VKTYP_MSDContract Account Categorynvarchar20 Allow NULL? 
73XSDIACTIVEIS-M: Media Product Sales and Distribution Activechar10 Allow NULL? 
74XFICA_SM_ACTIVEIS-M/CA Active for Service Settlementchar10 Allow NULL? 
75XJVTANN00_INACTIIndicator: Technical Order Deadline Limit Inactivechar10 Allow NULL? 
76XTMC_ACTIVEIS-M: Indicator - Market Coverage Activechar10 Allow NULL? 
77TMC_ORDER_TYPEOrder Type: Default Setting for Market Coveragenvarchar40 Allow NULL? 
78TMC_GPAGSold-to Party: Default Setting for Market Coveragenvarchar100 Allow NULL? 
79XINCPAYMENT_AS_SIS-M: Incoming Payment via tRFC as Separate Transactionchar10 Allow NULL? 
80XINTERFACE_SETLIndicator - Take Account of External Settlement Interfacechar10 Allow NULL? 
81XCLOSING_DATE_FOIndicator: Take Account of Order Deadline for Shipping Orderchar10 Allow NULL? 
82XNAE_ACTIVEIS-M: North American Extension Activechar10 Allow NULL? 
83XSHIPORD_VIABIndicator: Shipping Order Del. Via. Based on Householdschar10 Allow NULL? 
84XSDSHIPORD_VIABIndicator: SD Shipping Order Del. Via. Based on Householdschar10 Allow NULL? 
85XWORKLISTENQUEView-by-View Locking Active in Worklistchar10 Allow NULL? 
86XWORKLISTPUBLDATPublication Date Editable (for Articles Only)char10 Allow NULL? 
87XWORKLISTSELVARSelection Variants Are Specific to Transaction Variantschar10 Allow NULL? 
88XMAMBWORDERBW Delta Update According to Orderchar10 Allow NULL? 
89XPDUCHVERS2IS-M: Indicator Postal Data Upgrade CH Version 2char10 Allow NULL? 
NamePrimaryUniqueTypeColumns
TJY00~0YesYesCLUSTEREDMANDT