Monday, October 10, 2016

Database Tables

# CKIS  Items Unit Costing/Itemization Product Costing

CKIS table stores the cost estimate data - naemely the itemization data.

# CRHD (Work Center Header)
FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
OBJTYCR_OBJTYCHAR2Object types of the CIM resource
OBJIDCR_OBJIDNUMC8CRIDObject ID of the resource
BEGDABEGDATUMDATS8Start Date
ENDDAENDDATUMDATS8End Date
AEDAT_GRNDAEDTMDATS8Changed on
AENAM_GRNDUSRNAMECHAR12User Name
AEDAT_VORAAEDTMDATS8Changed on
AENAM_VORAUSRNAMECHAR12User Name
AEDAT_TERMAEDTMDATS8Changed on
AENAM_TERMUSRNAMECHAR12User Name
AEDAT_TECHAEDTMDATS8Changed on
AENAM_TECHUSRNAMECHAR12User Name
ARBPLARBPLCHAR8Work center
WERKSWERKS_DCHAR4T001WPlant
VERWEAP_VERWECHAR4TC30Work Center Category
LVORMAP_LOEVORMCHAR1Deletion flag for work center
PAR01AP_PAR01CHAR6TC20First work center parameter (for formulas)
PAR02AP_PAR02CHAR6TC20Second work center parameter (for formulas)
PAR03AP_PAR03CHAR6TC20Third work center parameter (for formulas)
PAR04AP_PAR04CHAR6TC20Fourth work center parameter (for formulas)
PAR05AP_PAR05CHAR6TC20Fifth work center parameter (for formulas)
PAR06AP_PAR06CHAR6TC20Sixth work center parameter (for formulas)
PARU1AP_PARUNITUNIT3T006Parameter unit
PARU2AP_PARUNITUNIT3T006Parameter unit
PARU3AP_PARUNITUNIT3T006Parameter unit
PARU4AP_PARUNITUNIT3T006Parameter unit
PARU5AP_PARUNITUNIT3T006Parameter unit
PARU6AP_PARUNITUNIT3T006Parameter unit
PARV1AP_PARVALQUAN9(3)Parameter value
PARV2AP_PARVALQUAN9(3)Parameter value
PARV3AP_PARVALQUAN9(3)Parameter value
PARV4AP_PARVALQUAN9(3)Parameter value
PARV5AP_PARVALQUAN9(3)Parameter value
PARV6AP_PARVALQUAN9(3)Parameter value
PLANVAP_PLANVCHAR3TC23Key for task list usage
STANDAP_STANDCHAR10T499SWork center location
VERANAP_VERANCHAR3TC24Person responsible for the work center
VGWTSVORGSCHLCHAR4TC21Standard value key
VGM01AP_VGW_MESCHAR1Rule for standard value maintenance
VGM02AP_VGW_MESCHAR1Rule for standard value maintenance
VGM03AP_VGW_MESCHAR1Rule for standard value maintenance
VGM04AP_VGW_MESCHAR1Rule for standard value maintenance
VGM05AP_VGW_MESCHAR1Rule for standard value maintenance
VGM06AP_VGW_MESCHAR1Rule for standard value maintenance
XDEFAAP_DEFAULTCHAR1Indicator: Work center for default values
XKOSTAP_XKOSTCHAR1Indicator: Work center is maintained for costing
XSPRRAP_XSPRRCHAR1Indicator: Work center is locked
XTERMAP_XTERMCHAR1Indicator: Work center is maintained for scheduling
ZGR01IDZEITGRADCHAR3TC31Key for performance efficiency rate
ZGR02IDZEITGRADCHAR3TC31Key for performance efficiency rate
ZGR03IDZEITGRADCHAR3TC31Key for performance efficiency rate
ZGR04IDZEITGRADCHAR3TC31Key for performance efficiency rate
ZGR05IDZEITGRADCHAR3TC31Key for performance efficiency rate
ZGR06IDZEITGRADCHAR3TC31Key for performance efficiency rate
KTSCHKTSCHCHAR7T435Standard text key
LOANZLOHNANZDEC3Number of Time Tickets
LOARTLOHNARTCHAR4Wage Type
LOGRPLOHNGRPCHAR3T421Wage group
QUALFQUALFCHAR2T423Suitability
RASCHRUEARSCHLUCHAR2T428Setup Type Key
STEUSSTEUSCHAR4T430Control key
VGE01VGWRTEHUNIT3T006Unit of measure for the standard value
VGE02VGWRTEHUNIT3T006Unit of measure for the standard value
VGE03VGWRTEHUNIT3T006Unit of measure for the standard value
VGE04VGWRTEHUNIT3T006Unit of measure for the standard value
VGE05VGWRTEHUNIT3T006Unit of measure for the standard value
VGE06VGWRTEHUNIT3T006Unit of measure for the standard value
KTSCH_REFKTSCH_REFCHAR1Indicator: Standard text key is referenced
LOART_REFLOART_REFCHAR1Indicator: Wage type is referenced
LOANZ_REFLOANZ_REFCHAR1Indicator: Number of time tickets is referenced
LOGRP_REFLOGRP_REFCHAR1Indicator: Wage group is referenced
QUALF_REFQUALF_REFCHAR1Indicator: Suitability is referenced
RASCH_REFRASCH_REFCHAR1Indicator: Setup type key is referenced
STEUS_REFSTEUS_REFCHAR1Indicator: Control key is referenced
FORT1AP_FORM_T1CHAR6TC25Formula for setup time
FORT2AP_FORM_T2CHAR6TC25Formula for the duration of processing time
FORT3AP_FORM_T3CHAR6TC25Formula for teardown time
KAPIDKAPIDNUMC8KAKOCapacity ID
ORTGRORTSGRUPPECHAR4
*
Location group
ZEIWNDZEIWNUNIT3T006Unit for the standard queue time
ZWNORDZWNORQUAN9(3)Standard queue time
ZEIWMDZEIWMUNIT3T006Unit for the minumum queue time
ZWMINDZWMINQUAN9(3)Minimum queue time
FORMRFLGFORMARTCHAR1Indicator: same formulas as in capacity
MATYPMATYPCHAR10TMATYMachine type
CPLGRCPLGRCHAR3T024CCAPP planner group
SORTBSORTBCHAR9TSRTBSort string
MTRVPMTRVPDEC3(1)Additional time percentage for setup
MTMVPMTMVPDEC3(1)Additional time percentage for machines
MTPVPMTPVPDEC3(1)Aditional time percentage for labor
RSANZCR_RS_ANZNUMC3Number of confirmation slips
PDESTCR_PDESTCHAR4TSP03Printer for shop papers
HROIDHROBJIDNUMC8PLOGIObject ID
FORTNAP_FORM_TNCHAR6TC25Formula for the duration of other types of int. processing
ZGR01_REFAP_KZREFCHAR1Field is referenced
ZGR02_REFAP_KZREFCHAR1Field is referenced
ZGR03_REFAP_KZREFCHAR1Field is referenced
ZGR04_REFAP_KZREFCHAR1Field is referenced
ZGR05_REFAP_KZREFCHAR1Field is referenced
ZGR06_REFAP_KZREFCHAR1Field is referenced
STEUS_CSTEUSCHAR4T430Control key
STEUS_ISTEUSCHAR4T430Control key
STEUS_NSTEUSCHAR4T430Control key
STEUS_QSTEUSCHAR4T430Control key
RUZUSRUZUSCHAR4TCERSKey: rounding and additional values
RSANZ_REFRSANZ_REFCHAR1Indicator: Number of confirmation slips is referenced
HRAP_KZHRCHAR1Work center only resides in HR
PRVBEPRVBECHAR10PVBEProduction Supply Area
SUBSYSQEIFSUBSYSCHAR6QISUBSubsystem Identifier for QM Subsystem Interface
BDEGRBDEGRCHAR3
*
Grouping for Connection to Subsystem
RGEKZRGEKZAPCHAR1Indicator: Backflushing
HRTYPOTYPECHAR2T778OObject Type
SLWIDSLWIDCHAR7TCN00Key word ID for user-defined fields
LIFNRLIFNRCHAR10LFA1Account Number of Vendor or Creditor
SLWID_REFAP_KZREFCHAR1Field is referenced
LIFNR_REFAP_KZREFCHAR1Field is referenced
VGARBVGWRTARUNIT3T006Unit of measure of work
VGDIMVGDIMARCHAR6T006DDimension of work
HRPLVARPLVARCHAR2T778PPlan Version
VGDAUDAUNOREUNIT3
*
Normal duration/unit
STOBJJ_OBJNRCHAR22
*
Object number
RESGRMATRIX_IDCHAR8TCYMIMatrix identification
LGORT_RESLGORT_RESCHAR4T001LStorage location storage resource
MIXMATMIXMATCHAR1Indicator: mixing of material allowed
ISTBED_KZCY_ISTBEDKZCHAR1Calculation of actual capacity requirements
.APPENDCOCF_S_CRHD_ADDAdditional Fields for Work Center
SRTYPECOCF_SR_SRTYPECHAR10COCF_CU_SRTYPEShift Report Type
SNTYPECOCF_SN_SNTYPECHAR2TQ80Shift Note Type

