Posts

Showing posts from August, 2021

Value flows with SAP

Image
The high level of integration is a prerequisite for the mapping of an integrated value flow and can only come about if integration is at the forefront throughout the entire life cycle of the system. Logistics - Controlling - Finance Purchase-to-Pay Order-to-Cash  Production Controlling types: Kundenauftragscontrolling Produktionscontrolling: Ein Unternehmen, das Massenware auf Lager herstellt Lieferantenmanagement und -controlling: Der Fokus liegt hier auf Einkauf und Absatz der Handelswaren. Organisationselemente Buchungskreis: um eine Legaleinheit abzubilden, auf der Ebene des Buchungskreises können jederzeit Bilanz und GuV erstellt werden ( Company code ) Gesellschaft: zur Darstellung der Unternehmensstruktur aus Konsolidierungssicht Geschäftsbereich: auf einer tieferen Ebene als dem Buchungskreis darstellen . Funktionsbereich: der Darstellung der GuV nach dem Umsatzkostenverfahren (UKV).  Kostenrechnungskreis: auf der Gemeinkostenrechnung, Produktkostenrechnung, Kostenträgerrech

Embedded Analytics in SAP S/4HANA

Image
 Note 2289865, "Configuration steps for SAP S/4HANA Analytics", describes the necessary steps to use Analytics in SAP S/4HANA OnPremises.  Architecture How do I find a suitable report in the Standard? SAP Fiori Apps Reference Library (ondemand.com) Custom Analytical Queries

JIT transactions

Image
VSB1N: Self billing monitor  EMJIT: IDoc-Monitor für JIT-Abrufe JIT1, JIT2 und JIT3: JIT-Abruf anlegen, ändern, anzeigen JIT4 und JIT5: JIT-Abruf Eingang: Simulation und Schnelländerung JIT6 und JIT7: Aktionserfassung (Barcode) und mit Vorgabe JITF: Fortschrittsmeldung JITM und JITOM: JIT-Monitoring (In- und Outbound) JITK: Versandfällige Mengenabrufe JITR: Reorganisation Grunddaten JITE und JITOE: Status-Korrektur (In- und Outbound) JITEMRA: Notfallerzeugung gebündelter Mengenabruf JITH: Abgleich JIT-Abrufe mit LAB/FAB JITA: Komponentenliste JITO: Check zur Lieferzusammenführung JITL: Pfegedialog JIT-Material JITB: Nachbearbeiten Rückmeldevorrat JITG und JITOG: JIT-Cockpit (In- und Outbound) JITJ: Impulsmonitor JITLOG und JITLOGDEL: Aktionsprotokolle anzeigen und löschen JITOAL: JIT-Outbound Alerting JITQ: Aktionsnetz anzeigen JITY und JITOA: Archivierung von JIT-Abrufe (In- und Outbound) JITO1 und JITO3: JIT-Abruf anlegen, ändern, anzeigen (Outbound) JITO6: Barcodeerfassung (Outbound

Margin analysis

The equivalent of account-based CO-PA in SAP S/4HANA is Margin analysis . Costing-based profitability analysis is still available in SAP S/4HANA but won’t be further developed. Nearly every process generates a financial accounting document and/or document in profitability analysis, it’s important that you understand the value flows in order to configure profitability analysis properly. Profitability analysis receives postings from previous components and enriches them with characteristics. Therefore, it’s very important to know where your data is coming from and how the processes are defined to make sure you receive the right data to analyze your data correctly.  #Purpose : External view (cash, inventory, accounts receivables) & Internal view ( assign costs to the responsible cost objects and identifies the most profitable products and services ) . #Concepts:  Profitability segment is created when a document is transferred to profitability analysis. Operating concern , which is th

Working with Excel

Image
Formulas How to find duplicates in a column? =IF(COUNTIF($A$2:A2,A2)>1,"Yes","") How to Count Duplicate Instances excluding the First Occurrence =COUNTIF($C$2:$C$8,E2)-1. Count Case-Sensitive Duplicates in Excel =SUM(--EXACT($C$2:$C$8,E2)). Counting Duplicate Rows in Excel =COUNTIFS($A$2:$A$8,A2,$B$2:$B$8,B2,$C$2:$C$8,C2) XLOOKUP function   Additional information tutorials for numerous situations: https://www.got-it.ai/solutions/excel-chat/excel-tutorial/

Finance relevant routines

Image
Negative postings M7053: Posting only possible in periods 2021/07 and 2021/06 in company code FICO Negative postings You can create negative postings in Contract Accounts Receivable and Payable. A negative posting reduces the transaction figures of the posted account in the general ledger. A debit posting as a negative posting therefore does not lead to an increase in transaction figures on the debit side, but to a reduction of the transaction figures on the credit side and vice versa. This enables you to display the transaction figures of accounts after an incorrect posting and corresponding correction (such as invoice posting and reversal) as if neither the incorrect posting nor their correction had taken place. Customizing: company code and document type. M7053: Posting only possible in periods 2021/07 and 2021/06 in company code FICO As many of us struggle with changing periods in our DEV and QA environments, here is quick reference for opening and closing period. In doubt, please