Yadda za a fitar da rahoton SAP zuwa Excel a cikin matakai 3 masu sauki?
SAP ta fitar da shi don ta fi kowace rahoto da bugawa zuwa fayil
Yana yiwuwa a fitarwa duk wani jerin SAP zuwa Excel, tsarin shine a zahiri don buga shi zuwa fayil, ƙyale zaɓi dama mafita, bugawa ba tare da juyawa ba, Export na MS Excel, fasali mai arziki don nunawa a cikin kundin rubutu, Tsarin HTML don mai bincike na yanar gizo nuni, da kwafe a cikin allo don yin kwafi da hannu.
Idan ba ku son fitarwa tebur na SAP zuwa Excel, amma don fitarwa rahoton SAP ta amfani da aikin ɓoye daga tsarin SAP, waɗannan su ne matakai uku masu sauƙi da za a bi:
- Nemo rahoton don fitarwa a SAP, kuma buɗe aikin bugawa, riƙe zaɓi SAP spool kawai a yanzu,
- Ta amfani da SAP spool ma'amala SP01, canza spool zuwa Excel a SAP ta hanyar fitarwa zuwa fayil na gida,
- Zazzage spool zuwa Excel a SAP ta buɗe fayil ɗin gida a cikin Excel.
Dubi matakan da ke ƙasa don fitarwa rahoton SAP zuwa Excel kuma aiwatar da maƙunsar bayanai na asali kamar su hangen nesa a cikin Excel, stringididdigar maɓallin Excel, ko ƙididdigar abubuwan da suka faru tsakanin wasu.
Farawa tare da tebur daga kowane rahoto da aka kashe a SAP, mataki na farko shine don zaɓar zuwa bayanan da ya wajaba don fitarwa ko ɗauka duk kuma zaɓi zaɓin bugaccen zane.
Yanzu, abin da ke da muhimmanci a iya fitar da wannan bayanan, koda kuwa babu wani zaɓi nagari don fitarwa, shine don zaɓar mai bugawa daidai, wanda ake kira na'urar sarrafawa.
Spool buga ko kai tsaye zuwa firintar
A nan, wajibi ne don amfani da samfurin da aka ba don iya samun takarda wanda ba zai buga wani abu ba, don muna son yin amfani da kwararrun fatalwa, kawai don samun fayiloli a cikin jerin jerin kayan.
Alal misali, ba tare da sanya wata maƙallin bincike ba, za a iya nuna jigidar ɗigon rubutun, yana da muhimmanci don samun buƙatar mai sassaucin da ba za ta yi wani aiki na jiki ba, amma kawai adana fayil har sai an gama shi.
A cikin misalinmu, mai wallafe-wallafen yana wallafawa tare da hudu X, wanda shine jigidar gwajin, ba a haɗe da kowane kwararru na jiki ba, amma kawai ana amfani dashi don gudanar da wuraren bugu.
Yanzu an zaɓi mai bugawa, fara bugu, kuma sakon ya tabbatar da nasarar aikin.
Baya a cikin babban allo na SAP, mai yiwuwa SAP Easy Access, je zuwa tsarin Menu> Wurin buƙatun buƙata, inda za mu iya dawo da fayil ɗin mu.
Kuma a nan shi ne! Wannan shigarwa shine ainihin rahoton bugu da muka kawo a gabanin. Wannan rahoto ba za a iya aikawa ta kowace hanya ba, amma a nan shi ne a cikin safiyar fayil da aka shirya.
Jerin sarrafawa na kayan buƙatun buƙatun da aka saka SPcode.
Yadda za a buga buƙatar buƙata a SAP
Lokaci ya yi da za a zaɓar dabbar don bugawa, ko fitarwa zuwa MSExcel, wanda a cikin yanayin mu kawai zabin.
Wannan buƙatar buƙata na iya nuna hoto, wanda shine mataki na farko don aikawa zuwa fayil ɗin da ake buƙata, ta danna kan gunkin da ya dace a saman dama.
Fayil din zai tambayi irin nau'in fayil ɗin ya kamata a sami ceto, wanda zai iya kasancewa ta tsohuwa wanda ba a karkatar da shi ba, da ɓangaren rubutu, ma'anar kayan arziki, Tsarin HTML, ko kwafin dukan abubuwan ciki zuwa cikin allo.
Bayan an zaɓi tsarin, wani fop-up zai nemi makamar fayil ɗin, wanda dole ne a iya samun damar shiga cikin rubutu ta %%. Zai iya zama babban fayil ɗin fayil.
Kuma wannan shi ne, taƙaitaccen sakon tabbatarwa a kasan SAP window ya nuna cewa aiki ya ci nasara.
Sakon da zai faru zai iya nuna cewa nuna ɗakunan shafukan yana iya haifar da ƙwaƙwalwar ƙwaƙwalwar ajiya, amma ga mafi yawan fayilolin da ya kamata ya zama lafiya, ana iya watsar da sakon.
Yadda za a fitarwa bayanai daga SAP zuwa mafi kyau
Ana iya buɗe fayiloli a Excel ko wani tsarin nuna allo, kuma ya kamata ya nuna teburin da yake samuwa a SAP.
Bayan an fitar da fayil ɗin, kar ka manta da komawa zuwa yarjejeniyar kasuwanci na SP01 SP01, saboda yana da mahimmanci don tsabtace jerin abubuwan da za a hana don rage ƙuntataccen ƙwaƙwalwar uwar garke.
Zaɓi abin da aka buga kuma ba wajibi ba ne, kuma zaɓi gunkin sharewa, buƙatarwa zai nemi tabbaci kafin a share nauyin.
Lissafin da ake buƙata ya kamata ya kasance mai tsabta, kuma fayil ɗin da aka fitar dashi a kwamfuta.
Shirya matsala
Yadda za a fitarwa bayanai daga SAP zuwa Excel, yadda za'a buga buƙatar buƙata a SAP, yadda za a buga takarda a SAP, yadda za a buga PO a SAP, yadda za a buga a SAP, yadda za a adana fayiloli a cikin SAP
Tambayoyi Akai-Akai
- Ta yaya zan fitarwa * Sanda * rahoton?
- Idan baku son fitarwa * SP * Tebur to Excel, amma kuna son fitarwa * Sanda * Rahoton, to, za ku iya yin shi cikin sauƙi tare da aikin tattarawa mai sauƙi.
- Ta yaya za ku fitar da rahoto daga SAP don Excel?
- Fitar da rahoto daga SAP Don fice-yafi dacewa ya ƙunshi amfani da aikin fitarwa a cikin rahoton keɓewa, inda za'a zaɓa daban-daban.
- Shin zaka iya sarrafa fitarwa daga SAP Rahotanni don Ingantaccen Rahoton Maimaitawa?
- Sarrafa kansa da fitarwa na maimaitawa SAP ta sami rahotuka ga Excel ta samu ta hanyar rubutun hannu ko shirya ayyukan da aka shirya a cikin SAP.
Gabatarwa zuwa SAP HANA ga Wadanda ba Techies ba a cikin bidiyo
Yoann Bierling shine ƙwararren ɗab'i na dijital, mai ba da shawara na duniya, yin tasiri na duniya ta hanyar ƙwarewa da bidi'a a cikin fasaha. Masu sha'awar ƙarfafa mutane da ƙungiyoyi don haɓaka sakamako na musamman da haɓaka haɓakawa ta hanyar samar da abun ciki.