#EKKO (Purchasing Document Header)

EKKO Table in SAP is the  Purchasing Document Header.
The most important within SAP Purchase Order Tables is EKPO.
Each Purchase order is identified by EBELN ( PO Number )

EKPO (Purchasing Document Item)

The lines of SAP PO ( Purchase Order ) can be found in EKPO table.
The main fields at EKPO are:
EBELN: Purchasing Document Number
EBELP : Item Number of Purchasing Document
MATNR: Material Number
BUKRS: Company Code
WERKS : Plant
LGORT: Storage Location
LIFNR : Vendor Account Number
IDNLF: Material Number Used by Vendor
KTMNG: Target Quantity
NETPR: Net Price in Purchasing Document (in Document Currency)
KNTTP: Account Assignment Category
PSTYP: Item Category


  • EKPA (Partner Roles in Purchasing)
EKPA is a standard SAP Table which is used to store Partner Roles in Purchasing information.

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
EBELNEBELNCHAR10EKKOPurchasing Document Number
EBELPEBELPNUMC5EKPOItem Number of Purchasing Document
EKORGEKORGCHAR4T024EPurchasing Organization
LTSNRLTSNRCHAR6WYT1Vendor Subrange
WERKSWERKS_DCHAR4T001WPlant
PARVWPARVWCHAR2TPARPartner Function
PARZAPARZANUMC3Partner counter
ERNAMERNAMCHAR12Name of Person who Created the Object
ERDATERDATDATS8Date on Which Record Was Created
LIFN2LIFN2CHAR10LFA1Reference to other vendor
DEFPADEFPACHAR1Default Partner
HITYPHITYP_LHCHAR1
*
Hierarchy category: vendor hierarchy
PARNRPARNRNUMC10Number of contact person
PERNRPERNR_DNUMC8Personnel Number
PRFREPRFRE_LHCHAR1Indicator: "relev. to price determination (vend. hierarchy)
BOLREBOLRECHAR1Indicator: vendor subject to subseq. settlement accounting
HISTUNRHISTUNRNUMC2Level number within hierarchy


KEKO (Product Costing - Header Data)

This is the table to store header data of product cost estimate. (Tcode CO01N or CO40N)


FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3
*
Client
BZOBJCK_OBJCHAR1
*
Reference Object
KALNRCK_KALNR1NUMC12CKHSCost Estimate Number - Product Costing
KALKACK_KALKACHAR2
*
Costing Type
KADKYCK_KADKYDATS8Costing Date (Key)
TVERSCK_TVERSNUMC2Costing Version
BWVARCK_BWVARCHAR3TCK05Valuation Variant in Costing
KKZMACK_KKZMACHAR1Costs Entered Manually in Additive or Automatic Cost Est.
MATNRMATNRCHAR18MARAMaterial Number
WERKSWERKS_DCHAR4T001WPlant
BWKEYBWKEYCHAR4T001KValuation Area
BWTARBWTAR_DCHAR10T149DValuation Type
KOKRSKOKRSCHAR4TKA01Controlling Area
KADATCK_ABDATDATS8Costing Date From
BIDATCK_BIDATDATS8Costing Date To
KADAMCK_ABDATDATS8Costing Date From
BIDAMCK_BIDATDATS8Costing Date To
BWDATCK_BWDATDATS8Valuation Date of a Cost Estimate
ALDATCK_BRDATDATS8Quantity Structure Date for Costing
BEDATCK_BEDATDATS8Requirements Date
VERIDVERIDCHAR4
*
Production Version
STNUMSTNUMCHAR8Bill of material
STLANSTLANCHAR1
*
BOM Usage
STALTSTALTCHAR2Alternative BOM
STCNTCIM_COUNTNUMC8Internal counter
PLNNRPLNNRCHAR8Key for Task List Group
PLNTYPLNTYCHAR1
*
Task List Type
PLNALPLNALCHAR2Group Counter
PLNCTCIM_COUNTNUMC8Internal counter
LOEKZCK_LOEKZCHAR1Deletion Indicator for Product Costing
LOSGRCK_LOSGRQUAN13(3)Lot Size for Product Costing
MEINSCK_MEINH_BEWUNIT3T006Valuation Unit of Measure
ERFNMCK_KALKUSRCHAR12Costed by User
ERFMACK_ERFMACHAR12User ID of Person Who Created Additive Cost Estimate
CPUDTCK_CPUDTDATS8Date on Which Cost Estimate Was Created
CPUDMCK_CPUDMDATS8Date on Which Additive Cost Estimate Was Saved
CPUTIMESYUZEITTIMS6System Time
FEH_ANZCK_FEH_ANZINT410No. System Messages in Selection/Qty Structure Determination
FEH_K_ANZCK_FEH_ANKINT410Number of System Messages in Costing
FEH_STACK_FEH_STACHAR2Costing Status
MAXMSGSYMSGTYCHAR1Message Type
FREIGCK_FREIGCHAR1Release of Standard Cost Estimate
MKALKCK_MKALKCHAR1Mixed Costing Indicator
BALTKZCK_BALT_FLAGCHAR1Cost Estimate for a Procurement Alternative
KALNR_BACKKALNRBANUMC12
*
Cost Estimate Number of Procurement Alternative
BTYPCKML_BTYPCHAR4
*
Process Category
MISCH_VERHCK_MISCHVERHDEC13(3)Mixed Costing: Mixing Ratio
BWVAR_BACK_BWVAR_BACHAR3
*
Valuation Variant of Procurement Alternative
PLSCNPLSCNNUMC3
*
Planning Scenario of Long-Term Planning
PLMNGCKI_PLMNGQUAN15(3)Production Plan Quantity Transferred to the Cost Estimate
SOBSLCK_SOBSKCHAR2
*
Special Procurement Key for the Costing Object
SOBESSOBESCHAR1Special procurement type
SOWRKCK_SOWRKCHAR4
*
Special Procurement Plant - Costing
SOBWTCK_SOBWTCHAR10
*
Valuation Type from Special Procurement
SODIRCLCORCHAR1Indicator for direct production (collective order)
SODUMDUMPSCHAR1Phantom item indicator
KALSMCK_KALSMCHAR6T683Costing Sheet for Calculating Overhead
AUFZAAUFZACHAR1Overhead type
BWSMRCK_BWSMRCHAR1Valuation Strategy for Raw Materials and Purchased Parts
SUBSTRATCK_SUBSTRATCHAR1Substrategy for Material Valuat. with Purchasing Info Record
KLVARCK_KLVARCHAR4TCK03Costing Variant
KOSGRCK_KOSGRCHAR10TCK14Costing Overhead Group
ZSCHLAUFZSCHLCHAR6TKZSLOverhead key
POPERPOPERNUMC3Posting period
BDATJBDATJNUMC4Posting Date YYYY
STKOZCIM_COUNTNUMC8Internal counter
ZAEHLCIM_COUNTNUMC8Internal counter
TOPKACK_TOPKACHAR1Top Cost Estimate (Point-of-Entry Position)
CMF_NRCMF_NRNUMC12Error Management Number
OCS_COUNTCMF_OCSCNTNUMC5Number of OCS Messages Sent
OBJNRJ_OBJNRCHAR22
*
Object number
ERZKACK_ERZKACHAR1Cost Estimate Created with Product Costing
LOSAUCK_LOSAUQUAN13(3)Lot Size Taking Scrap into Account
AUSIDCK_AUSIDCHAR1Assembly/Operation Scrap Included
AUSSSAUSSSDEC5(2)Assembly scrap in percent
SAPRLKK_SAPRLCHAR4Release the document as it was last saved
KZROHCK_KZROHCHAR1Material Component
AUFPLCK_AUFPLNUMC10Routing No. for Operations with Non-Order-Related Production
CUOBJCK_CUOBJNUMC18Object Number for Conf. Objects
CUOBJIDCK_CUOBJIDCHAR1Indicator for Configurable Objects
TECHSTECHSCHAR12Parameter Variant/Standard Variant
TYPECK_TYPECHAR18MARAConfigured Material (Variant)
WRKLTCK_WRKLTCHAR4
*
Plant (Variant)
VORMDATCK_VORMDATDATS8Date on Which Cost Estimate Was Marked
VORMUSRCK_VORMUSRCHAR12User Who Marked Cost Estimate in Material Master
FREIDATCK_FREIDATDATS8Date on Which Cost Estimate Released in Material Master
FREIUSRCK_FREIUSRCHAR12User Who Released Cost Estimate in Material Master Record
UEBIDCK_UEBIDCHAR4
*
Transfer Control
PROZESSCK_PROZESSCHAR18
*
Process Through Which Co-Product Was Costed
PR_VERIDCK_VERIDCHAR4MKALProduction Version To Be Costed
CSPLITCSPLITCHAR4
*
Apportionment Structure
KZKUPKZKUPMATCHAR1Indicator: Material can be co-product
FXPRUCK_FIXPRKUCHAR1Fixed-Price Co-Product
CFXPRCK_CONTFIXPRICECHAR1Cost Estimate Contains Fixed-Price Co-Products
ZIFFRCK_ZIFFRDEC3Equivalence Number
SUMZIFFRCK_SUMZIFFRDEC5Sum of Equivalence Numbers of Co-Products for a Process
AFAKTCK_SPLITFACFLTP16(16)Costg.: Apportionment Factor for Itemiz. Line in Joint Prod.
VBELNVBELNCHAR10
*
Sales and Distribution Document Number
POSNRPOSNRNUMC6
*
Item number of the SD document
PSPNRWB_POSNRNUMC8
*
Work Breakdown Structure Element (WBS element)
SBDKZSBDKZCHAR1Dependent requirements ind. for individual and coll. reqmts
MLMAACK_ML_MAACCHAR1Material ledger activated at material level
BESKZBESKZCHAR1Procurement Type
DISSTDISSTCHAR3Low-Level Code
KALSTCK_KALSTNUMC4Costing Level
TEMPLATEABC_TEMPLCHAR10
*
Template
PATNRNKPRTNNUMC6Partner number for costing
PART_VRSNCK_PARVRSNNUMC2Partner Version
ELEHKCK_ELESMHKCHAR2
*
Cost Component Structure - CGM and Sales/Administr. Costs
ELEHKNSCK_ELESMNSCHAR2
*
Cost Component Structure for Auxiliary Cost Component Split
VOCNTCK_VOCNTNUMC1Counter for Marking a Cost Estimate
GSBERGSBERCHAR4
*
Business Area
PRCTRPRCTRCHAR10
*
Profit Center
.INCLUDEIDA_TCK32Include KEKO, TCK32 for common data part
TPVARTPVARIANTCHAR3TPVAR1Variant for Finding Transfer Price
KURSTKURSTCHAR4TCURVExchange Rate Type
MGTYPCKML_MGTYPCHAR5CKMLMV006Quantity Structure Type
HWAERHWAERCUKY5
*
Local Currency
FWAER_KPFWAERSCUKY5
*
Currency Key
REFIDCK_REFIDNUMC2Reference Variant
MEINH_WSLRMEI_WSUNIT3
*
Batch-specific matl unit of measure (proportion/prod. unit)
KZWSOKZWSOCHAR1Units of measure usage
ASLCK_ASLCHAR1Cost Estimate of an Order BOM
KALAIDCK_KALAIDCHAR8Name of Costing Run
KALADATCK_KALADATDATS8Costing Run Date
OTYPCKML_OTYPCHAR2Object Type
BAPI_CREATEDCK_BAPICHAR1Cost Estimate Generated by BAPI
SGT_SCATSGT_SCATCHAR16Stock Segment


