SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
1ERP EHP76.0ZEIMMARA2281USING FOR STORING EIM MARA DATAS
SQL:  selectupdate insert create

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

SELECT MANDT, MATNR, ERSDA, ERNAM, LAEDA, AENAM, VPSTA, PSTAT, LVORM, MTART, MBRSH, MATKL, BISMT, MEINS, BSTME, ZEINR, ZEIAR, ZEIVR, ZEIFO, AESZN, BLATT, BLANZ, FERTH, FORMT, GROES, WRKST, NORMT, LABOR, EKWSL, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, BEHVO, RAUBE, TEMPB, DISST, TRAGR, STOFF, SPART, KUNNR, EANNR, WESCH, BWVOR, BWSCL, SAISO, ETIAR, ETIFO, ENTAR, EAN11, NUMTP, LAENG, BREIT, HOEHE, MEABM, PRDHA, AEKLK, CADKZ, QMPUR, ERGEW, ERGEI, ERVOL, ERVOE, GEWTO, VOLTO, VABME, KZREV, KZKFG, XCHPF, VHART, FUELG, STFAK, MAGRV, BEGRU, DATAB, LIQDT, SAISJ, PLGTP, MLGUT, EXTWG, SATNR, ATTYP, KZKUP, KZNFM, PMATA, MSTAE, MSTAV, MSTDE, MSTDV, TAKLV, RBNRM, MHDRZ, MHDHB, MHDLP, INHME, INHAL, VPREH, ETIAG, INHBR, CMETH, CUOBF, KZUMW, KOSCH, SPROF, NRFHG, MFRPN, MFRNR, BMATN, MPROF, KZWSM, SAITY, PROFL, IHIVI, ILOOS, SERLV, KZGVH, XGCHP, KZEFF, COMPL, IPRKZ, RDMHD, PRZUS, MTPOS_MARA, BFLME, MATFI, CMREL, BBTYP, SLED_BBD, GTIN_VARIANT, GENNR, RMATP, GDS_RELEVANT, WEORA, HUTYP_DFLT, PILFERABLE, WHSTC, WHMATGR, HNDLCODE, HAZMAT, HUTYP, TARE_VAR, MAXC, MAXC_TOL, MAXL, MAXB, MAXH, MAXDIM_UOM, HERKL, MFRGR, QQTIME, QQTIMEUOM, QGRP, SERIAL, PS_SMARTFORM, LOGUNIT, CWQREL, CWQPROC, CWQTOLGR, ADPROF, IPMIPPRODUCT, ALLOW_PMAT_IGNO, MEDIUM, COMMODITY, ANIMAL_ORIGIN, TEXTILE_COMP_IND, SGT_CSGR, SGT_COVSA, SGT_STAT, SGT_SCOPE, SGT_REL, ANP, FSH_MG_AT1, FSH_MG_AT2, FSH_MG_AT3, FSH_SEALV, FSH_SEAIM, FSH_SC_MID, /BEV1/LULEINH, /BEV1/LULDEGRP, /BEV1/NESTRUCCAT, /DSD/SL_TOLTYP, /DSD/SV_CNT_GRP, /DSD/VC_GROUP, /VSO/R_TILT_IND, /VSO/R_STACK_IND, /VSO/R_BOT_IND, /VSO/R_TOP_IND, /VSO/R_STACK_NO, /VSO/R_PAL_IND, /VSO/R_PAL_OVR_D, /VSO/R_PAL_OVR_W, /VSO/R_PAL_B_HT, /VSO/R_PAL_MIN_H, /VSO/R_TOL_B_HT, /VSO/R_NO_P_GVH, /VSO/R_QUAN_UNIT, /VSO/R_KZGVH_IND, PACKCODE, DG_PACK_STATUS, MCOND, RETDELC, LOGLEV_RETO, NSNID, ADSPC_SPC, IMATN, PICNUM, BSTAT, COLOR_ATINN, SIZE1_ATINN, SIZE2_ATINN, COLOR, SIZE1, SIZE2, FREE_CHAR, CARE_CODE, BRAND_ID, FIBER_CODE1, FIBER_PART1, FIBER_CODE2, FIBER_PART2, FIBER_CODE3, FIBER_PART3, FIBER_CODE4, FIBER_PART4, FIBER_CODE5, FIBER_PART5, FASHGRD FROM ZEIMMARA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2MATNRMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
3ERSDACreated Onnvarchar80DATS(N'00000000')YesERSDA Allow NULL? 
4ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
5LAEDADate of Last Changenvarchar80DATS(N'00000000')YesLAEDA Allow NULL? 
6AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
7VPSTAMaintenance status of complete materialnvarchar150CHAR(N' ')YesVPSTA Allow NULL? 
8PSTATMaintenance statusnvarchar150CHAR(N' ')YesPSTAT_D Allow NULL? 
9LVORMFlag Material for Deletion at Client Levelchar10CHAR(N' ')YesLVOMA Allow NULL? 
10MTARTMaterial Typenvarchar40CHAR(N' ')YesT134MTART Allow NULL? 
11MBRSHIndustry sectorchar10CHAR(N' ')YesT137MBRSH Allow NULL? 
12MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
13BISMTOld material numbernvarchar180CHAR(N' ')YesBISMT Allow NULL? 
14MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
15BSTMEPurchase Order Unit of Measurenvarchar30UNIT(N' ')YesT006BSTME Allow NULL? 
16ZEINRDocument number (without document management system)nvarchar220CHAR(N' ')YesDZEINR Allow NULL? 
17ZEIARDocument type (without Document Management system)nvarchar30CHAR(N' ')YesDZEIAR Allow NULL? 
18ZEIVRDocument version (without Document Management system)nvarchar20CHAR(N' ')YesDZEIVR Allow NULL? 
19ZEIFOPage format of document (without Document Management system)nvarchar40CHAR(N' ')YesDZEIFO Allow NULL? 
20AESZNDocument change number (without document management system)nvarchar60CHAR(N' ')YesAESZN Allow NULL? 
21BLATTPage number of document (without Document Management system)nvarchar30CHAR(N' ')YesBLATT Allow NULL? 
22BLANZNumber of sheets (without Document Management system)nvarchar30NUMC(N'000')YesBLANZ Allow NULL? 
23FERTHProduction/inspection memonvarchar180CHAR(N' ')YesFERTH Allow NULL? 
24FORMTPage Format of Production Memonvarchar40CHAR(N' ')YesFORMT Allow NULL? 
25GROESSize/dimensionsnvarchar320CHAR(N' ')YesGROES Allow NULL? 
26WRKSTBasic Materialnvarchar480CHAR(N' ')YesTWSPRWRKST Allow NULL? 
27NORMTIndustry Standard Description (such as ANSI or ISO)nvarchar180CHAR(N' ')YesNORMT Allow NULL? 
28LABORLaboratory/design officenvarchar30CHAR(N' ')YesT024LLABOR Allow NULL? 
29EKWSLPurchasing Value Keynvarchar40CHAR(N' ')YesT405EKWSL Allow NULL? 
30BRGEWGross Weightdecimal133QUAN((0))YesBRGEW
31NTGEWNet Weightdecimal133QUAN((0))YesNTGEW
32GEWEIWeight Unitnvarchar30UNIT(N' ')YesT006GEWEI Allow NULL? 
33VOLUMVolumedecimal133QUAN((0))YesVOLUM
34VOLEHVolume unitnvarchar30UNIT(N' ')YesT006VOLEH Allow NULL? 
35BEHVOContainer requirementsnvarchar20CHAR(N' ')YesT144BEHVO Allow NULL? 
36RAUBEStorage conditionsnvarchar20CHAR(N' ')YesT142RAUBE Allow NULL? 
37TEMPBTemperature conditions indicatornvarchar20CHAR(N' ')YesT143TEMPB Allow NULL? 
38DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
39TRAGRTransportation Groupnvarchar40CHAR(N' ')YesTTGRTRAGR Allow NULL? 
40STOFFHazardous material numbernvarchar180CHAR(N' ')YesMGEFSTOFF Allow NULL? 
41SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
42KUNNRCompetitornvarchar100CHAR(N' ')YesV_KNA1WETTWETTB Allow NULL? 
43EANNREuropean Article Number (EAN) - obsolete!!!!!nvarchar130CHAR(N' ')YesEANNR Allow NULL? 
44WESCHQuantity: Number of GR/GI slips to be printeddecimal133QUAN((0))YesWESCH
45BWVORProcurement rulechar10CHAR(N' ')YesT6WP1BWVOR Allow NULL? 
46BWSCLSource of Supplychar10CHAR(N' ')YesTMBW1BWSCL Allow NULL? 
47SAISOSeason Categorynvarchar40CHAR(N' ')YesT6WSPSAISO Allow NULL? 
48ETIARLabel typenvarchar20CHAR(N' ')YesT6WP3ETIAR Allow NULL? 
49ETIFOLabel formnvarchar20CHAR(N' ')YesT6WP4ETIFO Allow NULL? 
50ENTARDeactivatedchar10CHAR(N' ')YesDUMMYENTAR Allow NULL? 
51EAN11International Article Number (EAN/UPC)nvarchar180CHAR(N' ')YesEAN11 Allow NULL? 
52NUMTPCategory of International Article Number (EAN)nvarchar20CHAR(N' ')YesTNTPNUMTP Allow NULL? 
53LAENGLengthdecimal133QUAN((0))YesLAENG
54BREITWidthdecimal133QUAN((0))YesBREIT
55HOEHEHeightdecimal133QUAN((0))YesHOEHE
56MEABMUnit of Dimension for Length/Width/Heightnvarchar30UNIT(N' ')YesT006MEABM Allow NULL? 
57PRDHAProduct hierarchynvarchar180CHAR(N' ')YesT179PRODH_D Allow NULL? 
58AEKLKStock Transfer Net Change Costingchar10CHAR(N' ')YesCK_AEKLK Allow NULL? 
59CADKZCAD Indicatorchar10CHAR(N' ')YesCADKZ Allow NULL? 
60QMPURQM in Procurement is Activechar10CHAR(N' ')YesQMPUR Allow NULL? 
61ERGEWAllowed packaging weightdecimal133QUAN((0))YesERGEW
62ERGEIUnit of weight (allowed packaging weight)nvarchar30UNIT(N' ')YesT006ERGEI Allow NULL? 
63ERVOLAllowed packaging volumedecimal133QUAN((0))YesERVOL
64ERVOEVolume unit (allowed packaging volume)nvarchar30UNIT(N' ')YesT006ERVOE Allow NULL? 
65GEWTOExcess Weight Tolerance for Handling unitdecimal31DEC((0))YesGEWTO
66VOLTOExcess Volume Tolerance of the Handling Unitdecimal31DEC((0))YesVOLTO
67VABMEVariable Purchase Order Unit Activechar10CHAR(N' ')YesVABME Allow NULL? 
68KZREVRevision Level Has Been Assigned to the Materialchar10CHAR(N' ')YesKZREV Allow NULL? 
69KZKFGConfigurable Materialchar10CHAR(N' ')YesKZKFG Allow NULL? 
70XCHPFBatch management requirement indicatorchar10CHAR(N' ')YesXCHPF Allow NULL? 
71VHARTPackaging Material Typenvarchar40CHAR(N' ')YesTVTYVHIART Allow NULL? 
72FUELGMaximum level (by volume)decimal30DEC((0))YesFUELG
73STFAKStacking factorsmallint50INT2((0))YesSTFAK
74MAGRVMaterial Group: Packaging Materialsnvarchar40CHAR(N' ')YesTVEGRMAGRV Allow NULL? 
75BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
76DATABValid-From Datenvarchar80DATS(N'00000000')YesDATAB Allow NULL? 
77LIQDTDeletion datenvarchar80DATS(N'00000000')YesLIQDT Allow NULL? 
78SAISJSeason Yearnvarchar40CHAR(N' ')YesSAISJ Allow NULL? 
79PLGTPPrice Band Categorynvarchar20CHAR(N' ')YesTWPTPLGTP Allow NULL? 
80MLGUTEmpties Bill of Materialchar10CHAR(N' ')YesW_MITLEERG Allow NULL? 
81EXTWGExternal Material Groupnvarchar180CHAR(N' ')YesTWEWEXTWG Allow NULL? 
82SATNRCross-Plant Configurable Materialnvarchar180CHAR(N' ')YesMARASATNR Allow NULL? 
83ATTYPMaterial Categorynvarchar20CHAR(N' ')YesATTYP Allow NULL? 
84KZKUPIndicator: Material can be co-productchar10CHAR(N' ')YesKZKUPMAT Allow NULL? 
85KZNFMIndicator: The material has a follow-up materialchar10CHAR(N' ')YesKZNFM Allow NULL? 
86PMATAPricing Reference Materialnvarchar180CHAR(N' ')YesMARAPMATN Allow NULL? 
87MSTAECross-Plant Material Statusnvarchar20CHAR(N' ')YesT141MSTAE Allow NULL? 
88MSTAVCross-distribution-chain material statusnvarchar20CHAR(N' ')YesTVMSMSTAV Allow NULL? 
89MSTDEDate from which the cross-plant material status is validnvarchar80DATS(N'00000000')YesMSTDE Allow NULL? 
90MSTDVDate from which the X-distr.-chain material status is validnvarchar80DATS(N'00000000')YesMSTDV Allow NULL? 
91TAKLVTax classification of the materialchar10CHAR(N' ')YesTSKMTAKLV Allow NULL? 
92RBNRMCatalog Profilenvarchar90CHAR(N' ')YesT352BRBNR Allow NULL? 
93MHDRZMinimum Remaining Shelf Lifedecimal40DEC((0))YesMHDRZ
94MHDHBTotal shelf lifedecimal40DEC((0))YesMHDHB
95MHDLPStorage percentagedecimal30DEC((0))YesMHDLP
96INHMEContent unitnvarchar30UNIT(N' ')YesT006INHME Allow NULL? 
97INHALNet contentsdecimal133QUAN((0))YesINHAL
98VPREHComparison price unitdecimal50DEC((0))YesVPREH
99ETIAGIS-R Labeling: material grouping (deactivated in 4.0)nvarchar180CHAR(N' ')Yes*ETIAG Allow NULL? 
100INHBRGross contentsdecimal133QUAN((0))YesINHBR
101CMETHQuantity Conversion Methodchar10CHAR(N' ')YesOIB_CMETH Allow NULL? 
102CUOBFInternal object numbernvarchar180NUMC(N'000000000000000000')YesCUOBM Allow NULL? 
103KZUMWEnvironmentally Relevantchar10CHAR(N' ')YesKZUMW Allow NULL? 
104KOSCHProduct allocation determination procedurenvarchar180CHAR(N' ')YesT190SKOSCH Allow NULL? 
105SPROFPricing profile for variantschar10CHAR(N' ')YesSPROF Allow NULL? 
106NRFHGMaterial qualifies for discount in kindchar10CHAR(N' ')YesNRFHG Allow NULL? 
107MFRPNManufacturer Part Numbernvarchar400CHAR(N' ')YesMFRPN Allow NULL? 
108MFRNRNumber of a Manufacturernvarchar100CHAR(N' ')YesLFA1MFRNR Allow NULL? 
109BMATNNumber of firm's own (internal) inventory-managed materialnvarchar180CHAR(N' ')YesMARAMPMAT Allow NULL? 
110MPROFManufacturer Part Profilenvarchar40CHAR(N' ')YesTMPPFMPROF Allow NULL? 
111KZWSMUnits of measure usagechar10CHAR(N' ')YesKZWSO Allow NULL? 
112SAITYRollout in a Seasonnvarchar20CHAR(N' ')YesT6WSASAITY Allow NULL? 
113PROFLDangerous Goods Indicator Profilenvarchar30CHAR(N' ')YesTDG41ADGE_PROFL Allow NULL? 
114IHIVIIndicator: Highly Viscouschar10CHAR(N' ')YesADGE_IHIVI Allow NULL? 
115ILOOSIndicator: In Bulk/Liquidchar10CHAR(N' ')YesADGE_ILOOS Allow NULL? 
116SERLVLevel of Explicitness for Serial Numberchar10CHAR(N' ')YesSERLV Allow NULL? 
117KZGVHPackaging Material is Closed Packagingchar10CHAR(N' ')YesKZGVH Allow NULL? 
118XGCHPIndicator: Approved batch record requiredchar10CHAR(N' ')YesXGCHP Allow NULL? 
119KZEFFAssign effectivity parameter values/ override change numberschar10CHAR(N' ')YesCC_MTEFF Allow NULL? 
120COMPLMaterial completion levelnvarchar20NUMC(N'00')YesTCSCP_COMP_LVLCSCP_COMP_LVL Allow NULL? 
121IPRKZPeriod Indicator for Shelf Life Expiration Datechar10CHAR(N' ')YesDATTP Allow NULL? 
122RDMHDRounding rule for calculation of SLEDchar10CHAR(N' ')YesRDMHD Allow NULL? 
123PRZUSIndicator: Product composition printed on packagingchar10CHAR(N' ')YesPRZUS Allow NULL? 
124MTPOS_MARAGeneral item category groupnvarchar40CHAR(N' ')YesTPTMMTPOS_MARA Allow NULL? 
125BFLMEGeneric Material with Logistical Variantschar10CHAR(N' ')YesBFLME Allow NULL? 
126MATFIMaterial Is Lockedchar10CHAR(N' ')YesMATFI Allow NULL? 
127CMRELRelevant for Configuration Managementchar10CHAR(N' ')YesDE_CM_RELEVANCE_FLAG Allow NULL? 
128BBTYPAssortment List Typechar10CHAR(N' ')Yes*BBTYP Allow NULL? 
129SLED_BBDExpiration Datechar10CHAR(N' ')YesSLED_BBD Allow NULL? 
130GTIN_VARIANTGlobal Trade Item Number Variantnvarchar20CHAR(N' ')YesGTIN_VARIANT Allow NULL? 
131GENNRMaterial Number of the Generic Material in Prepack Materialsnvarchar180CHAR(N' ')YesMARAWSTR_SATNR_PP Allow NULL? 
132RMATPReference material for materials packed in same waynvarchar180CHAR(N' ')YesMARAPL_RMATP Allow NULL? 
133GDS_RELEVANTIndicator: Global Data Synchronization-Relevantchar10CHAR(N' ')YesGDS_RELEVANT Allow NULL? 
134WEORAAcceptance At Originchar10CHAR(N' ')YesWEORA Allow NULL? 
135HUTYP_DFLTStandard HU Typenvarchar40CHAR(N' ')YesTHUTYPCIFHUTYPDF Allow NULL? 
136PILFERABLEPilferablechar10CHAR(N' ')YesCIFPILFRBL Allow NULL? 
137WHSTCWarehouse Storage Conditionnvarchar20CHAR(N' ')YesTWHSTCCIFWHSTC Allow NULL? 
138WHMATGRWarehouse Material Groupnvarchar40CHAR(N' ')YesTWHMATGRCIFWHMATGR Allow NULL? 
139HNDLCODEHandling Indicatornvarchar40CHAR(N' ')YesTHNDLCDCIFHDLCODE Allow NULL? 
140HAZMATRelevant for Hazardous Substanceschar10CHAR(N' ')YesCIFHAZMAT Allow NULL? 
141HUTYPHandling Unit Typenvarchar40CHAR(N' ')YesTHUTYPCIFHUTYP Allow NULL? 
142TARE_VARVariable Tare Weightchar10CHAR(N' ')YesCIFTAREVAR Allow NULL? 
143MAXCMaximum Allowed Capacity of Packaging Materialdecimal153DEC((0))YesCIFMAXC
144MAXC_TOLOvercapacity Tolerance of the Handling Unitdecimal31DEC((0))YesCIFMAXCTOL
145MAXLMaximum Packing Length of Packaging Materialdecimal153QUAN((0))YesCIFMAXL
146MAXBMaximum Packing Width of Packaging Materialdecimal153QUAN((0))YesCIFMAXB
147MAXHMaximum Packing Height of Packaging Materialdecimal153QUAN((0))YesCIFMAXH
148MAXDIM_UOMUnit of Measure for Maximum Packing Length/Width/Heightnvarchar30UNIT(N' ')YesT006CIFMAXDUOM Allow NULL? 
149HERKLCountry of origin of the materialnvarchar30CHAR(N' ')YesT005HERKL Allow NULL? 
150MFRGRMaterial freight groupnvarchar80CHAR(N' ')YesTMFGMFRGR Allow NULL? 
151QQTIMEQuarantine Perioddecimal30QUAN((0))YesCIFQQTIME
152QQTIMEUOMTime Unit for Quarantine Periodnvarchar30UNIT(N' ')YesT006CIFQQTIMEUOM Allow NULL? 
153QGRPQuality Inspection Groupnvarchar40CHAR(N' ')YesTQGRPCIFQGRP Allow NULL? 
154SERIALSerial Number Profilenvarchar40CHAR(N' ')YesTSERIALCIFSERIAL Allow NULL? 
155PS_SMARTFORMForm Namenvarchar300CHAR(N' ')YesSTXFADMCIFPSSFNAME Allow NULL? 
156LOGUNITEWM CW: Logistics Unit of Measurenvarchar30UNIT(N' ')YesMARMCIFLOGUNIT Allow NULL? 
157CWQRELEWM CW: Material Is a Catch Weight Materialchar10CHAR(N' ')YesCIFCWQREL Allow NULL? 
158CWQPROCEWM CW: Catch Weight Profile for Entering CW Quantitynvarchar20CHAR(N' ')YesTCWQPROCCIFCWQPROC Allow NULL? 
159CWQTOLGREWM-CW: Catch Weight Tolerance Group for EWMnvarchar90CHAR(N' ')YesTCWQTOLGRCIFCWQTOLGR Allow NULL? 
160ADPROFAdjustment Profilenvarchar30CHAR(N' ')YesTAPROFCIFADPROF Allow NULL? 
161IPMIPPRODUCTID for an Intellectual Property (CRM Product)nvarchar400CHAR(N' ')YesCRM_PRODUCT_ID_IP Allow NULL? 
162ALLOW_PMAT_IGNOVariant Price Allowed (for Material Master)char10CHAR(N' ')YesWPM_ALLOW_PMAT_IGNO_MAT Allow NULL? 
163MEDIUMMediumnvarchar60CHAR(N' ')YesT372MMEDIU Allow NULL? 
164COMMODITYPhysical Commoditynvarchar180CHAR(N' ')YesTBAC_PHYSCOMMTBA_STOEFFCHEN Allow NULL? 
165ANIMAL_ORIGINIndicator: Contains Non-Textile Parts of Animal Originchar10CHAR(N' ')YesWRF_ANIMAL_ORIGIN_FLAG Allow NULL? 
166TEXTILE_COMP_INDIndicator: New Textile Composition Functionchar10CHAR(N' ')YesWRF_TEXTL_COMP_IND Allow NULL? 
167SGT_CSGRSegmentation Structurenvarchar40CHAR(N' ')YesSGT_CSGR_TSGT_CSGR Allow NULL? 
168SGT_COVSASegmentation Strategynvarchar80CHAR(N' ')YesSGT_COVS_TSGT_COVSA Allow NULL? 
169SGT_STATSegmentation Material Master Statuschar10CHAR(N' ')YesSGT_STATD Allow NULL? 
170SGT_SCOPESegmentation Strategy Scopechar10CHAR(N' ')YesSGT_SCOPE Allow NULL? 
171SGT_RELSegmentation Relevantchar10CHAR(N' ')YesSGT_REL Allow NULL? 
172ANPANP Codenvarchar90NUMC(N'000000000')YesJ_1BTANPJ_1BANP Allow NULL? 
173FSH_MG_AT1Fashion Information Field: 1nvarchar100CHAR(N' ')Yes*FSH_MG_ATTRIBUTE1 Allow NULL? 
174FSH_MG_AT2Fashion Information Field: 2nvarchar100CHAR(N' ')Yes*FSH_MG_ATTRIBUTE2 Allow NULL? 
175FSH_MG_AT3Fashion Information Field: 3nvarchar60CHAR(N' ')Yes*FSH_MG_ATTRIBUTE3 Allow NULL? 
176FSH_SEALVIndicator: Use of Seasonchar10CHAR(N' ')YesFSH_SEALV Allow NULL? 
177FSH_SEAIMIndicator: Season Active in Inventory Managementchar10CHAR(N' ')YesFSH_SEAIM Allow NULL? 
178FSH_SC_MIDMaterial Conversion ID for Characteristic Value Conversionnvarchar20CHAR(N' ')YesFSH_SC_VCIDSFSH_SC_MID Allow NULL? 
179/BEV1/LULEINHLoading Unitsnvarchar80NUMC(N'00000000')Yes/BEV1/LULEINH Allow NULL? 
180/BEV1/LULDEGRPLoading Unit Group: IS Beveragenvarchar30CHAR(N' ')Yes/BEV1/LUT906/BEV1/LULDEGRP Allow NULL? 
181/BEV1/NESTRUCCATStructure Category for Material Relationshipchar10CHAR(N' ')Yes/BEV1/NESTRUC_CAT Allow NULL? 
182/DSD/SL_TOLTYPTolerance Type IDnvarchar40CHAR(N' ')Yes/DSD/SL_TGTYP/DSD/SL_TOLTYP_ID Allow NULL? 
183/DSD/SV_CNT_GRPCounting Groupnvarchar100CHAR(N' ')Yes/DSD/SV_CNTGR/DSD/SV_COUNT_GROUP Allow NULL? 
184/DSD/VC_GROUPDSD Groupingnvarchar60CHAR(N' ')Yes/DSD/VC_GRP/DSD/VC_GROUP Allow NULL? 
185/VSO/R_TILT_INDMaterial may be Tilted (Vehicle Space Optimization)char10CHAR(N' ')Yes/VSO/M_TILT_IND Allow NULL? 
186/VSO/R_STACK_INDStacking not Allowed (VSO)char10CHAR(N' ')Yes/VSO/M_STACK_IND Allow NULL? 
187/VSO/R_BOT_INDBottom Layer (Vehicle Space Optimization)char10CHAR(N' ')Yes/VSO/M_BOTTOM_IND Allow NULL? 
188/VSO/R_TOP_INDTop Layer (VSO)char10CHAR(N' ')Yes/VSO/M_TOP_IND Allow NULL? 
189/VSO/R_STACK_NOStacking Factor (Vehicle Space Optimization)nvarchar30NUMC(N'000')Yes/VSO/M_STACK_NO Allow NULL? 
190/VSO/R_PAL_INDLoad without Packaging Material (VSO)char10CHAR(N' ')Yes/VSO/M_PALLET_IND Allow NULL? 
191/VSO/R_PAL_OVR_DPermissible Overhang (Depth) of Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_OVR_D
192/VSO/R_PAL_OVR_WPermissible Overhang (Width) of Shipping Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_OVR_W
193/VSO/R_PAL_B_HTMaximum Stacking Height of the Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_BIN_HGT
194/VSO/R_PAL_MIN_HMinimum Stacking Height of the Packaging Material (VSO)decimal133QUAN((0))Yes/VSO/R_PAL_MIN_HT
195/VSO/R_TOL_B_HTTolerance to Exceed the Max. Stacking Height (VSO)decimal133QUAN((0))Yes/VSO/R_TOL_BIN_HT
196/VSO/R_NO_P_GVHNumber of Materials for each Closed PKM (VSO)nvarchar20NUMC(N'00')Yes/VSO/M_ANZ_PER_GVH Allow NULL? 
197/VSO/R_QUAN_UNITUnit of Measure Vehicle Space Optimizationnvarchar30UNIT(N' ')Yes/VSO/R_QUAN_UNIT Allow NULL? 
198/VSO/R_KZGVH_INDClosed Packaging Material Required (VSO)char10CHAR(N' ')Yes/VSO/M_KZGVH_IND Allow NULL? 
199PACKCODEPackaging Codenvarchar100CHAR(N' ')YesCCUNC121CBUNE_PACODE Allow NULL? 
200DG_PACK_STATUSDangerous Goods Packaging Statusnvarchar100CHAR(N' ')YesTDG101ADGE_DG_PACK_STATUS Allow NULL? 
201MCONDMaterial Condition Managementchar10CHAR(N' ')YesDFPS_MCOND Allow NULL? 
202RETDELCReturn Codechar10CHAR(N' ')YesDFPS_RETDELC Allow NULL? 
203LOGLEV_RETOReturn to Logistics Levelchar10CHAR(N' ')YesDFPS_LOGLEV_RETO Allow NULL? 
204NSNIDNATO Item Identification Numbernvarchar90CHAR(N' ')YesDFPS_NSNID Allow NULL? 
205ADSPC_SPCSpare Part Class Codechar10NUMC(N'0')YesADSPC_SPC Allow NULL? 
206IMATNFFF classnvarchar180CHAR(N' ')Yes*IMATN Allow NULL? 
207PICNUMSupersession chain numbernvarchar180CHAR(N' ')YesPIC_PICNUM_SUS Allow NULL? 
208BSTATCreation Status - Seasonal Procurementnvarchar20CHAR(N' ')YesWRFMATBSTATWRFBSTAT Allow NULL? 
209COLOR_ATINNInternal Charactieristic Number for Color Characteristicsnvarchar100NUMC(N'0000000000')Yes*WRF_COLOR_ATINN Allow NULL? 
210SIZE1_ATINNInternal Char. Number for Characteristics for Main Sizesnvarchar100NUMC(N'0000000000')Yes*WRF_SIZE1_ATINN Allow NULL? 
211SIZE2_ATINNInternal Char. Number for Characteristics for Second Sizesnvarchar100NUMC(N'0000000000')Yes*WRF_SIZE2_ATINN Allow NULL? 
212COLORCharacteristic Value for Colors of Variantsnvarchar180CHAR(N' ')YesWRF_COLOR Allow NULL? 
213SIZE1Characteristic Value for Main Sizes of Variantsnvarchar180CHAR(N' ')YesWRF_SIZE1 Allow NULL? 
214SIZE2Characteristic Value for Second Size for Variantsnvarchar180CHAR(N' ')YesWRF_SIZE2 Allow NULL? 
215FREE_CHARCharacteristic Value for Evaluation Purposesnvarchar180CHAR(N' ')YesWRF_FREE_CHAR Allow NULL? 
216CARE_CODECare Codes (such as Washing Code, Ironing Code, etc.)nvarchar160CHAR(N' ')YesWRF_CARE_CODE Allow NULL? 
217BRAND_IDBrandnvarchar40CHAR(N' ')YesWRF_BRANDSWRF_BRAND_ID Allow NULL? 
218FIBER_CODE1Fiber Code for Textiles (Component 1)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_1 Allow NULL? 
219FIBER_PART1Percentage Share of Fiber (Component 1)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_1 Allow NULL? 
220FIBER_CODE2Fiber Code for Textiles (Component 2)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_2 Allow NULL? 
221FIBER_PART2Percentage Share of Fiber (Component 2)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_2 Allow NULL? 
222FIBER_CODE3Fiber Code for Textiles (Component 3)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_3 Allow NULL? 
223FIBER_PART3Percentage Share of Fiber (Component 3)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_3 Allow NULL? 
224FIBER_CODE4Fiber Code for Textiles (Component 4)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_4 Allow NULL? 
225FIBER_PART4Percentage Share of Fiber (Component 4)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_4 Allow NULL? 
226FIBER_CODE5Fiber Code for Textiles (Component 5)nvarchar30CHAR(N' ')YesWRF_FIBER_CODESWRF_FIBER_CODE_5 Allow NULL? 
227FIBER_PART5Percentage Share of Fiber (Component 5)nvarchar30NUMC(N'000')YesWRF_FIBER_PART_5 Allow NULL? 
228FASHGRDFashion Gradenvarchar40CHAR(N' ')YesT6WFGFASHGRD Allow NULL? 
NamePrimaryUniqueTypeColumns
ZEIMMARA~0YesYesCLUSTEREDMANDT, MATNR