Corporate Sales Data

This Model Table function represents information about sales data from the financial side, with possible integration with SAP S/4HANA ACDOCA table (Universal Journal Entry). It stores single transactions, thus giving a holistic overview over sales from an accounting perspective.

It defines the following fields:

  • Posting Date: You use this field to specify the date on which the transaction is posted.

  • Posting Period [Month]: You use this field to specify the month in which the transaction is executed in accounting.

  • Material Number: You use this field to store information of all types of material used.

  • Company Code: You use this field to specify the company whose financial data is taken into consideration. However, this field can have different values since Carbon Pricing and Taxation can be executed at controlling area level, which spans multiple companies and legal entities.

  • Customer: You use this field to specify a unique identifier for customers.

  • Customer Group: You use this field to specify an aggregation of customers into different groups.

  • Profit Center: You use this field to specify the lowest granularity in a company or legal entity that generates profit.

  • Country/Region of Company: You use this field to specify the country or region where the company is located.

  • Partner Country/Region: You use this field to specify the country or region where the business partner is located.

  • NACE Sector: You use this field to provide information about the industry the business partner is operating in.

  • Material Type: You use this field to specify the type of materials, that is, raw material, semi-finished product, final product.

  • Trade Flows: You use this field to provide information about the flow of the transaction, that is, whether the goods are inbound or outbound to the company.

  • Material Group: You use this field to provide information about the material group which is used as group of materials subsuming similar products.

  • Quantity: You use this field to specify the quantity of a good or service that was object of the transaction.

  • Unit: You use this field to specify the unit in which the good or service of the transaction is measured.

  • Standard Price in Group Currency: You use this field to specify the unit price of the good or service.

  • Company Code Currency: You use this field to specify a unit to describe the currency for recording transactions at the company code level, which means to apply regional or country/region-based legal accounting rules.

  • Status: You use this field to specify the status of the transaction.

  • Controlling Area: You use this field to specify the level of reporting that the company leverages, so it divides its controlling areas as in SAP system or financial systems.

  • Ledger: You use this field to specify the unique identifier of accounting standard of each transaction, for example, IFRS, US GAAP and similar.

  • Record Type: You use this field to specify the type of the data record. The entry can be either “0” for actual records, or “1” for planned records.

  • Posting Key: You use this field to specify the flag to distinguish whether the transaction is from accounts payable or accounts receivable transaction.

  • Sales Order: You use this field to specify the number of the sales order considering one sales invoice; it can be sequential or unique.

  • Document Type: You use this field to specify a categorization of documents that are entered in any transaction systems.

  • Account Number: You use this field to specify the account used for the transaction.