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  | TJY00
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.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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2XUSERSPEZChange Number is User-Specificchar10CHAR(N' ')YesXUSERSPEZ Allow NULL? 
3EXCL_DAUERIS-M: Validity Period (Days) for Exclusive Assignmentsnvarchar30NUMC(N'000')YesEXCL_DAUER Allow NULL? 
4UNTR_DAUERIS-M: Maximum duration of a suspension (in days)nvarchar30NUMC(N'000')YesUNTR_DAUER Allow NULL? 
5ANZ_TAG_AEIS-M: Number of Days Before Release Run (RJSWATCH)nvarchar30NUMC(N'000')YesANZ_TAG_AE Allow NULL? 
6ANZ_TAG_ANIS-M: Number of Days to Valid-From Date of Change Numbernvarchar30NUMC(N'000')YesANZ_TAG_AN Allow NULL? 
7ANZ_TAG_TAIS-M: Number of Days for Daily Change Numbernvarchar30NUMC(N'000')YesANZ_TAG_AT Allow NULL? 
8WDVLTEXTIDIS-M: Resubmission text IDnvarchar40CHAR(N' ')YesTTXIDWDVLTEXTID Allow NULL? 
9WDVLTXTOBJIS-M: SAPscript text object for resubmissionnvarchar100CHAR(N' ')YesTTXOBWDVLTXTOBJ Allow NULL? 
10DEFLAND1IS-M: Default Setting for Country Key in Structuresnvarchar30CHAR(N' ')YesT005DEFLAND1 Allow NULL? 
11BASISSPRBasic Language for Text Displaychar10LANG(N' ')YesT002BASISSPR Allow NULL? 
12ISP_MM_KNZIS-M: Material in Standard Tableschar10CHAR(N' ')YesISP_MM_KNZ Allow NULL? 
13MAXEXCEPTIS-M: Planned - not in use!nvarchar30NUMC(N'000')YesMAXEXCEPT Allow NULL? 
14XLAUFLISTIS-M: Generate carrier round sequence during releasechar10CHAR(N' ')YesXLAUFLIST Allow NULL? 
15ANZ_TAGE_WIS-M: No.Days for Which Del.Rd-BP Assgts Must be Maintainednvarchar30NUMC(N'000')YesANZ_TAGE_W Allow NULL? 
16ANZTAGEGPPIS-M: No. Days BP Assgmt to be Maintained Retroactivelynvarchar30NUMC(N'000')YesANZTAGEGPP Allow NULL? 
17XZUSTELLERIS-M: Parameter used to control existence of carrierschar10CHAR(N' ')YesXZUSTELLER Allow NULL? 
18XINKASSOIS-M: Field collectors existchar10CHAR(N' ')YesX_INKASSO Allow NULL? 
19XRECHERCHEIS-M: Parameter to control existence of researcherschar10CHAR(N' ')YesX_RECHERCH Allow NULL? 
20XSDTRANSIS-M: SD transaction for BP set up in BDCchar10CHAR(N' ')YesXSDTRANS Allow NULL? 
21XALTDGPIS-M: Old data transfer for bus.partner active (obsolete)char10CHAR(N' ')YesXALTDGP Allow NULL? 
22XDEZENTRALIS-M: Store master data decentrally (in sales area)char10CHAR(N' ')YesXJDEZENTR Allow NULL? 
23DBEZRNDDefault Delivery Roundnvarchar100CHAR(N' ')Yes*DBEZRND Allow NULL? 
24DTXTBEZRNDDefault Text for Delivery Roundnvarchar150CHAR(N' ')YesDTXTBEZRND Allow NULL? 
25MAXKNOTENIS-M: Maximum number of nodes in geographical structuresint100INT4((0))YesMAXKNOTEN Allow NULL? 
26MAXAENDNRIS-M: Max.no.of change numbers in geo.structure maintenanceint100INT4((0))YesMAXAENDNR Allow NULL? 
27MAXBEZIRKIS-M: Maximum number of carrier routes in geo.structuresint100INT4((0))YesMAXBEZIRK Allow NULL? 
28MAXGEOEINHIS-M: Maximum number of geo.units in geo.structuresint100INT4((0))YesMAXGEOEINH Allow NULL? 
29X_REGION_AIS-M: Copy region automatically (if maintained)char10CHAR(N' ')YesX_REGION_A Allow NULL? 
30XPKTWEIGHTIS-M: Bundling rules depend on weightchar10CHAR(N' ')YesXPKTWEIGHT Allow NULL? 
31XJKZDRERZIS-M: Indicator: Summarize items at publication levelchar10CHAR(N' ')YesJKZDRERZ Allow NULL? 
32XJKZPVAIS-M: Summarize at edition levelchar10CHAR(N' ')YesJKZPVA Allow NULL? 
33MAXZUORDIS-M: Maximum number of assignmentsint100INT4((0))YesMAXZUORD Allow NULL? 
34XKZPAMIS-M: IS-M/AM activechar10CHAR(N' ')YesXKZPAM Allow NULL? 
35XKZPSDIS-M: IS-M/SD activechar10CHAR(N' ')YesXKZPSD Allow NULL? 
36XANNPROSTPIS-M: Ad pre-print order deadline as dailychar10CHAR(N' ')YesXANNPROSTP Allow NULL? 
37XJKZBEZIRKIS-M: Carrier Route Flat Rate Depends on Carrier Routechar10CHAR(N' ')YesXJKZBEZIRK Allow NULL? 
38XJKZBEZLIFIS-M: Car.Route Flat Rate Depends on Car.Route and Del.Typechar10CHAR(N' ')YesXJKZBEZLIF Allow NULL? 
39FB_ABLRGLIIS-M: Function Module for Interpreting Unloading Rulenvarchar300CHAR(N' ')YesTFDIRFB_ABLRGLI Allow NULL? 
40FB_ABLRGLIS-M: Function Module for Reading Unloading Rulenvarchar300CHAR(N' ')YesTFDIRFB_ABLRGL Allow NULL? 
41FBAND_ORDRIS-M: Function Module for Modifying Orders from Releasenvarchar300CHAR(N' ')YesTFDIRFBAND_ORDR Allow NULL? 
42MANDT_POSTIS-M: Client for maintaining postal datanvarchar30CLNT(N'000')YesT000MANDT_POST Allow NULL? 
43RFCDEST_POSTIS-M: RFC Destination for Client Containing Postal Datanvarchar320CHAR(N' ')Yes*ISM_RFCDEST_POST Allow NULL? 
44XABLADVERDIS-M: Summarized maintenance of unloading viability setchar10CHAR(N' ')YesXABLADVERD Allow NULL? 
45XABLRGL_EIS-M: Exceptions to unloading rules possiblechar10CHAR(N' ')YesXABLRGL_E Allow NULL? 
46XKZPAMSIIS-M: IS-M/AM ad insert insertion activechar10CHAR(N' ')YesXKZPAMSI Allow NULL? 
47XADRCOPYIS-M: Address Management - Propose Addresschar10CHAR(N' ')YesXADRCOPY Allow NULL? 
48XPOSTUPGRAPostal upgrade procedure still activechar10CHAR(N' ')YesXPOSTUPGRA Allow NULL? 
49FORM_ZBUCHIS-M: Form for Carrier Listnvarchar160CHAR(N' ')YesFORM_ZBUCH Allow NULL? 
50XGPDUPLETTIS-M: Duplicate Check Active for BP Addresseschar10CHAR(N' ')YesXGPDUPLETT Allow NULL? 
51XKZPAMVRTLIS-M: IS-M/AM ad insert distribution activechar10CHAR(N' ')NoXKZPAMVRTL Allow NULL? 
52XADRUPPERCASEIS-M: Indicator for address printing in capital letterschar10CHAR(N' ')NoXADRUPPERCASE Allow NULL? 
53XTRANSFERTECHIS-M: FI/CO interface used for transferchar10CHAR(N' ')NoXTRANSFERTECH Allow NULL? 
54ANZ_SAETZEIS-M: Maximum Number of Records Selected in Central Accessnvarchar40NUMC(N'0000')NoISM_ANZ_SAETZE Allow NULL? 
55XENQORDREL_GIS-M/SD: Allow Detailed Block Between Order and Releasechar10CHAR(N' ')NoXENQORDREL_G Allow NULL? 
56XMAMBWACTIVEBusiness Information Warehouse Active for IS-M/AMchar10CHAR(N' ')NoXJMAMBWACTIVE Allow NULL? 
57XMSDBWACTIVEBusiness Information Warehouse Active for IS-M/SDchar10CHAR(N' ')NoXJMSDBWACTIVE Allow NULL? 
58MAXORDERSIS-M/SD: Maximum Number of Orders in Releaseint100INT4((0))NoMAXORDERS Allow NULL? 
59MAXMEDISSUESIS-M: Max.No.of Media Issues for Creation in Dialognvarchar30NUMC(N'000')NoMAXMEDISSUE_GEN_DIALOG Allow NULL? 
60COPYNR_SET_FUNCFunction Module for Default Copy Number in Issue Seq.nvarchar300CHAR(N' ')Yes*DELIVERY_SEQ_SET_COPYNR_FUNC Allow NULL? 
61MATNR_SET_FUNCFunction Module for Default Material Number in Issue Seq.nvarchar300CHAR(N' ')Yes*DELIVERY_SEQ_SET_MATNR_FUNC Allow NULL? 
62XSAPGPACTIVEIS-M: SAP Business Partner Activechar10CHAR(N' ')YesXSAPGPACTIVE Allow NULL? 
63XSAPGPACTIVE_EWIS-M: SAP Business Partner Activechar10CHAR(N' ')YesXSAPGPACTIVE Allow NULL? 
64XCPACTIVEIS-M: Contact Person as SAP BP with Active Relationshipchar10CHAR(N' ')YesISM_XCPACTIVE Allow NULL? 
65XCPVVACTIVEIS-M: SAP BP with Relnship Active in Sales Support (if 'X')char10CHAR(N' ')YesISM_XCPVVACTIVE Allow NULL? 
66XSDCPACTIVEIS-M: SD Contact Person Integration Activechar10CHAR(N' ')YesISM_XSDCPACTIVE Allow NULL? 
67XBANKSALESAREAIS-M: Bank details valid on sales area levelchar10CHAR(N' ')NoXBANKSALESAREA Allow NULL? 
68ISSNIDCODETYPEID Code Type for ISSN Numbernvarchar40CHAR(N' ')NoTJPIDCTYPISMISSNIDCODETYPE Allow NULL? 
69VDZVKIDCODETYPEID Code Type for VDZ Sales Indicatornvarchar40CHAR(N' ')NoTJPIDCTYPISMVDZVKIDCODETYPE Allow NULL? 
70PVKIDCODETYPEID Code Type for Postal Distribution Indicatornvarchar40CHAR(N' ')NoTJPIDCTYPISMPVKIDCODETYPE Allow NULL? 
71XVASAKTIVIndicator: Media issue mix synchronization activechar10CHAR(N' ')NoXVASAKTIV Allow NULL? 
72VKTYP_MSDContract Account Categorynvarchar20CHAR(N' ')NoTFK002AVKTYP_KK Allow NULL? 
73XSDIACTIVEIS-M: Media Product Sales and Distribution Activechar10CHAR(N' ')NoXMPSACTIVE Allow NULL? 
74XFICA_SM_ACTIVEIS-M/CA Active for Service Settlementchar10CHAR(N' ')NoXFICA_FOR_SETTLEMENT_ACTIVE Allow NULL? 
75XJVTANN00_INACTIIndicator: Technical Order Deadline Limit Inactivechar10CHAR(N' ')NoXJVTANN00_INACTIVE Allow NULL? 
76XTMC_ACTIVEIS-M: Indicator - Market Coverage Activechar10CHAR(N' ')NoXTMC_ACTIVE Allow NULL? 
77TMC_ORDER_TYPEOrder Type: Default Setting for Market Coveragenvarchar40CHAR(N' ')YesTJAKTMC_DEFAULT_AUART Allow NULL? 
78TMC_GPAGSold-to Party: Default Setting for Market Coveragenvarchar100CHAR(N' ')YesJGTGPNRTMC_DEFAULT_GPAG Allow NULL? 
79XINCPAYMENT_AS_SIS-M: Incoming Payment via tRFC as Separate Transactionchar10CHAR(N' ')YesXINCPAYMENT_AS_SEP_UNIT Allow NULL? 
80XINTERFACE_SETLIndicator - Take Account of External Settlement Interfacechar10CHAR(N' ')YesXINTERFACE_SETTLEMENT Allow NULL? 
81XCLOSING_DATE_FOIndicator: Take Account of Order Deadline for Shipping Orderchar10CHAR(N' ')YesXCLOSING_DATE_FOR_VSOP Allow NULL? 
82XNAE_ACTIVEIS-M: North American Extension Activechar10CHAR(N' ')YesXNAE_ACTIVE Allow NULL? 
83XSHIPORD_VIABIndicator: Shipping Order Del. Via. Based on Householdschar10CHAR(N' ')YesXSHIPORD_VIABILITY_ON_HH Allow NULL? 
84XSDSHIPORD_VIABIndicator: SD Shipping Order Del. Via. Based on Householdschar10CHAR(N' ')YesXSD_SHIPORD_VIABILITY_ON_HH Allow NULL? 
85XWORKLISTENQUEView-by-View Locking Active in Worklistchar10CHAR(N' ')YesXWORKLISTENQUE Allow NULL? 
86XWORKLISTPUBLDATPublication Date Editable (for Articles Only)char10CHAR(N' ')YesXWORKLISTPUBDATE Allow NULL? 
87XWORKLISTSELVARSelection Variants Are Specific to Transaction Variantschar10CHAR(N' ')YesXWORKLISTSELVAR Allow NULL? 
88XMAMBWORDERBW Delta Update According to Orderchar10CHAR(N' ')YesXMAMBWORDER Allow NULL? 
89XPDUCHVERS2IS-M: Indicator Postal Data Upgrade CH Version 2char10CHAR(N' ')YesXPDUCHVERS2 Allow NULL? 
NamePrimaryUniqueTypeColumns
TJY00~0YesYesCLUSTEREDMANDT

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