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
Logistics - General :: Logistics Basic Data :: Material Master
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MARA_TMP2351File for Incorrect Data in Direct InputMaterial Master
SQL:  selectupdate insert create

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

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