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  | WCOCOH
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
Logistics - General :: Global Trade :: Chargeback
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WCOCOH576Condition Contract: HeaderChargeback
SQL:  selectupdate insert create

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

SELECT CLIENT, NUM, CONTRACT_TYPE, VEND_OWNER, CUST_OWNER, REFERENCE, ASSIGNMENT, EXT_PARTNER, CREATED_BY, CREATED_ON, REC_TIME, EKORG, EKGRP, VKORG, VTWEG, SPART, ZTERM, ZBD1T, ZBD1P, ZBD2T, ZBD2P, ZBD3T, ZLSCH, GUID, DEACT, DATE_FROM, DATE_TO, ZONLO, EXT_NUM, CC_CURR, RATE, RATE_DATE, RATE_TYPE, VKGRP, VKBUR, ACCESS_TYPE, SETTL_MATNR, SETTL_TYPE_VEND, SETTL_CAL_FINAL, SETTL_CAL_PART, BUKRS, SETTL_TYPE_CUST, CH_NAME, CH_DATE, CH_TIME, EXTENSION_CAL, PRED_CC, CATEGORY, CC_PURPOSE, EXT_REF_CAT, EXT_REF, KOLIF, SETTL_CAL_DELTA, BVTAB_GROUP, SETTL_CAL_ACCR, AF_GROUP, EXT_GUID FROM WCOCOH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2NUMCondition Contractnvarchar100CHAR(N' ')NoWCB_COCO_NUM Allow NULL? 
3CONTRACT_TYPECondition Contract Typenvarchar40CHAR(N' ')YesTWCBCONTRTYPEWCB_CONTRACT_TYPE Allow NULL? 
4VEND_OWNERCondition Contract: Owner Vendornvarchar100CHAR(N' ')YesLFA1WCB_VEND_OWNER Allow NULL? 
5CUST_OWNERCondition Contract: Customer Ownernvarchar100CHAR(N' ')YesKNA1WCB_CUST_OWNER Allow NULL? 
6REFERENCECondition Contract: Referencenvarchar160CHAR(N' ')YesWCB_REFERENCE Allow NULL? 
7ASSIGNMENTCondition Contract: Assignmentnvarchar160CHAR(N' ')YesWCB_ASSIGNMENT Allow NULL? 
8EXT_PARTNERCondition Contract: External Partnernvarchar100CHAR(N' ')YesWCB_EXTERNAL_PARTNER Allow NULL? 
9CREATED_BYCondition Contract: Name of Processornvarchar120CHAR(N' ')YesWCB_CREATED_BY Allow NULL? 
10CREATED_ONCondition Contract: Date on Which Record Was Addednvarchar80DATS(N'00000000')YesWCB_CREATED_ON Allow NULL? 
11REC_TIMECondition Contr.: Time at Which Record Was Addednvarchar60TIMS(N'000000')YesWCB_REC_TIME Allow NULL? 
12EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
13EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
14VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
15VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
16SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
17ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
18ZBD1TCash (Prompt Payment) Discount Daysdecimal30DEC((0))YesDZBDET
19ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
20ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
21ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
22ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
23ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
24GUIDCondition Contract GUIDvarbinary160RAWYesWCB_GUID
25DEACTDeactivatedchar10CHAR(N' ')YesWCB_DEACTIVATED Allow NULL? 
26DATE_FROMValid fromnvarchar80DATS(N'00000000')YesWCB_DATE_FROM Allow NULL? 
27DATE_TOValid tonvarchar80DATS(N'00000000')YesWCB_DATE_TO Allow NULL? 
28ZONLOTime Zonenvarchar60CHAR(N' ')YesSYSTZONLO Allow NULL? 
29EXT_NUMExternal Number of Documentnvarchar300CHAR(N' ')YesWCB_EXTERNAL_NUMBER Allow NULL? 
30CC_CURRCurrency of Condition Contractnvarchar50CUKY(N' ')YesTCURCWCB_CC_CURR Allow NULL? 
31RATEExchange Ratedecimal95DEC((0))YesWCB_WKURS
32RATE_DATEConversion Datenvarchar80DATS(N'00000000')YesWCB_WWERT_D Allow NULL? 
33RATE_TYPEExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
34VKGRPSales Groupnvarchar30CHAR(N' ')YesTVBVKVKGRP Allow NULL? 
35VKBURSales Officenvarchar40CHAR(N' ')YesTVBURVKBUR Allow NULL? 
36ACCESS_TYPEAccess Typechar10CHAR(N' ')YesWCB_ACCESS_TYPE Allow NULL? 
37SETTL_MATNRCCS: Settlement Materialnvarchar180CHAR(N' ')YesMARAWB2_SETTLEMENT_MATNR Allow NULL? 
38SETTL_TYPE_VENDCondition Contract Settlement: Settlement Type Vendorchar10CHAR(N' ')YesWB2_SETTLEMENT_TYPE_VENDOR Allow NULL? 
39SETTL_CAL_FINALCondition Contract Settlement: Settlement Calendarnvarchar20CHAR(N' ')YesTFACDWB2_SETTLEMENT_CALENDAR Allow NULL? 
40SETTL_CAL_PARTCondition Contract Settlement: Calendar Partial Settlementnvarchar20CHAR(N' ')YesTFACDWB2_SETTLEMENT_CALENDAR_PART Allow NULL? 
41BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
42SETTL_TYPE_CUSTCondition Contract Settlement: Settlement Type Customerchar10CHAR(N' ')YesWB2_SETTLEMENT_TYPE_CUSTOMER Allow NULL? 
43CH_NAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
44CH_DATEChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
45CH_TIMETime of Changenvarchar60TIMS(N'000000')YesAEZEIT Allow NULL? 
46EXTENSION_CALCCS: Calendar for Contract Extensionnvarchar20CHAR(N' ')YesTFACDWB2_EXTENSION_CALENDAR Allow NULL? 
47PRED_CCPredecessor Condition Contract numbernvarchar100CHAR(N' ')YesWCB_PRED_COCO_NUM Allow NULL? 
48CATEGORYCondition Contract Categorynvarchar20CHAR(N' ')YesTWCBCATEGORYWCB_CONTRACT_CATEGORY Allow NULL? 
49CC_PURPOSECondition Contract Purposenvarchar20CHAR(N' ')YesWCB_CC_PURPOSE Allow NULL? 
50EXT_REF_CATExternal Reference Document Categorynvarchar20CHAR(N' ')YesWCB_REF_CAT Allow NULL? 
51EXT_REFExternal Referencenvarchar320CHAR(N' ')YesWCB_EXTERNAL_NUMBER2 Allow NULL? 
52KOLIFPrior Vendornvarchar100CHAR(N' ')YesLFA1KOLIF Allow NULL? 
53SETTL_CAL_DELTACondition Contract Settlement: Calendar Delta Settlementnvarchar20CHAR(N' ')YesTFACDWB2_SETTLEMENT_CALENDAR_DELTA Allow NULL? 
54BVTAB_GROUPBusiness Volume Table Groupnvarchar40CHAR(N' ')YesWB2_C_BVTAB_GRPWB2_BVTAB_GROUP Allow NULL? 
55SETTL_CAL_ACCRCondition Contract Settlement: Calendar Delta Accrualsnvarchar20CHAR(N' ')YesTFACDWB2_SETTLEMENT_CALENDAR_ACCR Allow NULL? 
56AF_GROUPCCS: Amount Fields Groupnvarchar40CHAR(N' ')YesWB2_C_AF_GROUPWB2_AMOUNT_FIELDS_GROUP Allow NULL? 
57EXT_GUIDExternal Condition Contract GUIDvarbinary160RAWYesWCB_EXT_GUID_CC
NamePrimaryUniqueTypeColumns
WCOCOH~0YesYesCLUSTEREDCLIENT, NUM
WCOCOH~001NoNoNONCLUSTEREDCLIENT, GUID
WCOCOH~002NoNoNONCLUSTEREDCLIENT, VEND_OWNER, DEACT, DATE_FROM, DATE_TO
WCOCOH~003NoNoNONCLUSTEREDCLIENT, CUST_OWNER, DEACT, DATE_FROM, DATE_TO
WCOCOH~005NoNoNONCLUSTEREDCLIENT, CONTRACT_TYPE
WCOCOH~008NoNoNONCLUSTEREDCLIENT, EXT_REF_CAT, EXT_REF

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