SAP Principal Tables2007. 09. 28Netweaver TeamContentsMaterial Master Tables SD-MM Tables .……….…………………….................……………………………..2 3PS Tables (6)PP Tables QM Tables CO T bl ........................…………………………….. ......................……………………………..710CO Tables FI Tables…………..…………………………………. ..........................………………………..……1115Dictionary Tables (16)Material Master TablesMaterial Ledger MaterialMaterial Material MaterialMaterial Master ViewMaterial LedgerHeader CKMLHD Material Ledger Total Values Forecast ParameterMPOPPlanning DataMPGD Material Databy Warehouse NumberMPGD Unit of MeasureMARMTax ClassificationMLANMaterial DescriptionGeneral Material MasterMARA CKMLCRMaterial Ledger Total Quantity CKMLPP Material LedgerMaterial Valuation DataMBEWMaterial Data by Plant MAKTPrices CKMLPRMARC Material Data by Storage LocationMARD Material Data by Storage Type M i l A ib Routing Assignmentto Material MAPL BOM Link to MaterialMASTProduction Versionof Material MKALRouting HeaderBOM HeaderProduction Version Bill of Material (BOM)Routing Material Sales Data MVKEby Storage TypeMLGT Material TypeT134Material Group Material Attribute Routing Header PLKO Routing ItemPLPOBOM Header STKO BOM Item STPOMaterialProduction HierarchyT179pT023Material Control RecordMARV 물류자재이동통제MMSD Sales Header StatusVBUK Sales Item StatusSales Doc. FlowVBFAPurchase Doc. HistoryEKBESales Order HeaderVBAK Sales Order ItemVBAPS/O Business DataVBKD VBUP S/O Schedule Line ÆPurchase RequisitionPurchase Requisition ÆPurchase OrderPurchase Order HeaderEKKOPurchase Order ItemEKPOS/O Schedule LineVBEPDelivery HeaderLIKP Shipping HeaderVEKP S/O Schedule Line ÆPurchase OrderEKKNEBKN EBANP/O Schedule LineDelivery ItemLIPSShipping ItemVEPOMaterial Doc. HeaderMKPFG d I (G/I)EKETMaterial Doc. HeaderMKPF Material Doc. ItemMSEGBilling HeaderGoods Issue (G/I)Material Doc. ItemMSEGGoods Receipt (G/R)Invoice Header출하실적VBRKBilling Item VBRPAccounting HeaderBKPF Accounting SegmentS GRBKP Invoice ItemRSEG매출실적매입실적BSEGSD MM ■Organization TablesCategory Table Description Text Master TVKO Sales Organization TVKOT TVTW Distribution Channel TVTWT Category Table Description Text Master T024E Purchasing OrganizationT024Purchasing GroupTSPA Division TSPAT TVBUR Sales Office TVKBT TVKGR Sales Group TVGRTT026Purchasing Area T026T WYT1Vendor Subrange(Vendor + Vendor Subrange)T001W PlantT171Sales Districts T171T Link TVKOS Sales Organization + DivisionTVKOV Sales Organization + ChannelS l O i i Ch l Di i iT001L Storage Location(Plant + Storage Location) Link T024W Plant + Purchasing OrganizationTVTA Sales Organization + Channel + Division TVBVK Sales Office + Sales GroupTVKBZ Sales Organization + Channel + Division + Sales OfficeT026Z Purchasing Organization + PurchasingGroup + Purchasing AreaVendor LFA1Vendor General DataLFB1Vendor + CompanyCustomer KNA1Customer General DataKNB1Customer + CompanyKNVV Customer + Sales Organization +Distribution Channel+Division LFM1Vendor + Purchasing Organization LFM2Vendor + Purchasing Organization + Vendor Subrange + PlantDistribution Channel + Division■MM Purchasing Info RecordSAP Script Text FileLong Text InformationMaterial Info RecordCondition HeaderKONH Condition ItemKONPHeader STXH SAP Script Text FileLines STXLMaterial Info Record Header EINA Material Info RecordItem EINEMaterial Info Recordby Plant A017Purchasing Info Record +Material + VendorPurchasing Doc.Header Purchasing OrderSales Order 재고Table(판매,고객,공급처,창고재고)EKKO Purchasing Doc.Item EKPOS/O Schedule Line ÆPurchase OrderEKKNSales OrderStock MSKA(MSKAH)Special Stocks with Customer MSKU(MSKUH)P/O Schedule LineEKETLogistics Summary TablesS???Special Stocks with Vendor MSLB(MSLBH)Storage Location Datafor Material MARD(MARDH)Project DefinitionWork Center HeaderCRHD Work Center CO Obj. Cost Total Summary ofActual & Plan Data Object Number (OBJNR)Project Definition PROJWork Center TextCRTX Assignment Work Centerto Cost CenterExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSS(O )WBS Element MasterPRPSScheduling Data to Cost Center CRCOProject Hierarchy Scheduling Data for Project ItemPRTEPS Texts (WBS)PRTXPS Texts (Header)Production OrderHeader AFKONetworkj y for WBS ElementPRHI PSTXPS Texts (Description)PSTTProject Hierarchy for WBS ElementPRHISOperation within OrderAFVCOperationActivity Value in Operation AFVVNetwork –RelationshipsAFAB Network 내작업순서선후관계Routing Assignmentto Material BOM Link to MaterialMASTProduction Versionof Material Production Version Bill of Material (BOM)Routing Work Center HeaderCRHD Work Center MAPL MKALRouting HeaderPLKO Routing ItemBOM HeaderSTKOBOM Item Work Center TextCRTX Assignment Work Centerto Cost Center Routing Selection of BOMItem Selection Production Order Master Data CAUFV ViewPlanned OrderPLAF PLPOSTPOto Cost CenterCRCOOperation/ActivatesPLASOrder Operation Data for Work CenterItem SelectionSTASAUFK Production OrderHeader AFKO P d ti O dP d ti O d 생산실적생산계획S022Goods Movements Errors from ConfirmationsAFFWConfirmationProduction Order Item AFPOProduction Order ConfirmationAFRUMaterial Doc.Header MKPF M t i l DSubsequently posted 생산품입고(G/R)BOM 에의한투입원자재예약ReservationItem Reservation Header RKPF Material Doc.Item MSEGSubseque t y posted Goods Movements for ConfirmationsAFWI Goods Movement for Production OrderRESB원자재투입(G/I)AUFM■ConfirmationOperation within OrderÆOrder 내공정작업:Order Routing Table of Planned Changesf C fi tiAFVCActivity Value in Operation AFVV: Order 생성시Routing 정보가복사된다.Production Order ConfirmationAFRU생산실적생산품입고(G/R)Goods Movements Errors from ConfirmationsAFFW Incorrect Cost Calculationfrom Confirmations ErrorsPDCAFRP0for Confirmation Automatic Goods ReceiptSubsequently posted Goods Movements for ConfirmationsAFWIfrom ConfirmationsAFRCAFRP1Backflushing AFRP2만약Confirmation 도중Error 가발생했거나Backlog 가남아있을경우다음의Program 을실행한다.Program :CORUPROC Material Doc.Header MKPF Data Transfer to HRAFRP4Calc. Actual CostsAFRP3Program : CORUPROC,CORUAFFW(T-Code :COGI)Material Doc.Item MSEGCharacteristics ■Production VersionProduction Versionsof MaterialMKALLink between Internal MKAL-MATNR = 자재번호MKAL-WERKS = 플랜트MKAL-PLNTYMKAL-PLNNRMKAL-ALNALINOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+MKAL-ALNALLink between Internal Number and ObjectINOB INOB OBJEK MKAL PLNTY + MKAL PLNNR + MKAL ALNAL INOB-KLARTINOB-OBTABAllocation Table Object to Class KSSK-OBJEK = INOB-OBTAB KSSK-KLART=INOB-KLARTObject to ClassKSSK KSSK KLART INOB KLART KSSK-CLINTClass Header DataKLAH Characteristics KLAH-CLINT = KSSK-CLINT KLAH-KLART = INOB-KLART KLAH-CLASSCharacteristics of a ClassKSMLInspection Lot Record Inspection CatalogCode Code Texts Quality Message –QALSInspection Processing: Usage DecisionGenerated TableFor View QMFELCharacteristic Specificationsfor Inspection ProcessingQPCDQuality Notification ItemsQMFEQPCT Maintenance Data ExcerptQMIHÆ설비고장시간Inspection MethodQAVE QMFELQAMVCharacteristic Results in Sample Specifications Insp. Specifications/Quality NotificationQMELInspectionCharacteristic MasterQPMKpMaster RecordQMTBInspectionMethod TextsQMTTInspection ProcessingQAMRp pfor Inspection ProcessingQASVp pValuationQAMVRMSInspection CharacteristicI M th d/Results Tablefor the Sample UnitQASEConfirmation Data for Multiple Spec. SampleQASRMSpMaster TextsQPMTLink Inspection Lot Insp. Methods/Insp. CharacteristicQPMZLogistics Summary TablesS???Link Inspection Lotand Material DocumentQAMBMaterial Doc. ItemMSEGMaterial Doc. HeaderMKPFEC-PCA: Actual Line Items CO-PCA Table■Basic TableCost Center MasterCSKS Profit Center MasterCEPCCost Element MasterCSKAMaster DataObject Number Index EC-PCA: Totals TableGLPCTLine Items GLPCA EC-PCA: Object Tablefor AccountAssignment ElementsObject Number Index for Cost CenterONRKSGLPCO EC-PCA: TransactionAttributes GLPCPObject Number(OBJNR):‘KS’+CO Object CO Obj. Cost Total Summary of Actual & Plan DataActual Line ItemCE1????CO Object Document CO-PA TableObject Number(OBJNR) : KS + Controlling Area(KOKRS) + Cost Center(KOSTL)Document LineCOEPCO ObjectDocument HeaderExternal PostingCOSP CO Obj. Cost Total Internal PostingCOSSLine (by Fiscal Year)COEJPlan Line Item CE2????Summary Record Profitability Segment COBKProfitability SegmentCE3????Profitability SegmentDefinition CE4????ll dÆ???? :Controlling Area Code■Material LedgerMaterial Ledger Document 기준Cost Estimate 기준Header Record CKMLHDPeriod Totals d l Cost Component Splitd Product Costing d Document HeaderMLHDDocument C i d lDocument Posting i d d Q i iDocument ItemsMaterial 과Cost Estimate 의Link 정보Records Values CKMLCR Period Totals Records QuantityCKMLPPHeader CKMLKEKO Cost Component SplitElements CKMLKEPHHeader Data KEKO Product Costing Cost ComponentsKEPHCurrencies and Values MLCR Periods and Quantities MLPPDocument Items MLITDocument 와Material, Cost Estimate,Production Process 의Link 정보를담고있다.Prices CKMLPRMaterial Valuation DataCost Component Split Material Costing View Cost Component Split Cost Component GroupsCost Components PP 의원가취합처나생산작업지시와연결된다.MBEW Cost Component Split Header for Prices CKMLPRKEKO Cost Component Split Elements for Prices CKMLPRKEPHMaterial Valuation DataHistory MBEWHCost Component Split (Control Record)CKMLKEV TCKH7Cost Component Groups-Texts TCKH6Cost Components만약CKMLHD 와CKMLPRKEKO 를대사하여CKMLPRKEKO 에존재하지않는Cost Estimate 가있거나Price Update(T-Code:CK24)에서오류발생시별도생성작업을한다.Program : MLCCS_STARTUPMLCCS_RESET ExecuteCost Components-Texts TCKH1Cost Components TCKH3■Product CostsÆProduct Cost by Period(기간별제품원가)에서사용하는Product Cost Collector(제품원가취합처)에취합된Cost DataOrder Master DataAUFK Generated View for COCOASCO Object 기준ÆWRTTP (Val e T pe)Object Number(OBJNR) : ‘OR’ +Order Number (AUFNR:원가취합처or 생산작업지시)Order Header DataAFKOTotal Variances/Results AnalysesCOSB Order Item Cost Totals for External PostingsGenerated View for PPCAUFVWRTTP (Value Type) -‘04’ : 사전원가(Preliminary Cost)-‘05’ : 실적AFPOCOSP Cost Totals for Internal PostingsCOSS Activity Type TotalsÆAUFNR : 원가취합처번호(Order Type:RM01)COSL ÆOBJNR : 오브젝트번호※Product Cost by Order(오더별제품원가)에서는Production Order 단위로Cost Data 가취합된다.※기간별제품원가에서사전원가(Preliminary Cost)는표준원가(Standard Cost)와달리원가취합처별(생산버전: BOM + Routing)로계산하여사용한다.■Activity TypesActivity Master CSLA, CSLTCost Center MasterCSKSCost Center /Activity TypeCSSLControl Data forActivity TypeCOKLObject Number(OBJNR) : ‘KL’ +Controlling Area(KOKRS) +Cost Center(KOSTL) +Activity Type(LSTAR)Activity Type Totals Line Item for ActivityTypes(by Fiscal Year)Line Item for Activity Types(by Period)COSL Types(by Fiscal Year)COEJL Types(by Period)COEPLFI TablesGeneral Ledger TotalVendorG/L AccountCustomerNew G/LClient Level Vendor General DataG/L Account MasterCustomer General DataGeneral Ledger Total FAGLFLEXT G/L Actual Line ItemFAGLFLEXAClient Level Master Data Vendor General Data LFA1G/L Account Master SKA1Customer General Data KNA1Company Level Master Data Vendor Master (Company Code)LFB1G/L Account (Company Code)SKB1Customer Master (Company Code)KNB1Monthly Summary DataVendorTransaction DataLFC1Customer Transaction DataKNC1Accounting for Vendor General Ledger TotalFAGLFLEXT Accounting for G/L AccountAccounting for CustomerÅOpen ItemÅFI SummaryDocuments for Material Secondary IndexBSIK BSIS BSID Accounting for Vendor BSAKAccounting for G/L AccountBSASAccounting for CustomerBSADÅCleared ItemBSIMAccounting DocumentHeader BKPFAccounting Document Header for ParkingVBKPFParking Documentfor Asset Parking Document for Customer Parking Documentfor Vendor Parking Document for G/L Account Accounting DocumentPosting DocumentParked DocumentClustered by RFBLGfor Asset VBSEGAfor Customer VBSEGDfor Vendor VBSEGKfor G/L AccountVBSEGSSegment BSEGTax Data BSETOne-time Accounting DataBSECBill of ExchangingBSEDControl Data(Obsolete)BSESDictionary TablesTable Description Text DD01L DomainsDD01T DD02LSAP TablesDD02T-TRANSP : Transparent table -INTTAB : Structure -CLUSTER : Cluster table DD03L Table Fields DD03T -POOL: Pooled table-VIEW : General view structure -APPEND: Append structureDD04L Data Elements DD04T DD07L Domain Fixed ValueDD07T DD08L Dictionary Relationship Definition (Check Table, Foreign Key)DD08T Table Secondary Indexes DD12L Table Secondary Indexes DD12TDD17S Secondary Index Fields DD20L Match Code Objects DD20T DD30L Search HelpDD30TDD33S Assigned Fields to Search Help ARCH_OCLAS Assign classes to Archive Object ARCH_CLASS Classes of Integrated Objects ARCH DEF Definition of Archive Object ARCH_DEF Definition of Archive Object TFDIR Function Modules TFTIT FUPARAREF Function Parameters TRMAC ABAP Program Macro TFACSFactory Calendar。