Search Results

We are driven by the purpose of creating value and generating impact for our clients. Helping businesses to achieve its goals and building better future. We have a clear purpose: to help companies run SAP better, which reflects our mission to generate positive and significant. Luiz C. Mar iani SAP S/4 HANA FICO Solution Architect Managing Director at SAP NFe https://www.linkedin.com/in/luizmariani/ Contact Us First name Last name Email Write a message Thanks for submitting! Submit Locations Phone UK Office Address: 25 Crossharbour Plaza, London E14 9SS, UK US Office Address: 1200 Brickell Ave Suite 1950 #1137, Miami, FL 33131, USA BR Office Address: Av. Paulista, 1636 - Cerqueira César, São Paulo - SP, 01310-200, Brazil

We are driven by the purpose of creating value and generating impact for our clients. Helping businesses to achieve its goals and building better future. Available for SAP FICO as Consultant, SME, Leader or Solution Architect Fully Remote New technologies like S/4 HANA are preferable Long-term contracts Download CV Availability Phone SAP S/4 HANA FI 1909 SAP Design Thinking Deloitte Lean Six Sigma Belt SAP S/4 HANA FI 1909 1/6 I'm SAP S/4 FICO Solution Architect with 18+ years of experience in implementation and business integration, fitment and fulfillment for big sized projects with high complexity, able to implement and solve mission-critical business challenges. I have a full resume with successful delivered projects by providing skilled technical consulting and custom training. Years of Experience Finance 18 Years ▇▇▇▇▇▇▇▇▇ Controlling 18 Years ▇▇▇▇▇▇▇▇▇ Material Ledger 18 Years ▇▇▇▇▇▇▇▇▇ CO-PC 18 Years ▇▇▇▇▇▇▇▇▇ CO-PA 18 Years ▇▇▇▇▇▇▇▇▇ Cash Mgnt 18 Years ▇▇▇▇▇▇▇▇▇ Credit Mgnt 10 Years ▇▇▇▇▇ Tax 14 Years ▇▇▇▇▇▇ FM 04 Years ▇▇▇▇ ABAP 03 Years ▇▇▇ CFIN 03 Years ▇▇▇ FI-CA 01 Years ▇ Retail 04 Years ▇▇▇▇ Number of Projects Full Lifecycle 05 Prjs ▇▇▇▇▇ S/4 HANA 07 Prjs ▇▇▇▇▇▇▇ Greenfield 06 Prjs ▇▇▇▇▇▇ Rollout 10 Prjs ▇▇▇▇▇▇▇▇▇ Improvements 09 Prjs ▇▇▇▇▇▇▇▇ Blueprints 02 Prjs ▇ QA 02 Prjs ▇▇ PoC 01 Prj ▇ Upgrades 01 Prj ▇ Industry Sectors Agribusiness 03 Prjs ▇▇▇ Automotive 01 Prj ▇ Beverage 02 Prjs ▇▇ Biotech 01 Prj ▇ Chemical 06 Prjs ▇▇▇▇▇ Cons. Goods 01 Prj ▇ Finance 01 Prj ▇ Food 02 Prjs ▇▇ Healthcare 01 Prj ▇ Manufacture 03 Prjs ▇▇▇ Media 01 Prj ▇ Mining 01 Prj ▇ Oil & Gas 01 Prj ▇ Paper 01 Prj ▇ Pharma 04 Prjs ▇▇▇▇ Metals 01 Prj ▇ Public Sector 01 Prj ▇ Retail 03 Prjs ▇▇▇ Tech. / Serv. 03 Prjs ▇▇▇ My Mission To help companies run SAP better Improving processes, running cost-effective solutions and creating value Applying best practices and bringing the system back to standard Consultancies in my Portfolio Accenture | Capgemini | Cast Group | Deloitte | Engineering | Everis | EY | iGate | Infosys | PwC | SAP Integration Skills Integration with MM, SD, PP, PS, QM, PM, BW/BI, PI/PO and PLM cProjects, to design architectural solutions in SAP and also legacy systems. Solution Skills SAP Solutions for Tax Engine, Country versions, Revenue Recognition, Legal statements, Bank communication and Consolidation. Data Migration Data Collection / Data Cleansing / Data Transformation / Data Migration SAP CFIN Central Finance Transformation LSMW Legacy System Migration (accelerated with embedded ABAP code) LMTC Legacy Transfer Migration Cockpit Industry Solutions Agribusiness | Aerospace | Automotive | Beverage | Biotechnology | Chemical | Consumer Goods | Finance | Food | Fracking | Health Care | Manufacture | Media | Metals & Mining | Oil & Gas | Precious Metals | Public Sector | Paper & Cellulose | Pharmaceutical | Retail | Services | Technology | Telecommunication SAP IS-Solutions SAP PSCD Public Sector Collection and Disbursement | SAP FI-CA Contract Accounting | SAP POS-DM (Retail) Point of Sale Data Management Education 2016 MBA Strategic Management in Information Technology FGV 2015 Alumni Program Technology, Organizations and Innovation MIT 2015 Bachelor’s Degree Economics (Leave of Absence) Paulista University 2011 Bachelor’s Degree Accounting Paulista University 2004 Bachelor’s Degree Business Administration Mackenzie University Certification 2021 Design Thinking [+] SAP Certified Associate Design Thinking SAP 2020 SAP S/4 FI [+] SAP S/4 HANA 1909 for Financial Accounting Associates SAP 2013 ITIL [+] ITIL v3 Foundation Certification EXIN 2012 COBIT COBIT 4.1 Foundation Certification ISACA 2009 Lean/Six Sigma Lean/Six Sigma Certification (Yellow Belt) Deloitte 2008 SAP FI SAP ECC 6.0 for Financial Accounting Associates SAP Qualifications and Professional Activities 2020 Agile Agile with Jira (SCRUM and KANBAN) Coursera 2020 SAP TRM SAP TRM Tax and Revenue Management Capgemini 2020 SAP PSCD SAP PSCD Public Sector Collection and Disbursement Capgemini 2020 SAP S/4 FI SAP S/4 Financial Accounting in S/4HANA 1909 SAP 2017 SAP ABAP SAP ABAP Academy SAP 2015 SAP Simple FI SAP HANA Simple Finance, S/4 HANA Migration SAP 2014 SAP NF-e SAP NF-e Nota Fiscal Eletronica 3.10 with GRC Tech Consulting 2013 ITIL ITIL V3 Foundations KA Solution 2012 SAP Material Ledger SAP CO Brazil Localization (Material Ledger) SAP 2012 SAP NF-e GRC SAP NF-e 10.0 with GRC, WBRNFE_10 SAP 2012 SAP NewGL SAP NewGL (New General Ledger) SAP 2012 COBIT COBIT 4.1 Foundations KA Solution 2012 SQL SQL, Microsoft SQL Server Writing Queries KA Solution 2011 SAP CO SAP CO Academy (Controlling Accounting) SAP 2010 HPQC HP Quality Center SAP 2010 SAP InfoPak SAP InfoPak, Documentation Tool SAP 2009 Lean/Six Sigma Lean/Six Sigma (Green Belt Academy) Deloitte 2009 IFRS IFRS, Concepts and Preparation Deloitte 2008 SAP FI SAP FI Brazil Localization SAP 2008 SAP SolMan SAP Solution Manager Deloitte 2008 HPQC HP Quality Center, Mercury HP 2007 SAP FI SAP FI Academy (Financial Accounting) SAP 2007 SAP R/3 SAP BootCamp R/3 4.6c, FI,CO,MM,SD,PP Modules Deloitte

Somos movidos pelo propósito de criar valor e gerar impacto para nossos clientes. Ajudando empresas a atingirem seus objetivos e construírem um futuro melhor. Disponivel para projetos: 100% Remotos SAP S/4 HANA FICO Arquiteto de Soluções, Lider ou Consultor Senior Modelo PJ Baixar CV Disponibilidade Taxa/Hora SAP S/4 HANA FI 1909 SAP Design Thinking Deloitte Lean Six Sigma Belt SAP S/4 HANA FI 1909 1/6 Arquiteto de soluções SAP S/4 FICO com 18+ anos de experiência em implementação e integração de negócios, adequação e cumprimento de projetos de grande porte com alta complexidade, capaz de implementar e resolver desafios de negócios de missão crítica. Tenho um currículo repleto de projetos entregues com sucesso, fornecendo consultoria técnica qualificada e treinamento personalizado. Experiência Finance 18 Years ▇▇▇▇▇▇▇▇▇ Controlling 18 Years ▇▇▇▇▇▇▇▇▇ Material Ledger 18 Years ▇▇▇▇▇▇▇▇▇ CO-PC 18 Years ▇▇▇▇▇▇▇▇▇ CO-PA 18 Years ▇▇▇▇▇▇▇▇▇ Cash Mgnt 18 Years ▇▇▇▇▇▇▇▇▇ Credit Mgnt 10 Years ▇▇▇▇▇ Tax 14 Years ▇▇▇▇▇▇ FM 04 Years ▇▇▇▇ ABAP 03 Years ▇▇▇ CFIN 03 Years ▇▇▇ FI-CA 01 Years ▇ Retail 04 Years ▇▇▇▇ Número de Projetos Full Lifecycle 05 Prjs ▇▇▇▇▇ S/4 HANA 07 Prjs ▇▇▇▇▇▇▇ Greenfield 06 Prjs ▇▇▇▇▇▇ Rollout 10 Prjs ▇▇▇▇▇▇▇▇▇ Improvements 09 Prjs ▇▇▇▇▇▇▇▇ Blueprints 02 Prjs ▇ QA 02 Prjs ▇▇ PoC 01 Prj ▇ Upgrades 01 Prj ▇ Indústrias Agribusiness 03 Prjs ▇▇▇ Automotive 01 Prj ▇ Beverage 02 Prjs ▇▇ Biotech 01 Prj ▇ Chemical 06 Prjs ▇▇▇▇▇ Cons. Goods 01 Prj ▇ Finance 01 Prj ▇ Food 02 Prjs ▇▇ Healthcare 01 Prj ▇ Manufacture 03 Prjs ▇▇▇ Media 01 Prj ▇ Mining 01 Prj ▇ Oil & Gas 01 Prj ▇ Paper 01 Prj ▇ Pharma 04 Prjs ▇▇▇▇ Metals 01 Prj ▇ Public Sector 01 Prj ▇ Retail 03 Prjs ▇▇▇ Tech. / Serv. 03 Prjs ▇▇▇ Missão Ajudar as empresas a executar melhor o SAP Melhorando processos, executando soluções custo efetivas e criando valor Aplicando as melhores práticas e trazendo o sistema de volta ao padrão Portfolio de Consultorias Accenture | Capgemini | Cast Group | Deloitte | Engineering | Everis | EY | iGate | Infosys | PwC | SAP Integrações Integração com MM, SD, PP, PS, QM, PM, BW/BI, PI/PO e PLM cProjects, para projetar soluções integradas SAP e sistemas legados. Soluções SAP Solutions for Tax Engine, Country versions, Revenue Recognition, Legal statements, Bank communication and Consolidation. Migração de Dados Coleta de dados | Limpeza de dados | Transformação de dados | Migração de dados SAP CFIN Central Finance Transformation LSMW Legacy System Migration (com código ABAP incorporado) LMTC Legacy Transfer Migration Cockpit Indústrias Agronegócio | Aeroespacial | Automotivo | Bebidas | Biotecnologia | Química | Bens de consumo | Finanças | Alimentos | Fracking | Assistência médica | Fabricação | Mídia | Metais e mineração | Petróleo e gás | Metais preciosos | Setor público | Papel e celulose | Farmacêutico | Varejo | Serviços | Tecnologia | Telecomunicações SAP IS-Solutions SAP PSCD Public Sector Collection and Disbursement | SAP FI-CA Contract Accounting | SAP POS-DM (Retail/Varejo) Gestão de Dados de Ponto de Venda Educação 2016 MBA Strategic Management in Information Technology FGV 2015 Alumni Program Technology, Organizations and Innovation MIT 2015 Bachelor’s Degree Economics (Leave of Absence) Paulista University 2011 Bachelor’s Degree Accounting Paulista University 2004 Bachelor’s Degree Business Administration Mackenzie University Certificações 2021 Design Thinking [+] SAP Certified Associate Design Thinking SAP 2020 SAP S/4 FI [+] SAP S/4 HANA 1909 for Financial Accounting Associates SAP 2013 ITIL [+] ITIL v3 Foundation Certification EXIN 2012 COBIT COBIT 4.1 Foundation Certification ISACA 2009 Lean/Six Sigma Lean/Six Sigma Certification (Yellow Belt) Deloitte 2008 SAP FI SAP ECC 6.0 for Financial Accounting Associates SAP Qualificação e Atividades Profissionais 2020 Agile Agile with Jira (SCRUM and KANBAN) Coursera 2020 SAP TRM SAP TRM Tax and Revenue Management Capgemini 2020 SAP PSCD SAP PSCD Public Sector Collection and Disbursement Capgemini 2020 SAP S/4 FI SAP S/4 Financial Accounting in S/4HANA 1909 SAP 2017 SAP ABAP SAP ABAP Academy SAP 2015 SAP Simple FI SAP HANA Simple Finance, S/4 HANA Migration SAP 2014 SAP NF-e SAP NF-e Nota Fiscal Eletronica 3.10 with GRC Tech Consulting 2013 ITIL ITIL V3 Foundations KA Solution 2012 SAP Material Ledger SAP CO Brazil Localization (Material Ledger) SAP 2012 SAP NF-e GRC SAP NF-e 10.0 with GRC, WBRNFE_10 SAP 2012 SAP NewGL SAP NewGL (New General Ledger) SAP 2012 COBIT COBIT 4.1 Foundations KA Solution 2012 SQL SQL, Microsoft SQL Server Writing Queries KA Solution 2011 SAP CO SAP CO Academy (Controlling Accounting) SAP 2010 HPQC HP Quality Center SAP 2010 SAP InfoPak SAP InfoPak, Documentation Tool SAP 2009 Lean/Six Sigma Lean/Six Sigma (Green Belt Academy) Deloitte 2009 IFRS IFRS, Concepts and Preparation Deloitte 2008 SAP FI SAP FI Brazil Localization SAP 2008 SAP SolMan SAP Solution Manager Deloitte 2008 HPQC HP Quality Center, Mercury HP 2007 SAP FI SAP FI Academy (Financial Accounting) SAP 2007 SAP R/3 SAP BootCamp R/3 4.6c, FI,CO,MM,SD,PP Modules Deloitte

SAP NFe is focused on SAP Localizations/Versions for Countries in Europe, North America and South America. We can improve processes, applying best practices and bringing SAP back to standard, creating value for your company. Creating value and generating positive and significant impacts on business. SAP NFe To Help Companies Run SAP Better Most of the companies spend hundreds of thousands of dollars , hiring unprepared consultancies and consultants, resulting in a expensive and unreliable system, with high maintenance costs, which ends up not meeting the company's expectations. This is the usual experience that the most valuable companies on the market are used to living on a day-to-day basis. We are focused on Europe , North America and South America country versions and localizations. We can improve processes, applying best practices and bringing the SAP back to standard, creating value to your company. If you're ready to innovate, we can help your business achieve its goals with cost-effective, tailor-made solutions. SAP Global Best Practices These articles cover the guidelines and best practices that the big techs don't want you to know. SAP Brazil Localization These articles cover roadmap implementation, localization complexity, nota fiscal (e-invoicing), indirect taxes, direct taxes, withholding, bank communication, electronic reporting (SPED) and more. SAP EU Localization These articles cover the main points about the EU Common Market, Localization, Single Euro Payments Area and more. SAP UK Localisation These articles cover roadmap implementation, localisation complexity, financial accounting, taxes, accounts payable, bank accounting and more. SAP US Localization These articles cover roadmap implementation, localization complexity, financial accounting, taxes, treasure, accounts payable, bank accounting, check (or also known as a cheque, in British English), withholding taxes (1099 misc) and more. Solutions We are focused on helping companies achieve their goals with cost-effective, tailor-made solutions. Sustainability Technology shaping the future of your company with sustainability, eliminating the waste of resources and process. Global Trends Our values go beyond simply redesigning processes. We help improve performance, compliance and more.