#MARC  (Plant Data for Material)


This table is used to check the information of material in plant level.


FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
MATNRMATNRCHAR18MARAMaterial Number
WERKSWERKS_DCHAR4T001WPlant
.INCLUDEEMARCData Division MARC
.INCLUDEEMARC1Data Division MARC: Division 1
PSTATPSTAT_DCHAR15Maintenance status
LVORMLVOWKCHAR1Flag Material for Deletion at Plant Level
BWTTYBWTTY_DCHAR1T149CValuation Category
XCHARXCHARCHAR1Batch management indicator (internal)
MMSTAMMSTACHAR2T141Plant-Specific Material Status
MMSTDMMSTDDATS8Date from which the plant-specific material status is valid
MAABCMAABCCHAR1TMABCABC Indicator
KZKRIKZKRICHAR1Indicator: Critical part
EKGRPEKGRPCHAR3T024Purchasing Group
AUSMEAUSMEUNIT3T006Unit of issue
DISPRDISPRCHAR4MDIPMaterial: MRP profile
DISMMDISMMCHAR2T438AMRP Type
DISPODISPOCHAR3T024DMRP Controller (Materials Planner)
KZDIEKZDIECHAR1Indicator: MRP controller is buyer (deactivated)
PLIFZPLIFZDEC3Planned Delivery Time in Days
WEBAZWEBAZDEC3Goods Receipt Processing Time in Days
PERKZPERKZCHAR1Period Indicator
AUSSSAUSSSDEC5(2)Assembly scrap in percent
DISLSDISLSCHAR2T439ALot size (materials planning)
BESKZBESKZCHAR1Procurement Type
SOBSLSOBSLCHAR2T460ASpecial procurement type
MINBEMINBEQUAN13(3)Reorder Point
EISBEEISBEQUAN13(3)Safety Stock
BSTMIBSTMIQUAN13(3)Minimum Lot Size
BSTMABSTMAQUAN13(3)Maximum Lot Size
BSTFEBSTFEQUAN13(3)Fixed lot size
BSTRFBSTRFQUAN13(3)Rounding value for purchase order quantity
MABSTMABSTQUAN13(3)Maximum stock level
LOSFXLOSFXCURR11(2)Ordering costs
SBDKZSBDKZCHAR1Dependent requirements ind. for individual and coll. reqmts
LAGPRLAGPRCHAR1T439LStorage costs indicator
ALTSLALTSLCHAR1Method for Selecting Alternative Bills of Material
KZAUSKZAUSCHAR1Discontinuation indicator
AUSDTAUSDTDATS8Effective-Out Date
NFMATNFMATCHAR18MARAFollow-Up Material
KZBEDKZBEDCHAR1Indicator for Requirements Grouping
MISKZMISKZCHAR1Mixed MRP indicator
FHORIFHORICHAR3T436AScheduling Margin Key for Floats
PFREIPFREICHAR1Indicator: automatic fixing of planned orders
FFREIFFREICHAR1Release indicator for production orders
RGEKZRGEKMCHAR1Indicator: Backflush
FEVORFEVORCHAR3T024FProduction Supervisor
BEARZBEARZDEC5(2)Processing time
RUEZTRUEZTDEC5(2)Setup and teardown time
TRANZTRANZDEC5(2)Interoperation time
BASMGBASMGQUAN13(3)Base quantity
DZEITDZEITDEC3In-house production time
MAXLZMAXLZDEC5Maximum Storage Period
LZEIHLZEIHUNIT3T006Unit for maximum storage period
KZPROKZPROCHAR1Indicator: withdrawal of stock from production bin
GPMKZGPMKZCHAR1Indicator: Material Included in Rough-Cut Planning
UEETOUEETODEC3(1)Overdelivery tolerance limit
UEETKUEETKCHAR1Indicator: Unlimited Overdelivery Allowed
UNETOUNETODEC3(1)Underdelivery tolerance limit
WZEITWZEITDEC3Total replenishment lead time (in workdays)
ATPKZATPKZCHAR1Replacement part
VZUSLVZUSLDEC5(2)Surcharge factor for cost in percent
HERBLHERBLCHAR2State of manufacture
INSMKINSMK_MATCHAR1Post to Inspection Stock
SPROZSPROZDEC3(1)Sample for quality inspection (in %) (deactivated)
QUAZTQUAZTDEC3Quarantine period (deactivated)
SSQSSQSSPURCHAR8TQ08Control Key for Quality Management in Procurement
MPDAUMPDAUDEC5Mean inspection duration (deactivated)
KZPPVKZPPVCHAR1Indicator for inspection plan (deactivated)
KZDKZKZDKZCHAR1Documentation required indicator
WSTGHWSTGHDEC9Active substance content (deactivated)
PRFRQPRFRQDEC5Interval until next recurring inspection
NKMPRNKMPRDATS8Date according to check sampling inspection (deactivated)
UMLMCUMLMEQUAN13(3)Stock in Transfer (Plant to Plant)
.INCLUDEEMARC2Data Division MARC: Division 2
LADGRLADGRCHAR4TLGRLoading Group
XCHPFXCHPFCHAR1Batch management requirement indicator
USEQUUSEQUCHAR1TMQ2Quota arrangement usage
LGRADLGRADDEC3(1)Service level
AUFTLAUFTLCHAR1T439PSplitting Indicator
PLVARPLVARCHAR2T778PPlan Version
OTYPEOTYPECHAR2T778OObject Type
OBJIDOBJEKTIDNUMC8Object ID
MTVFPMTVFPCHAR2TMVFChecking Group for Availability Check
PERIVPERIVCHAR2T009Fiscal Year Variant
KZKFKKZKFKCHAR1Indicator: take correction factors into account
VRVEZVRVEZDEC5(2)Shipping setup time
VBAMGVBAMGQUAN13(3)Base quantity for capacity planning in shipping
VBEAZVBEAZDEC5(2)Shipping processing time
LIZYKDUMMYLIZYKCHAR4
*
Deactivated
BWSCLBWSCLCHAR1TMBW1Source of Supply
KAUTBKAUTBCHAR1Indicator: "automatic purchase order allowed"
KORDBKORDBCHAR1Indicator: Source list requirement
STAWNSTAWNCHAR17T604Commodity Code/Import Code Number for Foreign Trade
HERKLHERKLCHAR3T005Country of origin of the material
HERKRHERKRCHAR3T005SRegion of origin of material (non-preferential origin)
EXPMEEXPMEUNIT3T006Unit of measure for commodity code (foreign trade)
MTVERMTVERCHAR4TVFMExport/import material group
PRCTRPRCTRCHAR10
*
Profit Center
TRAMETRAMEQUAN13(3)Stock in Transit
.INCLUDEEMARC3Data Division MARC: Division 3
MRPPPMRPPPCHAR3T439GPPC planning calendar
SAUFTSA_SAUFTCHAR1Ind.: Repetitive mfg allowed
FXHORFXHORNUMC3Planning time fence
VRMODVRMODCHAR1Consumption mode
VINT1VINT1NUMC3Consumption period: backward
VINT2VINT2NUMC3Consumption period: forward
VERKZCK_VERK1CHAR1Version Indicator
STLALSTALTCHAR2Alternative BOM
STLANSTLANCHAR1T416BOM Usage
PLNNRPLNNRCHAR8Key for Task List Group
APLALPLNALCHAR2Group Counter
LOSGRCK_LOSGRQUAN13(3)Lot Size for Product Costing
SOBSKCK_SOBSLCHAR2T460ASpecial Procurement Type for Costing
FRTMEFRTMEUNIT3T006Production unit
LGPROLGPROCHAR4T001LIssue Storage Location
DISGRDISGRCHAR4T438MMRP Group
KAUSFKAUSFDEC5(2)Component scrap in percent
QZGTPQZGTYPCHAR4TQ05Certificate Type
QMATVQMATVCHAR1Inspection Setup Exists for Material/Plant
TAKZTTAKZTDEC3Takt time
RWPRORWPROCHAR3T438RRange of coverage profile
COPAMCOPAMCHAR10Local field name for CO/PA link to SOP
ABCINABCINCHAR1T159CPhysical inventory indicator for cycle counting
AWSLSAWSLSCHAR6TKV01Variance Key
SERNPSERAILCHAR4T377PSerial Number Profile
CUOBJCUOBMNUMC18Internal object number
STDPDSTDPDCHAR18MARAConfigurable material
SFEPRSFEPRCHAR4T437SRepetitive manufacturing profile
XMCNGXMCNGCHAR1Negative stocks allowed in plant
QSSYSQSSYS_SOLLCHAR4TQ02Required QM System for Vendor
LFRHYLFRHYCHAR3T439GPlanning cycle
RDPRFRDPRFCHAR4RDPRRounding Profile
VRBMTVRBMTCHAR18MARAReference material for consumption
VRBWKVRBWKCHAR4T001WReference plant for consumption
VRBDTVRBDTDATS8To date of the material to be copied for consumption
VRBFKVRBFKDEC4(2)Multiplier for reference material for consumption
AUTRUAUTRUCHAR1Reset Forecast Model Automatically
PREFEPREFECHAR1Preference indicator in export/import
PRENCPRENCCHAR1Exemption certificate: Indicator for legal control
PRENOPRENNCHAR8Exemption certificate number for legal control
PRENDPRENDDATS8Exemption certificate: Issue date of exemption certificate
PRENEPRENECHAR1Indicator: Vendor declaration exists
PRENGPRENGDATS8Validity date of vendor declaration
ITARKITARKCHAR1Indicator: Military goods
SERVGW_SERVGRDCHAR1TWSGIS-R service level
KZKUPKZKUPMATCHAR1Indicator: Material can be co-product
STRGRSTRGRCHAR2T461PPlanning strategy group
CUOBVCUOBVNUMC18Internal object number of configurable material for planning
LGFSBLGFSBCHAR4T001LDefault storage location for external procurement
SCHGTSCHGTCHAR1Indicator: Bulk Material
CCFIXCCFIXCHAR1CC indicator is fixed
EPRIOBF_GROUPCHAR4T434GStock determination group
QMATAQMATAUTHCHAR6TQ01BMaterial Authorization Group for Activities in QM
RESVPRESVPDEC3Period of adjustment for planned independent requirements
PLNTYPLNTYCHAR1TCA01Task List Type
UOMGROIB_UOMGRCHAR3OIB06Unit of Mearsure Group (Oil, Natural Gas,...)
UMRSLOIB_UMRSLCHAR4OIB01Conversion Group (Oil, Natural Gas,..)
ABFACOIL_ABFACDEC2(1)
*
Air Bouyancy Factor
SFCPFCO_PRODPRFCHAR6TCO43Production Scheduling Profile
SHFLGSHFLGCHAR1Safety time indicator (with or without safety time)
SHZETSHZETNUMC2Safety time (in workdays)
MDACHMDACHCHAR2T46ACAction control: planned order processing
KZECHKZECHCHAR1Determination of batch entry in the production/process order
MEGRUMEGRUCHAR4TWMEGUnit of Measure Group
MFRGRMFRGRCHAR8TMFGMaterial freight group
VKUMCVKUMCCURR13(2)Stock transfer sales value (plant to plant) for VO material
VKTRWVKTRWCURR13(2)Transit value at sales price for value-only material
.INCLUDEEMARC4Data Part MARC - Part 4
KZAGLKZAGLCHAR1Indicator: smooth promotion consumption
FVIDKCK_VERIDCHAR4
*
Production Version To Be Costed
FXPRUCK_FIXPRKUCHAR1Fixed-Price Co-Product
LOGGRLOGGRCHAR4TLOGLogistics handling group for workload calculation
FPRFMFPRFMCHAR3TMFPFDistribution profile of material in plant
GLGMGGLGMGQUAN13(3)Tied Empties Stock
VKGLGVKGLGCURR13(2)Sales value of tied empties stock
INDUSJ_1BINDUS3CHAR2Material CFOP category
MOWNRMOWNRCHAR12T618MCAP: Number of CAP products list
MOGRUMOGRUCHAR6T618GCommon Agricultural Policy: CAP products group-Foreign Trade
CASNRCASNRCHAR15T610CCAS number for pharmaceutical products in foreign trade
GPNUMGPNUMCHAR9T609GProduction statistics: PRODCOM number for foreign trade
STEUCSTEUCCHAR16T604FControl code for consumption taxes in foreign trade
FABKZFABKZCHAR1Indicator: Item Relevant to JIT Delivery Schedules
MATGRMATNRGROUPCHAR20Group of Materials for Transition Matrix
VSPVBVSPVBCHAR10PVBEProposed Supply Area in Material Master Record
DPLFSDPLFSCHAR2Fair share rule
DPLPUDPLPUCHAR1Indicator: push distribution
DPLHODPLHODEC3Deployment horizon in days
MINLSCSCP_MINLOTSIZEQUAN13(3)Minimum lot size for Supply Demand Match
MAXLSCSCP_MAXLOTSIZEQUAN13(3)Maximum lot size for Supply Demand Match
FIXLSCSCP_FIXLOTSIZEQUAN13(3)Fixed lot size for Supply Demand Match
LTINCCSCP_LOTINCREMENTQUAN13(3)Lot size increment for Supply Demand Match
COMPLCSCP_DUMMYNUMC2TCSCP_COMP_LVLThis field is no longer used
CONVTCSCP_CONV_TYPECHAR2TCSCP_CONV_TYPEConversion types for production figures
SHPROSHPROCHAR3T438VPeriod Profile for Safety Time
AHDISAHDISCHAR1MRP relevancy for dependent requirements
DIBERDIBERCHAR1Indicator: MRP area exists
KZPSPKZPSPCHAR1Indicator for cross-project material
OCMPFOCM_GPROFILECHAR6TCO48Overall profile for order change management
APOKZAPOKZCHAR1Indicator: Is material relevant for APO
MCRUEMCRUECHAR1MARDH rec. already exists for per. before last of MARD per.
LFMONLFMONNUMC2Current period (posting period)
LFGJALFGJANUMC4Fiscal Year of Current Period
EISLOEISLOQUAN13(3)Minimum Safety Stock
NCOSTCK_NO_COSTINGCHAR1Do Not Cost
ROTATION_DATEROTATION_DATECHAR1Strategy for Putaway and Stock Removal
UCHKZUCHKZCHAR1Indicator for Original Batch Management
UCMATVBOB_OB_RFMATCHAR18MARAReference Material for Original Batches
BWESBBWESBQUAN13(3)Valuated Goods Receipt Blocked Stock
.INCLUDESGT_MARC_STYMARC Extension with New Fields: Segmentation
SGT_COVSSGT_COVSCHAR8SGT_COVS_TSegmentation Strategy
SGT_STATCSGT_STATCCHAR1Segmentation Status
SGT_SCOPESGT_SCOPECHAR1Segmentation Strategy Scope
SGT_MRPSISGT_SRT_STKCHAR1Sort Stock based on Segment
SGT_PRCMSGT_PRCMCHAR1Consumption Priority
SGT_CHINTSGT_CHINTCHAR1Discrete Batch Number
SGT_STK_PRTSGT_STK_PRTCHAR1Stock Protection Indicator
SGT_DEFSCSGT_DEFSCCHAR16Default Stock Segment value
SGT_MRP_ATP_STATUSSGT_MRP_ATP_STATUSCHAR2ATP/MRP Status for Material and Segment
SGT_MMSTDSGT_MMSTDDATS8Date from which the plant-specific material status is valid
.INCLUDEFSH_MARC_STYMARC Extension with New Fields: Fashion
FSH_MG_ARUN_REQFSH_MG_ARUN_REQCHAR1Order Allocation Run
FSH_SEAIMFSH_SEAIMCHAR1Indicator: Season Active in Inventory Management
FSH_VAR_GROUPFSH_VAR_GROUPCHAR2Variant Group
FSH_KZECHFSH_KZECHCHAR1Indicator: Batch Assignment during TR to TO conversion
.APPEND/VSO/R_EMARC_AEMARC Append for Vehicle Space Optimization
.INCLUDE/VSO/R_MARC_IInclude for Append to MARC for Vehicle Space Optimization
/VSO/R_PKGRP/VSO/M_PKGRPCHAR18/VSO/M_PKGPacking Group of the Material (VSO)
/VSO/R_LANE_NUM/VSO/M_LANE_NUMCHAR3Line within the Automatic Picking Zone (VSO)
/VSO/R_PAL_VEND/VSO/R_MATNR_PAL_VENDCHAR18
*
Material No. of the Packaging Material of the Vendor (VSO)
/VSO/R_FORK_DIR/VSO/M_FORK_DIRCHAR1Pick Packaging Materials only Lengthwise (VSO)
.APPENDIUID_FIELDSItem Unique Identification Fields
IUID_RELEVANTIUID_RELEVANTCHAR1IUID-Relevant
IUID_TYPEIUID_TYPECHAR10TIUID_TYPEStructure Type of UII
UID_IEAUID_IEACHAR1External Allocation of UII
.APPENDWRF_MARC_APPENDMARC Extension with New Fields - Seasonal Procurement
.INCLUDEWRF_CONSIGNMENT_STYSeasonal Procurmnt: Include for Consgnmnt Cntrl, Art. Master
CONS_PROCGWRF_CONS_PROCGCHAR1WRFT_CONS_PROCGConsignment Control
.INCLUDEWRF_MARC_STYMARC Extension with New Fields - Seasonal Procurement
GI_PR_TIMEWRF_PSCD_WABAZDEC3Goods Issue Processing Time in Days
MULTIPLE_EKGRPWRF_POHF_OTHER_EKGRP_ALLOWCHAR1Purchasing Across Purchasing Group
REF_SCHEMAWRF_REF_SCHEMACHAR2WRF_REF_RFSReference Determination Schema
MIN_TROCWRF_FRE_TROC_MINNUMC3Minimum Target Range of Coverage
MAX_TROCWRF_FRE_TROC_MAXNUMC3Maximum Target Range of Coverage
TARGET_STOCKWRF_FRE_TARGET_STOCKQUAN13(3)Target Stock#MARM

