SELECT COPA.`Posting period`, COPA.BU_Name,COPA.Mois, COPA.`FSC Org`, COPA.`Application ID`, COPA.`Calendar day`, COPA.Division, COPA.`Nom Division`, COPA.`Sales Group`, COPA.`Nom Sales Group`, COPA.`COPA Doc Number`, COPA.`No Commande`, COPA.`No Ligne`, COPA.Customer, COPA.`Nom Customer`, COPA.`Sales Employee`, COPA.`Nom Employee`, COPA.Endcustomer, COPA.Type_Cde, COPA.`Ship-to-party - Name 1`, COPA.`Ship-to-party - Postal Code`, COPA.`Ship-to-party - City`, COPA.Material, COPA.Description, COPA.`2 Product Segment`, COPA.`6 Mid Model`, COPA.Fabrikategruppe, COPA.`Transaction Type`, COPA.MAAG, COPA.`PLA Volume`, COPA.`Sales quantity`, COPA.`Revenue-Sales`, COPA.`Revenue - Agreed Special Price Rebate`, COPA.`Revenue - Distr_Cust Volume Rebate`, COPA.`Revenue - Cash Discount`, COPA.`Revenue - Service Contract Management`, COPA.`Revenue - Business Growth Rebate`, COPA.`Revenue - Service Pack Reset`, COPA.`Revenue - Service Pack Monthly`, COPA.`Revenue - Rental`, COPA.`Revenue Net`, COPA.`DCoS-Transfer Cost`, COPA.`DCoS-Warranty`, COPA.`DCoS - Service Contract Management`, COPA.`DCoS - Service Pack`, COPA.`DCoS - Service Pack Reset Statist Cost`, COPA.Projet, COPA.NomIC11, COPA.NomIC12, COPA.`Login IC2`, COPA.NomIC2, COPA.NomIC_final, COPA.ClientIC2, COPA.GA, COPA.`Customer Group`, COPA.Taux_RFA, COPA.Revenu_Brut, COPA.Avoirs_Retours, COPA.Avoirs_Financiers, COPA.Warranty_Group, COPA.Sales_Group_Name, COPA.Segment_Produit, COPA.VFY, COPA.Annee_Mois, `IC FR82`.New_BU, COPA.Secteur, COPA.DIV, COPA.Motif_Cde, COPA.BU FROM `V:\mani3\Access\mani3.mdb`.COPA COPA, `V:\mani3\Access\mani3.mdb`.`IC FR82` `IC FR82` WHERE COPA.NomIC_final = `IC FR82`.`Nom SAP` ORDER BY COPA.ClientIC2, COPA.`COPA Doc Number`
Partager