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
Industry Specific :: SAP Media :: Media Sales and Distribution :: Media Product Sales and Distribution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0JKSDUNSOLDITEM928IS-M: Item Data on Unsold Copies/Credit MemosMedia Product Sales and Distribution
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, POSNR, UE_POSNR, POSNR_EX, MEDIA_FAMILY, MEDIA_PRODUCT, MEDIA_ISSUE, COPY_NUMBER, PUBL_DATE, DAY_FROM, DAY_TO, QUANTITY, UNIT, CON_QUANTITY, CON_UNIT, REF_ORDER_VBELN, REF_ORDER_POSNR, REASON_CODE, REF_POSNR, CALCTYPCON, COND_VALUE, CURRENCY, COND_UNIT, COND_P_UNT, MATNR, STATE, CREDIT_NUMBER, CREDIT_POSNR, XCORASSIGEND, XRELBLOCKED, XRELMMBLOCKED, WERKS, ROUTE, QUANTITY1, XQUANTITY1ZERO, QUANTITY2, XQUANTITY2ZERO, QUANTITY3, XQUANTITY3ZERO, QUANTITY4, XQUANTITY4ZERO, QUANTITY5, XQUANTITY5ZERO, QUANTITY6, XQUANTITY6ZERO, QUANTITY7, XQUANTITY7ZERO, QUANTITY8, XQUANTITY8ZERO, QUANTITY9, XQUANTITY9ZERO, QUANTITY10, XQUANTITY10ZERO, QUANTITYUNIT, QUANTITYCHECK, XQUANCHECKZERO, QUANTITYPRCP, XQUANPRCPZERO, QUANTITYGRS, XQUANGRSZERO, QUANTITYCREDIT1, XQUANCREDIT1ZERO, QUANTITYCREDIT2, XQUANCREDIT2ZERO, QUANTITYCREDIT3, XQUANCREDIT3ZERO, QUANTITYCREDIT4, XQUANCREDIT4ZERO, QUANTITYCREDIT5, XQUANCREDIT5ZERO, CREDIT_POSNR2, CREDIT_POSNR3, CREDIT_POSNR4, PRSDT, ISMPERRULE, EAN11, VBELNCONTRACT, POSNRCONTRACT, PROD, STATEGR, STATEPO, RETURNCOMMENT, PHASEMDL, PHASENBR, UNSOLDDATEITEM, ERFUSER, ERFDATE, ERFTIME, AENUSER, AENDATE, AENTIME FROM JKSDUNSOLDITEM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNInternal Numbernvarchar100CHAR(N' ')NoJKSDUNSOLDJVBELNRETURN Allow NULL? 
3POSNRIS-M: Request Item Numbernvarchar60NUMC(N'000000')No*JRETURNPOSNR Allow NULL? 
4UE_POSNRIS-M: Request Item Numbernvarchar60NUMC(N'000000')Yes*JRETURNPOSNR Allow NULL? 
5POSNR_EXIS-M: External Item Numbernvarchar60NUMC(N'000000')Yes*JRETURNPOSNR_EX Allow NULL? 
6MEDIA_FAMILYMedia Product Familynvarchar180CHAR(N' ')YesMARAISMMATNR_FAMILY Allow NULL? 
7MEDIA_PRODUCTMedia Productnvarchar180CHAR(N' ')YesMARAISMMATNR_PRODUCT Allow NULL? 
8MEDIA_ISSUEMedia Issuenvarchar180CHAR(N' ')YesMARAISMMATNR_ISSUE Allow NULL? 
9COPY_NUMBERCopy Number of Media Issuenvarchar90CHAR(N' ')YesISMHEFTNUMMER Allow NULL? 
10PUBL_DATEPublication Datenvarchar80DATS(N'00000000')YesISMPUBLDATE Allow NULL? 
11DAY_FROMIS-M: Summarized Returns Fromnvarchar80DATS(N'00000000')YesDAY_FROM Allow NULL? 
12DAY_TOIS-M: Summarized Return Tonvarchar80DATS(N'00000000')YesDAY_TO Allow NULL? 
13QUANTITYIS-M: Unsold Quantitydecimal133QUAN((0))YesJRETURNQUANTITY
14UNITIS-M: Unit of Measure for Unconfirmed Quantitynvarchar30UNIT(N' ')Yes*JRETURNUNIT Allow NULL? 
15CON_QUANTITYIS-M: Confirmed Unsold Quantitydecimal133QUAN((0))YesJCONFIRMEDRETURNQUANTITY
16CON_UNITIS-M: Unit of Measure for Confirmed Unsold Quantitynvarchar30UNIT(N' ')Yes*JCONFIRMEDRETURNUNIT Allow NULL? 
17REF_ORDER_VBELNIS-M: Reference Documentnvarchar100CHAR(N' ')Yes*JREF_VBELN Allow NULL? 
18REF_ORDER_POSNRIS-M: Reference Itemnvarchar60NUMC(N'000000')Yes*JREF_POSNR Allow NULL? 
19REASON_CODEIS-M: Reasonnvarchar30CHAR(N' ')YesTVAUJREASON_CODE Allow NULL? 
20REF_POSNRSales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
21CALCTYPCONIS-M: Condition Calculation Rule for Credit Memo Requestchar10CHAR(N' ')YesCALCTYPECRED Allow NULL? 
22COND_VALUERate (condition amount or percentage)decimal112CURR((0))YesKBETR
23CURRENCYCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
24COND_UNITCondition unitnvarchar30UNIT(N' ')YesT006KMEIN Allow NULL? 
25COND_P_UNTCondition pricing unitdecimal50DEC((0))YesKPEIN
26MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
27STATEIS-M: Processing Statuschar10CHAR(N' ')YesJRETURNSTATE Allow NULL? 
28CREDIT_NUMBERSales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
29CREDIT_POSNRSales Document Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VA Allow NULL? 
30XCORASSIGENDIS-M: Correction Quantities Assigned to Contractchar10CHAR(N' ')YesXCORASSIGEND Allow NULL? 
31XRELBLOCKEDSD Lockchar10CHAR(N' ')YesXRELBLOCKED Allow NULL? 
32XRELMMBLOCKEDMM Lockchar10CHAR(N' ')YesXRELMMBLOCKED Allow NULL? 
33WERKSPlantnvarchar40CHAR(N' ')YesT001WJWERK Allow NULL? 
34ROUTERoutenvarchar60CHAR(N' ')YesTVROROUTE Allow NULL? 
35QUANTITY1Quantity Field 1decimal60QUAN((0))YesISMRETURNQUANTITY1
36XQUANTITY1ZEROZero Quantity in Quantity Field 1char10CHAR(N' ')YesISMRETURNQUAN1ZERO Allow NULL? 
37QUANTITY2Quantity Field 2decimal60QUAN((0))YesISMRETURNQUANTITY2
38XQUANTITY2ZEROZero Quantity in Quantity Field 2char10CHAR(N' ')YesISMRETURNQUAN2ZERO Allow NULL? 
39QUANTITY3Quantity Field 3decimal60QUAN((0))YesISMRETURNQUANTITY3
40XQUANTITY3ZEROZero Quantity in Quantity Field 3char10CHAR(N' ')YesISMRETURNQUAN3ZERO Allow NULL? 
41QUANTITY4Quantity Field 4decimal60QUAN((0))YesISMRETURNQUANTITY4
42XQUANTITY4ZEROZero Quantity in Quantity Field 1char10CHAR(N' ')YesISMRETURNQUAN1ZERO Allow NULL? 
43QUANTITY5Quantity Field 5decimal60QUAN((0))YesISMRETURNQUANTITY5
44XQUANTITY5ZEROZero Quantity in Quantity Field 5char10CHAR(N' ')YesISMRETURNQUAN5ZERO Allow NULL? 
45QUANTITY6Quantity Field 6decimal60QUAN((0))YesISMRETURNQUANTITY6
46XQUANTITY6ZEROZero Quantity in Quantity Field 6char10CHAR(N' ')YesISMRETURNQUAN6ZERO Allow NULL? 
47QUANTITY7Quantity Field 7decimal60QUAN((0))YesISMRETURNQUANTITY7
48XQUANTITY7ZEROZero Quantity in Quantity Field 7char10CHAR(N' ')YesISMRETURNQUAN7ZERO Allow NULL? 
49QUANTITY8Quantity Field 8decimal60QUAN((0))YesISMRETURNQUANTITY8
50XQUANTITY8ZEROZero Quantity in Quantity Field 8char10CHAR(N' ')YesISMRETURNQUAN8ZERO Allow NULL? 
51QUANTITY9Quantity Field 9decimal60QUAN((0))YesISMRETURNQUANTITY9
52XQUANTITY9ZEROZero Quantity in Quantity Field 9char10CHAR(N' ')YesISMRETURNQUAN9ZERO Allow NULL? 
53QUANTITY10Quantity Field 10decimal60QUAN((0))YesISMRETURNQUANTITY10
54XQUANTITY10ZEROZero Quantity in Quantity Field 1char10CHAR(N' ')YesISMRETURNQUAN10ZERO Allow NULL? 
55QUANTITYUNITUnit of Measurenvarchar30UNIT(N' ')YesT006ISMRETURNUNIT Allow NULL? 
56QUANTITYCHECKRelevant Quantity for Quantity Checkdecimal60QUAN((0))YesISMRETURNQUANTITYCHECK
57XQUANCHECKZEROIS-M: Indicator for Zero Quantity for Quantity Checkchar10CHAR(N' ')YesISMRETURNQUANTITYCHECKZERO Allow NULL? 
58QUANTITYPRCPRelevant Quantity for Return to Publisherdecimal60QUAN((0))YesISMRETURNQUANTITYPRCP
59XQUANPRCPZEROIS-M: Indicator for Zero Quantity for Return to Publisherchar10CHAR(N' ')YesISMRETURNQUANTITYPRCPZERO Allow NULL? 
60QUANTITYGRSRelevant Quantity for Goods Receiptdecimal60QUAN((0))YesISMRETURNQUANTITYGRS
61XQUANGRSZEROIS-M: Indicator for Zero Quantity for Goods Receiptchar10CHAR(N' ')YesISMRETURNQUANTITYGRSZERO Allow NULL? 
62QUANTITYCREDIT1Credit Memo Quantity 1decimal60QUAN((0))YesISMRETURNQUANTITYCREDIT1
63XQUANCREDIT1ZEROIS-M: Indicator for Zero Quantity for Credit Memo Quantity 1char10CHAR(N' ')YesISMRETURNQUANTITYCRD1ZERO Allow NULL? 
64QUANTITYCREDIT2Credit Memo Quantity 2decimal60QUAN((0))YesISMRETURNQUANTITYCREDIT2
65XQUANCREDIT2ZEROIS-M: Indicator for Zero Quantity for Credit Memo Quantity 2char10CHAR(N' ')YesISMRETURNQUANTITYCRD2ZERO Allow NULL? 
66QUANTITYCREDIT3Credit Memo Quantity 3decimal60QUAN((0))YesISMRETURNQUANTITYCREDIT3
67XQUANCREDIT3ZEROIS-M: Indicator for Zero Quantity for Credit Memo Quantity 3char10CHAR(N' ')YesISMRETURNQUANTITYCRD3ZERO Allow NULL? 
68QUANTITYCREDIT4Credit Memo Quantity 4decimal60QUAN((0))YesISMRETURNQUANTITYCREDIT4
69XQUANCREDIT4ZEROIS-M: Indicator for Zero Quantity for Credit Memo Quantity 4char10CHAR(N' ')YesISMRETURNQUANTITYCRD4ZERO Allow NULL? 
70QUANTITYCREDIT5Credit Memo Quantity 5decimal60QUAN((0))YesISMRETURNQUANTITYCREDIT5
71XQUANCREDIT5ZEROIS-M: Indicator for Zero Quantity for Credit Memo Quantity 5char10CHAR(N' ')YesISMRETURNQUANTITYCRD5ZERO Allow NULL? 
72CREDIT_POSNR2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
73CREDIT_POSNR3Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
74CREDIT_POSNR4Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
75PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')YesPRSDT Allow NULL? 
76ISMPERRULEFrequency for Media Productsnvarchar50CHAR(N' ')Yes*ISMPERREGEL Allow NULL? 
77EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesISMEAN11 Allow NULL? 
78VBELNCONTRACTContract Numbernvarchar100CHAR(N' ')Yes*JVBELNCONTRACT Allow NULL? 
79POSNRCONTRACTItem Number in Contractnvarchar60NUMC(N'000000')Yes*JPOSNRCONTRACT Allow NULL? 
80PRODIS-M: Media Productnvarchar180CHAR(N' ')Yes*ISMMEDIAPRODUCT Allow NULL? 
81STATEGRGoods Receipt Effectedchar10CHAR(N' ')YesISMSTATEGR Allow NULL? 
82STATEPOPurchase Order Createdchar10CHAR(N' ')YesISMSTATEPO Allow NULL? 
83RETURNCOMMENTCommentnvarchar300CHAR(N' ')YesISMRETURNCOMMENT Allow NULL? 
84PHASEMDLPhase Modelnvarchar100CHAR(N' ')Yes*JVPHASEMDL Allow NULL? 
85PHASENBRSequence Number in Phase Deliverynvarchar100NUMC(N'0000000000')YesJVPHASENBR Allow NULL? 
86UNSOLDDATEITEMItem Notification Datenvarchar80DATS(N'00000000')YesJUNSOLDDATE_ITEM Allow NULL? 
87ERFUSERCreated Bynvarchar120CHAR(N' ')YesERFUSER Allow NULL? 
88ERFDATECreated Onnvarchar80DATS(N'00000000')YesERFDATE Allow NULL? 
89ERFTIMETime Creatednvarchar60TIMS(N'000000')YesERFTIME Allow NULL? 
90AENUSERLast Changed Bynvarchar120CHAR(N' ')YesAENUSER Allow NULL? 
91AENDATEDate of Last Changenvarchar80DATS(N'00000000')YesAENDATE Allow NULL? 
92AENTIMETime of Last Changenvarchar60TIMS(N'000000')YesAENTIME Allow NULL? 
NamePrimaryUniqueTypeColumns
JKSDUNSOLDITEM~0YesYesCLUSTEREDPOSNR, VBELN, MANDT
JKSDUNSOLDITEM~001NoNoNONCLUSTEREDMATNR, MANDT
JKSDUNSOLDITEM~002NoNoNONCLUSTEREDCREDIT_POSNR, CREDIT_NUMBER, MANDT
JKSDUNSOLDITEM~003NoNoNONCLUSTEREDSTATE, PUBL_DATE, COPY_NUMBER, MEDIA_ISSUE, MEDIA_PRODUCT, MEDIA_FAMILY, MANDT
JKSDUNSOLDITEM~004NoNoNONCLUSTEREDREF_POSNR, MANDT
JKSDUNSOLDITEM~005NoNoNONCLUSTEREDPUBL_DATE, MANDT
JKSDUNSOLDITEM~006NoNoNONCLUSTEREDMEDIA_ISSUE, MANDT
JKSDUNSOLDITEM~007NoNoNONCLUSTEREDSTATE, MANDT