# MARM

MARM is a standard SAP Table which is used to store conversions between different unit of measure. It is also applied to provide the conversion from alternative unit of measure to base unit of measure as following:
Alternative Unit of Measure MEINH = ( Numerator UMREZ/Denominator UMREN) *  Base Unit of Measure


FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
MATNRMATNRCHAR18MARAMaterial Number
MEINHLRMEIUNIT3T006Alternative Unit of Measure for Stockkeeping Unit (All units of measure other than the base unit of measure are referred to as alternative units of measure)
.INCLUDEEMARMUnits of Measure
UMREZUMREZDEC5Numerator for Conversion to Base Units of Measure
UMRENUMRENDEC5Denominator for conversion to base units of measure
EANNREANNRCHAR13European Article Number (EAN) - obsolete!!!!!
EAN11EAN11CHAR18International Article Number (EAN/UPC)
NUMTPNUMTPCHAR2TNTPCategory of International Article Number (EAN)
LAENGLAENGQUAN13(3)Length
BREITBREITQUAN13(3)Width
HOEHEHOEHEQUAN13(3)Height
MEABMMEABMUNIT3T006Unit of Dimension for Length/Width/Height
VOLUMVOLUMQUAN13(3)Volume
VOLEHVOLEHUNIT3T006Volume unit
BRGEWBRGEWQUAN13(3)Gross Weight
GEWEIGEWEIUNIT3T006Weight Unit
MESUBMESUBUNIT3T006Lower-Level Unit of Measure in a Packing Hierarchy
ATINNATINNNUMC10
*
Internal characteristic
MESRTMESRTNUMC2Unit of measure sort number
XFHDWXFHDWCHAR1Leading batch-specific unit of measure
XBEWWXBEWWCHAR1Valuation based on the batch-specific unit of measure
KZWSOKZWSOCHAR1Units of measure usage
MSEHIMSEHI_WSUNIT3TCHW2Unit of Measurement of Characteristic
BFLME_MARMBFLMECHAR1Generic Material with Logistical Variants
GTIN_VARIANTGTIN_VARIANTCHAR2Global Trade Item Number Variant
NEST_FTRCIFNESTFTRDEC3Remaining Volume after Nesting (in Percentage)
MAX_STACKCIFMXSTACKINT13Maximum Stacking Factor
CAPAUSECIFCAPAUSEDEC15(3)Capacity Usage
TY2TQDE_EWMTY2TQCHAR1EWM-CW: Category of Unit of Measure



