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  | WBASSOC
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Logistics - General :: Global Trade :: Position Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WBASSOC424Global Trade: Association TablePosition Management
SQL:  selectupdate insert create

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

SELECT MANDT, TEW_TYPE, ASSOC_STEP_FROM, RNUMBER, RPOSNR, RPOSNR_SUB, ASSOC_STEP_TO, ANUMBER, APOSNR, APOSNR_SUB, REC_BASE, BAS_DOCTYPE_REC, BAS_DOCNR_REC, BAS_ITEM_REC, BAS_S_ITEM_REC, PORTFOLIO_REC, RMATNR, BAS_DOCTYPE_ASSO, BAS_DOCNR_ASSO, BAS_ITEM_ASSO, BAS_S_ITEM_ASSO, PORTFOLIO_ASSOC, AMATNR, UNIT_OF_QUAN, ASSOC_QUAN_ORIG, ASSOC_QUAN, LOCKED_QUAN, LOCK_FLAG, LOCK_REASON, COMPLETED, DOC_TYPE_FROM, DOC_TYPE_TO, STATUS, CHARG_ASSO, CHARG_REC, PRED_STEP_FROM, PRED_STEP_TO, PRED_QUAN_FROM, PRED_QUAN_TO, ERDAT, ERNAM, IGNORE_ASSO FROM WBASSOC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TEW_TYPETrading Execution Workbench Typenvarchar40CHAR(N' ')NoTEWTYPEWB2_TEW_TYPE Allow NULL? 
3ASSOC_STEP_FROMAssociation Mngt: Process Step That Contains An Associationnvarchar40CHAR(N' ')NoTEWSTEPWB2_ASSOC_STEP_FROM Allow NULL? 
4RNUMBERAssoc. Mngt: Number of Document to Which Doc. is Assignednvarchar180CHAR(N' ')NoWB2_RECEIVING_NUMBER Allow NULL? 
5RPOSNRAssoc. Mngt: Item No. of Document to Which Doc.is Assignednvarchar100CHAR(N' ')NoWB2_RECEIVING_POSNR Allow NULL? 
6RPOSNR_SUBAssoc. Mngt: Sub-Item No. of Doc. to Which Doc. is Assignednvarchar60NUMC(N'000000')NoWB2_RECEIVING_POSNR_SUB Allow NULL? 
7ASSOC_STEP_TOAssociation Management: Process Step That is Associatednvarchar40CHAR(N' ')NoTEWSTEPWB2_ASSOC_STEP_TO Allow NULL? 
8ANUMBERAssoc. Mngt: Number of a Document that is Assignednvarchar180CHAR(N' ')NoWB2_ASSOCIATED_NUMBER Allow NULL? 
9APOSNRAssoc. Mngt: Item No. of a Doc. that is Assigned to a Doc.nvarchar100CHAR(N' ')NoWB2_ASSOCIATED_POSNR Allow NULL? 
10APOSNR_SUBAssoc. Mngt: Sub-Item No. of Doc. That is Assigned to Doc.nvarchar60NUMC(N'000000')NoWB2_ASSOCIATED_POSNR_SUB Allow NULL? 
11REC_BASEAssoc. Mngt: Basis for Receiving Documentnvarchar20CHAR(N' ')NoWB2_RECEIVING_BASE Allow NULL? 
12BAS_DOCTYPE_RECDocument Typenvarchar20CHAR(N' ')YesWB2_DOC_TYPE Allow NULL? 
13BAS_DOCNR_RECAssoc. Mngt: Base Document Receiving Associationsnvarchar100CHAR(N' ')YesWB2_BASE_DOCUMENT_RECEIVING Allow NULL? 
14BAS_ITEM_RECAssoc. Mngt: Item Number in Base Documentnvarchar60NUMC(N'000000')YesWB2_BASE_ITEM Allow NULL? 
15BAS_S_ITEM_RECAssoc. Mngt: Sub-Item Number in Base Documentnvarchar60NUMC(N'000000')YesWB2_BASE_SUB_ITEM Allow NULL? 
16PORTFOLIO_RECGlobal Trade: (Internal) Portfolio Numbernvarchar100CHAR(N' ')YesKONHMWB2_PORTFOLIO Allow NULL? 
17RMATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
18BAS_DOCTYPE_ASSODocument Typenvarchar20CHAR(N' ')YesWB2_DOC_TYPE Allow NULL? 
19BAS_DOCNR_ASSOAssoc. Mngt: Base Document That is Associatednvarchar100CHAR(N' ')YesWB2_BASE_DOCUMENT_ASSOCIATED Allow NULL? 
20BAS_ITEM_ASSOAssoc. Mngt: Item Number in Base Documentnvarchar60NUMC(N'000000')YesWB2_BASE_ITEM Allow NULL? 
21BAS_S_ITEM_ASSOAssoc. Mngt: Sub-Item Number in Base Documentnvarchar60NUMC(N'000000')YesWB2_BASE_SUB_ITEM Allow NULL? 
22PORTFOLIO_ASSOCGlobal Trade: (Internal) Portfolio Numbernvarchar100CHAR(N' ')YesKONHMWB2_PORTFOLIO Allow NULL? 
23AMATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
24UNIT_OF_QUANAssociation Management: Association Unit of Measurenvarchar30UNIT(N' ')YesT006WB2_ASSO_UNIT Allow NULL? 
25ASSOC_QUAN_ORIGAssoc. Mngt: Originally Associated Quantity of an Itemdecimal153QUAN((0))YesWB2_ASSOC_QUAN_ORIG
26ASSOC_QUANAssoc. Mngt: Actually Associated Quantity of an Itemdecimal153QUAN((0))YesWB2_ASSOCIATED_QUAN
27LOCKED_QUANAssoc. Mngt: Locked Quantitydecimal153QUAN((0))YesWB2_LOCKED_QUAN
28LOCK_FLAGAssoc. Mngt: Flag for Locked Quantitychar10CHAR(N' ')YesWB2_LOCK_FLAG Allow NULL? 
29LOCK_REASONAssoc. Mngt: Lock Reasonnvarchar40CHAR(N' ')YesWB2_ASS_LOCK_REASON Allow NULL? 
30COMPLETEDAssoc. Mngt: Indicates Whether Asc.Qty is Transferred inFullchar10CHAR(N' ')YesWB2_ASSOC_TRANSFER_COMPLETED Allow NULL? 
31DOC_TYPE_FROMAssoc. Mngt: Document Category Receiving Associationnvarchar20CHAR(N' ')YesWB2_ASSOC_DOC_TYPE_FROM Allow NULL? 
32DOC_TYPE_TOAssoc. Mngt: Document Category That Is Associatednvarchar20CHAR(N' ')YesWB2_ASSOC_DOC_TYPE_TO Allow NULL? 
33STATUSAssoc. Mngt: Association Status, Only Needed Internallychar10CHAR(N' ')YesWB2_ASSO_STATUS Allow NULL? 
34CHARG_ASSOAssoc. Management: Batch Number of Associated Itemnvarchar100CHAR(N' ')Yes*WB2_ASSO_CHARG Allow NULL? 
35CHARG_RECAssoc. Mngt: Batch Number of Item Receiving Associationnvarchar100CHAR(N' ')Yes*WB2_REC_CHARG Allow NULL? 
36PRED_STEP_FROMAssociation Mngt: Process Step That Contains An Associationnvarchar40CHAR(N' ')YesWB2_ASSOC_STEP_FROM Allow NULL? 
37PRED_STEP_TOAssociation Management: Process Step That is Associatednvarchar40CHAR(N' ')YesWB2_ASSOC_STEP_TO Allow NULL? 
38PRED_QUAN_FROMAssoc. Mngt: Quantity Transferred from Preceding Associationdecimal153QUAN((0))YesWB2_TRANSFERRED_QUANTITY
39PRED_QUAN_TOAssoc. Mngt: Quantity Transferred from Preceding Associationdecimal153QUAN((0))YesWB2_TRANSFERRED_QUANTITY
40ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
41ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
42IGNORE_ASSOAssociation Management: Ignore Active Association Quantity?char10CHAR(N' ')YesWB2_IGNORE_ACTIVE_ASSOC_QUAN Allow NULL? 
NamePrimaryUniqueTypeColumns
WBASSOC~0YesYesCLUSTEREDMANDT, TEW_TYPE, ASSOC_STEP_FROM, RNUMBER, RPOSNR, RPOSNR_SUB, ASSOC_STEP_TO, ANUMBER, APOSNR, APOSNR_SUB, REC_BASE
WBASSOC~001NoNoNONCLUSTEREDMANDT, BAS_DOCTYPE_REC, BAS_DOCNR_REC, BAS_ITEM_REC, BAS_S_ITEM_REC
WBASSOC~002NoNoNONCLUSTEREDMANDT, BAS_DOCTYPE_ASSO, BAS_DOCNR_ASSO, BAS_ITEM_ASSO, BAS_S_ITEM_ASSO
WBASSOC~003NoNoNONCLUSTEREDMANDT, TEW_TYPE, ASSOC_STEP_TO, ANUMBER, APOSNR, APOSNR_SUB

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