SAP NFe fully supports vaccination and a safe business environment, respecting and supporting people's lives. If you are not feeling well, follow the public health guidelines posted in your community. Stay home, stay safe, take care of each other and your community. SAP NFe Take Care Today, Be Safe Tomorrow Health Policy SAP NFe fully supports vaccination and a safe business environment, respecting and supporting people's lives. If you are not feeling well, follow the public health guidelines posted in your community. Stay home, stay safe, take care of each other and your community. If you are in need, please, seek support at UK NHS National Health Service https://www.nhs.uk/conditions/vaccinations/ US CDC Centers for Disease Control https://www.cdc.gov/vaccines/ BR SUS Health Unic System https://www.gov.br/saude/

Terminology These are some global terminologies and acronyms used in a business context. SAP It stands for Systems, Applications and Products. ERP It stands for Enterprise Resource Planning. It is a type of software system that helps organizations automate and manage core business processes. It’s capable of linking a company’s financials, supply chain, operations, commerce, reporting, manufacturing, and human resources activities on one platform. (e.g. SAP and Oracle) ECC It stands for ERP Central Component. It is the largest system element of the SAP Business Suite, and consists of the group of functions that businesses can perform. S/4 Some sources say that "S" stands for Simple and "4" refers to the generation sequence, others say the the "S/4" comer from the short version "Suite 4" of "SAP Business Suite 4 HANA". HANA It stands for High Performance Analytic Appliance and was introduced for marketing purposes (although it doesn´t sounds a proper acronym). But according to other sources, initially the name HANA was conceived in Palo Alto, as Hasso’s New Architecture inspired by SAP's founder, Hasso Plattner. SAP OSS Note OSS stands for Online Attendance System. As the name implies, it is the service accessible through the internet. The SAP note is a set of instructions for correcting known bugs and providing answers to frequently asked questions, and it is part of the SAP service portal. MRP It stands for Material Requirements Planning. It is a software-based integrated inventory and supply management system designed for businesses. Companies use MRP to estimate quantities of raw materials, maintain inventory levels, and schedule production and deliveries. Both MRP and MRP II are seen as predecessors to ERP MRP II It stands for Manufacturing Resource Planning. It is an integrated information system evolved from early MRP by including the integration of additional data, such as employee and financial needs. Both MRP and MRP II are seen as predecessors to ERP. Modules Modules, in SAP, are a set of applications created to support specific business processes within an organization, designed exactly like the functional areas or departments that a company has, from finance to sales, including procurement, production and many others. ABAP It stands for Advanced Business Application Programming, also known originally as Allgemeiner Berichts-Aufbereitungs-Prozessor (in German) or General report-consolidating processor (in English). It is the programming language created by SAP. In its syntax, SAP ABAP is similar to the COBOL (Common Business Oriented Language) programming language, and it is clearly based on the natural language, with its functions integrated with database access via Open SQL statements. The programming language can utilize procedural, object-oriented, and other programming principles. Although ABAP is SAP’s primary programming language, programs written with ABAP can run alongside those based on other programming languages such as Java, JavaScript, and others. KPI It stands for Key Performance Indicator. It is a type of performance measurement that evaluates the success of an organization or of a particular activity. KANBAN It is a Japanese word for Sign. It is a scheduling system for lean manufacturing, used for inventory control in just-in-time (JIT) production. An industrial engineer at Toyota, developed kanban to improve manufacturing efficiency using visual cues to prompt the action needed to keep a process flowing. One of the main goals is to limit the buildup of excess inventory at any point on the production line. JIT It stands for Just-in-Time. It is a form of inventory management that requires working closely with suppliers so that raw materials arrive as production is scheduled to begin, but no sooner. The goal is to have the minimum amount of inventory on hand to meet demand. PDCA It stands for Plan-Do-Check-Act. It is a four-step cycle problem-solving iterative technique used to improve business processes. The PDCA process is similar to the Japanese business philosophy of Kaizen. Kaizen It is a Japanese term meaning change for the better or continuous improvement. It is a Japanese business philosophy that focuses on gradually improving productivity and making a work environment more efficient. The concept also applies to all process, crossing organization boundaries, improving all functions and involving all employees, from the CEO to the assembly line workers. ASAP In an SAP context, It stands for Accelerated SAP. Despite being widely used as "As Soon As Possible" in business-related and non-business contexts. It is a SAP methodology designed to help implementations as efficiently as possible. Its goal is to effectively optimize time, people, quality and other resources. Agile In software development, it is an umbrella term for a set of frameworks and practices based on the values and principles expressed in the Agile Manifesto. Basically it is a simple concept of continuous incremental improvement through small and frequent releases, using daily meetings, segregating deliverables in User Stories, addressing Personas, analysing Milestones and using product strategies such as Interative and Incremental developments. Despite being much more effective when used in small software developments (e.g. mobile apps), it is widely used in SAP projects with such methodologies as SCRUM, SAP Activate and others. SCRUM The term scrum comes from rugby football, where players packing closely together with their heads down and try to gain possession of the ball. The scrum methodology, commonly used in software developments, is a way to get work done as a team in small pieces at a time, with continuous experimentation and feedback loops along the way to learn and improve as you go, helping people and teams deliver value incrementally in a collaborative way. The fundamental unit of scrum is a small team, consisting of a product owner, a scrum master, and developers, where the methodological process involves daily scrum meetings, with product backlogs to be done, segregated in user stories, with sprint cycles for the deliverables. Trade Name A trade name, trading name, or business name, is a pseudonym used by companies that do not operate under their registered company name. Brazil-specific Terminology These are some Brazil-specific terminologies and acronyms used in a Business context, related to taxation and legal requirements in the national territory. LATAM It stands for Latin America. It is a geographical grouping widely used by global corporations to define regional business activity. It is a shorthand method to refer to the countries of American continent that speak the languages derived from Latin (Spanish, Portuguese and French). Latin America comprises almost all of South and Central America with exceptions, and Mexico of North America. Mercosul / Mercosur It stands for Mercado Comum do Sul (in Portuguese) or Mercado Común del Sur (in Spanish). In English it is known as Southern Common Market. It is a South American trade bloc and its purpose is to promote free trade and the fluid movement of goods, people, and currency. BRICS It stands for Brazil, Russia, India, China and South Africa. The term was originally developed in the context of foreign investment strategies. It was introduced in the 2001 publication, "Building Better Global Economic BRICs" by the Goldman Sachs economist Jim O'Neill. CNPJ It stands for Cadastro Nacional de Pessoa Juridica (in Portuguese). It is the Company ID and also the Tax Number for legal entities. CPF It stands for Codigo de Pessoa Fisica (in Portuguese). It is the taxpayer's identification for natural person. In other countries like UK is similar to NIN (National Insurance Number), or in US, the SSN (Social Security Number). SAP: It is to be informed in the customer/vendor master record if the customer/vendor is a natural person. RG It stands for Registro Geral (in Portuguese) or General Registration (in English). It is the Brazilian natural person ID (Identification / Identity). Tax Regimes [ More... ] Or in Portugues "Regime Tributatio". It is what determines which taxes will be paid by a company and how it will be done. There are 3 tax regimes in Brazil: Actual profit, Presumed profit and Simplified (in Portugues "Simples Nacional"). CNAE [ More... ] It stands for Codigo Nacional da Atividade Economica (in Portuguese) or National Code of Economic Activity (in English). It is the code of national classification of the companies according to their economic Activity. CFOP [ More... ] It stands for Codigo Fiscal de Operacoes e Prestacoes (in Portuguese) or Fiscal Code of Operations and Provisions (in English). It is the code defined by the Brazilian authorities to describe the type of the business transaction. IBGE It stands for Instituto Brasileiro de Geografia e Estatistica (in Portuguese) or Brazilian Institute of Geography and Statistics (in English). It is the Brazilian state agency responsible for surveying the country's data. This institute, founded with the aim of gathering geographic information and Brazilian statistics, is of great importance in government terms. It is responsible, among other duties, for carrying out the demographic census. Traditionally, the IBGE conducts censuses in cyclical ten-year periods, providing important socioeconomic information for the country. CONCLA It stands for Comissão Nacional de Classificação (in Portuguese) or National Classification Commission (in English). It is the institution responsible for statistical classifications in Brazil, for selected topics, used in the country's statistical system and administrative records and the international classifications associated with them. The classifications organized by CONCLA are: CNAE, CBO, CID-10, PRODLIST, Dialling Phone Codes, Environment Classification, Education Classification and others. EFR It stands for Ente Federativo Responsável (in Portuguese) or Responsible Federal Entity (in English). It is an administrative unit of public body and they can provide their information in a decentralized way. For example, the Vitória Municipality has the Vitória City Hall as its EFR, that is, in most cases the EFR is the City Hall. ANATEL It stands for Agencia Nacional de Telecomunicacoes (in Portuguese) or National Telecommunications Agency (in English). It is the regulatory agency for the Brazilian telecommunications sector. Its main roles are to supervise and edit rules for the sector, as well as mediate conflicts between operators and consumers. UF It stands for Unidade Federativa (in Portuguese) or Federative Unit (in English). Basically they are all the states of Brazil, plus the Distrito Federal (Federal Distric). For example, São Paulo is a Federation Unit, and the UF of São Paulo is SP. BACEN / BCB / BC It stands for Brazilian Central Bank. It is the institution responsible for regulating, controlling and supervising the Brazilian financial system. SISBACEN It stands for Sistema de Informações Banco Central (in Portuguese) or Central Bank Information System (in English). It is the group of IT systems and resources that support the Brazilian Central Bank. PTAX The term comes from PTAX800, a SISBACEN transaction (Central Bank System) used for many years, by the public, to consult exchange rates. The transaction was deactivated on September 1, 2014, but the name remained, due to widespread use by foreign exchange market agents. The PTAX is the reference exchange rate (BRL/USD) most used in the Brazilian foreign exchange market, it is calculated and published by the Brazilian Central Bank on a daily basis. DREX It standard for Digital, Real, Eletronico, X representa modernidade e conexao (in Portugues) or Digital, Real, Eletronic, X stands for modernity and connection (in Enlish). DREX is the name of the digital version of the Real (BRL). Considered the newest solution by the (BCB) Central Bank of Brazil to digitize the economy. Despite also using blockchain technology, as well as crypto currencies (Bitcoin), the DREX is not a crypto currency. This is because the economic policies and fundamentals of the Brazilian digital currency will be the same as the physical Real and will be 100% controlled by the BCB. This means that the value of the asset will be stable in relation to the Brazilian real (1 BRL = 1 DREX) and will be controlled and monitored by the Brazilian Central Bank. Boleto It is a payment form (bank payment slip) very common in Brazil. Vendor send Boletos to their customers attached to the invoice (NF Nota Fiscal) or in an electronic format. Duplicata It is a payment method used to collect payments from customers, like a trade note. The commercial duplicata is a nominal document issued by the Banks, with the overall value and the invoice due date. PIX PIX is not an acronym, nor does it mean a specific concept. It is a new Brazilian Payment Method, that was named, by Brazilian Central Bank, with the name PIX because the term is reminiscent of technology, transactions and pixels (the luminous points on a screen). CNAB It stands for Centro Nacional de Automacao Bancaria (in Portuguese) or National Banking Automation Center (in Eglish). It is a flat file layout for bank communication, allowing automatic payment, collection and receipt of bank statements. FEBRABAN It stands for Federação Brasileira de Bancos (in Portuguese) or Brazilian Federation of Banks (in Eglish). It is the main entity representing the Brazilian banking sector. It has a wide range of activities but all aimed at improving the financial system. In the SAP banking context, it represents one of the most used bank file formats by the main banks in Brazil. PPI It stands for Preco de Paridade de Importacao (in Portuguese) or Import Parity Price (in English). Basically it is the total cost to internalize a product. It is commom used to refer to Fuel, in other words, it is a reference calculated based on the purchase price of fuel, plus logistical costs up to the delivery point, which includes freight, port fees, road transport and others. NF-e [ More... ] It stands for Nota Fiscal Eletronica (in Portuguse) or Eletronic Nota Fiscal (in English) . It is the official document in Brazil in a form of "electronic tax invoice". This kind of e-invoicing is used in logistics and services operations and it is the basis for Brazilian legal operations and reports. CC-e It stands for Carta de Correcao Eletronica (in Portuguese) or Electronic Correction Letter (Electronic Correction Letter). It is a event to correct the Nota Fiscal (e-invoice) information, which has already authorized by tax authorities. If there is any incorrect information in the Nota Fiscal (e-invoice) the issues is responsible for issuing a correction (CC-e). CT-e It stands for Conhecimento de Transporte Eletronico (in Portuguese) or Electronic Bill of Lading (in English). It is similar to Nota Fiscal (e-invoice), but it is used for freight instead of goods or services. SPED It stands for Sistema Publico de Escrituracao Digital (in Portuguese) or Public System of Digital bookkeeping (in English). It is an e-Reporting to standardize and simplify the fiscal and accounting reports, with objective to replace paper-based reports. Suframa It stands for Superintendencia da Zona Franca de Manaus (in Portuguese) or Superintendence of the Manaus Free Trade Zone (in English). It ia an organization dependent on the Brazilian Ministry of Development, Industry and Foreign Trade with the purpose of developing the Manaus area (it is the largest city in the Amazon rainforest) and promote sustainable economy. Companies taking part in such program get a Suframa registration number. EFD Fiscal It stands for Escrituracao Fiscal Digital (in Portuguese) or Digital Fiscal Bookkeeping (in English). It is also known as SPED EFD Fiscal. It is a report under the SPED solution umbrella that the main purpose is send information about the ICMS (Goods and Services Tax) and IPI (Tax on Industrialized Products). EFD Contributions It stands for Escrituracao Fiscal Digital (in Portuguese) or Digital Fiscal Bookkeeping (in English). It is also known as SPED EFD Contributions. It is a report under the SPED solution umbrella that the main purpose is send information about the PIS (Social Integration Program) and COFINS (Contribution to Social Security Financing). IPTU IPVA G7 G20 DIRF ECD FCI PERDCOMP DCTF GIA IR ISS CIAP REINF IBGE BACEN PTAX EU Specific Terminology These are some EU specific terminologies and acronyms used in a Business context, related to taxation and legal requirements in the national territory. EMEA It stands for Europe, Middle East, and Africa. It is a geographical grouping and an acronym widely used by global corporations to define regional business activity. It is a shorthand method to refer to the three continents and their regional areas. EU It stands for European Union. It is a political and economic grouping of 27 countries committed to shared democratic values. The European Union was created to bind the nations of Europe closer together for the economic, social, and security welfare of all, into a single entity. EAA It stands for European Economic Area. The EEA aims to strengthen trade and economic relations between each of the EEA countries. The EEA includes EU countries and also Iceland, Liechtenstein and Norway. It allows them to be part of the EU’s single market. EFTA It stands for European Free Trade Association. It is a regional trade organisation and a free trade area between each of the Member States, which are Iceland, Liechtenstein, Norway and Switzerland. Schengen Area The Schengen Area was created following the Schengen Agreement, signed in 1985 in a village in Luxemburg. The Schengen Convention, which followed in 1990, set out more details on the operation of the borderless area. In the Schengen Area there are no passport or border controls at the borders within the area. The Schengen Area is made up of 23 of the 27 EU Member States plus the 4 countries that form the EFTA SEPA It stands for Single Euro Payments Area. It is a payment-integration initiative of the European Union for simplification of bank transfers in Euro. Eurozone It is the economic region formed by those member countries of the European Union that have adopted the euro. Euro The Euro is the official currency of the European Union, adopted by some, but not all member. It is the world's second most popular reserve currency after the U.S. dollar, and the second most traded. NATO / OTAN NATO stands for North Atlantic Treaty Organization (in English) or OTAN that stands for Organisation du Traité de l'Atlantique Nord (in French) or Organizacao do Tratado do Atlantico Norte (in Portuguese). It is a security alliance of 31 countries from North America and Europe to contribute to the security of the North Atlantic area. Ombudsman The European Ombudsman investigates complaints about mismanagement in the institutions and bodies of the European Union. The Ombudsman is completely independent and impartial. INTRASTAT It is the system, with harmonised rules, for collecting information and producing statistics on the trade in goods between countries of the European Union. EXTRASTAT It is the system, with harmonised rules, for collecting information and producing statistics on the trade in goods between the EU and non-EU countries. KOBRA Declaration A monthly declaration to the German authorities that records the export of sensitive goods (for example, weapons and goods that can be used to manufacture weapons). The declaration may contains information such, Legal Entity ID, Date, Goods Direction, Reference Number, KOBRA B Record, KOBRA C Record, INTRASTAT Receipt/Dispatch, SED / AERP Export, EXTRASTAT / VAR Export/ Import, and more. UK Specific Terminology These are some UK specific terminologies and acronyms used in a Business context, related to taxation and legal requirements in the national territory. HMRC It stands for His/Her Majesty's Revenue and Customs or simply HM Revenue and Customs. It is the UK's tax, payments and customs authority, and its purpose is to collect taxpayers' money to support UK’s public services. NIN It stands for National Insurance Number. Also referred as NINo. It is a number used in the UK to record the national insurance contributions and taxes on behalf of taxpayers. The number is unique to each person and used throughout life.It's made up of two letters, six numbers and a final letter. (e.g. XX 00 00 00 X) PAYE It stands for Pay As You Earn. It is the system used by the tax office (HMRC) to tax people who are employed. This is the system that your employer or pension provider uses to take Income Tax and National Insurance contributions before they pay your wages or pension. P45 It is the reference code of a tax form titled "Details of employee leaving work" that an employer gives to an employee upon termination of employment. In other words, you’ll get a P45 from your employer when you stop working for them. This form provides information about the amount of income and total taxes paid while the person was employed. The P45 in slang terms is equivalent to "pink slip" in the United States. P60 It is a form or certificate that shows how much you have earned, and the amount of tax you have paid in the last tax year. In other words, your P60 shows the tax you’ve paid on your salary in the tax year (6 April to 5 April). You get a separate P60 for each of your jobs every tax year. P11D It is a form used to report benefits provided and expense payments made to employees by employers, that are not put through the payroll (PAYE), about their ‘benefits in kind’ (for example company cars or interest-free loans). Personal Allowance A tax-free amount of income in each tax year. The amount is called the personal allowance. If income is below that level in the tax year, no tax is due. ILR It stands for Indefinite Leave to Remain. It is the UK permanent residency and also called ‘settlement’. It gives you the right to live, work and study in UK for as long as you like. It is the equivalent of the US Green Card. US Specific Terminology These are some US specific terminologies and acronyms used in a Business context, related to taxation and legal requirements in the national territory. NAFTA It stands for North American Free Trade Agreement. It was an agreement signed by Canada, United States and Mexico that created a trilateral trade bloc in North America. It is the one of the largest trade blocs in the world by gross domestic product and resulted in the elimination or reduction of barriers to trade and investment among members. SOX / Sarbo x Compliance It stands for the Sarbanes-Oxley Act. It is a 2002 law that congress passed to increase accountability in the financial sector. The law helps ensure public companies engage in non-deceptive business accounting practices. IRS It stands for Internal Revenue Service. It is a government agency that administers tax laws and collects federal taxes from U.S. individual and corporate taxpayers. SSN It stands for Social Security Number. It is a numerical identifier assigned to U.S. citizens and other residents to track income and determine benefits. All U.S. citizens, permanent residents, and temporary or working residents have a Social Security number, with very few exceptions. TIN It stands for Tax Identification Number. It is an unique set consisting of a nine-digit number used as a tracking number by the IRS to identifies individuals, corporations, and other entities. It is mandatory for anyone filing annual tax returns with the IRS. GC It stands for Green Card. It is also known as permanent resident card. It is an identity document which shows that a person has permanent residency in the United States. W2 / W-2 It is a US form, also known as the Wage and Tax Statement. It is the document an employer is required to send to each employee and the Internal Revenue Service (IRS) at the end of the year. A W-2 reports employees' annual wages and the amount of taxes withheld from their paychecks. A W-2 employee is someone whose employer deducts taxes from their paychecks and submits this information to the government. C2C It stands for Corporation-2-Corporation, or simply, Corp-2-Corp. It is a contract in which one corporation hires another corporation and pay the salaries for the work of another corporation. To work under C2C position employee must have a company settled up. 1099-Misc It is a IRS form, called 1099-MISC Miscellaneous Income or Miscellaneous Information. It is used to report certain types of miscellaneous compensation, such as rents, prizes, and awards, healthcare payments, and payments to an attorney. AERP It stands for Automated Export Reporting Program. A monthly declaration reporting exports from the US to the Bureau of the Census. SED It stands for Shipper's Export Declaration. It is a document to monitor shipments of controlled goods. HMF It stands for Harbor Maintenance Fee. It is a fee intended for who benefit from maintenance of US ports and harbors. Article written by Luiz C. Mariani Reference sources: SAP (www.sap.com ); Wikipedia (www.wikipedia.org ); Investopedia (www.investopedia.com ); Agile Alliance (www.agilealliance.org ); Brazilian Ministry of Finance ( www.gov.br ); HM Revenue & Customs ( www.gov.uk );IRS ( www.irs.gov ); Census Bureau ( www.census.gov );