#MCHB
MCHB is a standard SAP Table which is used to store current Batch Stocks information at the storage location level.
Whenever there is a material movement this table gets updated & the corresponding history table(MCHBH) gets updated as well.

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
MATNRMATNRCHAR18MARAMaterial Number
WERKSWERKS_DCHAR4MARCPlant
LGORTLGORT_DCHAR4MARDStorage Location
CHARGCHARG_DCHAR10MCHABatch Number
LVORMLVOCBCHAR1Deletion Flag for All Data on a Batch Stock
ERSDAERSDADATS8Created On
ERNAMERNAMCHAR12Name of Person who Created the Object
LAEDALAEDADATS8Date of Last Change
AENAMAENAMCHAR12Name of Person Who Changed Object
LFGJALFGJANUMC4Fiscal Year of Current Period
LFMONLFMONNUMC2Current period (posting period)
SPERCSPERRCHAR1Physical Inventory Blocking Indicator
CLABSLABSTQUAN13(3)Valuated Unrestricted-Use Stock
CUMLMUMLMDQUAN13(3)Stock in transfer (from one storage location to another)
CINSMINSMEQUAN13(3)Stock in Quality Inspection
CEINMEINMEQUAN13(3)Total Stock of All Restricted Batches
CSPEMSPEMEQUAN13(3)Blocked Stock
CRETMRETMEQUAN13(3)Blocked Stock Returns
CVMLAVMLABQUAN13(3)Valuated unrestricted-use stock in previous period
CVMUMVMUMLQUAN13(3)Stock in Transfer in Previous Period
CVMINVMINSQUAN13(3)Stock in Quality Inspection in Previous Period
CVMEIVMEINQUAN13(3)Restricted-Use Stock in Previous Period
CVMSPVMSPEQUAN13(3)Blocked stock of previous period
CVMREVMRETQUAN13(3)Blocked Stock Returns in Previous Period
KZICLKZILLCHAR3Physical inventory indicator for whse stock in current year
KZICQKZILQCHAR3Phys. inventory ind. f. stock in qual. insp. in current year
KZICEKZILECHAR3Physical inventory indicator for restricted-use stock
KZICSKZILSCHAR3Physical inventory indicator for blocked stock
KZVCLKZVLLCHAR3Physical inventory indicator for stock in previous year
KZVCQKZVLQCHAR3Phys. inventory ind. f. stock in qual. insp. in prev. period
KZVCEKZVLECHAR3Physical inventory ind. for restricted-use stock, prev.pd
KZVCSKZVLSCHAR3Phys. inventory indicator for blocked stock in prev. period
HERKLHERKLCHAR3T005Country of origin of the material
CHDLLDLINLDATS8Date of Last Posted Count for Unrestricted-Use Stock
CHJINGJINVNUMC4Fiscal year of current physical inventory indicator
CHRUECHRUECHAR1MCHBH rec. already exists for per. before last of MCHB per.

