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  | STPO
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 :: Logistics Basic Data :: Bills of Material
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0STPO12810BOM itemBills of Material
SQL:  selectupdate insert create

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

SELECT MANDT, STLTY, STLNR, STLKN, STPOZ, DATUV, TECHV, AENNR, LKENZ, VGKNT, VGPZL, ANDAT, ANNAM, AEDAT, AENAM, IDNRK, PSWRK, POSTP, POSNR, SORTF, MEINS, MENGE, FMENG, AUSCH, AVOAU, NETAU, SCHGT, BEIKZ, ERSKZ, RVREL, SANFE, SANIN, SANKA, SANKO, SANVS, STKKZ, REKRI, REKRS, CADPO, NFMAT, NLFZT, VERTI, ALPOS, EWAHR, EKGRP, LIFZT, LIFNR, PREIS, PEINH, WAERS, SAKTO, ROANZ, ROMS1, ROMS2, ROMS3, ROMEI, ROMEN, RFORM, UPSKZ, VALKZ, LTXSP, POTX1, POTX2, OBJTY, MATKL, WEBAZ, DOKAR, DOKNR, DOKVR, DOKTL, CSSTR, CLASS, KLART, POTPR, AWAKZ, INSKZ, VCEKZ, VSTKZ, VACKZ, EKORG, CLOBK, CLMUL, CLALT, CVIEW, KNOBJ, LGORT, KZKUP, INTRM, TPEKZ, STVKN, DVDAT, DVNAM, DSPST, ALPST, ALPRF, ALPGR, KZNFP, NFGRP, NFEAG, KNDVB, KNDBZ, KSTTY, KSTNR, KSTKN, KSTPZ, CLSZU, KZCLB, AEHLP, PRVBE, NLFZV, NLFMV, IDPOS, IDHIS, IDVAR, ALEKZ, ITMID, GUID, ITSOB, RFPNT, GUIDX, SGT_CMKZ, SGT_CATV, VALID_TO, VALID_TO_RKEY, ECN_TO, ECN_TO_RKEY, CUFACTOR, FUNCID FROM STPO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2STLTYBOM categorychar10CHAR(N' ')NoSTLTY Allow NULL? 
3STLNRBill of materialnvarchar80CHAR(N' ')NoSTNUM Allow NULL? 
4STLKNBOM item node numbernvarchar80NUMC(N'00000000')NoSTLKN Allow NULL? 
5STPOZInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
6DATUVValid-From Datenvarchar80DATS(N'00000000')YesDATUV Allow NULL? 
7TECHVTechnical status fromnvarchar120CHAR(N' ')YesTECHV Allow NULL? 
8AENNRChange Numbernvarchar120CHAR(N' ')YesAENRAENNR Allow NULL? 
9LKENZDeletion Indicatorchar10CHAR(N' ')YesLKENZ Allow NULL? 
10VGKNTPredecessor Nodenvarchar80NUMC(N'00000000')YesVGKNT Allow NULL? 
11VGPZLPrevious item counternvarchar80NUMC(N'00000000')YesVGPZL Allow NULL? 
12ANDATDate record created onnvarchar80DATS(N'00000000')YesANDAT Allow NULL? 
13ANNAMUser who created recordnvarchar120CHAR(N' ')YesANNAM Allow NULL? 
14AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
15AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
16IDNRKBOM componentnvarchar180CHAR(N' ')Yes*IDNRK Allow NULL? 
17PSWRKIssuing plantnvarchar40CHAR(N' ')YesT001WPSWRK Allow NULL? 
18POSTPItem Category (Bill of Material)char10CHAR(N' ')YesT418POSTP Allow NULL? 
19POSNRBOM Item Numbernvarchar40CHAR(N' ')YesSPOSN Allow NULL? 
20SORTFSort Stringnvarchar100CHAR(N' ')YesSORTP Allow NULL? 
21MEINSComponent unit of measurenvarchar30UNIT(N' ')YesT006KMPME Allow NULL? 
22MENGEComponent quantitydecimal133QUAN((0))YesKMPMG
23FMENGFixed qtychar10CHAR(N' ')YesFMNGE Allow NULL? 
24AUSCHComponent scrap in percentdecimal52DEC((0))YesKAUSF
25AVOAUOperation scrapdecimal52DEC((0))YesAVOAU
26NETAUIndicator: Net scrapchar10CHAR(N' ')YesNETAU Allow NULL? 
27SCHGTIndicator: Bulk Materialchar10CHAR(N' ')YesSCHGT Allow NULL? 
28BEIKZMaterial Provision Indicatorchar10CHAR(N' ')YesT417BEIKZ Allow NULL? 
29ERSKZIndicator: spare partchar10CHAR(N' ')YesT413ERSKZ Allow NULL? 
30RVRELIndicator: item relevant to saleschar10CHAR(N' ')YesTVRLRVREL Allow NULL? 
31SANFEIndicator: item relevant to productionchar10CHAR(N' ')YesSANFE Allow NULL? 
32SANINIndicator: item relevant to plant maintenancechar10CHAR(N' ')YesSANIN Allow NULL? 
33SANKAIndicator for relevancy to costingchar10CHAR(N' ')YesTCK08CS_SANKA Allow NULL? 
34SANKOIndicator: item relevant to engineeringchar10CHAR(N' ')YesSANKO Allow NULL? 
35SANVSIndicator: high-level configurationchar10CHAR(N' ')YesSANVS Allow NULL? 
36STKKZPM assembly indicatorchar10CHAR(N' ')YesSTKKZ Allow NULL? 
37REKRIIndicator: BOM is recursivechar10CHAR(N' ')YesREKRI Allow NULL? 
38REKRSIndicator: recursiveness allowedchar10CHAR(N' ')YesREKRS Allow NULL? 
39CADPOCAD Indicatorchar10CHAR(N' ')YesCADPO Allow NULL? 
40NFMATFollow-up material in BOM item - NOT IN USEnvarchar180CHAR(N' ')YesMARACS_NFMAT Allow NULL? 
41NLFZTLead-time offsetdecimal30DEC((0))YesNLFZT
42VERTIDistribution key for component consumptionnvarchar40CHAR(N' ')YesT437VSA_VERTI Allow NULL? 
43ALPOSIndicator: alternative itemchar10CHAR(N' ')YesALPOS Allow NULL? 
44EWAHRUsage probability in % (alternative item)decimal30DEC((0))YesEWAHR
45EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
46LIFZTDelivery time in daysdecimal30DEC((0))YesLIFZT
47LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
48PREISPricedecimal112CURR((0))YesCPREI
49PEINHPrice Unitdecimal50DEC((0))YesPEINH
50WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
51SAKTOCost elementnvarchar100CHAR(N' ')Yes*SAKTO Allow NULL? 
52ROANZNumber of variable-size itemsdecimal133QUAN((0))YesROANZ
53ROMS1Size 1decimal133QUAN((0))YesROMS1
54ROMS2Size 2decimal133QUAN((0))YesROMS2
55ROMS3Size 3decimal133QUAN((0))YesROMS3
56ROMEIUnit of measure for sizes 1 to 3nvarchar30UNIT(N' ')YesT006ROMEI Allow NULL? 
57ROMENQuantity of variable-size itemdecimal133QUAN((0))YesROMEN
58RFORMFormula keynvarchar20CHAR(N' ')YesT418FRFORM Allow NULL? 
59UPSKZIndicator: sub-items existchar10CHAR(N' ')YesUPSKZ Allow NULL? 
60VALKZIndicator: item in more than one alternativechar10CHAR(N' ')YesVALKZ Allow NULL? 
61LTXSPLong Text Language, for Creation of a Change Documentchar10LANG(N' ')YesT002LTXSP_CP Allow NULL? 
62POTX1BOM Item Text (Line 1)nvarchar400CHAR(N' ')YesPOTX1 Allow NULL? 
63POTX2BOM item text (line 2)nvarchar400CHAR(N' ')YesPOTX2 Allow NULL? 
64OBJTYObject type (BOM item)char10CHAR(N' ')Yes*OBJTY Allow NULL? 
65MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
66WEBAZGoods Receipt Processing Time in Daysdecimal30DEC((0))YesWEBAZ
67DOKARDocument Typenvarchar30CHAR(N' ')YesTDWADOKAR Allow NULL? 
68DOKNRDocument numbernvarchar250CHAR(N' ')Yes*DOKNR Allow NULL? 
69DOKVRDocument Versionnvarchar20CHAR(N' ')YesDOKVR Allow NULL? 
70DOKTLDocument Partnvarchar30CHAR(N' ')YesDOKTL_D Allow NULL? 
71CSSTRAverage material purity in %decimal52DEC((0))YesCSSTR
72CLASSClass numbernvarchar180CHAR(N' ')YesKLASSE_D Allow NULL? 
73KLARTClass Typenvarchar30CHAR(N' ')YesTCLAKLASSENART Allow NULL? 
74POTPRResulting item categorychar10CHAR(N' ')YesT418POTPR Allow NULL? 
75AWAKZSelection indicator for configurable BOMschar10CHAR(N' ')YesAWAKZ Allow NULL? 
76INSKZInstance indicatorchar10CHAR(N' ')YesINSKZ Allow NULL? 
77VCEKZIndicator: not displayed in configuration editorchar10CHAR(N' ')YesVCEKZ Allow NULL? 
78VSTKZIndicator: not displayed in single-level configurationchar10CHAR(N' ')YesVSTKZ Allow NULL? 
79VACKZIndicator: not displayed in automatic configurationchar10CHAR(N' ')YesVACKZ Allow NULL? 
80EKORGPurchasing Organizationnvarchar40CHAR(N' ')YesT024EEKORG Allow NULL? 
81CLOBKRequired Componentchar10CHAR(N' ')YesCLOBK Allow NULL? 
82CLMULMultiple Selection Allowedchar10CHAR(N' ')YesCLMULT Allow NULL? 
83CLALTAlternative Display Formatchar10CHAR(N' ')YesCLALT Allow NULL? 
84CVIEWOrganizational Areanvarchar100CHAR(N' ')YesABTEILUNG Allow NULL? 
85KNOBJNumber of Object with Assigned Dependenciesnvarchar180NUMC(N'000000000000000000')YesKNOBJ Allow NULL? 
86LGORTIssue location for production ordernvarchar40CHAR(N' ')YesT001LCSLGO Allow NULL? 
87KZKUPIndicator: co-productchar10CHAR(N' ')YesKZKUP Allow NULL? 
88INTRMIntra Materialnvarchar180CHAR(N' ')Yes*INTRM Allow NULL? 
89TPEKZIndicator: restrictions existchar10CHAR(N' ')YesTPEKZ Allow NULL? 
90STVKNInherited node number of BOM itemnvarchar80NUMC(N'00000000')YesSTVKN Allow NULL? 
91DVDATDate of last date shiftnvarchar80DATS(N'00000000')YesDVDAT Allow NULL? 
92DVNAMName of the user who carried out the date shiftnvarchar120CHAR(N' ')YesDVNAM Allow NULL? 
93DSPSTExplosion typenvarchar20CHAR(N' ')YesT414CS_DISPO Allow NULL? 
94ALPSTAlternative item: strategychar10CHAR(N' ')YesCS_ALPST Allow NULL? 
95ALPRFAlternative item: ranking ordernvarchar20NUMC(N'00')YesCS_ALPRF Allow NULL? 
96ALPGRAlternative item: groupnvarchar20CHAR(N' ')YesCS_ALPGR Allow NULL? 
97KZNFPIndicator: Follow-Up Itemchar10CHAR(N' ')YesCS_KZNFP Allow NULL? 
98NFGRPFollow-up groupnvarchar20CHAR(N' ')YesCS_NFGRP Allow NULL? 
99NFEAGDiscontinuation groupnvarchar20CHAR(N' ')YesCS_NFEAG Allow NULL? 
100KNDVBIndicator: manual change to sales order BOMchar10CHAR(N' ')YesCS_KNDVB Allow NULL? 
101KNDBZIndicator: BOM item changed/selected via obj. dependencieschar10CHAR(N' ')YesCS_KNDBZ Allow NULL? 
102KSTTYBOM category of original sales order BOM itemchar10CHAR(N' ')YesCS_KSTTY Allow NULL? 
103KSTNRBill of material for original sales order BOM itemnvarchar80CHAR(N' ')YesCS_KSTNR Allow NULL? 
104KSTKNNode number of original sales order BOM itemnvarchar80NUMC(N'00000000')YesCS_KSTKN Allow NULL? 
105KSTPZCounter for original sales order BOM itemnvarchar80NUMC(N'00000000')YesCS_KSTPZ Allow NULL? 
106CLSZUClassification numbernvarchar80NUMC(N'00000000')YesCS_CLSZU Allow NULL? 
107KZCLBIndicator: classification as selection conditionchar10CHAR(N' ')YesCS_KZCLB Allow NULL? 
108AEHLPDate Shift Hierarchy Indicatornvarchar20NUMC(N'00')YesCC_AEHLP Allow NULL? 
109PRVBEProduction Supply Areanvarchar100CHAR(N' ')YesPVBEPRVBE Allow NULL? 
110NLFZVLead-time offset for operationdecimal30DEC((0))YesCS_NLFZV
111NLFMVUnit for lead-time offset for operationnvarchar30UNIT(N' ')YesT006CS_NLFMV Allow NULL? 
112IDPOSItem groupnvarchar200CHAR(N' ')YesCS_IDPOS Allow NULL? 
113IDHISHistory counternvarchar50NUMC(N'00000')YesCS_IDHIS Allow NULL? 
114IDVARComponent Variantnvarchar50CHAR(N' ')YesCS_IDVAR Allow NULL? 
115ALEKZALE indicatorchar10CHAR(N' ')YesCS_ALEKZ Allow NULL? 
116ITMIDExternal identification of an itemnvarchar80CHAR(N' ')YesCS_ITMID Allow NULL? 
117GUIDTemporarily not usednvarchar220CHAR(N' ')YesCS_CHAR22 Allow NULL? 
118ITSOBSpecial procurement type for BOM itemnvarchar20CHAR(N' ')Yes*CS_SOBSL Allow NULL? 
119RFPNTReference point for BOM transfernvarchar200CHAR(N' ')YesTCNRFPCN_RFPNT Allow NULL? 
120GUIDXGlobal identification of an item's change statusvarbinary160RAWYesCS_GUID
121SGT_CMKZSegmentation Maintained for BOM Componentschar10CHAR(N' ')YesSGT_CMKZ Allow NULL? 
122SGT_CATVSegmentation Valuenvarchar160CHAR(N' ')YesSGT_CATV Allow NULL? 
123VALID_TOValid-to datenvarchar80DATS(N'00000000')YesDATUB Allow NULL? 
124VALID_TO_RKEYValid-to datenvarchar80DATS(N'00000000')YesDATUB Allow NULL? 
125ECN_TOChange Number Tonvarchar120CHAR(N' ')Yes*AENRA Allow NULL? 
126ECN_TO_RKEYChange Number Tonvarchar120CHAR(N' ')Yes*AENRA Allow NULL? 
127CUFACTORCU: Number of CU Instancesnvarchar60NUMC(N'000000')Yes*/CUM/CUFACTOR Allow NULL? 
128FUNCIDFunction Identifiernvarchar400CHAR(N' ')YesCCC_FUNCID Allow NULL? 
NamePrimaryUniqueTypeColumns
STPO~0YesYesCLUSTEREDSTPOZ, STLKN, STLNR, STLTY, MANDT
STPO~ANoNoNONCLUSTEREDAENNR, MANDT
STPO~CNoNoNONCLUSTEREDCLSZU, STLNR, STLTY, MANDT
STPO~DNoNoNONCLUSTEREDSTLTY, DOKTL, DOKVR, DOKNR, DOKAR, MANDT
STPO~GNoNoNONCLUSTEREDGUIDX, MANDT
STPO~KNoNoNONCLUSTEREDSTLTY, CLASS, KLART, MANDT
STPO~MNoNoNONCLUSTEREDSTLTY, KZKUP, IDNRK, MANDT
STPO~PNoNoNONCLUSTEREDIDVAR, IDPOS, MANDT
STPO~SNoNoNONCLUSTEREDSTVKN, STLNR, STLTY, MANDT
STPO~WNoNoNONCLUSTEREDSTLTY, KNOBJ, MANDT

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