Finance Currency Types Account Master Data Document Split Currency Types T-Code : SPRO Path : IMG -> Financial Accounting -> Financial Accounting Global Settings -> Ledgers -> Ledger -> Define Settings for Ledgers and Currency Types Section : Currency Types SAP Version : SAP S/4 HANA 2020 Currency Types List 00 = Document Currency 01 = Document Currency, Group Valuation 02 = Document Currency, Profit Center Valuation 10 = Company Code Currency 11 = Company Code Currency, Group Valuation 12 = Company Code Currency, Profit Center Valuation 20 = Controlling Area Currency 30 = Group Currency 31 = Group Currency, Group Valuation 32 = Group Currency, Profit Center Valuation 40 = Hard Currency 50 = Index-Based Currency 60 = Global Company Currency 70 = Controlling Object Currency Currency Type in the Controlling Area The controlling area currency type determines which currency is allowed as controlling area currency and whether the CO area currency can differ from the currency of the assined company codes. CO area currency is either set by the user or derived from other organizational units. The Assignment Control is a very important setting when the subject is controlling area currency type. There are 2 options: 1 = Controlling Area Same As Company Code 2 = Cross-Company-Code Cost Accounting 1 Controlling Area Same As Company Code Relationship (1:1): The financial accounting and cost accounting views of the organization are identical. Currency Type: The system will automatically assign currency type 10 (Company Code). 2 Cross-Company-Code Cost Accounting Relationship (1:n): Cost accounting is carried out in multiple company codes in the same controlling area. The Company Codes must use: The same number of posting periods (you can check it in the fiscal year variant) The same Chart of Account Hint : A 1:n relationship is appropriate, for example, if the organization has independent subsidiaries using a global cost accounting system, since it is possible to perform internal allocations between company codes. Account Master Data T-Code : FS00 | G/L Account Centrally Control Data | Account Control (Company Code) Balances in Local Currency Only Indicates that balances are updated only in local currency when users post items to this account. You set this if you do not want the system yp update transaction figures se parately by currency. Recommended for some Balance Sheet Accounts: Not managed as open items and not kept in foreign currencies. Managed as open items and and have the same types of items posted in different currencies, but always allow clearing to be made if the local currency amounts correspond. Example : You set up a clearing account for GR/IR and post these itema to it. Goods Receipt (Posted always in Local Currency) EUR 890 Invoice Receipt (Posted Invoice Currency) USD 1000 EUR 890 Both items can be cleared if the clearing account balances are recorded in Local Currency Only. Unless you set the indicator for this account, the system will translate the USD to EUR during the clearing procedure to determine the account in EUR required to clear 1000 USD. If the translation rate is 0.89, the system displays 900 EUR for the invoice receipt and 890 EUR for the goods receipt when the open items are processed. This means that to clear both od these items, you will also have to enter a difference posting for 10 EUR, and the system will automatically make an additional exchange rate difference posting for this amount. Posting without tax allowed Indicates that acoount can be posted without tax code. It is possible to post both taxable and non-taxable items to that account. But If you post with tax code the system checks the entry against the Tax Category. Tax Category You only use Tax Category if the account is tax-relevant, If not, leave the field in blank. Example of tax categories: "*" All Tax Types Permitted "+ " Only Output Tax Permitted "- " Only Input Tax Permitted "> " Output Tax Account "< " Input Tax Account Control Data | Account Management (Company Code) Open Item Management Indicator activated: The items posted are marked as open or cleared. Indicator Inactivated: The items posted has no offsetting option, with open and clared marks. Accounts managed as open items: Clearing accounts Blank Clearing Account Payroll Clearing Account Cash Discount Clearing Account GR/IR Clearing Account Accounts that are NOT managed as open items: Bank Accounts Tax Accounts Raw Material Accounts Reconciliation Accounts (There are managed implicitly using the subledger open item function) Profit and Loss Accounts Materials Management (MM) Accounts (Posted with a posting key that has account type 'M') Create/Bank/Interest | Control of Document Creation ( Company Code) Post Automatically Only Indicates that this account can only be posted to by the system using account determination tables. Docum ent Split Document Splitting is a function delivered initially within the New G/L, similar to FI-SL splitting available from release 4.7 onwards. It is an essential tool for drawing up complete financial statements for the selected dimensions (e.g. Segment, Profit Center, Business Area, Fund, Grant or Customer field) at any time. Document splitting splits up line items during the posting for selected dimensions such as receivable lines by "Profit Center". Also, to affect a zero balance setting in the document for selected dimensions such as "Segment", document splitting can be used. The zero balance setting may generate additional clearing lines in the general ledger view. Seq Transaction Name Module Reference SAP Path Comments 001 GSP_CD Maintain constans FI-GL 002 GSP_KD Maintain account determination FI-GL 003 GSP_KD1 Maintain acct deter: 0 balance FI-GL 004 GSP_KD2 Maintain acct deter: Additional rows FI-GL 005 GSP_LD Define item type FI-GL business transaction - do not change 006 GSP_LZ1 SAP internal item cat. Assigment FI-GL assignment do de cima 007 GSP_LZ2 Allocation: acct number - item type FI-GL Clsssify G/L Accounts for Document Splitting 008 GSP_MD Define Splitting Method FI-GL 009 GSP_PD Define business process FI-GL do not change 010 GSP_RD Define Split Rule FI-GL 011 GSP_VD Define business process variant FI-GL 012 GSP_VZ1 Transaction->process var. assignment FI-GL Assigment: Transaction Code - Accounting Transaction Variant 013 GSP_VZ2 MM movem. Type->process var. assgmt FI-GL Assigment: MM Movement Type - Accounting Transaction Variant 014 GSP_VZ3 FI doc type->process var. assignment FI-GL Classify FI Document Type for Document Splitting Views Entry View | Based on table BSEG as used in Classic G/L General Ledger View | Based on the New G/L tables for ECC (ACDOCA for S/4 HANA) You can choose between displaying the document either in its original form in the entry view or with the generated clearing lines from the perspective of a ledger in the general ledger view. Issues Balancing Field is not Filled |Error messages for example "the balancing field is not filled" may arise while you are working with relevant business processes. These issues are usually based on missing or incorrect document split customizing New G/L Migration | Subsequent activation of document split functionality within a productive environment (with existing transactional data) is critical. It has to be handled with a separate migration project Subsequent Changes | Processes in a customer system are dynamic and changes in document split customizing may arise. If subsequent changes are necessary, please refer to the long text of the warnings and also to OSS Note 891144 1. Document Split Functionality With the functionality 'document splitting' a complete financial statement for selected dimensions can be provided at any time. Document splitting splits up line items for selected dimensions such as "Segment", "Profit Center", etc. Document Splitting Method | A splitting method contains the splitting rules governing how the individual item categories are dealt with Splitting Rule | Depending on the business transactions the rule governs how the individual item categories will be processed by the system Business Transaction | SAP delivers 10 business transactions. A business transaction describes the structure of a business process for each document type. For each business transaction, you can determine which item categories (can) appear in the transaction. Business transactions are only used in document splitting Item category | The item category characterizes the items of an accounting document. You need to classify the individual document items so that the system knows how to handle them. Therefore, an item category has to be assigned to all G/L accounts (T-Code: GSP_LZ2) Processing category | The processing category controls how the amounts are split. 0 | Transfer a fixed value (No Splitting) 1 | Splitting by base item categories specified 2 | Splitting based on current account balance Warning When using document splitting SAP recommends to avoid posting mixed business processes A new document type for each business process needs to be defined in order to separate them. Generally it has to be ensured that each business process is posted with an appropriate document type (Example: Within SAP standard delivered customizing for business transaction "0300 Vendor Invoices" it is not possible to post customer or bank account lines) 2. New G/L Scenarios In order to define the relevant fields to be updated within open items and totals, scenarios have to be assigned to the ledgers used. SAP standard delivers 6 scenarios (Also custom fields can be assigned). To split the posted items of a particular ledger by the selected criteria (Segment, Profit Center, Custom Field [ZZxxx], etc.), the relevant New G/L scenario has to be assigned to the ledger. 2.1. Define Document Splitting Method The document splitting method contains the rules governing how the individual item categories are dealt with. In case changes need to be applied to standard customizing, SAP recommends copying the standard method 0000000012 and applying the changes. 2.1.1. Define Document Splitting Method T-Code | SM30 ( V_T8G01) Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions -> Document Splitting -> Extended Document Splitting -> Define Document Splitting Method Step 1 | Create an own defined method (e.g. Z000000012) Step 2 | Select all rules included in the standard method and copy it to the Z000000012 Step 3 | Apply the changes needed Step 4 | Activate the new to be used document splitting method 2.2. Activate Document Splitting T-Code | SM34 (VC_FAGL_SPLIT) Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions >- Document Splitting -> Activate Document Splitting Step 1 | Document Splitting Assignment - Document splitting method has to be assigned (e.g. Z000000012) Step 2 | Activating Inheritance of Account Assignments Inheritance of Account Assignments The indicator "Inheritance of Account Assignments" transfers the account assignments which are defined as split criteria. The values of the split criteria are always taken into consideration together as a combination of the account assignments. The field values are inherited only in case the account assignment combination is unique within the complete document. That means the account assignments are being inherited if the values of the split criteria in the complete document are the same. Please consider that only account assignments relevant for the balance sheet (G/L split criteria) are taken over since it is rather a fallback mechanism for the unassigned processes Hint: There is also a possibility to deactivate inheritance for some specific business transactions. Deactivating Inheritance of Account Assignments T-Code | GSP_RD Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions -> Document Splitting -> Extended Document Splitting -> Define Document Splitting Rules Step 1 | In the "Header Data", double click in the "Method + Business Transaction + Variant" desired Step 2 | Flag the indicator " No Inheritance of A/c Assignments" Hint: This indicator 'No Inheritance of A/c Assignments' can be set/removed in the definition of the business transaction (Only available in ERP2005) Activation Standard A/C Assignment on the Splitting Method Level The constant defines default account assignments for all line items for which it is not possible to derive any account assignments via the splitting rule or the inheritance. To activate this function select indicator "Standard A/C Assgnmt" and assign the constant. Constant Definition T-Code | SM34 (FAGL_CONSTANTS_GLOBAL) Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions >- Document Splitting -> Edit Constant for Nonassigne d Processes Step 1 | Create the Constant (eg. Zxxx) Step 2 | Assign Profit Center Deactivate Constant Default at Business Transaction Level T-Code | GSP_RD Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions -> Document Splitting -> Extended Document Splitting -> Define Document Splitting Rules Step 1 | In the "Header Data", double click in the "Method + Business Transaction + Variant" desired Step 2 | Flag the indicator " No Default of A/c Assignments" There is also a possibility to deactivate the default account assignment (constant) set on method level for some specific business transactions. Deactivate Document Splitting at Company Code Level Document split can be deactivated at company code level. In case one or more company codes in your system should not use document splitting functionality, then choose the "inactive" indicator at company code level. Define Document Splitting T-Code | SM34 (VC_FAGL_SPLIT) Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions >- Document Splitting -> Activate Document Splitting Step 1 | In the Dialog Structure, click in "Deactivation per Company Code" Step 2 | Flag the indicator "Inactive" in the desired Company Code Warning: If you perform any cross company code postings please make sure that all company codes involved use document splitting Hint: In addition the company codes which are used in cross company postings have to be assigned in Transaction "OBY6" to companies in a 1:1 relation 2.3. Document splitting characteristics Document splitting is a tool for drawing up complete financial statements for selected dimensions. Additional zero balance items are automatically created in case the balance of account assignment objects is not zero. Document splitting characteristics can be defined for General Ledger and additional characteristics for controlling and assets. Characteristics for General Ledger Accounting Characteristics for Controlling Characteristics for Cash Discounts Capitalized to Assets 2.3.1. Document splitting Characteristics for General Ledger In this IMG-step the account assignments taken into consideration in document splitting are defined. It can be defined if a zero balance setting for the characteristic and a partner field has to be used. If the zero balance flag has been activated, the system makes sure that the document balances to zero on account assignment level. The account assignment can also be defined as mandatory. The system accepts postings if the account assignment has been filled in the general ledger view. Either it can be filled in the entry view by entering it or it is derived from the document splitting rules. If a field is defined as a splitting characteristic, but the relevant scenario or custom field is not assigned to a ledger, then it will not be updated in certain new g/l tables. The account assignments specified have to be maintained at least in one of the ledgers. Otherwise the mandatory check is not processed. 2.3.2. Define Document Splitting Characteristics for Controlling Document splitting characteristics for controlling are being transferred only into relevant line items. The CO account assignments are just needed for the cost elements. Therefore the accounts of the corresponding line items need to be defined as a cost element. 2.3.3. Characteristics for Cash Discounts Capitalized to Assets (Post-Capitalization of Cash Discount to Assets) he activation of the "Post-Capitalization of Cash Discount to Assets" has the effect that the cash discount of an asset-relevant payment is not posted to the cash discount account, but directly to the asset. 2.3.4. Zero balance indicator and balance zero clearing account The zero balance indicator setting, ensures that the document is balanced according to document split characteristics for the selected dimensions such as "Segment". In case the balance of account assignment objects is not zero after document splitting the system generates additional clearing items. The triggered line items in the document are posted to the zero balance clearing account defined for each account key in customizing. Define Zero-Balance Clearing Account T-Code | GSP_KD1 Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions >- Document Splitting -> Define Zero-Balance Clearing Account Warning: Therefore, a clearing account has to be created for the additional clearing line items. 2.4. Account key assignment (define zero-balance clearing account) As explained above in some business processes additional clearing line items have to be created automatically so a full financial statement per splitting criteria is available. The automatic posting is made to a zero-balance clearing account defined in the account key. One or more zero-balance clearing accounts may be used. To post to different clearing accounts, each clearing account has to be assigned to a separate account key and each account key to the relevant business transaction variants. Define Zero-Balance Clearing Account T-Code | GSP_KD1 Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions >- Document Splitting -> Define Zero-Balance Clearing Account 2.5. Constant definition In order to set default account assignments within the document splitting, one or more constants can be defined. Edit Constants for Non-assigned Processes T-Code | GSP_CD Path | IMG -> Financial Accounting (New) -> General Ledger Accounting (New) -> Business Transactions >- Document Splitting -> Edit Constants for Non-assigned Processes For defining the constant only the defined split criteria can be chosen. A default value can either be assigned to all or just to several split criteria. The default values are always set as a combination, meaning all or nothing. Example: Split criteria A and B is set as default If fields A and B are both not filled during posting, the default values of the constant are set. If field A is set with the default value of the constant and B is not filled, the constant fills the value of field B. If field A is set but not with the default value of the constant, nothing is done by the constant. If any other split criteria is filled which is not defined within the constant, the constant fills fields A and B. If an assigned split criteria is set with default 'blank', the system considers 'blank' as a value. Two different ways of using a constant exist: General constant for all business processes Specific constant assigned to explicit item categories References: SAP (www.sap.com ); SAP Support (support.sap.com ); SAP Help (help.sap.com ); SAP Blog (blogs.sap.com )

