oracle_数据仓库简介

Zahnrad-undGetriebetechnikGmbHLetzteÄnderung:31.07.201909:16:00Bearbeiter:D.ArmbrusterSeite1von50MM–MasterData1.VendorMaster.........................................................................................................................21.1Overview................................................................................................................................21.2Menupath/transactions........................................................................................................21.3CreateVendor(Auftraggeber)................................................................................................4Extension(onlyfordataconversion)(e.g.dataline).....................................................................7Addressnotes..............................................................................................................................7EvaluatedReceiptSettlement(ERS)..........................................................................................12OrderAcknowledgmentRequirement.........................................................................................121.4Createvendor(orderingaddress)........................................................................................161.5ChangeVendor....................................................................................................................162.Materialmaster......................................................................................................................202.1Overview..............................................................................................................................202.2Transactions/Menupath.....................................................................................................202.3CreateMaterial.....................................................................................................................22ManufacturerBookPartNumber................................................................................................31Datefromwhichtheplant-specificmaterialstatusisvalid..........................................................343.Inforecord.............................................................................................................................393.1Overview..............................................................................................................................393.2Transactions/Menupath.....................................................................................................393.3CreatInfoRecord.................................................................................................................414.Sourcelist..............................................................................................................................474.1Overview..............................................................................................................................474.2Transactions/Menupath.....................................................................................................474.3Maintainsoureclist..............................................................................................................49Zahnrad-undGetriebetechnikGmbHLetzteÄnderung:31.07.201909:16:00Bearbeiter:D.ArmbrusterSeite2von501.VendorMaster1.1OverviewThevendormasterrecordcontainsinformationaboutthesuppliersofacompany.Inadditiontothenameandaddressofthesupplieravendormasterrecordincludesinformationaboutvendorcurrency,paymenttermsandnamesofimportantcontactpersons.Sincethesupplierisdeemedtobecredit-sidebusinesspartnersofthecompanyintheaccountingdepartment,thevendormasterrecordalsocontainsaccountingdatasuchasthereconciliationoftheGeneralLedgerAccounting.Thevendormasterrecordisthereforemaintainedbybothpurchasingaswellasaccounting.Informationinthevendormasterrecordarecategorizedasfollows:•Generaldata:Thisdataismaintainedontheclientlevelandcontainsgeneralinformationvalidfortheclient,e.g.addressandbankdata.•Companycodedata:Thisdataismaintainedonthecompanycodelevel.Examplesincludenumberofreconciliationaccountandpaymentmethod.•Purchasingorganizationdata:Thisdataismaintainedonpurchasingorganizationlevel.Examplesincludeordercurrency,Incotermsandvariouscontroldatafortthevendor.Inadditionyoucanmaintaindifferentpurchasingdatadependentontheplantorvendorsubrange.1.2Menupath/transactionsCentralMaintenance:SAPMenu→Logistics→MaterialManagement→Purchasing→MasterData→Vendor→Central→Create/Change/Display(XK01/XK02/XK03)Einkaufs-Pflegetransaktion:SAPMenu→Logistics→MaterialManagement→Purchasing→MasterData→Vendor→Purchasing→Create/Change/Display(MK01/MK02/MK03)MenupathZahnrad-undGetriebetechnikGmbHLetzteÄnderung:31.07.201909:16:00Bearbeiter:D.ArmbrusterSeite3von50Thefollowingpagesdescribehowtomaintainpurchasingdataforavendor.TheaccountingdataismaintainedbytheAccountingdepartment.Zahnrad-undGetriebetechnikGmbHLetzteÄnderung:31.07.201909:16:00Bearbeiter:D.ArmbrusterSeite4von501.3C