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  | WSUBST_SWITCHDAT
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
6BSEG345Accounting Document Segment
7/ISDFPS/CHVW_E34External Batch Where-Used List
8FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Logistics Execution :: Shipping
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WSUBST_SWITCHDAT303Switch/Switch Back DataShipping
SQL:  selectupdate insert create

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

SELECT MANDT, PO_NUMBER, PO_ITEM_NO, PO_SCHED_NO, REC_PLANT, SUP_PLANT, SUP_VENDOR, DELIV_DATE, ATP_RESULT, SUBST_CTRL, CTRL_TYPE_ENH, MATNR_ORIG, QUANTITY_ORIG, UOM_ORIG, MATNR_SUBST, QUANTITY_SUBST, UOM_SUBST, DATE_SUBST, TIME_SUBST, TSTAMP_SUBST, APPLICATION, SWITCH_TYPE, ERNAM, AENAM, EVALUATION_DATE, SWITCH_PER_START, SWITCH_PER_END, TRANSFERRED, DATE_TRANS, PACKAGE_ID FROM WSUBST_SWITCHDAT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PO_NUMBERPurchasing Document Numbernvarchar100CHAR(N' ')No*EBELN Allow NULL? 
3PO_ITEM_NOItem Number of Purchasing Documentnvarchar50NUMC(N'00000')No*EBELP Allow NULL? 
4PO_SCHED_NODelivery Schedule Line Numbernvarchar40NUMC(N'0000')No*ETENR Allow NULL? 
5REC_PLANTReceiving Plantnvarchar40CHAR(N' ')Yes*WSUBST_REC_PLANT Allow NULL? 
6SUP_PLANTIssuing Plantnvarchar40CHAR(N' ')Yes*WSUBST_SUP_PLANT Allow NULL? 
7SUP_VENDORVendor Account Numbernvarchar100CHAR(N' ')Yes*WSUBST_SUP_VENDOR Allow NULL? 
8DELIV_DATEDelivery Datenvarchar80DATS(N'00000000')YesWSUBST_DELIV_DATE Allow NULL? 
9ATP_RESULTResult of Availability Checkchar10CHAR(N' ')YesWSUBST_ATP_RESULT Allow NULL? 
10SUBST_CTRLSubstitution Controlchar10CHAR(N' ')YesWSUBST_SUBST_CTRL Allow NULL? 
11CTRL_TYPE_ENHSubstitution Control Enhancedchar10CHAR(N' ')YesWSUBST_CTRL_TYPE_ENHANCED Allow NULL? 
12MATNR_ORIGOriginal Materialnvarchar180CHAR(N' ')YesWSUBST_MATNR_ORIG Allow NULL? 
13QUANTITY_ORIGOriginal Material Quantitydecimal133QUAN((0))YesWSUBST_QUANTITY_ORIG
14UOM_ORIGOriginal Material Unit of Measurenvarchar30UNIT(N' ')Yes*WSUBST_UOM_ORIG Allow NULL? 
15MATNR_SUBSTSubstitute Material Numbernvarchar180CHAR(N' ')YesWSUBST_MATNR_SUBST Allow NULL? 
16QUANTITY_SUBSTSubstitute Material Quantitydecimal133QUAN((0))YesWSUBST_QUANTITY_SUBST
17UOM_SUBSTSubstitute Material Unit of Measurenvarchar30UNIT(N' ')Yes*WSUBST_UOM_SUBST Allow NULL? 
18DATE_SUBSTDate of Substitutionnvarchar80DATS(N'00000000')YesWSUBST_DATE Allow NULL? 
19TIME_SUBSTTime of Substitutionnvarchar60TIMS(N'000000')YesWSUBST_TIME Allow NULL? 
20TSTAMP_SUBSTSubstitution Time Stampdecimal217DEC((0))YesWSUBST_TIMESTAMP
21APPLICATIONCalling Application in Substitution Processnvarchar20CHAR(N' ')YesWSUBST_APPL Allow NULL? 
22SWITCH_TYPESwitch Type: 1= Switchover; 2 = Switch Backchar10CHAR(N' ')YesWSUBST_SUBST_SWITCH Allow NULL? 
23ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
24AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
25EVALUATION_DATEEvaluation Datenvarchar80DATS(N'00000000')YesWSUBST_EVAL_DATE Allow NULL? 
26SWITCH_PER_STARTSwitchover Period Start Datenvarchar80DATS(N'00000000')YesWSUBST_SWITCH_PERIOD_START Allow NULL? 
27SWITCH_PER_ENDSwitchover Period End Datenvarchar80DATS(N'00000000')YesWSUBST_SWITCH_PERIOD_END Allow NULL? 
28TRANSFERREDIndicator Transfer Data Recordchar10CHAR(N' ')YesWSUBST_SUBST_TRANSFERRED Allow NULL? 
29DATE_TRANSTransfer Date of Switch Informationnvarchar80DATS(N'00000000')YesWSUBST_SUBST_TRANS_DATE Allow NULL? 
30PACKAGE_IDPackage Identifiernvarchar350CHAR(N' ')YesFRE_PACKAGE_ID Allow NULL? 
NamePrimaryUniqueTypeColumns
WSUBST_SWITCHDATS1NoNoNONCLUSTEREDMANDT, REC_PLANT, MATNR_ORIG, SUP_PLANT, SUP_VENDOR
WSUBST_SWITCHDATS2NoNoNONCLUSTEREDMANDT, TSTAMP_SUBST, TRANSFERRED, SWITCH_TYPE
WSUBST_SWITCHDAT~0YesYesCLUSTEREDMANDT, PO_NUMBER, PO_ITEM_NO, PO_SCHED_NO

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