Topics: SAP S/4 HANA Material Ledger Step by Step Customizing SAP Material Ledger SAP Actual Costing / Material Ledger Standard Price versus Moving Average Price Standard Price (S) | Advantages x Disadvantages Moving Average Price (V) | Advantages x Disadvantages SAP Actual Costing / Material Ledger Configuring SAP Material Ledger involves several steps to ensure accurate and detailed material valuation. Below is a step-by-step guide on how to configure SAP Material Ledger. Please note that the exact steps and transaction codes may vary depending on your SAP version and configuration. Always refer to the official SAP documentation for your specific SAP version. F ollowing the best practices implementation is always the best solution to leveraging the full capabilities of SAP Material Ledger. Seq Transaction Name Module Reference SAP Path 001 OX14 Valuation Level MM Define Valuation Level IMG -> Enterprise Structure -> Definition -> Logistics - General -> Define Valuation Level 002 OMX2 Assign Currency Types and Define Material Ledger Types PC-ML Assign Currency Types and Define Material Ledger Types IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Assign Currency Types and Define Material Ledger Types 003 OMX3 Assign Material Ledger Types to Valuation Area PC-ML Assign Material Ledger Types to Valuation Area IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Assign Material Ledger Types to Valuation Area 004 CKM9 Check Material Ledger Settings (Display of ML-Relevant Customizing Settings) PC-ML Activate Material Ledger for Valuation Area IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Activate Material Ledger for Valuation Areas 005 OMX1 Activation of Material Ledger PC-ML Activate Material Ledger for Valuation Area IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Activate Material Ledger for Valuation Areas 006 S_ALR_87008137 Maintain Number Ranges for Material Ledger Documents PC-ML Maintain Number Ranges for Material Ledger Documents IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Maintain Number Ranges for Material Ledger Documents 007 OMX4 Number range: Material ledger document PC-ML Maintain Number Ranges for Material Ledger Documents IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Maintain Number Ranges for Material Ledger Documents 008 OMX5 Configure Dynamic Price Changes PC-ML Configure Dynamic Price Changes IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Configure Dynamic Price Changes 009 V_CKMLKONT No text found for transaction (Assign Acc. Assignment Reason to Acct Modification Const) PC-ML Reasons for Price Changes IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Reasons for Price Changes 010 OMX_UMB_ACCOUNTS Display Accounts For Account Key UMB PC-ML Reasons for Price Changes IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Reasons for Price Changes 011 OPR4_ACT Define User-Defined Message Types PC-ML Define User-Defined Message Types IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Define User-Defined Message Types 012 SM30 (V_CKMLMV010_T) Define Movement Type Groups of Material Ledger PC-ML Define Movement Type Groups of Material Ledger IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Material Update -> Define Movement Type Groups of Material Ledger 013 SM30 (V_156Q_ML) Assign Movement Type Groups of Material Ledger PC-ML Assign Movement Type Groups of Material Ledger IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Material Update -> Assign Movement Type Groups of Material Ledger 014 OMX9 Define Material Update Structure PC-ML Define Material Update Structure IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Material Update -> Define Material Update Structure 015 OMX8 Assign Material Update Structure to a Valuation Area PC-ML Assign Material Update Structure to a Valuation Area IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Material Update -> Assign Material Update Structure to a Valuation Area 016 CKM9 Verify Settings for Actual Costing (Display of ML-Relevant Customizing Settings) PC-ML Activate Actual Costing IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Actual Costing -> Activate Actual Costing 017 SM30 (VV_T001W_MV_1) Activate actual costing PC-ML Activate Actual Costing IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Actual Costing -> Activate Actual Costing 018 OMXW Activate WIP at Actual Costs PC-ML Activate WIP at Actual Costs IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Actual Costing ->Activate WIP at Actual Costs 019 SM30 (V_T001K_CCS) Activate Actual Cost Component Split PC-ML Activate Actual Cost Component Split IMG -> Controlling -> Product Cost Controlling -> Actual Costing /Material Ledger -> Actual Costing -> Activate Actual Cost Component Split SPRO IMG Customizing Tree These are the basic customizing transaction used to setup Material Ledger: Assign Currency Types and Define Material Ledger Types Assign Material Ledger Types to Valuation Area Activate Material Ledger for Valuation Areas Maintain Number Ranges to Material Ledger Documents Configure Dynamic Price Changes Reasons for Price Changes Define User-Defined Massage Types Define Movement Types Groups of Material Ledger Assign Movement Types Groups of Material Ledger Activate Actual Costing Activate Actual Cost Component Split Activate WIP at Actual Costs 1. Assign Currency Types and Define Material Ledger Types Material Ledger Types Automatic getting CT from: Currency Type from FI Currency Type from CO You don't need to enter the currency type manually Manual: You need to enter the desired currency types manually 2. Assign Material Ledger Types to Valuation Area The Material Ledger Type that was created in the step above needs to be assigned Valuation Area. Valuation Area | Organizational level at which the material ledger is valuated. It can be one of the following: Plant All plants belonging to a company code, in which case the valuation area is the company code. 2.1. Valuation Level You define the valuation level by specifying the level at which material stocks are valuated. You can valuate material stocks at the following levels: Plant Level Valuation must be at this level in the following cases If you want to use the application component Production Planning (PP) or Costing If your system is a SAP Retail system Company Code Level Valuation level choice affects the following: Maintenance of material master records G/L accounts in which material stocks are managed G/L accounts to which transactions are posted in Materials Management Important: Once set, it is not possible to switch the valuation level from plant to company code, or vice versa. If absolutely necessary to subsequently change the valuation level, contact a SAP consultant because a data conversion is required. Standard Price versus Moving Average Price Material Valuation How materials are valuated in the SAP system essentially depends on the price control that was set for the material in the material master. You can choose between a valuation at the standard price (S price) or at the moving average price (V price). When using the Material Ledger, you have the possibility of combining the advantages of standard price control and moving average price control. With moving average price control, a new material price is calculated after every goods receipt, invoice receipt, and/or order settlement. This material price is an average value calculated from the total inventory value and the total quantity of the material in stock. With standard price control, goods movements are valuated with a price that remains constant for at least one period. The standard price that is assigned to a material is usually the result of a standard cost estimate. The main difference between the two valuation procedures is that the moving average price represents a current delivered price while the standard price is based on planned values and not actual values. Differences between the planned price and the actual prices are not assigned to the material stock in Financial Accounting, but rather are assigned to a price difference account. When using the moving average price, however, the material stock value in Financial Accounting can reflect the prices actually incurred. However, the moving average price has its disadvantages too. Actual Costing Use the component Actual Costing/Material Ledger to ensure a method of cost management that uses the most current data to calculate your actual material costs. You can use this component to calculate an average price at the end of the period using the actual costs incurred in that period. You can then use this average price to valuate the material stock in the period in question. The standard price is used for preliminary material valuation in the Actual Costing/Material Ledger component. In the following text, problems that could result from valuating materials with the moving average price are illustrated in conjunction with a comparison of advantages and disadvantages of both methods of price control. You can avoid the problems that arise when using the standard price for material valuation by using the component Actual Costing/Material Ledger . In addition, there will be some recommendations from SAP as to which price control to use. Standard Price (S) Advantages When using the standard price, all goods movements of a material are valuated with the same price over at least one period. Therefore, the standard price ensures consistent cost management of the production process and makes variances within production transparent. A periodic price (standard price) is especially useful when working with cost management by period. The standard price can also be used as a benchmark by which you can measure different methods of production, or compare the contribution margins of a material in different market segments in Profitability Analysis. Disadvantages Because the standard price is held constant for an entire period, it does not reflect the actual costs incurred during the period. This can lead to inexact valuation prices for materials whose procurement prices change a great deal over a period, or whose method of production changes within a period. This problem increases in multilevel production with each new production step. This means that the costs for the finished product may not reflect the most recent data. The material stock value does not reflect the current procurement costs, as variances from the standard price are collected in a price difference account in Financial Accounting and do not lead to a correction of the material stock account. The variances collected in the price difference account can no longer be assigned to the individual material. If you use split valuation for materials, please note that you can only release the material price at the header level of a material (not at the level of the valuation type) when calculating a material price in Product Cost Planning. Moving Average Price (V) Advantages The advantage of using the moving average price is that variances are updated in the material price and the material stock value. Because the material price reflects the average procurement cost of a material, material issues could, in principle, be valuated with the current price. Only in special cases are variances allocated to a price difference account in Financial Accounting rather than to the material stock. The advantages of the moving average price are seen only if: you are looking at the material valuation data at the lowest production level; all variances occur immediately; the material price is not distorted by the sequence of postings by the system. Disadvantages The main disadvantage of using the moving average price is that the price used to valuate a material consumption is almost completely dependent on the time at which the goods issue is posted in the system. If, for example, an invoice receipt is posted in the system after a goods issue was entered, that invoice value is not reflected in the value of the material issued. The material is therefore not valuated with its actual procurement cost. The moving average price also does little to guarantee consistent cost management of your production process. The effect of changes in the production process, for example, are not recognizable in the finished product, and comparing results from different areas in Profitability Analysis is not really meaningful due to lack of a benchmark. The fact that the moving average price is not dependent on the period can also lead to incorrect material valuation, as goods movements that are posted to a previous period are not valuated with the price from that period, but rather with the current moving average price. Another problem with the moving average price is that any mistake entering data can cause immediate and unwanted changes in the material price. Any goods issues posted following this error will be valuated immediately with this incorrect material price. In particular, the moving average price can lead to unrealistic material prices in cases of multi-level production or when there are variances that do not appear immediately. Such unrealistic prices occur, for example, when, in the context of stock coverage, a subsequent adjustment to the material stock occurs using an incorrect base quantity. Material Ledger When using the application component Material Ledger, you only use the standard price as a preliminary valuation price in the current period. At the end of the period, you can use this component to calculate an average price for the material using the actual costs incurred in that period. You can then use this average price to valuate the material stock in the period in question. Hint : If you use Material Ledger, you should also use standard price control of raw materials and trading goods to ensure consistent cost management of your production process. Only in this way are variances completely transparent within production. In Summary The problems described above show that the moving average price, despite its advantages can lead to problems. In particular, the moving average price can cause unrealistic valuations of material inventory when materials are produced in-house or when variances do not appear immediately. On the other hand, the standard price does not take any actual procurement costs into account, which can be a problem, for example, with externally procured materials with highly variable prices. Recommendation Moving Average Price: It should be used only in Trading Goods, but not in Raw Materials. Standard Price: It must be used for Semi-Finished, Finished Goods and Raw Materials. Price S Price V References: SAP (www.sap.com ); SAP Support (support.sap.com ); SAP Help (help.sap.com ); SAP Blog (blogs.sap.com )

