Hallo,
ich habe in den letzten Tagen viel recherchiert und folgende Tabellen mit Beziehungen gefunden:
----------------------------------------------------------Planned Orders: PLAF----------------------------------------------------------
Table Column FriendlyName Table Relationship
PLAF AUFNR ProductionOrderNr AUFK
PLAF KDAUF Sales_Order_Number VBUK
PLAF KDPOS Sales_Order_Number_Position VBUK
PLAF KONNR Number_of_Principal_Purchase_Agreement EKKO
PLAF KTPNR Number_of_Principal_Purchase_Agreement_Position EKPO
----------------------------------------------------------Purchase Requistions: EBAN----------------------------------------------------------
Table Column FriendlyName Table Relationship
EBAN EBELN PurchaseRequestNr EKPO
EBAN EBELP PurchaseRequestNr_Position EKPO
EBAN KONNR Number_of_Principal_Purchase_Agreement EKKO
EBAN KTPNR Number_of_Principal_Purchase_Agreement_Position EKPO
----------------------------------------------------------Purchase Orders EKPO, EKKO, EKKN----------------------------------------------------------
Table Column FriendlyName Table Relationship
EKPO BANFN BANF EBAN
EKPO BNFPO BANF_Position EBAN
EKPO KONNR Number_of_Principal_Purchase_Agreement EKKO
EKPO KTPNR Number_of_Principal_Purchase_Agreement_Position EKPO
EKPO UEBPO Higher_Level_Item_Purchasing_Documents EKPO
------------------------------------------------------------------------------------------------------------------------------------------------------
Table Column FriendlyName Table Relationship
EKKO KONNR Number_of_Principal_Purchase_Agreement EKKO
EKKO LPONR Last_Item_Number EKPO
EKKO AUSNR Bid_invitation_number EKKO
------------------------------------------------------------------------------------------------------------------------------------------------------
Table Column FriendlyName Table Relationship
EKKN EBELN PurchaseRequestNr EKPO
EKKN EBELP PurchaseRequestNr_Position EKPO
EKKN VBELN Sales_Order_Number VBUK
EKKN VBELP Sales_Order_Number_Position VBUK
EKKN AUFNR ProductionOrderNr AUFK
----------------------------------------------------------Material: MSEG, STPO----------------------------------------------------------
Table Column FriendlyName Table Relationship
MSEG KDAUF Sales_Order_Number VBUK
MSEG KDPOS Sales_Order_Number_Position VBUK
MSEG RSNUM Reservation_Number RESB
MSEG RSPOS Reservation_Number_Position RESB
MSEG EBELN PurchaseRequestNr EKPO
MSEG EBELP PurchaseRequestNr_Position EKPO
MSEG AUFNR ProductionOrderNr AUFK
------------------------------------------------------------------------------------------------------------------------------------------------------
Table Column FriendlyName Table Relationship
STPO STLNR Bill_of_material CAUFV
STPO STLTY BOM_category CAUFV
----------------------------------------------------------Production Orders: CAUFV(AUFK+AFKO)----------------------------------------------------------
Table Column FriendlyName Table Relationship
CAUFV STLNR Bill_of_material STPO
CAUFV STLTY BOM_category STPO
CAUFV KDAUF Sales_Order_Number VBUK
CAUFV KDPOS Sales_Order_Number_Position VBUK
----------------------------------------------------------Sales Orders: VBBE, VBEP----------------------------------------------------------
Table Column FriendlyName Table Relationship
VBBE VBELE Business_document_number VBUK
VBBE POSNE Business_item_number VBUP
VBBE ETENE Schedule_line VBEP
------------------------------------------------------------------------------------------------------------------------------------------------------
Table Column FriendlyName Table Relationship
VBEP BNFPO BANF_Position EBAN
VBEP AUFNR ProductionOrderNr AUFK
VBEP PLNUM PlannedOrderNr PLAF
VBEP VBELE Business_document_number VBUK
VBEP POSNE Business_item_number VBUP
VBEP ETENE Schedule_line VBEP
----------------------------------------------------------Reservations: RESB----------------------------------------------------------
Table Column FriendlyName Table Relationship
RESB AUFNR ProductionOrderNr AUFK
RESB PLNUM PlannedOrderNr PLAF
RESB BANFN BANF EBAN
RESB BNFPO BANF_Position EBAN
RESB KDAUF Sales_Order_Number VBUK
RESB KDPOS Sales_Order_Number_Position VBUK
RESB EBELN PurchaseRequestNr EKPO
RESB EBELP PurchaseRequestNr_Position EKPO
----------------------------------------------------------Stock Available: MARD----------------------------------------------------------
Trotzdem weiß ich nicht genau, mit welcher Tabelle ich anfangen soll und ob alle gesammelten Informationen richtig sind oder ob es vielleicht bessere Möglichkeiten gibt?
Vielen Dank im Voraus
Bearbeitet vom Benutzer
vor 5 Tage
|
Grund: Nicht angegeben