#T001K (Valuation Area)
FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
BWKEYBWKEYCHAR4Valuation Area
BUKRSBUKRSCHAR4T001Company Code
.INCLUDESI_T001KValuation area
BWMODBWMODCHAR4Valuation Grouping Code
XBKNGXBKNGCHAR1Negative stocks in valuation area allowed
MLBWACK_ML_BWACCHAR1Material ledger activated in valuation area
MLBWVCK_ML_BWAVCHAR1Material ledger activated in valuation area (compulsory)
XVKBWXVKBWCHAR1Sales price valuation active
ERKLAERKOMERKLAERKOMCHAR1Explanation Facility for Material Ledger Active/Inactive
UPROFUPROF_DCHAR4TWUPRetail revalution profile
WBPROWBPROCHAR4TWPRProfile for value-based inventory management
MLASTCK_ML_ABSTCHAR1Material Price Determination: Control
MLASVCK_ML_ABSVCHAR1Price Determination is Binding in Valuation Area
BDIFPBDIFPDEC5(2)Stock correction tolerance
XLBPDXLBPDCHAR1Price difference posting in GR for subcontract oder
XEWRXXEWRXCHAR1Post purchase account with receipt value
X2FDOX2FDOCHAR1Two FI documents with purchase account
PRSFRPRSFRGCHAR1Price Release
MLCCSCK_MLCCSCHAR1Active Actual Cost Component Split
XEFREXEFRECHAR1Del. costs to price diff. acct when purch. acct active
EFREJEFREJNUMC4Start of validity period f. del. costs in price diff. acct


  • T006 (Unit of Measurement)

