SAP 各模块表逻辑关系图详解

SAPPrincipal

Tables2007.09.

28Netweaver

TeamContents........................……………..........................……………..Material

Master

Tables .……….…….

2SD-MM

Tables ................……………..

367PS

TablesPPTablesQM

TablesCO

Tables......................……………..

10…………..………………….

11FI

Tables ..........................………..……

15Dictionary

Tables ..........….…………..

161MaterialMaster

TablesMaterial

LedgerMaterialMaster

ViewMaterial

LedgerHeaderCKMLHDMaterial

LedgerTotal

ValuesCKMLCRMaterialForecast

ParameterMPOPMaterialPlanning

DataMPGDMaterial

DatabyWarehouse

NumberMPGDMaterialUnitof

MeasureMARMMaterialTax

ClassificationMLANGeneralMaterial

MasterMARAMaterial

LedgerTotalQuantityCKMLPPMaterialValuation

DataMBEWMaterial

DatabyPlantMARCMaterial

DescriptionMAKTMaterial

Ledger

PricesCKMLPRMaterial

DatabyStorage

LocationMARDRouting

Assignmentto

MaterialMAPLBOMLinkto

MaterialMASTProduction

Versionof

MaterialMKALRouting

HeaderBOM

HeaderProduction

VersionBillofMaterial

(BOM)RoutingMaterialSales

DataMVKEMaterialDatabyStorage

TypeMLGTMaterial

TypeT134PLKORouting

ItemPLPOSTKOBOM

ItemSTPOMaterial

AttributeMaterial

GroupT023MaterialProduction

HierarchyT179MaterialControl

RecordMARV물류자재이동

통제2SD-MM

TablesSD

MMSalesHeaderStatusVBUKSalesItem

StatusSalesDoc.

FlowVBFAPurchaseDoc.

HistoryEKBESalesOrder

HeaderVBAKSalesOrder

ItemVBAPS/OBusiness

DataVBKDVBUPPurchase

Requisition

Purchase

OrderEBANPurchaseOrder

HeaderEKKOPurchaseOrder

ItemEKPOS/OSchedule

LineVBEPDelivery

HeaderLIKPShipping

HeaderVEKPS/OSchedule

Line

Purchase

RequisitionEBKNS/OSchedule

Line

Purchase

OrderEKKNDelivery

ItemLIPSShipping

ItemVEPOMaterialDoc.

HeaderMKPFP/OSchedule

LineEKETMaterialDoc.

HeaderMKPFMaterialDoc.

ItemMSEGGoodsIssue

(G/I)MaterialDoc.

ItemMSEGGoodsReceipt

(G/R)출하실적Billing

HeaderVBRKBilling

ItemVBRPAccounting

HeaderBKPFInvoice

HeaderRBKPInvoice

ItemRSEG매출실적매입실적Accounting

SegmentBSEG3SD-MM

TablesOrganization

TablesSDMMCategoryTableDescriptionTextMasterTVKOSalesOrganizationTVKOTTVTWDistributionChannelTVTWTTSPADivisionTSPATTVBURSalesOfficeTVKBTTVKGRSalesGroupTVGRTT171SalesDistrictsT171TLinkTVKOSSalesOrganization+

DivisionTVKOVSalesOrganization+

ChannelTVTASalesOrganization+Channel+

DivisionTVBVKSalesOffice+Sales

GroupTVKBZSalesOrganization+Channel+

Division+Sales

OfficeCustomerKNA1CustomerGeneral

DataKNB1Customer+

CompanyKNVVCustomer+SalesOrganization+DistributionChannel+

Division4CategoryTableDescriptionTextMasterT024EPurchasing

OrganizationT024Purchasing

GroupT026Purchasing

AreaT026TWYT1Vendor

Subrange(Vendor+Vendor

Subrange)T001WPlantT001LStorage

Location(Plant+Storage

Location)LinkT024WPlant+Purchasing

OrganizationT026ZPurchasingOrganization+PurchasingGroup+Purchasing

AreaVendorLFA1VendorGeneral

DataLFB1Vendor+

CompanyLFM1Vendor+Purchasing

OrganizationLFM2Vendor+PurchasingOrganization+VendorSubrange+

PlantSD-MM

TablesMMPurchasingInfo

RecordLongText

InformationMaterialInfo

RecordCondition

HeaderKONHCondition

ItemKONPSAPScriptTextFileHeaderSTXHSAPScriptTextFileLinesSTXLHeaderEINAMaterialInfo

RecordItemEINEMaterialInfo

RecordbyPlantA017PurchasingInfoRecord

+Material+

VendorPurchasing

Order재고Table(판매,고객,공급처,창고

재고)Purchasing

Doc.HeaderEKKOPurchasing

Doc.ItemEKPOS/OSchedule

Line

Purchase

OrderEKKNP/OSchedule

LineEKETLogisticsSummary

TablesS???SalesOrde

StockMSKA(MSKAH)SpecialStockswithCustomerMSKU(MSKUH)Special

