Talent.com
S.i. Systems
SAP IDT Developer (Information Design Tool) to create complex reports and have functional knowledgeS.i. Systems • Toronto
SAP IDT Developer (Information Design Tool) to create complex reports and have functional knowledge

SAP IDT Developer (Information Design Tool) to create complex reports and have functional knowledge

S.i. Systems • Toronto
30+ days ago
Job type
  • Full-time
Job description

As an IDT Developer, you will have a strong grasp of the semantic layer and exactly how FI and CO module tables interact.

Core IDT Modeling Competencies

To build high-performance data foundations and business layers, your resource should possess the following skills:

  • Relational and OLAP Data Modeling: Extracting and combining metadata from backend SAP HANA systems or data warehouses.
  • Semantic Layer Design: Creating user-friendly hierarchies, custom measures, and dimensions in the Business Layer.
  • Complex Joins and Aliases: Managing loops, contexts, and alias tables to resolve ambiguous SQL joins across finance dimensions.

Key FICO Modules and Tables They Must Understand

As the SAP IDT developer, you must understand the backend tables to create accurate logical joins.

The core tables include:

Financial Accounting (FI) Tables:

  • ACDOCA: Universal Journal Entry Line Items (the backbone of SAP S/4HANA)
  • BKPF: Accounting Document Header
  • BSEG: Accounting Document Segment (Line Items)
  • SKA1 & SKB1: G/L Account Master Data (Chart of Accounts and Company Code) [, , ]

Controlling (CO) Tables:

  • COBK: CO Object Document Header
  • COEP: CO Object Line Items by Period (Note: Replaced by ACDOCA in S/4HANA).
  • CSKS & CSKT: Cost Center Master Data and Texts
  • CEPC & CEPCT: Profit Center Master Data and Texts [, ]


Create a job alert for this search

SAP IDT Developer (Information Design Tool) to create complex reports and have functional knowledge of both the FI and CO modules and the tables within those modules for our mining client. • Toronto

Similar jobs

EDI - ITX Developer

Iris Software Inc.Toronto, ON, CA
Full-time

Iris's Fortune 100 direct client is looking for.Please find below Job description and share me your updated resume at.Develop and maintain IBM Sterling Transformation Extender (ITX) maps, type tree... Show more

 • Promoted

BluePrism Developer

Themesoft Inc.Toronto, ON, CA
Full-time

A Bachelor's degree in Engineering, preferably Computer Science or Information Technology.Must have 4+ years of Blue Prism experience.Experience of working within an agile, continuous integration e... Show more

 • Promoted

Innovative Erp Applications Developer Focused On Data And Integration

ReelcruitToronto, Canada
Full-time

Drive the future of enterprise solutions as an ERP Applications Developer, focusing on analytics and system integration.Utilize a hybrid work model to collaborate on innovative projects.Your role w... Show more

 • Promoted

Senior Developer

AdeccoToronto, ON, CA
Temporary

Recruitment Consultant @ Adecco | Human Resources, HRM, Training and Development | CHRP in process.Adecco is currently recruiting for a Senior Developer.This is a 6-month contract opportunity with ... Show more

 • Promoted

Senior Software Developer ETL in Hybrid Setting

Rubicon PathToronto, ON, CA
Full-time

Elevate your expertise as a Senior Software Developer ETL at the Office of the Public Guardian and Trustee.This hybrid role focuses on integrating and testing the Dynamics 365 solution.In this posi... Show more

 • Promoted

Senior Developer, D365

Yoush ConsultingToronto, ON, CA
Full-time

Downtown Toronto (Underground city), Canada | Posted on 06/18/2024.Are you anindependent IT Consultant or wish to become one?.Asa Senior Developer, Dynamics 365 your responsibilities will include:.... Show more

 • Promoted

SAP Cloud Integration Developer (CPI/BTP)

Tech Talent InternationalToronto, ON, CA
Full-time

SAP Cloud Integration Developer (CPI/BTP).About the job SAP Cloud Integration Developer (CPI/BTP).Fortune 100/500/1000 companies to startup organizations in Canada/US.We currently have a 6 month re... Show more

 • Promoted

Innovative ERP Applications Developer Focused on Data and Integration

ReelcruitToronto
Full-time

Drive the future of enterprise solutions as an ERP Applications Developer, focusing on analytics and system integration.Utilize a hybrid work model to collaborate on innovative projects.Your role w... Show more

 • Promoted

Senior SAP Developer

The SWATCH GroupToronto, ON, CA
Full-time

You will join a large and dynamic SAP Competence Center and play a key role in designing, developing and implementing solutions that support complex business requirements across global operations.W... Show more

 • Promoted

Senior ETL Developer - D365 & Azure Data (Hybrid)

Source CodeToronto, ON, CA
Full-time

A tech company in Toronto is seeking a Senior Software Developer specializing in ETL for Microsoft D365.The role involves significant hands-on experience in enterprise-level data integration and da... Show more

 • Promoted

Lead Design Role for P3 Projects

Parkin Architects LimitedToronto, ON, CA
Full-time

Join our dynamic team as a P3 Design Lead, driving infrastructure projects forward through innovative design and collaboration.Your leadership will ensure project success.We are looking for an expe... Show more

 • Promoted

Sr. IDMC Developer

Tata Consultancy Services LimitedToronto, ON, CA
Full-time

TCS is an equal opportunity employer and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation.ETL development experience in larg... Show more

 • Promoted

SAP Datasphere Developer

Insight GlobalToronto, ON, CA
Temporary

Get AI-powered advice on this job and more exclusive features.This range is provided by Insight Global.Your actual pay will be based on your skills and experience — talk with your recruiter to lear... Show more

 • Promoted

ETL Developer

CloudVitalToronto
Full-time

We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.This is an onsite role located in Toronto, requiring you to work in ... Show more

 • Promoted

Senior Ui Developer -Vice President

CitiToronto, Canada
Full-time

We are seeking a highly skilled and experienced Senior Application Developer to join our dynamic Rates Technology team.This position is responsible for the design, development, and implementation o... Show more

 • Promoted

Developer

Absorb SoftwareToronto, ON, CA
Full-time

Absorb is seeking an intermediate-level Developer to take ownership of an internal ETL tool that supports billing, accounting, and operations.In this individual contributor role, you’ll help mainta... Show more

 • Promoted

SAP BODS Developer

Tekgence IncToronto, ON, CA
Full-time

The SAP BODS Developer supports Enbridge Gas’s data integration and analytics landscape by designing, developing, and maintaining ETL solutions that move data from SAP and non‑SAP systems into ente... Show more

 • Promoted

Hybrid Integration Developer – Poc & Api Specialist

Insight GlobalToronto, Canada
Full-time

A leading recruitment agency is seeking an experienced Integration Developer for a hybrid contract in Toronto.This role involves integrating third-party cyber risk assessment tools, managing API in... Show more

 • Promoted

IDD Director

Aecon Group Inc.Toronto, ON, CA
Full-time

Come Build Your Career at Aecon!.As a Canadian leader in infrastructure development, Aecon is safely and sustainably building what matters for future generations to thrive! We lead some of the most... Show more

 • Promoted

ETL Developer - Snowflake (Pharmaceutical client experience mandatory)

Cygnus Professionals Inc.Toronto, Ontario, Canada
Temporary

ETL Developer - Snowflake (Pharmaceutical client experience mandatory).ETL Developer - Snowflake (Pharmaceutical client experience mandatory).Direct message the job poster from Cygnus Professionals... Show more