SAP Material Management Tables

 SAP Material Management Tables:

Material Management Tables 
EINA purchasing Info record.
EINE Purchasing Info Record Purchasing Data.
MAKT Material description.
MARA General Material Data.
MARC Plant data for material
MARD Storage location Data for material.
MAST Material to BOM Link.
MBEW Material valuation
MKPF Header Material Document
MSEG Document segment material.
MVER Material consumption.
MVKE Sales data for material.
PKPF document header Reservation
TO23 Material Groups .
TO24 Purchasing groups .
T156 Movement Type
Purchasing Tables 
EBAN Purchasing requisition.
EBKN Purchase requisition account assignment.
EKBE History per purchasing document.
EKET Scheduling agreement schedule lines.
EKKN Account assignment in purchasing document.
EKKO Purchasing document header.
EKPO Purchasing document Item.
IKPF Header Physical inventory document.
ISEG Physical inventory document items.
LFA1 Vendor master general data.
LFB1 Vendor Master (company Code)
RESB Reservation/Dependent requirement
MARD Storage location data for material.
           ( Important Fields)
MATNR    Material Number (18C CT-MARA).
WERKS   Plant (4C CT-MARC)
LGORT    Storage location (4C)
LABST     Valuated stock with unrestricted use (13 QUAN).
VMLHE    Stock in transfer (from one storage location 2
                another) (13 QUAN).
VNSHE    Stock  in quality inspection (13 QUAN)
EKKO Purchasing document header  
   ( Important Fields)
EBELN     Purchasing document number.
BUKRS    Company code.
BSTYP     Purchasing document category (1C).
BSART     Purchasing document type (4C).
EKORG    Purchasing organiation (4C  CT-T024E).
EKGRP    Purchasing group (3C CT-T024).
ANGNR    Quotation number.
LLIEF       Supplying Vendor (10C  CT-LFA1).
KUNNR    Customer number (10C CT-KNA1).
MEMORY Purchase Order not yet complete(1C).
MSEG  Document segment material
   (Important Fields)
MBLNR    Number of matrial document (10C)
MJAHR    Material document year.
ZEILE       Item in material document.
MATNR    Material number (18C CT-MARA).
WERKS   Plant (4C CT-T001W).
KDPOS    Item number is sales order(6C).
KDEIN      Delivery schedule for sales order.
BUKRS    Company code.
T001L  Storage Locations  
   (Important Fields)
WERKS    Plant  .
LGORT      Storage location (4C) .
VSTEL      Shipping /Recieving point (CT-TVST) .
VKORG     SAles Organization  (CT-TVKO).
VTWEG     Distribution channel (CT-TVTW).
SPART      Division    (CT-TSPA).
T001W  Plant /Branches.   
     (Important Fields)
WERKS     Plant
ANME1      NAme (30C).
EKORG     Purchase organization (4C CT-T024E).
VSTEL       Shipping /Rekieving port (4C).
MARC  : Plant Data for material.
   (Important Fields)