StockswithVendorMSLB(MSLBH)StorageLocation

DataforMaterialMARD(MARDH)5PS

TablesProject

DefinitionWorkCenter

HeaderCRHDWork

CenterCOObj.Cost

TotalSummaryofActual&Plan

DataObject

Number(OBJNR)PROJWorkCenter

TextCRTXExternal

PostingCOSPCOObj.Cost

TotalInternalPostingCOSSWBSElement

MasterPRPS

AssignmentWork

CentertoCost

CenterCRCOScheduling

DataforProjectItemPRTEPSTexts

(WBS)PRTXPSTexts

(Header)PSTXProduction

OrderHeaderAFKONetworkPSTexts(Description)PSTTProjectHierarchyforWBSElementPRHIProjectHierarchyforWBSElementPRHISOperationwithin

OrderAFVCOperationActivity

ValueinOperationAFVVNetwork–

RelationshipsAFABNetwork내작업순서

선후관계6PP

TablesRouting

Assignmentto

MaterialMAPLBOMLinkto

MaterialMASTProduction

Versionof

MaterialMKALProduction

VersionBillofMaterial

(BOM)RoutingWorkCenter

HeaderCRHDWork

CenterRouting

HeaderPLKORouting

ItemBOM

HeaderSTKOBOM

ItemWorkCenter

TextCRTXAssignmentWorkCentertoCost

CenterRoutingSelection

ofOperation/ActivatesBOMItem

SelectionProduction

OrderMaster

DataCAUFV

ViewPlanned

OrderPLAFPLPOSTPOCRCOPLASSTASAUFKProduction

OrderHeaderAFKO생산실적생산계획OrderOperation

DataforWorkCenterS022GoodsMovements

Errorsfrom

ConfirmationsAFFWConfirmationProduction

OrderItemAFPOProduction

OrderConfirmationAFRU생산품입고

(G/R)Subsequently

postedBOM에

의한투입원자재

예약Material

Doc.HeaderMKPFMaterial

Doc.ItemMSEGGoods

MovementsforConfirmationsAFWIReservationHeaderRKPFReservationItemRESB원자재

투입(G/I)GoodsMovementforProduction

OrderAUFM7PP

TablesConfirmationOperationwithin

OrderAFVC

Order내

공정작업:Order생성시Routing정보가

복사된다.Activity

ValueinOperationAFVVProduction

OrderConfirmationAFRU생산실적생산품입고

(G/R)GoodsMovements

ErrorsfromConfirmationsAFFWIncorrectCostCalculationfrom

ConfirmationsErrorsPDCAFRP0TableofPlannedChangesfor

ConfirmationAutomaticGoods

ReceiptSubsequently

postedGoodsMovementsforConfirmationsAFWIAFRCAFRP1BackflushingAFRP2Material

Doc.HeaderMKPFDataTransferto

HRAFRP4Calc.Actual

CostsAFRP3만약Confirmation도중Error가발생했거나Backlog가남아있을경우다음의Program을실행한다.Program:

CORUPROC,CORUAFFW(T-Code

:COGI)Material

Doc.ItemMSEG8CharacteristicsProduction

VersionProduction

Versionsof

MaterialMKALMKAL-MATNR=

자재번호MKAL-WERKS=플랜트MKAL-PLNTYMKAL-PLNNRMKAL-ALNALINOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+

MKAL-ALNALLinkbetween

InternalNumberand

ObjectINOBINOB-KLARTINOB-OBTABAllocation

Table

ObjecttoClassKSSKKSSK-OBJEK=INOB-OBTABKSSK-KLART=INOB-KLARTKSSK-CLINTClassHeader

DataKLAHKLAH-CLINT=KSSK-CLINTKLAH-KLART=

INOB-KLARTKLAH-CLASSCharacteristicsofaClassKSML9QM

TablesInspectionLot

RecordQALSCode

TextsQPCT

설비고장시간Inspection

CatalogCodeQPCDQualityNotification

ItemsQMFEQualityMessage–MaintenanceData

ExcerptQMIHInspection

Processing:Usage

DecisionQAVEGeneratedTableForViewQMFELQMFELCharacteristicSpecificationsforInspectionProcessingQAMVQuality

NotificationQMELInspection

MethodMasterRecordQMTBInspectionMethod

TextsQMTTCharacteristicResultsinInspectionProcessingQAMRSampleSpecificationsforInspection

ProcessingQASVInsp.

Specifications/ValuationQAMVRMSResultsTablefortheSample

UnitQASEConfirmationDataforMultipleSpec.SampleQASRMSInspectionCharacteristicMasterQPMKInspectionCharacteristicMaster

TextsQPMTInsp.Methods/Insp.CharacteristicQPMZLogisticsSummary

TablesS???LinkInspection

LotandMaterial

DocumentQAMBMaterialDoc.

ItemMSEGMaterialDoc.

HeaderMKPF10CO

TablesCO-PCA

TableBasic

TableCostCenter

MasterCSKSProfitCenter

MasterCEPCCostElement