A method is a structured procedure for bringing about a certain goal, like acquiring knowledge or verifying knowledge claims. This normally involves various steps, like choosing a sample, collecting data from this sample, and interpreting the data. Methodologies In its most common sense, methodology is the study of research methods. However, the term can also refer to the methods themselves or to the philosophical discussion of associated background assumptions. A method is a structured procedure for bringing about a certain goal, like acquiring knowledge or verifying knowledge claims. This normally involves various steps, like choosing a sample, collecting data from this sample, and interpreting the data. The study of methods concerns a detailed description and analysis of these processes. It includes evaluative aspects by comparing different methods. This way, it is assessed what advantages and disadvantages they have and for what research goals they may be used. These descriptions and evaluations depend on philosophical background assumptions. Examples are how to conceptualize the studied phenomena and what constitutes evidence for or against them. When understood in the widest sense, methodology also includes the discussion of these more abstract issues. Methodologies to Save Time Eat The Frog The idea is that you identify one challenging task (the frog) and complete the task first thing in the morning (eating it). To put it simply, eating the frog is the process of identifying your most difficult task of the day and completing it before you do any other work. 3-3-3 Method 3 Hours Deep Work: Most critical and important things 3 Hours Shorter Tasks: Urgent tasks that you've been avoiding but need to be completed 3 Hours Maintenance Tasks: Activities to keep life in order Warren Buffett's 5/25 Rule Identify the top 25 important tasks Prioritize them by importance Only focus on the top 5 tasks Ignore the remaining 20 tasks 80/20 Rule (Pareto Principle) The 80/20 rule maintains that 80% of outcomes comes from 20% of causes. The 80/20 rule prioritizes the 20% of factors that will produce the best results. A principle of the 80/20 rule is to identify an entity's best assets and use them efficiently to create maximum value. Identify the vital 20% that will produce the best results That 20% will eliminate or reduce the trivial 80% Pomodoro Technique Decide Task Set timer 25 minutes Stop when timer goes off Take 5 minutes break After 4 cycles take 15-30 minutes break ABCDE Method Categorize tasks and execute by importance A - Most Important B - Important C - Nice To Do D - Delegate E - Eliminate MSCW Method Must-Have: Critical for project success Should-Have: Important but not critical Could-Have: Desirable, if time and resource Won't-Have: Deferred for future phases Pickle Jar Method (Glass Jar) The idea is that you should always start with your rocks (high-priority tasks), followed by your pebbles (medium-priority tasks), and then your sand (low-priority tasks). Finish off by filling the jar with water (“off” time). Do major tasks first Slot in minor tasks around the major ones Continuously assess and reprioritized tasks 1-3-5 Method The 1-3-5 Rule is a structured technique by which you can categorize your tasks into a to-do list that is proven to increase productivity. This rule asks you to accomplish 1 big mission, 3 medium tasks, and 5 small things. 1 Major Task 3 Medium Tasks 5 Small Tasks Eisenhower Matrix The Eisenhower Matrix is also known as the time management matrix, the Eisenhower Box, and the urgent-important matrix. This tool helps you divide your tasks into four categories: the tasks you'll do first, the tasks you'll schedule for later, the tasks you'll delegate, and the tasks you'll delete. Important /Urgent: Do - Tasks with clear deadlines and significance consequences if not completed in a timely fashion Important /Not Urgent: Schedule - Tasks with no set deadline but that bring you closer to your long-term goals Not Important / Urgent: Delegate - Tasks that need to get done, but don't need your expertise in order to be completed Not Important / Not Urgent: Delete - Tasks that distract you from your preferred course, and don't add any measurable value Getting Things Done Method (GTD) GTD method operates with the belief that the more information you're mentally keeping track of, the less productive and focused you are. Instead of relying on your brain, the GTD methodology encourages you to store all of your work information in an external, organized source of truth. Capture Tasks Clarify Their Meaning Organize Them Into Lists Reflect On Progress Engage With Action 2-Minute Rule The 2-Minute Rule was created to help reducing procrastination by enabling you to tackle small tasks that often get overlooked. If task is less than 2 minutes do it now If task is greater than 2 minutes delegate or defer Task Batching Technique Task batching is a productivity strategy that involves grouping similar tasks together to complete all at once. This technique can help you avoid multitasking and increase the amount of time you have to focus on tasks. Sort Similar Tasks Block Deliciated Time Do Tasks In Batches Time Batching Technique Time blocking is a time management technique where you schedule how you'll spend each day, one block at a time. For every task you need to complete, decide how much time (roughly) it'll take, and add that amount of time to your calendar. 08:00am - 11:00am: Deep Work (Your most important tasks) 11:00am - 11:30am: Quick Tasks (Emails, phone calls, etc) 11:30am - 12:30pm: Break (eat, exercise, relax) 12:30pm - 02:00pm: Important Tasks (Projects, planning, etc) 02:00pm - 04:00pm: Meetings (one-on-ones, follow ups) Agile Methodology The Agile methodology is a project management approach that involves breaking the project into phases and emphasizes continuous collaboration and improvement. Teams follow a cycle of planning, executing, and evaluating. Kanban

Topics: USGAAP, Financial Accounting, US Treasure, Bank Communication, US Taxation US Localization Overview The complexity of US localization is medium and supported by SAP. General Information ISO Codes: US / USA Country Codes: +1 Capital: Washington, D.C. Official Language(s): English Currency: USD (United States Dollar) Complexity Information Complexity Ranking: Medium Frequency of Legal Changes: Dynamic Interpretation of Law Text: Difficult Main SAP localization points Financial Accounting Treasure Taxation References: SAP (www.sap.com )

The market for Data Brokers dealing personal data has a prominent role in the global economy. The increasing volume of personal data collection can build strong and accurate population profiles.You probably know some of the main Data Brokers: Experian, TransUnion, Equifax, CoreLogic, Epsilon, Acxiom​. Global Market Data Broker Experian | UK Credit Score Segmentation True Size of Countries Geographic Information Data Brokers The market for Data Brokers dealing personal data has a prominent role in the global economy. The increasing volume of personal data collection can build strong and accurate population profiles. The analysis of consumer groups and segments helps organizations to: Targeted offers Prospection Monetization of the customer portfolio Targeted communication Statistical modeling Market study (such as profile and consumption analysis) Geomarketing You probably know some of the main Data Brokers : Experian TransUnion Equifax CoreLogic Epsilon Acxiom Experian | UK Credit Score Segmentation Experian has a services called Mosaic. Mosaic is a comprehensive cross-channel consumer classification that groups together individuals likely to share similar demographics, lifestyles and behaviours into 15 summary groups and 66 detailed types by codes and names. Group Codes Groups Segment Codes Segments A City Prosperity A01 World-Class Wealth A02 Uptown Elite A03 Penthouse Chic A04 Metro High-Flyers B Prestige Positions B05 Premium Fortunes B06 Diamond Days B07 Alpha Families B08 Bank of Mum and Dad B09 Empty-Nest Adventure C Country Living C10 Wealthy Landowners C11 Rural Vogue C12 Scattered Homesteads C23 Village Retirement D Rural Reality D14 Satellite Settlers D15 Local Focus D16 Outlying Seniors C17 Far-Flung Outposts E Senior Security E18 Legacy Elders E19 Bungalow Haven E20 Classic Grandparents E21 Solo Retirees F Suburban Stability F22 Boomerang Boarders F23 Family Ties F24 Fledgling Free F25 Dependable Me G Domestic Success G26 Cafes and Catchments G27 Thriving Independence G28 Penthouse Chic G29 Mid-Career Convention H Aspiring Homemakers H30 Primary Ambitions H31 Affordable Fringe H32 First-Rung Futures H33 Contemporary Starts H34 New Foundations H35 Flying Solo I Family Basics I36 Solid Economy I37 Budget Generations I38 Economical Families I39 Families on a Budget J Transient Renters J40 Value Rentals J41 Youthful Endeavours J42 Midlife Renters J43 Renting Rooms K Municipal Tenants K44 Inner City Stalwarts K45 City Diversity K46 High Rise Residents K47 Single Essentials K48 Mature Workers L Vintage Value L49 Flatlet Seniors L50 Pocket Pensions L51 Retirement Communities L52 Estate Veterans L53 Seasoned Survivors M Modest Traditions M54 Down-to-Earth Owners M55 Back with the Folks M56 Self Supporters N Urban Cohesion N57 Community Elders N58 Culture & Comfort N59 Large Family Living N60 Ageing Access O Rental Hubs O61 Career Builders O62 Central Pulse O63 Flexible Workforce O64 Bus-Route Renters O65 Learners & Earners O66 Student Scene True Size of Countries The Mercator projection is a cylindrical map projection and it became the standard map projection for navigation because it is unique in representing north as up and south as down everywhere while preserving local directions and shapes. As a side effect, the Mercator projection inflates the size of objects away from the equator. In the transformation of a curved structure to the plane, a kind of deformation occurs so that there are the necessary adjustments to fit the object of study in that proposed form. Geographi c Information Check all the information in the table below. Country Land Area (Km²) Population Density (P/Km²) Afghanistan 652.860 42.239.854 65 Albania 27.400 2.832.439 103 Algeria 2.381.740 45.606.480 19 Andorra 470 80.088 170 Angola 1.246.700 36.684.202 29 Antigua and Barbuda 440 94.298 214 Argentina 2.736.690 45.773.884 17 Armenia 28.470 2.777.970 98 Australia 7.682.300 26.439.111 3 Austria 82.409 8.958.960 109 Azerbaijan 82.658 10.412.651 126 Bahamas 10.010 412.623 41 Bahrain 760 1.485.509 1.955 Bangladesh 130.170 172.954.319 1.329 Barbados 430 281.995 656 Belarus 202.910 9.498.238 47 Belgium 30.280 11.686.140 386 Belize 22.810 410.825 18 Benin 112.760 13.712.828 122 Bhutan 38.117 787.424 21 Bolivia 1.083.300 12.388.571 11 Bosnia and Herzegovina 51 3.210.847 63 Botswana 566.730 2.675.352 5 Brazil 8.358.140 216.422.446 26 Brunei 5.270 452.524 86 Bulgaria 108.560 6.687.717 62 Burkina Faso 273.600 23.251.485 85 Burundi 25.680 13.238.559 516 Côte d'Ivoire 318 28.873.034 91 Cabo Verde 4.030 598.682 149 Cambodia 176.520 16.944.826 96 Cameroon 472.710 28.647.293 61 Canada 9.093.510 38.781.291 4 Central African Republic 622.980 5.742.315 9 Chad 1.259.200 18.278.568 15 Chile 743.532 19.629.590 26 China 9.388.211 1.425.671.352 152 Colombia 1.109.500 52.085.168 47 Comoros 1.861 852.075 458 Congo (Congo-Brazzaville) 341.500 6.106.869 18 Costa Rica 51.060 5.212.173 102 Croatia 55.960 4.008.617 72 Cuba 106.440 11.194.449 105 Cyprus 9.240 1.260.138 136 Czechia (Czech Republic) 77.240 10.495.295 136 Democratic Republic of the Congo 2.267.050 102.262.808 45 Denmark 42.430 5.910.913 139 Djibouti 23.180 1.136.455 49 Dominica 750 73.040 97 Dominican Republic 48.320 11.332.972 235 Ecuador 248.360 18.190.484 73 Egypt 995.450 112.716.598 113 El Salvador 20.720 6.364.943 307 Equatorial Guinea 28.050 1.714.671 61 Eritrea 101 3.748.901 37 Estonia 42.390 1.322.765 31 Eswatini (fmr. "Swaziland") 17.200 1.210.822 70 Ethiopia 1.000.000 126.527.060 127 Fiji 18.270 936.375 51 Finland 303.890 5.545.475 18 France 547.557 64.756.584 118 Gabon 257.670 2.436.566 9 Gambia 10.120 2.773.168 274 Georgia 69.490 3.728.282 54 Germany 348.560 83.294.633 239 Ghana 227.540 34.121.985 150 Greece 128.900 10.341.277 80 Grenada 340 126.183 371 Guatemala 107.160 18.092.026 169 Guinea 245.720 14.190.612 58 Guinea-Bissau 28.120 2.150.842 76 Guyana 196.850 813.834 4 Haiti 27.560 11.724.763 425 Holy See - 518 1.295 Honduras 111.890 10.593.798 95 Hungary 90.530 10.156.239 112 Iceland 100.250 375.318 4 India 2.973.190 1.428.627.663 481 Indonesia 1.811.570 277.534.122 153 Iran 1.628.550 89.172.767 55 Iraq 434.320 45.504.560 105 Ireland 68.890 5.056.935 73 Israel 21.640 9.174.520 424 Italy 294.140 58.870.762 200 Jamaica 10.830 2.825.544 261 Japan 364.555 123.294.513 338 Jordan 88.780 11.337.052 128 Kazakhstan 2.699.700 19.606.633 7 Kenya 569.140 55.100.586 97 Kiribati 810 133.515 165 Kuwait 17.820 4.310.108 242 Kyrgyzstan 191.800 6.735.347 35 Laos 230.800 7.633.779 33 Latvia 62.200 1.830.211 29 Lebanon 10.230 5.353.930 523 Lesotho 30.360 2.330.318 77 Liberia 96.320 5.418.377 56 Libya 1.759.540 6.888.388 4 Liechtenstein 160 39.584 247 Lithuania 62.674 2.718.352 43 Luxembourg 2.590 654.768 253 Madagascar 581.795 30.325.732 52 Malawi 94.280 20.931.751 222 Malaysia 328.550 34.308.525 104 Maldives 300 521.021 1.737 Mali 1.220.190 23.293.698 19 Malta 320 535.064 1.672 Marshall Islands 180 41.996 233 Mauritania 1.030.700 4.862.989 5 Mauritius 2.030 1.300.557 641 Mexico 1.943.950 128.455.567 66 Micronesia 700 544.321 778 Moldova 32.850 3.435.931 105 Monaco 1 36.297 24.360 Mongolia 1.553.560 3.447.157 2 Montenegro 13.450 626.485 47 Morocco 446.300 37.840.044 85 Mozambique 786.380 33.897.354 43 Myanmar (formerly Burma) 653.290 54.577.997 84 Namibia 823.290 2.604.172 3 Nauru 20 12.780 639 Nepal 143.350 30.896.590 216 Netherlands 33.720 17.618.299 522 New Zealand 263.310 5.228.100 20 Nicaragua 120.340 7.046.310 59 Niger 1.266.700 27.202.843 21 Nigeria 910.770 223.804.632 246 North Korea 120.410 26.160.821 217 North Macedonia 25.220 2.085.679 83 Norway 365.268 5.474.360 15 Oman 309.500 4.644.384 15 Pakistan 770.880 240.485.658 312 Palau 460 18.058 39 Palestine State 6.020 5.371.230 892 Panama 74.340 4.468.087 60 Papua New Guinea 452.860 10.329.931 23 Paraguay 397.300 6.861.524 17 Peru 1.280.000 34.352.719 27 Philippines 298.170 117.337.368 394 Poland 306.230 41.026.067 134 Portugal 91.590 10.247.605 112 Qatar 11.610 2.716.391 234 Romania 230.170 19.892.812 86 Russia 16.376.870 144.444.359 9 Rwanda 24.670 14.094.683 571 Saint Kitts and Nevis 260 47.755 184 Saint Lucia 610 180.251 295 Saint Vincent and the Grenadines 390 103.698 266 Samoa 2.830 225.681 80 San Marino 60 33.642 561 Sao Tome and Principe 960 231.856 242 Saudi Arabia 2.149.690 36.947.025 17 Senegal 192.530 17.763.163 92 Serbia 87.460 7.149.077 82 Seychelles 460 107.66 234 Sierra Leone 72.180 8.791.092 122 Singapore 700 6.014.723 8.592 Slovakia 48.088 5.795.199 121 Slovenia 20.140 2.119.675 105 Solomon Islands 27.990 740.424 26 Somalia 627.340 18.143.378 29 South Africa 1.213.090 60.414.495 50 South Korea 97.230 51.784.059 533 South Sudan 610.952 11.088.796 18 Spain 498.800 47.519.628 95 Sri Lanka 62.710 21.893.579 349 Sudan 1.765.048 48.109.006 27 Suriname 156 623.236 4 Sweden 410.340 10.612.086 26 Switzerland 39.516 8.796.669 223 Syria 183.630 23.227.014 126 Tajikistan 139.960 10.143.543 72 Tanzania 885.800 67.438.106 76 Thailand 510.890 71.801.279 141 Timor-Leste 14.870 1.360.596 91 Togo 54.390 9.053.799 166 Tonga 720 107.773 150 Trinidad and Tobago 5.130 1.534.937 299 Tunisia 155.360 12.458.223 80 Turkey 769.630 85.816.199 112 Turkmenistan 469.930 6.516.100 14 Tuvalu 30 11.396 380 Uganda 199.810 48.582.334 243 Ukraine 579.320 36.744.634 63 United Arab Emirates 83.600 9.516.871 114 United Kingdom 241.930 67.736.802 280 United States of America 9.147.420 339.996.563 37 Uruguay 175.020 3.423.108 20 Uzbekistan 425.400 35.163.944 83 Vanuatu 12.190 334.506 27 Venezuela 882.050 28.838.499 33 Vietnam 310.070 98.858.950 319 Yemen 527.970 34.449.825 65 Zambia 743.390 20.569.737 28 Zimbabwe 386.850 16.665.409 43 References: Wikipedia (www.wikipedia.org ); World O Meters (www.worldometers.info ); Experian (www.experian.co.uk )

