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
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
1ERP EHP76.0REQHEADS861Temporary Header Data: Requirement Coverage Request (Limit)
SQL:  selectupdate insert create

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

SELECT CLIENT, REQNO, REQLLINE, PCKG_NO, LIMIT, NO_LIMIT, EXP_VALUE, SSC_EXIST, CON_EXIST, TMP_EXIST, PRICE_CHG, FREE_LIMIT, NO_FRLIMIT, SERV_TYPE, EDITION, SSC_LIMIT, SSC_NOLIM, SSC_PRSCHG, SSC_PERC, TMP_NUMBER, TMP_LIMIT, TMP_NOLIM, TMP_PRSCHG, TMP_PERC, CONT_PERC, DOC_TYPE, PUR_GROUP, SHORT_TEXT, PLANT, TRACKINGNO, MAT_GRP, DEL_DATCAT, DELIV_DATE, ITEM_CAT, ACCTASSCAT, DISTRIB, PART_INV, GR_IND, GR_NON_VAL, IR_IND, DES_VENDOR, FIXED_VEND, PURCH_ORG, AGREEMENT, AGMT_ITEM, CURRENCY, SHEET_NO, EXT_NUMBER, PERSON_INT, PERSON_EXT, LOCATION, REF_DATE, BEGDATE, ENDDATE, PO_NUMBER, PO_ITEM, BLOCK_IND, SCORE_TIME, SCORE_QUAL, DOC_DATE, POST_DATE, REF_DOC_NO, COMM_NO, USER_FIELD, CO_CODE, CATEGORY, CATEGORY_ID, LOGICAL_SYSTEM, PROC_GROUP, PROC_ORG, PCNUM, PCINS, PCDATE, PCNAME, PARTNER, PARTNER_GUID, GR_RCPT_GUID, IV_RCPT_GUID, CATALOGID, LOGSYS_FI, PREQ_NAME, EXT_QUOTE_ID, EXT_QUOTE_ITEM, CATALOGITEM, CTR_GUID, GR_RCPT_PLANT FROM REQHEADS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*EC_CLIENT Allow NULL? 
2REQNORequirement Coverage Request Document Numbernvarchar100CHAR(N' ')No*EC_REQNO Allow NULL? 
3REQLLINEAdministrative line number of requirement coverage requestnvarchar100NUMC(N'0000000000')YesREQLLINE Allow NULL? 
4PCKG_NOPackage numbernvarchar100NUMC(N'0000000000')Yes*PACKNO Allow NULL? 
5LIMITOverall Limitdecimal234DEC((0))YesBBP_BSUMLIMIT
6NO_LIMITNo Limitchar10CHAR(N' ')YesBBP_NO_LIMIT Allow NULL? 
7EXP_VALUEExpected valuedecimal234DEC((0))YesBBP_BCOMMITMNT
8SSC_EXISTLimits exist for service typeschar10CHAR(N' ')YesBBP_ST_EXIST Allow NULL? 
9CON_EXISTLimit on contract items existschar10CHAR(N' ')YesBBP_VC_EXIST Allow NULL? 
10TMP_EXISTLimit on service packages existschar10CHAR(N' ')YesBBP_PK_EXIST Allow NULL? 
11PRICE_CHGPrice change in entry sheetchar10CHAR(N' ')YesBBP_PRS_CHG Allow NULL? 
12FREE_LIMITFree limitdecimal234DEC((0))YesBBP_BRESTLIMIT
13NO_FRLIMITNo Limitchar10CHAR(N' ')YesBBP_NO_LIMIT Allow NULL? 
14SERV_TYPEShort description of service typenvarchar30CHAR(N' ')YesBBP_LBNUM Allow NULL? 
15EDITIONEdition of service typenvarchar40NUMC(N'0000')YesBBP_AUSGB Allow NULL? 
16SSC_LIMITValue limits on service typesdecimal234DEC((0))YesBBP_BLBLIMIT
17SSC_NOLIMNo limit on standard service typechar10CHAR(N' ')YesBBP_LBNOLIM Allow NULL? 
18SSC_PRSCHGPrice change in entry sheetchar10CHAR(N' ')YesBBP_SSCPRS_CHG Allow NULL? 
19SSC_PERCPercentage for price determinationdecimal31DEC((0))YesBBP_SSC_PROZ
20TMP_NUMBERNumber of a set of model service specificationsnvarchar100CHAR(N' ')YesBBP_SPEC_NO Allow NULL? 
21TMP_LIMITLimits on model service specificationsdecimal234DEC((0))YesBBP_BSPECLIMIT
22TMP_NOLIMNo limit on model specificationschar10CHAR(N' ')YesBBP_SPECNOLIM Allow NULL? 
23TMP_PRSCHGPrice change in entry sheetchar10CHAR(N' ')YesBBP_TMPPRS_CHG Allow NULL? 
24TMP_PERCPercentage for price determinationdecimal31DEC((0))YesBBP_TMP_PROZ
25CONT_PERCPercentage for price determinationdecimal31DEC((0))YesBBP_CON_PROZ
26DOC_TYPEPurchase Requisition Document Typenvarchar40CHAR(N' ')Yes*BBSRT Allow NULL? 
27PUR_GROUPPurchasing Groupnvarchar30CHAR(N' ')Yes*EKGRP Allow NULL? 
28SHORT_TEXTShort Textnvarchar400CHAR(N' ')YesTXZ01 Allow NULL? 
29PLANTPlantnvarchar40CHAR(N' ')Yes*EWERK Allow NULL? 
30TRACKINGNORequirement Tracking Numbernvarchar100CHAR(N' ')YesBEDNR Allow NULL? 
31MAT_GRPMaterial Groupnvarchar90CHAR(N' ')Yes*MATKL Allow NULL? 
32DEL_DATCATDate type (day, week, month, interval)char10CHAR(N' ')YesLPEIN_INT Allow NULL? 
33DELIV_DATEItem Delivery Datenvarchar80DATS(N'00000000')YesEINDT Allow NULL? 
34ITEM_CATItem Category in Purchasing Documentchar10CHAR(N' ')Yes*PSTYP Allow NULL? 
35ACCTASSCATAccount Assignment Categorychar10CHAR(N' ')Yes*KNTTP Allow NULL? 
36DISTRIBDistribution indicator for multiple account assignmentchar10CHAR(N' ')YesVRTKZ Allow NULL? 
37PART_INVPartial Invoice Indicatorchar10CHAR(N' ')YesTWRKZ Allow NULL? 
38GR_INDGoods Receipt Indicatorchar10CHAR(N' ')YesWEPOS Allow NULL? 
39GR_NON_VALGoods Receipt, Non-Valuatedchar10CHAR(N' ')YesWEUNB Allow NULL? 
40IR_INDInvoice Receipt Indicatorchar10CHAR(N' ')YesREPOS Allow NULL? 
41DES_VENDORDesired Vendornvarchar100CHAR(N' ')Yes*WLIEF Allow NULL? 
42FIXED_VENDFixed Vendornvarchar100CHAR(N' ')Yes*FLIEF Allow NULL? 
43PURCH_ORGPurchasing Organizationnvarchar40CHAR(N' ')Yes*EKORG Allow NULL? 
44AGREEMENTNumber of Principal Purchase Agreementnvarchar100CHAR(N' ')Yes*KONNR Allow NULL? 
45AGMT_ITEMItem Number of Principal Purchase Agreementnvarchar50NUMC(N'00000')Yes*KTPNR Allow NULL? 
46CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
47SHEET_NOEntry sheet numbernvarchar100CHAR(N' ')YesBBP_LBLNI Allow NULL? 
48EXT_NUMBERExternal entry sheet numbernvarchar160CHAR(N' ')YesBBP_LBLNE Allow NULL? 
49PERSON_INTPerson responsible (internal)nvarchar120CHAR(N' ')YesBBP_SBNAMAG Allow NULL? 
50PERSON_EXTPerson responsible (external)nvarchar120CHAR(N' ')YesBBP_SBNAMAN Allow NULL? 
51LOCATIONLocation where service was performednvarchar250CHAR(N' ')YesBBP_DLORT Allow NULL? 
52REF_DATEPrice reference date of entry sheetnvarchar80DATS(N'00000000')YesBBP_LBLDT Allow NULL? 
53BEGDATETimeframenvarchar80DATS(N'00000000')YesBBP_LZVON Allow NULL? 
54ENDDATETimeframenvarchar80DATS(N'00000000')YesBBP_LZBIS Allow NULL? 
55PO_NUMBERPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
56PO_ITEMItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
57BLOCK_INDBlock release of entry sheetchar10CHAR(N' ')YesBBP_F_LOCK Allow NULL? 
58SCORE_TIMEPoints score for on-time deliverydecimal30DEC((0))YesBBP_MC_PWFR
59SCORE_QUALPoints score for quality of servicesdecimal30DEC((0))YesBBP_MC_PWWE
60DOC_DATEDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
61POST_DATEPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
62REF_DOC_NOReference Document Numbernvarchar160CHAR(N' ')YesXBLNR Allow NULL? 
63COMM_NOTechnical reference field for external entry sheet numbernvarchar200CHAR(N' ')YesBBP_ESSR_D Allow NULL? 
64USER_FIELDUser field: Service entry sheetnvarchar200CHAR(N' ')YesBBP_USR_ESSR Allow NULL? 
65CO_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
66CATEGORYCategory GUIDvarbinary160RAWYesCOMT_CATEGORY_GUID
67CATEGORY_IDCategory IDnvarchar200CHAR(N' ')YesCOMT_CATEGORY_ID Allow NULL? 
68LOGICAL_SYSTEMLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
69PROC_GROUPResponsible Purchasing Groupnvarchar140CHAR(N' ')YesBBP_PROC_GROUP Allow NULL? 
70PROC_ORGResponsible Purchasing Organizationnvarchar140CHAR(N' ')YesBBP_PROC_ORG Allow NULL? 
71PCNUMProcurement card numbernvarchar250CHAR(N' ')Yes*BBPPCNUM Allow NULL? 
72PCINSProcurement card companynvarchar40CHAR(N' ')Yes*BBPPCINS Allow NULL? 
73PCDATEProcurement card expiration datenvarchar80DATS(N'00000000')YesBBPPCDATE Allow NULL? 
74PCNAMEName of procurement cardholdernvarchar400CHAR(N' ')YesBBPPCNAME Allow NULL? 
75PARTNERBusiness Partner Numbernvarchar100CHAR(N' ')Yes*BU_PARTNER Allow NULL? 
76PARTNER_GUIDBusiness Partner GUIDvarbinary160RAWYesBU_PARTNER_GUID
77GR_RCPT_GUIDBusiness Partner GUIDvarbinary160RAWYesBU_PARTNER_GUID
78IV_RCPT_GUIDBusiness Partner GUIDvarbinary160RAWYesBU_PARTNER_GUID
79CATALOGIDCatalog ID from which the line was selectednvarchar200CHAR(N' ')YesCATALOG Allow NULL? 
80LOGSYS_FILogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
81PREQ_NAMEName of Requisitioner/Requesternvarchar120CHAR(N' ')YesAFNAM Allow NULL? 
82EXT_QUOTE_IDNumber of an External RFx Responsenvarchar350CHAR(N' ')YesBBP_EXT_QUOTE_ID Allow NULL? 
83EXT_QUOTE_ITEMItem of an External RFx Responsenvarchar100NUMC(N'0000000000')YesBBP_EXT_QUOTE_ITEM Allow NULL? 
84CATALOGITEMCatalog Item (Unique Key)nvarchar400CHAR(N' ')YesCATALOGITEM Allow NULL? 
85CTR_GUIDContract Template Item GUIDvarbinary160RAWYesBBP_CTR_I_GUID
86GR_RCPT_PLANTIndicator: Goods Recipient is a Plantchar10CHAR(N' ')YesBBP_GR_RCPT_PLANT Allow NULL? 
NamePrimaryUniqueTypeColumns
REQHEADS~0YesYesCLUSTEREDREQNO, CLIENT