T006 is a standard SAP Table which is used to store all unit of measurement in the system. This data is created when you create a unit of measurement by transaction CUNI (SPRO-> SAP Net Weaver-> General Settings ->Check units of measurement).

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
MSEHIMSEHIUNIT3Unit of Measurement
KZEX3KZEX3CHAR13-char indicator for external unit of measurement
KZEX6KZEX6CHAR16-char. ID for external unit of measurement
ANDECANDECINT25No. of decimal places to which rounding should be performed
KZKEHKZKEHCHAR1Commercial measurement unit ID
KZWOBKZWOBCHAR1Value-based commitment indicator
KZ1EHKZ1EHCHAR1Indicator (1) unit (indicator not yet defined)
KZ2EHKZ2EHCHAR1Indicator (2) unit (indicator not yet defined)
DIMIDDIMIDCHAR6T006DDimension key (VOLUME, LENGTH, ...)
ZAEHLDZAEHLINT410Numerator for conversion to SI unit
NENNRNENNRINT410Denominator for conversion into SI unit
EXP10EXP10INT25base ten exponent for conversion to SI unit
ADDKOADDKODEC9(6)Additive constant for conversion to SI unit
EXPONEXPONINT25Base ten exponent for floating-point display
DECANDECANINT25Number of decimal places for number display
ISOCODEISOCD_UNITCHAR3T006IISO code for unit of measurement
PRIMARYISOCD_MARKCHAR1Selection field for conversion from ISO code to int. code
TEMP_VALUETEMP_VALUEFLTP16(16)Temperature
TEMP_UNITTEMP_UNITUNIT3T006Temperature unit
FAMUNITFAMUNITCHAR1Unit of measurement family
PRESS_VALPRESS_VALFLTP16(16)Pressure Value
PRESS_UNITPRESS_UNITUNIT3
*
Unit of Pressure


#VBKPF: Document Header for Document Parking

Fields:
  • Bstat:
Value(from)Value(to)Description

N/ANormal document
AN/AClearing Document
BN/AReset clearing document
DN/ARecurring entry document
LN/APosting Not in Leading Ledger
MN/ASample document
SN/ANoted items
VN/AParked document
WN/AParked document with change of document ID
ZN/AParked document which was deleted
CN/ABalance Carryforward Line Items

vbsegs: Document Segment for Document Parking - G/L Account Database

No comments:

Post a Comment

SAP giới thiệu mã hỗ trợ AI trong ngôn ngữ ABAP riêng của mình

SAP đã ra mắt một loạt tính năng mã hỗ trợ AI trong môi trường phát triển ứng dụng dựa trên đám mây của mình, đồng thời tham gia vào danh sá...