SAP 各模塊表邏輯關(guān)系圖詳解

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