Topics: SAP Tables | Relationships | Key Fields | S/4 HANA ACDOCA and Elements | Table Joins SAP S/4 HANA Tables SAP Tables SAP S/4 HANA ACDOCA and Elements SAP Tables Relationship | Material Master Record Table Category Internal Table SAP Tables Environment | Structural | Organizational Table Description Type Area T-Code Key Field1 Key Field 2 Key Field 3 Key Field 4 Add Field Explanation SKA1 G/L Account Master (Chart of Accounts) Master Data Accounting FS00 SAKNR KTOPL SKAT G/L Account Master Record (Chart of Accounts: Description) Master Data Accounting FS00 SAKNR KTOPL SPRAS SKB1 G/L account master (company code) Master Data Accounting FS00 SAKNR BUKRS ACDOCA Universal Journal Entry Line Items Transactional Accounting FB01 BELNR RBUKRS GJAHR RLDNR S/4 HANA Universal Journal (Single Source of Truth). All Financial and Management Accounting Postings ACDOCP Plan Data Line Items Transactional Accounting REQTSN DATAPAKID RECORD RACCT S/4 HANA Universal Journal for Plan Data Line Items BKPF Accounting Document Header Transactional Accounting FB01 BELNR BUKRS GJAHR BSEG Accounting Document Segment Transactional Accounting FB01 BELNR BUKRS GJAHR REGUS Accounts blocked by Payment proposal Transactional Accounts Payable F110 BUKRS KOART LAUFI LAUFD Find payment proposals that are blocking payment runs CSKS Cost Center Master Record Master Data Cost Center KS01 KOSTL KOKRS DATBI CSKT Cost Center Texts Master Data Cost Center KS01 KOSTL KOKRS DATBI SPRAS COBK CO Object: Document Header Transactional Cost Center COEP CO Object: Line Items (by Period) Transactional Cost Center COSP CO Object: Cost Totals for External Postings ("COSP") Transactional Cost Center CSKA Cost Elements (Data Dependent on Chart of Accounts) Master Data Cost Element FS00 / KA01 KSTAR KTOPL CSKB Cost Elements (Data Dependent on Controlling Area) Master Data Cost Element FS00 / KA01 KSTAR KOKRS DATBI CSKU Cost Element Texts Master Data Cost Element FS00 / KA01 KSTAR KTOPL SPRAS KNA1 General Data in Customer Master Master Data Customer BP / XD01 KUNNR KNB1 Customer Master (Company Code) Master Data Customer BP / XD01 KUNNR BUKRS KNB4 Customer Payment History Master Data Customer BP / XD01 KUNNR BUKRS KNB5 Customer master (dunning data) Master Data Customer BP / XD01 KUNNR BUKRS MABER KNBW Customer master record (withholding tax types) X Master Data Customer BP / XD01 KUNNR BUKRS WITHT KNVD Customer master record sales request form Master Data Customer KUNNR VKORG VTWEG SPART KNVP Customer Master Partner Functions Master Data Customer KUNNR VKORG VTWEG SPART KNVV Customer Master Sales Data Master Data Customer KUNNR VKORG VTWEG SPART MAKT Material Descriptions Master Data Material MM01 MATNR SPRAS MARA General Material Data Master Data Material MM01 MATNR MARC Plant Data for Material Master Data Material MATNR WERKS MARM Units of Measure for Material Master Data Material MATNR MEINH MBEW Material Valuation Master Data Material MATNR BWKEY BWTAR MLAN Tax Classification for Material Master Data Material MATNR ALAND MVKE Sales Data for Material Master Data Material MATNR VKORG VTWEG PRODH T179 Materials: Product Hierarchies Master Data Material PRODH T001 Company Codes Customizing Organizational OBY6 BUKRS T001W Plants/Branches Customizing Organizational WERKS T002 Language Keys Customizing Organizational SPRAS T003 Document Types Customizing Organizational BLART T004 Directory of Charts of Accounts Customizing Organizational KTOPL T005 Countries Customizing Organizational LAND1 T006 Units of Measurement Customizing Organizational MSEHI T008 Blocking Reasons for Automatic Payment Transcations Customizing Organizational ZAHLS T009 Fiscal Year Variants Customizing Organizational PERIV T011 Financial Statement Versions Customizing Organizational VERSN T012 House Banks Customizing Organizational HBKID BUKRS T014 Credit control areas Customizing Organizational KKBER T016 Industries (Branch) Customizing Organizational BRSCH T030 Standard Accounts Table Customizing Organizational OBYC KTOPL KTOSL BKLAS KOMOK KONTS Check the transaction OBYC (Automatic Accounting Posts - Procedures | Account Determination) T030H Acct Determ.for Open Item Exch.Rate Differences Customizing Organizational OBA1 HKONT KTOPL WAERS CURTP Use to check the Account Determination for Open Item Exchange Rate Differences Account | This is used in FAGL_FCV (Foreign Currency Valuation) PROJ Project definition Master Data PS PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data Master Data PS PSPNR CEPC Profit Center Master Data Table Master Data Profit Center KE51 PRCTR KOKRS DATBI CEPCT Texts for Profit Center Master Data Master Data Profit Center KE51 PRCTR KOKRS DATBI SPRAS T000 Clients Customizing System SCC1 MANDT DD03L Table Fields System System SE16H FIELDNAME You can check which tables a specific field is in PRGN_CORR2 Correction Table for Modif. Transaction Codes in Area Menu System System T_TCODE S_TCODE REL_NAME You can check the old transaction that was replaced by new ones TSTC SAP Transactional Codes System System SE93 TCODE LFA1 Supplier Master (General Section) Master Data Vendor BP / XK01 LIFNR LFB1 Vendor Master (Company Code) Master Data Vendor BP / XK01 LIFNR BUKRS LFB5 Vendor master (dunning data) Master Data Vendor BP / XK01 LIFNR BUKRS MABER LFBK Vendor Master (Bank Details) Master Data Vendor BP / XK01 LIFNR BANKS BANKL BANKN LFBW Vendor master record (withholding tax types) X Master Data Vendor BP / XK01 LIFNR BUKRS WITHT LFM1 Vendor master record purchasing organization data Master Data Vendor BP / XK01 LIFNR EKORG LFM2 Vendor Master Record: Purchasing Data Master Data Vendor BP / XK01 LIFNR EKORG LTSNR WERKS SAP S/4 HANA ACDOCA and Elements Field Data Element Short Description Check Table Domain Data Type Length Decimal Places Search Help Origin of Input Help RCLNT MANDT Client T000 MANDT CLNT 3 0 H_T000 Input help implemented with check table RLDNR FINS_LEDGER Ledger in General Ledger Accounting FINSC_LEDGER FINS_LEDGER CHAR 2 0 Input help implemented with check table RBUKRS BUKRS Company Code T001 BUKRS CHAR 4 0 C_T001 Input help implemented with check table GJAHR GJAHR Fiscal Year GJAHR NUMC 4 0 BELNR BELNR_D Accounting Document Number BELNR CHAR 10 0 DOCLN DOCLN6 Six-Character Posting Item for Ledger DOCLN6 CHAR 6 0 RYEAR GJAHR_POS General Ledger Fiscal Year GJAHR NUMC 4 0 DOCNR_LD FINS_DOCNR_LD Ledger specific Accounting Document Number BELNR CHAR 10 0 RRCTY RRCTY Record Type RRCTY CHAR 1 0 Input help with fixed values .INCLUDE ACDOC_SI_00 Universal Journal Entry: Transaction, Currencies, Units STRU 0 0 RMVCT RMVCT Transaction type T856 RMVCT CHAR 3 0 H_T856 Input help implemented with check table VORGN VORGN Transaction Type for General Ledger VORGN CHAR 4 0 VRGNG CO_VORGANG CO Business Transaction TJ01 J_VORGANG CHAR 4 0 H_TJ01 Input help implemented with check table BTTYPE FINS_BTTYPE Business Transaction Type FINSC_BTTYPE FINS_BTTYPE CHAR 4 0 Input help implemented with check table AWTYP AWTYP Reference procedure TTYP AWTYP CHAR 5 0 Input help implemented with check table AWSYS AWSYS Logical system of source document TBDLS LOGSYS CHAR 10 0 Input help implemented with check table AWORG AWORG Reference Organizational Units AWORG CHAR 10 0 AWREF AWREF Reference document number AWREF CHAR 10 0 AWITEM FINS_AWITEM Reference Document Line Item NUMC6 NUMC 6 0 AWITGRP FINS_AWITGRP Group of Reference Document Line Items NUMC6 NUMC 6 0 SUBTA FINS_SUBTA Partial Document to be balanced to zero NUMC6 NUMC 6 0 XREVERSING FINS_XREVERSING Indicator: Item is reversing another item XFELD CHAR 1 0 Input help with fixed values XREVERSED FINS_XREVERSED Indicator: Item is reversed XFELD CHAR 1 0 Input help with fixed values XTRUEREV FINS_XTRUEREV Indicator: True reversal (i.e. cancellation) XFELD CHAR 1 0 Input help with fixed values AWTYP_REV AWTYP_REV Reversal: Reference Transaction of Document to Be Reversed TTYP AWTYP CHAR 5 0 Input help implemented with check table AWORG_REV AWORG_REV Reversal: Reference Organizations of Document to Be Reversed AWORG CHAR 10 0 AWREF_REV AWREF_REV Reversal: Reference Document No. of Document to Be Reversed AWREF CHAR 10 0 SUBTA_REV FINS_SUBTA_REV Reversal: Partial Document to be balanced to zero NUMC6 NUMC 6 0 XSETTLING FINS_XSETTLING Indicator: Item is settling or transferring another item XFELD CHAR 1 0 Input help with fixed values XSETTLED FINS_XSETTLED Indicator: Line item is settled or transferred XFELD CHAR 1 0 Input help with fixed values PREC_AWTYP FINS_PREC_AWTYP Preceding Document Reference Transaction TTYP AWTYP CHAR 5 0 Input help implemented with check table PREC_AWSYS FINS_PREC_AWSYS Logical System of Preceding Reference Document TBDLS LOGSYS CHAR 10 0 Input help implemented with check table PREC_AWORG FINS_PREC_AWORG Preceding Document Reference Organizational Units AWORG CHAR 10 0 PREC_AWREF FINS_PREC_AWREF Preceding Document Reference Document Number AWREF CHAR 10 0 PREC_AWITEM FINS_PREC_AWITEM Preceding Reference Document Line Item NUMC6 NUMC 6 0 PREC_SUBTA FINS_PREC_SUBTA Preceding Partial Document to be balanced to zero NUMC6 NUMC 6 0 PREC_AWMULT FINS_PREC_AWMULT_UUID ID of multiple Preceding Document References SYSUUID RAW 16 0 XSECONDARY FINS_SECONDARY_ENTRY Secondary journal entry BOOLE CHAR 1 0 Input help with fixed values SRC_AWTYP FINS_SRC_AWTYP Source Document Reference Transaction TTYP AWTYP CHAR 5 0 Input help implemented with check table SRC_AWSYS FINS_SRC_AWSYS Logical System of Source Reference Document TBDLS LOGSYS CHAR 10 0 Input help implemented with check table SRC_AWORG FINS_SRC_AWORG Source Document Reference Organizational Units AWORG CHAR 10 0 SRC_AWREF FINS_SRC_AWREF Source Document Reference Document Number AWREF CHAR 10 0 SRC_AWITEM FINS_SRC_AWITEM Source Reference Document Line Item NUMC6 NUMC 6 0 SRC_AWSUBIT FINS_SRC_AWSUBIT Source Reference Document Sub-Item NUMC6 NUMC 6 0 XCOMMITMENT FINS_XCOMMITMENT Indicator: Commitment XFELD CHAR 1 0 Input help with fixed values OBS_REASON FINS_OBSOLETE_ITEM_REASON Reason why this item is obsolete FINS_OBSOLETE_ITEM_REASON CHAR 1 0 Input help with fixed values .INCLUDE ACDOC_SI_CURRKEYS Universal Journal Entry: Currency Keys STRU 0 0 RTCUR FINS_CURRT Balance Transaction Currency TCURC WAERS CUKY 5 0 Input help implemented with check table RWCUR FINS_CURRW Transaction Currency TCURC WAERS CUKY 5 0 Input help implemented with check table RHCUR FINS_CURRH Company Code Currency TCURC WAERS CUKY 5 0 Input help implemented with check table RKCUR FINS_CURRK Global Currency TCURC WAERS CUKY 5 0 Input help implemented with check table ROCUR FINS_CURR1 Freely Defined Currency 1 TCURC WAERS CUKY 5 0 Input help implemented with check table RVCUR FINS_CURR2 Freely Defined Currency 2 TCURC WAERS CUKY 5 0 Input help implemented with check table RBCUR FINS_CURR3 Freely Defined Currency 3 TCURC WAERS CUKY 5 0 Input help implemented with check table RCCUR FINS_CURR4 Freely Defined Currency 4 TCURC WAERS CUKY 5 0 Input help implemented with check table RDCUR FINS_CURR5 Freely Defined Currency 5 TCURC WAERS CUKY 5 0 Input help implemented with check table RECUR FINS_CURR6 Freely Defined Currency 6 TCURC WAERS CUKY 5 0 Input help implemented with check table RFCUR FINS_CURR7 Freely Defined Currency 7 TCURC WAERS CUKY 5 0 Input help implemented with check table RGCUR FINS_CURR8 Freely Defined Currency 8 TCURC WAERS CUKY 5 0 Input help implemented with check table RCO_OCUR FINS_CO_OCUR CO Object Currency TCURC WAERS CUKY 5 0 Input help implemented with check table .INCLUDE ACDOC_SI_UNIT_OF_MEASURES Universal Journal Entry: Unit of Measures STRU 0 0 RUNIT MEINS Base Unit of Measure T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table RVUNIT RVUNIT Unit of Measure for Valuation Quantity T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table RRUNIT RRUNIT Unit of Measure for Reference Quantity T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table RIUNIT FINS_RIUNIT Unit of Measure for Inventory Quantity T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table QUNIT1 FCO_QUNIT1 Additional Unit of Measure 1 T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table QUNIT2 FCO_QUNIT2 Additional Unit of Measure 2 T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table QUNIT3 FCO_QUNIT3 Additional Unit of Measure 3 T006 MEINS UNIT 3 0 H_T006 Input help implemented with check table CO_MEINH FCO_MEINH Unit of Measure for CO Valuation Quantity MEINS UNIT 3 0 RACCT RACCT Account Number SKB1 SAKNR CHAR 10 0 SAKO Input help implemented with check table .INCLUDE ACDOC_SI_GL_ACCAS Universal Journal Entry: G/L additional account assignments STRU 0 0 RCNTR KOSTL Cost Center CSKS KOSTL CHAR 10 0 Input help implemented with check table PRCTR PRCTR Profit Center CEPC PRCTR CHAR 10 0 Input help implemented with check table RFAREA FKBER Functional Area TFKB FKBER CHAR 16 0 Input help implemented with check table RBUSA GSBER Business Area TGSB GSBER CHAR 4 0 H_TGSB Input help implemented with check table KOKRS KOKRS Controlling Area TKA01 CACCD CHAR 4 0 CSH_TKA01 Input help implemented with check table SEGMENT FB_SEGMENT Segment for Segmental Reporting FAGL_SEGM FB_SEGMENT CHAR 10 0 Input help implemented with check table SCNTR SKOST Sender cost center CSKS KOSTL CHAR 10 0 Input help implemented with check table PPRCTR PPRCTR Partner Profit Center CEPC PRCTR CHAR 10 0 Input help implemented with check table SFAREA SFKBER Partner Functional Area TFKB FKBER CHAR 16 0 Input help implemented with check table SBUSA PARGB Trading partner's business area TGSB GSBER CHAR 4 0 H_TGSB Input help implemented with check table RASSC RASSC Company ID of Trading Partner T880 RCOMP CHAR 6 0 CSHDP_T880 Input help implemented with check table PSEGMENT FB_PSEGMENT Partner Segment for Segmental Reporting FAGL_SEGM FB_SEGMENT CHAR 10 0 Input help implemented with check table .INCLUDE ACDOC_SI_VALUE_DATA Universal Journal Entry: Value Fields STRU 0 0 .INCLUDE ACDOC_SI_VALUE_DATA_FLOW Universal Journal Entry: Non-cumulative Value Fields STRU 0 0 TSL FINS_VTCUR12 Amount in Balance Transaction Currency WERTV12 CURR 23 2 WSL FINS_VWCUR12 Amount in Transaction Currency WERTV12 CURR 23 2 WSL2 FINS_VWCUR12_2 Group Valuation Amount in Transaction Currency WERTV12 CURR 23 2 WSL3 FINS_VWCUR12_3 Profit-Center Valuation Amount in Transaction Currency WERTV12 CURR 23 2 HSL FINS_VHCUR12 Amount in Company Code Currency WERTV12 CURR 23 2 KSL FINS_VKCUR12 Amount in Global Currency WERTV12 CURR 23 2 OSL FINS_VOCUR12 Amount in Freely Defined Currency 1 WERTV12 CURR 23 2 VSL FINS_VVCUR12 Amount in Freely Defined Currency 2 WERTV12 CURR 23 2 BSL FINS_VBCUR12 Amount in Freely Defined Currency 3 WERTV12 CURR 23 2 CSL FINS_VCCUR12 Amount in Freely Defined Currency 4 WERTV12 CURR 23 2 DSL FINS_VDCUR12 Amount in Freely Defined Currency 5 WERTV12 CURR 23 2 ESL FINS_VECUR12 Amount in Freely Defined Currency 6 WERTV12 CURR 23 2 FSL FINS_VFCUR12 Amount in Freely Defined Currency 7 WERTV12 CURR 23 2 GSL FINS_VGCUR12 Amount in Freely Defined Currency 8 WERTV12 CURR 23 2 KFSL FINS_VGCUR12_FIX Fixed Amount in Global Currency WERTV12 CURR 23 2 KFSL2 FINS_VGCUR12_FIX2 Group Valuation Fixed Amount in Global Currency WERTV12 CURR 23 2 KFSL3 FINS_VGCUR12_FIX3 PrCtr Valuation Fixed Amount in Global Currency WERTV12 CURR 23 2 PSL FINS_VPCUR12 Total Price Variance in Global Currency WERTV12 CURR 23 2 PSL2 FINS_VPCUR12_2 Group Valuation Total Price Variance in Global Currency WERTV12 CURR 23 2 PSL3 FINS_VPCUR12_3 PrCtr Valuation Total Price Variance in Global Currency WERTV12 CURR 23 2 PFSL FINS_VPFCUR12 Fixed Price Variance in Global Currency WERTV12 CURR 23 2 PFSL2 FINS_VPFCUR12_2 Group Valuation Fixed Price Variance in Global Currency WERTV12 CURR 23 2 PFSL3 FINS_VPFCUR12_3 PrCtr Valuation Fixed Price Variance in Global Currency WERTV12 CURR 23 2 CO_OSL FINS_VCO_OCUR12 Amount in CO Object Currency WERTV12 CURR 23 2 HSLALT MLHSLALT Alternative Value in Local Currency WERTV12 CURR 23 2 KSLALT MLKSLALT Alternative Value in Group Currency WERTV12 CURR 23 2 OSLALT MLOSLALT Alternative Value in Freely Defined Currency 1 WERTV12 CURR 23 2 VSLALT ML4SLALT Alternative Value in Freely Defined Currency 2 WERTV12 CURR 23 2 BSLALT MLBSLALT Alternative Value in Freely Defined Currency 3 WERTV12 CURR 23 2 CSLALT MLCSLALT Alternative Value in Freely Defined Currency 4 WERTV12 CURR 23 2 DSLALT MLDSLALT Alternative Value in Freely Defined Currency 5 WERTV12 CURR 23 2 ESLALT MLESLALT Alternative Value in Freely Defined Currency 6 WERTV12 CURR 23 2 FSLALT MLFSLALT Alternative Value in Freely Defined Currency 7 WERTV12 CURR 23 2 GSLALT MLGSLALT Alternative Value in Freely Defined Currency 8 WERTV12 CURR 23 2 HSLEXT MLHSLEXT External Value in Local Currency WERTV12 CURR 23 2 KSLEXT MLKSLEXT External Value in Group Currency WERTV12 CURR 23 2 OSLEXT MLOSLEXT External Value in Freely Defined Currency 1 WERTV12 CURR 23 2 VSLEXT ML4SLEXT External Value in Freely Defined Currency 2 WERTV12 CURR 23 2 BSLEXT MLBSLEXT External Value in Freely Defined Currency 3 WERTV12 CURR 23 2 CSLEXT MLCSLEXT External Value in Freely Defined Currency 4 WERTV12 CURR 23 2 DSLEXT MLDSLEXT External Value in Freely Defined Currency 5 WERTV12 CURR 23 2 ESLEXT MLESLEXT External Value in Freely Defined Currency 6 WERTV12 CURR 23 2 FSLEXT MLFSLEXT External Value in Freely Defined Currency 7 WERTV12 CURR 23 2 GSLEXT MLGSLEXT External Value in Freely Defined Currency 8 WERTV12 CURR 23 2 HVKWRT MLHVKWRT Value at Sales Price in Local Currency WERTV12 CURR 23 2 MSL QUAN1_12 Quantity MENGV12 QUAN 23 3 MFSL QUAN1_12_FIX Fixed quantity MENGV12 QUAN 23 3 VMSL VQUAN1_12 Valuation quantity MENGV12 QUAN 23 3 VMFSL VQUAN1_12_FIX Fixed valuation quantity MENGV12 QUAN 23 3 RMSL RQUAN1_12 Reference quantity MENGV12 QUAN 23 3 QUANT1 FCO_QUAN1_L Additional Quantity 1 MENGV12 QUAN 23 3 QUANT2 FCO_QUAN2_L Additional Quantity 2 MENGV12 QUAN 23 3 QUANT3 FCO_QUAN3_L Additional Quantity 3 MENGV12 QUAN 23 3 CO_MEGBTR FCO_MEGBTR CO Valuation Quantity MENGV12 QUAN 23 3 CO_MEFBTR FCO_MEFBTR CO Valuation Quantity Fix MENGV12 QUAN 23 3 .INCLUDE ACDOC_SI_VALUE_DATA_BALANCE Universal Journal Entry: Cumulative Value Fields STRU 0 0 HSALK3 MLHSALK3 Inventory Value in Local Currency WERTV12 CURR 23 2 KSALK3 MLKSALK3 Inventory Value in Group Currency WERTV12 CURR 23 2 OSALK3 MLOSALK3 Inventory Value in Freely Defined Currency 1 WERTV12 CURR 23 2 VSALK3 ML4SALK3 Inventory Value in Freely Defined Currency 2 WERTV12 CURR 23 2 HSALKV MLHSALKV Alternative Inventory Value in Local Currency WERTV12 CURR 23 2 KSALKV MLKSALKV Alternative Inventory Value in Group Currency WERTV12 CURR 23 2 OSALKV MLOSALKV Alternative Inventory Value in Freely Defined Currency 1 WERTV12 CURR 23 2 VSALKV ML4SALKV Alternative Inventory Value in Freely Defined Currency 2 WERTV12 CURR 23 2 HPVPRS MLHPVPRS Moving Average Price in Local Currency WERTV12 CURR 23 2 KPVPRS MLKPVPRS Moving Average Price in Group Currency WERTV12 CURR 23 2 OPVPRS MLOPVPRS Moving Average Price in Another Currency WERTV12 CURR 23 2 VPVPRS ML4PVPRS Moving Average Price in Fourth Currency WERTV12 CURR 23 2 HSTPRS MLHSTPRS Standard Price in Local Currency WERTV12 CURR 23 2 KSTPRS MLKSTPRS Standard Price in Group Currency WERTV12 CURR 23 2 OSTPRS MLOSTPRS Standard Price in Another Currency WERTV12 CURR 23 2 VSTPRS ML4STPRS Standard Price in Fourth Currency WERTV12 CURR 23 2 HVKSAL MLHVKSAL Inventory Value at Sales Price in Local Currency WERTV12 CURR 23 2 LBKUM MLLBKUM Inventory Quantity MENGV12 QUAN 23 3 .INCLUDE ACDOC_SI_FIX Universal Journal Entry: Mandatory fields for G/L STRU 0 0 DRCRK SHKZG Debit/Credit Indicator SHKZG CHAR 1 0 Input help with fixed values POPER POPER Posting Period POPER NUMC 3 0 PERIV PERIV Fiscal Year Variant T009 PERIV CHAR 2 0 Input help implemented with check table FISCYEARPER JAHRPER Period/Year JAHRPER NUMC 7 0 BUDAT BUDAT Posting Date in the Document DATUM DATS 8 0 Input help based on data type BLDAT BLDAT Document Date in Document DATUM DATS 8 0 Input help based on data type BLART BLART Document Type T003 BLART CHAR 2 0 CSH_T003 Input help implemented with check table BUZEI BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0 ZUONR DZUONR Assignment number ZUONR CHAR 18 0 BSCHL BSCHL Posting Key TBSL BSCHL CHAR 2 0 H_TBSL Input help implemented with check table BSTAT BSTAT_D Document Status BSTAT CHAR 1 0 Input help with fixed values LINETYPE LINETYPE Item Category T8G02 LINETYPE CHAR 5 0 Input help implemented with check table KTOSL KTOSL Transaction Key CHAR3 CHAR 3 0 SLALITTYPE SLALITTYPE Subledger-Specific Line Item Type FINSTS_SLALITTY SLALITTYPE NUMC 5 0 Input help implemented with check table XSPLITMOD XSPLITMOD Item Changed by Document Splitting XFELD CHAR 1 0 Input help with fixed values USNAM USNAM User Name XUBNAME CHAR 12 0 TIMESTAMP TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0 EPRCTR EPRCTR Partner profit center for elimination of internal business CEPC PRCTR CHAR 10 0 Input help implemented with check table RHOART HOART Type of origin object (EC-PCA) HOART NUMC 2 0 Input help with fixed values GLACCOUNT_TYPE GLACCOUNT_TYPE Type of a General Ledger Account GLACCOUNT_TYPE CHAR 1 0 Input help with fixed values KTOPL KTOPL Chart of Accounts T004 KTOPL CHAR 4 0 H_T004 Input help implemented with check table LOKKT ALTKT_SKB1 Alternative Account Number in Company Code SKA1 SAKNR CHAR 10 0 SAKO Input help implemented with check table KTOP2 KTOP2 Chart of Accounts According to Country Legislation T004 KTOPL CHAR 4 0 H_T004 Input help implemented with check table .INCLUDE ACDOC_SI_GEN Universal Journal Entry: Fields for several subledgers STRU 0 0 REBZG REBZG Document No. of the Invoice to Which the Transaction Belongs BELNR CHAR 10 0 REBZJ REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) GJAHR NUMC 4 0 REBZZ REBZZ Line Item in the Relevant Invoice BUZEI NUMC 3 0 REBZT REBZT Follow-On Document Type REBZT CHAR 1 0 RBEST CO_RBEST Category of Reference Purchase Order BELEGTYP NUMC 3 0 Input help with fixed values EBELN EBELN Purchasing Document Number EKKO EBELN CHAR 10 0 Input help implemented with check table EBELP EBELP Item Number of Purchasing Document EKPO EBELP NUMC 5 0 Input help implemented with check table ZEKKN DZEKKN Sequential Number of Account Assignment NUM02 NUMC 2 0 SGTXT SGTXT Item Text TEXT50 CHAR 50 0 KDAUF KDAUF Sales Order Number VBELN CHAR 10 0 COBL_EX_VMVA Explicit search help interface to field KDPOS KDPOS Item number in Sales Order NUM06 NUMC 6 0 COBL_EX_VMPC2 Explicit search help interface to field MATNR MATNR Material Number MARA MATNR CHAR 40 0 MAT1 Input help implemented with check table WERKS WERKS_D Plant T001W WERKS CHAR 4 0 H_T001W Input help implemented with check table LIFNR LIFNR Account Number of Supplier LFA1 LIFNR CHAR 10 0 KRED Input help implemented with check table KUNNR KUNNR Customer Number KNA1 KUNNR CHAR 10 0 DEBI Input help implemented with check table FBUDA FBUDA Date on which services are rendered DATUM DATS 8 0 Input help based on data type Reference Transaction Object Type Name Structure Remote Function /OPT/ Accounting document ABR FS-RI Sett. Document ACE Accrual Engine ACEPS_AWKY ACEPS_DOCUMENT_SENDER ACES4 Accrual Engine BKPF_AWOBJ FI_DOCUMENT_SENDER AFRU Reporting document COBK_AWOBJ AC_DOCUMENT_AFRU_DISPLAY AIBU Assts und.const.set. BKPF_AWOBJ AMFI_SHOW_AM_DOCUMENT AMBU Asset Transaction BKPF_AWOBJ AMFI_SHOW_AM_DOCUMENT AMDP Depreciation posting BKPF_AWOBJ AC_DOCUMENT_RECORD ANLA Asset Transaction AS91 FIAA old assets data AUAK Settlement document K_SETTLEMENT_DOC_DISPLAY AXBTA Bus. Travel Account BCAEB Acc.Mgt Single Doc. BCASU Acc.Mgt Totals Doc. BEBD RE Billing Document AC_DOCUMENT_SENDER_BEBD BERD Settlement document AC_DOCUMENT_SENDER_CRM_REBATES BERE Transaction Data AC_DOCUMENT_SENDER_CRM_REBATES BKKEB BCA individual doc. BKK_DOCUMENT_SENDER_SU BKKPR Pmnt order from BCA BKK_AWOBPR BKKSU BCA totals document BKK_DOCUMENT_SENDER_SU BKPF Accounting document BKPF_AWOBJ FI_DOCUMENT_SENDER BKPFE Acctg doc.ECS BKPF_AWOBJ GLE_ECS_ITEM_SENDER BKPFF Actg doc.direct inpt BKPF_AWOBJ FI_DOCUMENT_SENDER BKPFI Acctg doc.f.initial. BKPF_AWOBJ ISH_ERP_FI_SD_VBRK_DISPLAY BKPFM Substitute Document BKPF_AWOBJ X FDM_COLL_DOCUMENT_SENDER BKPFO Actg Doc.Direct Inpt BKPF_AWOBJ FI_DOCUMENT_SENDER BKPFR Reorg. Transfer BKPF_AWOBJ FAGL_R_DOCUMENT_SENDER BKPWF BKPF_AWOBJ FAGL_R_DOCUMENT_SENDER CACS Commission Settlemt ACCHD_AWOR CACS_TRANSFER_DISPLAY_DOC CAJO Cash journal doc. FCJ_DISPLAY_DOCUMENT_IN_CAJO CATS Document from CATS COBK_AWOBJ AC_CATS_DISPLAY_DOCUMENT CF3P CIAP CMPEV MEV_AC_DOCUMENT_SENDER COBK Controlling Document COBK_AWOBJ K_DOCUMENT_SENDER COFIS Reconcil. ledger K_RCL_DOCUMENT_SENDER COPA Profitab. Analysis COPCA Profit center doc. CRMCS Claim Subm. Posting X CRMFM Funds Posting X AC_DOCUMENT_SENDER_CRMFM CRP CRP Document DBMCD DBM Cash Desk /DBM/CD_DOCUMENT_SENDER DBMDP DBM Down Payment /DBM/DP_DOCUMENT_SENDER DBMIB DBM Int. Billing Doc /DBM/IB_DOCUMENT_SENDER DBMSO DBM Workshop Order /DBM/CO_UI_ORDER_SENDER DBMTR DBM Time Recording /DBM/TR_DOCUMENT_SENDER DBMVM DBM Vehicle Mgmt. /DBM/VM_DOCUMENT_SENDER DELI DIDPC Down Payment Chains /SAPPCE/KY /SAPPCE/DPC_AC_DOCUMENT_DISP DIPNV Constr. Prog. Report COBK_AWOBJ /SAPPCE/PNV_AC_DOCUMENT_DISP EACC Accounting Engine CON_FIN_AC_DOCUMENT_SENDER EBKPF External accounting EBKPFAWOBJ ECCS Consolidation ENTD Deposit Refund Prog. AC_DOCUMENT_SENDER_BEBD EXTX Excise Tax BKPF-AWOBJ X FI_DOCUMENT_SENDER FARA FARR_ACCR_NAVIGATION FARR Rev. Recognition FARR_ACCR_NAVIGATION FCO Failure Cost Proc. FCO_DOCUMENT_DISPLAY FCVS FDIS Cash Management FEBEP Acct statement item FEBEPAWOBJ DISPLAY_AS_LINE FERC FERC: Reporting COBK_AWOBJ FERC_DOCUMENT_SENDER FICA Contract A/R and A/P FILA Lease accounting BKPF_AWOBJ AMFI_SHOW_AM_DOCUMENT FILC Consolidation FKKCO Contract A/R and A/P FKK_AC_DOCUMENT_FICA FKKKO FI-CA Document FKK_DOCUMENT_SENDER FKKSU Contract A/R and A/P FKK_AC_DOCUMENT_FICA FMBHI FM_LEDGER_SHOW_ORIG_DOCUMENT FMBL Budgetary Ledger FMBTR FM_LEDGER_SHOW_ORIG_DOCUMENT FMCA Funds Management doc FMCCF Cmmt Carryforw. Doc. FM_CCF_DOCUMENT_DISPLAY FMCJ PS Cash journal FMCJ_DOCUMENT_SENDER FMCO Proj.Cash Mngmnt doc COBK_AWOBJ PS13_CASH_DOCUMENT_SENDER FMED BCS Entry Documents FMED_S_AW FMKU_ED_DISPLAY FMLI BCS Change Document FMLI_S_AW FMKU_LI_DISPLAY FMPSO Request document BKPF_AWOBJ FI_PSO_DOCUMENT_SENDER FMRES Earmarked funds FM_LEDGER_SHOW_ORIG_DOCUMENT FOTP One-Time Postings BKPF_AWOBJ FPL00 FPL01 FPL02 FPL03 FS-BA GL Bank Analyzer AC_DOCUMENT_SENDER_FSBA FS-PM Policy Management GLAL0 FlexGL Allocation FI_DOCUMENT_SENDER GLX Spec. purpose ledger GLYEC Year-End Closing Doc FI_DOCUMENT_SENDER GM Grants Mgm. Doc. GMBD Grants Mgm. Doc. GM_BDGT_DOCUMENT_DISPLAY GMCTR Guaran. Min.Contract HRBLK Funds Block DOCUMENT_SENDER_HRFPM HRBUD Budget Planning DOCUMENT_SENDER_HRFPM HRCOM HR funds commitment DOCUMENT_SENDER_HRFPM HRPAY HR settlement post. AC_DOCUMENT_SENDER_HRPAY HRPRE HR funds precommt DOCUMENT_SENDER_HRFPM HRRES Funds Reservation DOCUMENT_SENDER_HRFPM HRTIM Time management post COBK_AWOBJ HRTIM_AA_DOC_SHOW_REMOTE IBKPF Document from IDoc FI_DOCUMENT_SENDER IDOC External IDoc doc. ISU IS-U billing request ISUDR ISU Agg. Invoice ISU_DEREG_RECTRANSF_DISP_DOC JVA Joint Venture JVAM Joint Venture BKPF_AWOBJ KADO Reval. of Act. Pstg CKMLDUVACT_DOCUMENT_SENDER KFPK Fixed price alloc. KFPRS_AC_DOCUMENT_SENDER_KFPK KOROP FS-RI Open Items KORUM FS-RI Transfer LOANS Loans X FVD_SM_SHOW_DOC MKPF Material document MKPF_AWKEY MB_DOCUMENT_SENDER_MKPF MLCU Cumulation fin.stats CKMLAVR_DOCUMENT_SENDER MLDUV Mat. Posting Reval. CKMLDUVACT_DOCUMENT_SENDER MLHD Material ledger MLHD_AWKEY CKML_F_AC_DOCUMENT_SENDER MYDLT Delta Posting Bal.Sh MY_DELTALAUF_RESULT_GET NFSC Nota Fiscal Brazil NFWRI ITMF_DOCUMENT_SENDER_NFWRI PAYRQ Payment request PCON Contract ME_DOCUMENT_SENDER PEAC Payment Engine X AC_DOCUMENT_SENDER_PE PORD Purchase order ME_DOCUMENT_SENDER PRCHG Price change MLHD_AWKEY CKML_F_AC_DOCUMENT_SENDER PREQ Purchase requisition ME_DOCUMENT_SENDER PYMTD Payment data REACC Real Estate document RE_INTERFACE_DOCUMENT_SENDER REACI Real Estate document RE_INTERFACE_DOCUMENT_SENDER RECOM Real Estate Contract RE_INTERFACE_CONTRACT_SENDER RESV Material Reservation FM_RESV_DOCUMENT_SENDER RETAX Real est. doc. in.tx RE_INTERFACE_DOCUMENT_SENDER RMBE SRM Document RMRP Invoice receipt X MRM_AC_DOCUMENT_SENDER_RMRP SLRV Only Special Pur.Ldg SLRV_DOCUMENT_SENDER TBRR Event-Based RevRecog FINS_TRR_CLOSE_DISPLAYDOCUMENT TR-TM Treasury Management TRCA_DOCUMENT_SENDER_TRTM TRAVL Posting: Travel Exp. AC_DOCUMENT_SENDER_TRAVL UKPF Rtl revaluation doc. SP_DOCUMENT_SENDER_UKPF VBAK Sales Document AC_DOCUMENT_SENDER_VBAK VBRK Billing document AC_DOCUMENT_SENDER_VBRK VBRR Original Document SD_REV_REC_ORIGINAL_DOCUMENT VOVP VZBL Int.doc.in PS SHOW_DOCUMENT_CREATE_REVERSE WBRK Vendor Bill.Document WLF_AC_DOCUMENT_SENDER_WBRK WTYD Warranty Claim WTYD_AWKEY WTYD_DOCUMENT_SENDER XIPAC /IRM/IPG_FI_TO_IP_NAVIGATE XIPST /IRM/IPG_FI_TO_IP_NAVIGATE Business Transaction Type Text ABAK Last retirement on Group Asset ABAW New Revaluation ABGA Asset Retirement ACEA ACE Accruals Postings ACPA One Allocation Plan Assess. ACPD One Allocation Plan Distrib. AFAB Legacy data transfer: pst. val ANZA Down Payment AS91 Legacy data transfer: cum. val AUAB Retirement of Inv. Meas. AuC AUFW Revaluation AUUA AuC: Transf. Retirem. to Asset AUUS AuC: Transf. Retirem. to Other AUUZ AuC: Transf. Acquis. on Asset AUVA AuC: Part. Clearing Down Pmnt AUVZ AuC: Part. Settlement of APC AUZF AuC: Acquisition Other Receiv. AZAF Down Payment Request AZBU Down Payment Clearing AZUM Down Payment - Transfer Postg AZVA AuC: Carryforward of Down Pmnt AZVZ AuC: Carryforward of APC CFPC CF: PCA internal posting COFI Online Posting from CO COFM CO-FM Integration GLA0 GL Act. Assessment:Integrative GLD0 GL Actual Distrib: Integrative GLYC G/L Year End Closing GPDP Distribution Primary Costs GPDS Distribution Secondary Costs HRP1 HR Payroll Accounting INVZ Investment Support JVAB JVA: Retirement JVUM JVA:Transfer Retirement KAMV Manual Cost Allocation KAZI Actual Cost Center Accrual KOAE Actual Settlement (external) KOAO Actual Settlement KPPE Std cost est. (ind.purch.ordr) KPPP Standard costing (primary) KPPS Standard costing (secondary) KPPZ Standard costing (overhead) KSII Actual Price Calculation KSPA Assessment to CO-PA KTDA COPA: TOP-DOWN: Actuals KZPI Actual Overhead (periodic) KZRI Interest Calculation (actual) NACH Post-Capitalization OCAB Asset OrgAssChg: Transfer RET OCZU Asset OrgAssChg: Transfer ACQ PRC5 Profit Center Document Entry RFAD Accrual / Deferral RFBC Balance Carryforward RFBU FI Postings RFCL Manual Clearing RFCV Foreign Currency Valuation RFIC Customer Invoice / Credit Memo RFIG FI Memo Postings RFIV Vendor Invoice / Credit Memo RFPI Incoming Payment RFPO Outgoing Payment RFRA G/L Realignment RFT1 Travel Expenses RFTP Tax Payable RKIB Actual Periodic Repostings RKIL Actual Inverse Activity Alloc. RKIU Actual Overhead Assessment RKIV Actual Overhead Distribution RKL Actual Activity Allocation RKLN Revaluation at Actual Price RKLT Actual Template Allocation RKLU Activity Allocation Reposting RKLX Predistribution of Fixed Costs RKU1 Repost Costs RKU2 Repost Revenue RKU3 Repost CO Line Items RMBK Adjustment of Inventory Value RMBL Material Debit/Credit RMM1 Post Closing Material Ledger RMM2 Material Ledger Initialization RMPR Change in Material Price RMRP Incoming Invoice RMRU Confirm Order RMWA Goods Movement RMWE Goods Receipt for Purch. Order RMWF Goods Receipt for Prodn. Order RMWI Inventory Difference RMWL Goods Issue Delivery RMWQ Goods Movement for Usage Dec. SD00 Billing Document TBCS COGS Split TBRR Event Based Revenue Recognitn. UMAB Asset Transfer (retirement) UMAI Posting Outflow Internal UMZI Posting Access Internal UMZU Asset Transfer (acquisition) SAP Tables Relationship | Material Master Record Material Master Record Table Category The table category defines whether a physical table exists for the logical table description defined in the ABAP Dictionary and how the table is stored on the database. Transparent Tables (TRANSP) There is a physical table on the database for each transparent table. The names of the physical table and the logical table definition in the ABAP/4 Dictionary agree. All the business and application data is stored in transparent tables. Structure (INTTAB) No data records exist on the database for a structure. Structures are used for the interface definition between programs or between screens and programs. Append Structure (APPEND) An Append structure defines a subset of fields which belong to another table or structure but which are treated as a separate object in the correction management. Append structures are used to support modifications. Pooled table Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored. Cluster table Cluster tables contain continuous text, for example documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table category. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least part of the keys must agree. Several cluster tables are stored in one corresponding table on the database. Generated view structure (VIEW) A structure is generated for a view during activation. This structure is used as the interface for the runtime environment. It is not usually displayed in the ABAP Dictionary. Internal Table Internal tables are dynamic data objects containing any number of rows with a common row type. Internal tables are particularly well suited for editing mass data in business applications. As well as the row type, the data type of an internal table is also defined by its table category and a table key. Row Type The row type can be a non-generic data type from ABAP Dictionary or global class or interface, a non-generic type in the local program, or a predefined ABAP type. Any types can be used as row types, such as elementary types, structured types, table types, and reference types. Table Category The table category defines how individual rows can be accessed: Standard tables : They are managed using a row index. New rows can either be appended to end of the table or inserted at specific positions. Individual rows are accessed using the table key or the row index. Sorted tables : They are also managed using a row index, but are sorted by the table key in ascending order. New rows can be inserted or appended only if they are sorted. The rows are accessed in the same way as in standard tables. Hashed tables : They are managed using a hash algorithm. The rows are accessed using the table key only. Index operations are not possible. Generic Table Categories Two other generic table categories exist that can be used when typing formal parameters and field symbols. Any Table : covers all table categories Index Table : only covers those where index operations are possible (namely standard tables and sorted tables) Table Key Internal tables have a primary table key and can also have secondary table keys. If the row types are structured, the table key can consist of a list of structure components. Alternatively, the pseudo component table_line can be used to specify the entire table row as a key. Another option is to specify the standard key DEFAULT KEY. This key contains all components that are not numeric and are not themselves table types. The primary table key of a standard table can also be empty. Table keys in standard keys are always non-unique, which means multiple rows in the same table can have the same key. Hashed tables, on the other hand, always have a unique key. In sorted tables, this property can be defined using the additions UNIQUE and NON-UNIQUE. Editing Internal Tables Internal tables can be edited, for example, using the statements: READ TABLE LOOP AT INSERT INTO TABLE MODIFY TABLE DELETE TABLE Example Declares an internal table itab with a structured row type Fills the table by inserting rows Reads the rows sequentially in a loop / Assigns the fifth row to a field symbol declared inline * 1 Declare an internal table * --- DATA: BEGIN OF struc, col1 TYPE i, col2 TYPE i, END OF struc, itab LIKE STANDARD TABLE OF struc. * 2 Inserting rows * --- DO 10 TIMES. struc-col1 = sy-index. struc-col2 = sy-index ** 2. INSERT struc INTO TABLE itab. ENDDO. * 3 Reads in a loop * --- LOOP AT itab INTO struc. WRITE: / struc-col1, struc-col2. ENDLOOP. READ TABLE itab INDEX 5 ASSIGNING FIELD-SYMBOL(). WRITE: / -col1, -col2. References: SAP (www.sap.com ); SAP Support (support.sap.com ); SAP Help (help.sap.com ); SAP Blog (blogs.sap.com )