MANDT     Client
MATNR     Material Number 
WERKS    Plant
DISPR       Material MRP Profile (4C).
DISMM      MRP TYpe (2C) .
DISPO       MRP Controller (3C).
PRCTR      Profit center (10C).
TRAME      Stock in transit (QUAN-13).
STLAN       BOM Usage  (1C).
Area Table Description  
Master Data QMAT Inspection type - material parameters  
Master Data QMHU QM Link Between Inspection Lot and Handling Unit Item  
Master Data QMTB Inspection method master record  
Master Data QMTT Inspection Method Texts  
Master Data QPAC Inspection catalog codes for selected sets  
Master Data QPAM Inspection catalog selected sets  
Master Data QPMK Inspection characteristic master  
Master Data QPMT Master Inspection Characteristics Texts  
Master Data QPMZ Assignment table - insp. methods/master insp. characteristic  
Master Data TQ01D Authorization groups for QM master data  
Master Data TQ01E Text authorization groups for QM master data  
Master Data TQ21 Assignment of screens to screen groups  
Master Data TQ25 QM:screen sequence for master and inspection characteristics  
QM Master Data 
Catalog QPCD Inspection catalog codes  
Catalog QPCT Code texts  
Catalog QPGR Inspection catalog code groups  
Catalog QPGT Code group texts  
Catalog TQ07 Follow-Up Action for Usage Decision of Inspection Lot  
Catalog TQ07A QM: Function Modules for Follow-Up Action  
Catalog TQ07T Language-dependent texts for Table TQ07  
Catalog TQ15 Inspection catalog type index  
Catalog TQ15T Language-dependent texts for table TQ15  
Catalog TQ17 Defect classes  
Catalog TQ17T Language-dependent texts for table TQ17  
Catalog 
Sample Determination QDEB Allwd. Relationships: Sampling Procedures/Dynamic Mod. Rules  
Sample Determination QDEBT Allowed combinations of procedures/dynamic mod. rules: texts  
Sample Determination QDPA Sampling scheme-instructions  
Sample Determination QDPK Sampling scheme header  
Sample Determination QDPKT Sampling scheme: texts  
Sample Determination QDPP Sampling scheme item  
Sample Determination QDQL Quality level  
Sample Determination 
Inspection Char TQ17A Weighting of Char  
Inspection Char TQ11 Inspection Qualification  
Inspection Char TQ29 Tolerance Keys  
Inspection Char T006 Unit of measurement  
Inspection Char 
Dynamic Modification QDBM Valuation mode  
Dynamic Modification QDBMT Valuation Mode: Texts  
Dynamic Modification QDDR Dynamic modification rule (header)  
Dynamic Modification QDDRT Dynamic modification rule: texts  
Dynamic Modification QDEP Allowed inspection severities  
Dynamic Modification QDEPT Allowed Inspection Severities: Texts  
Dynamic Modification QDFB Function modules for the individual procedure categories  
Dynamic Modification QDFBT Function Modules for Procedure: Texts 
Dynamic Modification QDFM Function modules for valuation mode  
Dynamic Modification QDFMT Function Modules for Valuation Mode: Texts  
Dynamic Modification QDPS Inspection stages for a dynamic modification rule 
Dynamic Modification QDPST Inspection Stages: Texts  
Dynamic Modification QDSA Sampling type  
Dynamic Modification QDSAT Sampling Type: Texts  
Dynamic Modification QDSV Sampling procedure  
Dynamic Modification QDSVT Sampling Procedure: Texts  
Dynamic Modification TQ39B QM : Activates reference for dyn. modification level  
Dynamic Modification 
Graphics & SPC QASH Quality control chart  
Graphics & SPC QAST Control chart track  
Graphics & SPC QPSH Control chart types  
Graphics & SPC QPSHT Texts for control chart types  
Graphics & SPC QPSP SPC criterion  
Graphics & SPC QPSPT Texts for SPC criteria  
Graphics & SPC QPST Control chart track  
Graphics & SPC QPSTT Texts for control chart tracks  
Graphics & SPC 
Specifications QMSP QM: material specification  
Specifications 
Inspection Plan PLKO Inspection plan Header  
Inspection Plan MAPL Material Assignement  
Inspection Plan PLPO Operation Details  
Inspection Plan PLMK Inspection plan characteristics  
Inspection Plan PLMW MAPL-Dependent Charac. Specifications (Inspection Plan)  
Inspection Plan TQ03 QSS: Control for Screen Texts/TABLE NOT USED (Rel. 4.6)  
Inspection Plan TQ29A Dependency tolerance key - nominal measurement  
Inspection Plan TQ72 Type of share calculation  
Inspection Plan TQ72T Texts for type of share calculation  
Inspection Plan TQ75 QM formula parameters  
Inspection Plan TQ75F Field names for QM formulas  
Inspection Plan TQ75K Short text for Table TQ75F  
Inspection Plan TQ75T Description of formula parameters  
Inspection Plan 
Qm in procurement QINF QM-info record for material and vendor  
Qm in procurement TQ02 QM system definition  
Qm in procurement TQ02A QM system assignment and QM system requirements  
Qm in procurement TQ02B QM system  
Qm in procurement TQ02T QM system description  
Qm in procurement TQ02U Description QM system  
Qm in procurement TQ04A Functions that can be blocked  
Qm in procurement TQ04S QM block functions : texts  
Qm in procurement TQ05 QM certificate categories for procurement  
Qm in procurement TQ05T QM: text table for certificate types  
Qm in procurement TQ08 Control of QM in procurement  
Qm in procurement TQ08T QM: text for QM procurement keys  
Qm in procurement TQ09 QM: agreement of QM document types  
Qm in procurement TQ09T QM: agreement of QM document types  
Qm in procurement TQ32A Inspection type to status assignment from status profile  
Qm in procurement 
QM in SD QVDM QM Info Record - QM Control in SD  
QM in SD TQ32B Find insp.type for quality insp. for delivery note  
QM in SD 
Inspectio lot QALS Inspection lot record  
Inspectio lot QALT Partial lot  
Inspectio lot T156Q Movement Type: Material-Independent Control  
Inspectio lot TQ30 Inspection types  
Inspectio lot TQ30T Texts for inspection types  
Inspectio lot TQ32 Assignment of inspection type to origin  
Inspectio lot TQ32C Lot creation allowed values for the origin  
Inspectio lot TQ32C _T Texts for lot creation indicator  
Inspectio lot TQ33 Relevant fields for origin  
Inspectio lot TQ34 Default values for inspection type  
Inspectio lot 
Inspection point QAPP Inspection point  
Inspection point TQ79 Table with inspection point/user field combinations  
Inspection point TQ79T Key words for inspeciton point user fields  
Inspection point 
Results Recording QAES Sample unit table  
Results Recording QAKL Results table for value classes  
Results Recording QAMR Characteristic results during inspection processing  
Results Recording QAMV Characteristic specifications for inspection processing  
Results Recording QASE Results table for the sample unit  
Results Recording QASR Sample results for inspection characteristics  
Results Recording QASV Sample specifications for inspection processing  
Results Recording TQ12 Ind. external numbering for test units in results recording  
Results Recording TQ12T Texts for the ind. for ext. numbering of units to be insp.  
Results Recording TQ70 Control table for results recording  
Results Recording TQ70C Function codes for navigation from the char.overview screen  
Results Recording TQ70E Screen-based processing tables  
Results Recording TQ70F Navigation during results recording  
Results Recording TQ70S Characteristic overview screen for results recording  
Results Recording TQ73 Origin of results data  
Results Recording TQ73T Texts for origin of results data  
Results Recording TQ74 Recording configuration  
Results Recording TQ74T Recording configuration  
Results Recording TQ76 Processing status of inspection characteristics  
Results Recording TQ76T Texts for the processing status of insp. characteristics  
Results Recording TQ77 Attributes for the Inspection Characteristic  
Results Recording TQ77T Text Tables for Attributes  
Results Recording TQ78 Status-dependent processing table for insp. characteristics  
Results Recording TQ78T Texts for the status-specific proc. table for insp. char.  
Results Recording 
Defects recording TQ84 Confirmation profile  
Defects recording TQ84T Text table for confirmation profile  
Defects recording TQ86 Report category for defects recording  
Defects recording TQ86A Assignment report category for work center  
Defects recording TQ86T Text table for report category  
Defects recording V_T35 2B_F Generated table for view V_T352B_F  
Defects recording 
Usage decision QAMB QM: Link Between Inspection Lot and Material Document  
Usage decision QAVE Inspection processing: Usage decision  
Usage decision TQ06 Procedure for Calculating the Quality Score  
Usage decision TQ06T Language-specific texts for Table TQ06  
Usage decision TQ07M QM: Inventory postings with usage decision  
Usage decision 
Sample Mgmt QPRN Sample drawing of phys. samples  
Sample Mgmt QPRS Master record for phys. samples  
Sample Mgmt QPRVK Sample-drawing procedure  
Sample Mgmt QPRVK T Header for sample drawing procedure texts  
Sample Mgmt QPRVP Sample-drawing items  
Sample Mgmt QPRVP T Items for sample drawing procedure texts  
Sample Mgmt TQ40 Definition of sample types  
Sample Mgmt TQ40T Text table for sample type  
Sample Mgmt TQ41 Storage locations for physical samples  
Sample Mgmt TQ41T Texts for storage locations  
Sample Mgmt TQ42 Physical sample containers  
Sample Mgmt TQ42T Texts for phys. sample containers  
Sample Mgmt 
QMIS S068 Vendor statistics  
QMIS S069 Material statistics  
QMIS S097 QM notifications: Matl anal.  
QMIS S098 QM notification: Vendor anal.  
QMIS S099 QM notifications: Cust. anal.  
QMIS S100 Problems: Material analysis  
QMIS S102 Problems: Vendor analysis  
QMIS S103 Problems: Customer analysis  
QMIS S104 Customer statistics  
QMIS S161 Inspection results: General  
QMIS S162 Quantitative insp. results  
QMIS S163 Quant. Insp. Result: Vendor 
QMIS S164 Quant. Insp. Result: Vendor  
QMIS S165 Inspection result: gen. custs  
QMIS S166 Insp. Results: Quant. Customer  
QMIS TQ55 Assign inspection lot origin for update group  
QMIS TQ56 Definition of quality score classes  
QMIS TQ56T Text table for the definition of quality score classes  
QMIS TQ57 Assignment of quality score key to info structure  
QMIS 
Quality Certificates QCPR QM quality certificates in procurement  
Quality Certificates I000 Conditions for certificate profile  
Quality Certificates KONDI Conditions: Data part for certificates  
Quality Certificates QCVK Certificate profile header  
Quality Certificates QCVM Certificate profile characteristic level  
Quality Certificates QCVMT Certificate profile characteristic level: texts  
Quality Certificates QCVV Certificate Profile: List of Preliminary Products  
Quality Certificates TQ61 Result value origin for certificates  
Quality Certificates TQ61T Origin of result values for certificates: texts  
Quality Certificates TQ62 Output strategy for skip characteristics  
Quality Certificates TQ62T Output strategy for skip characteristics: texts  
Quality Certificates TQ63 Origin of insp. specs for certificates (function modules)  
Quality Certificates TQ63T Origin of inspection specifications for certificates: texts  
Quality Certificates TQ64 Origin of characteristic short text for certificates  
Quality Certificates TQ64T Origin of characteristic short text for certificates: texts  
Quality Certificates TQ65 Certificates: Combinations allowed for origins, specs/values  
Quality Certificates TQ67 Certificate-Relevant Output Types  
Quality Certificates 
Quality Notification QMEL Notification header  
Quality Notification QMFE Item  
Quality Notification QMSM Task  
Quality Notification QMMA Activities  
Quality Notification T352C Catalog types for each catalog profile  
Quality Notification TQ81 Notification Scenario  
Quality Notification TQ81V Usage of parts  
Quality Notification TQ81V_T Texts for usage of parts  
Quality Notification TQ81_T Texts for Notification Scenarios  
Quality Notification TQ82 Change of Notification Type  
Quality Notification TQ83 Partner Functions for Codes  
Quality Notification TQ85 Function table for follow-up functions  
Quality Notification TQ85R Rules for Follow-Up Functions  
Quality Notification TQ85_T Action box text table  
Quality Notification TQ8CO Assignment of reference orders to notification type  
Quality Notification 
Other Objects MARA Material Number  
Other Objects T001W Plant  
Other Objects LFA1 Vendor  
Other Objects KNA1 Customer  
Other Objects AUFK Order Number  
Other Objects SAFK Run Schedule Header Number  
Other Objects MCH1 Batch Number  
Other Objects MCHA Batch Record  
Other Objects EKKO Purchasing Document Header  
Other Objects EKPO Purchasing document Item  
Other Objects EKET Delivery Schedule  
Other Objects VBUK Delivery Header  
Other Objects VBUP Delivery Item  
Other Objects CSKS Cost Center  
Other Objects EQUI Equipment Number

0 Comments

Thanks for visiting our site : sapguidanceconsultant.blogspot.com
For Fast Response message us through "Contact Form".

Post a Comment

Thanks for visiting our site : sapguidanceconsultant.blogspot.com
For Fast Response message us through "Contact Form".

Post a Comment (0)

Previous Post Next Post