MasterCSKAMaster

DataObjectNumber

IndexEC-PCA:Totals

TableGLPCTEC-PCA:

ActualLineItemsGLPCAEC-PCA:

Object

TableforAccountAssignmentElementsGLPCOforCost

CenterONRKSEC-PCA:

TransactionAttributesGLPCPSummaryofActual&Plan

DataCO-PA

TableObjectNumber(OBJNR):‘KS’+ControllingArea(KOKRS)

+Cost

Center(KOSTL)COObjectDocument

LineCOEPCOObj.Cost

TotalExternalPostingCOSPCOObj.Cost

TotalInternalPostingCOSSCOObjectDocumentLine(byFiscal

Year)COEJPlanLine

ItemCE2????COObjectDocument

HeaderCOBKActualLine

ItemCE1????SummaryRecordProfitability

SegmentCE3????ProfitabilitySegmentDefinitionCE4????

????:ControllingArea

Code11CO

TablesMaterial

LedgerMaterialLedgerDocument

기준CostEstimate

기준Header

RecordCKMLHDDocument

HeaderMLHDDocumentDocument

PostingDocument

ItemsMaterial과CostEstimate의

Link정보PeriodTotalsRecords

ValuesCKMLCRPeriodTotalsRecords

QuantityCKMLPPCostComponent

SplitHeaderCKMLKEKOCostComponentSplitElementsCKMLKEPHProduct

CostingHeaderDataKEKOProductCostingCost

ComponentsKEPHCurrenciesand

ValuesMLCRPeriodsand

QuantitiesMLPPMLITDocument와Material,CostEstimate,Production

Process의

Link

정보를

담고

있다.PricesCKMLPRPP의원가취합처나생산작업지시와

연결된다.Cost

Components MaterialCosting

ViewCostComponent

SplitHeaderforPricesCKMLPRKEKOCostComponent

SplitElementsforPricesCKMLPRKEPHMaterialValuationDataHistoryMBEWHCostComponent

Split(ControlRecord)CKMLKEVCost

Component

Groups MaterialValuation

DataTCKH7 MBEWCostComponent

Groups-

TextsTCKH6만약CKMLHD와CKMLPRKEKO를

대사하여CKMLPRKEKO에존재하지않는CostEstimate가

있거나PriceUpdate(T-Code:CK24)에서오류발생시별도생성작업을한다.Program:

MLCCS_STARTUPMLCCS_RESET

ExecuteCost

Components-

TextsTCKH1Cost

ComponentsTCKH312CO

TablesOrderMaster

DataAUFKGeneratedViewfor

COCOASCOObject

기준Product

Costs

ProductCostbyPeriod(기간별제품원가)에서사용하는ProductCostCollector(제품원가취합처)에취합된Cost

DataObjectNumber(OBJNR):‘OR’

+OrderNumber(AUFNR:원가취합처or

생산작업지시)OrderHeader

DataAFKOTotalVariances/Results

AnalysesCOSBOrder

ItemAFPOCostTotalsforExternal

PostingsCOSPGeneratedViewfor

PPCAUFV

WRTTP(Value

Type)-‘04’:사전원가(Preliminary

Cost)-‘05’:

실적CostTotalsforInternal

PostingsCOSS

AUFNR:원가취합처번호(Order

Type:RM01)ActivityType

TotalsCOSL

OBJNR:오브젝트

번호※ProductCostbyOrder(오더별제품원가)에서는ProductionOrder단위로CostData가

취합된다.※기간별제품원가에서사전원가(PreliminaryCost)는표준원가(StandardCost)와달리원가취합처별(생산버전:BOM+Routing)로계산하여

사용한다.13CO

TablesActivity

TypesActivity

MasterCSLA,

CSLTCostCenter

MasterCSKSCostCenter

/ActivityTypeCSSLControlData

forActivityTypeCOKLObjectNumber(OBJNR):‘KL’

+ControllingArea(KOKRS)

+CostCenter(KOSTL)

+Activity

Type(LSTAR)ActivityType

TotalsLineItemforActivityTypes(byFiscal

Year)LineItemforActivityTypes(by

Period)COSLCOEJLCOEPL14FI

TablesGeneralLedger

TotalVendorG/L

AccountCustomerNew

G/LClient

LevelVendorGeneral

DataG/LAccount

MasterCustomerGeneral

DataFAGLFLEXTG/LActualLine

ItemFAGLFLEXAMaster

DataLFA1SKA1KNA1Company

LevelMaster

DataVendorMaster(Company

Code)

LFB1G/LAccount(Company

Code)

SKB1Customer

Master(Company

Code)KNB1MonthlySummary

DataVendorTransaction

DataLFC1CustomerTransaction

DataKNC1GeneralLedgerTotalFAGLFLEXT

Open

Item

FI

SummarySecondary

IndexAccountingforVendorBSIKAccountingforG/L

AccountBSISAccountingfor

CustomerBSIDAccountingforVendorBSAKAccountingforG/L

AccountBSASAccountingfor

C