About Author:
Agr_1251 Table In Sap Stand
- AGR1251 Authorization data for the activity group; AGR1252 Organizational elements for authorizations. ADR6 E-mail addresses of sap user; Other Tables.
- Go to agr1251 table and check the field value of Column 'whether object is' select status 'Manually' and since this question is to check for manually added tcodes in roles so put object STCODE and its corresponding value TCD as any tcode for which you want to check it.
- SAP Agr 1251 Tables: AGR1251 — Authorization data for the activity group, AGR1252 — Organizational elements for authorizations, AGRTCODES — Assignment of roles to Tcodes, AGRCUSTOM — Role Customizing objects, AGRHIER — Table for Structure Information for Menu, AGRUSERS — Assignment of roles to users, and more. View the full list of Tables for Agr 1251.
AGR1251 AGR1251 is a standard ABAP Authorization and Role Management Transparent Table in SAP Basis application, which stores Authorization data for the activity group data.
Hari Boda is working as a Senior BW-HANA consultant at TekLink Software Pvt Ltd (www.teklink.com) and has worked on multiple assignments in BW-HANA analytics domain.
With S/4 HANA is growing in SAP world there are many questions looming regarding the impact/changes and disruptions. This post mainly outlines the impact on traditional SAP tables after migration to ‘S/4 HANA Simple Finance' as it contains fewer database tables.
Brief about S/4 HANA:
- S/4 HANA is an abbreviation for SAP Business Suite (4th generation) SAP HANA. S = Simple and 4 = 4th generation of SAP Enterprise software.
- R/1,R/2,R/3 are the previous generations Enterprise Central Component (ECC)
- SAP S/4 runs only on SAP HANA platform unlike ECC which can work on other databases like IBM, Oracle etc.
- SAP S/4 HANA has advantage of HANA's in memory capability
- OLTP and OLAP capabilities in same system with real time reporting and predictive analytics
Tables in ECC which are being reduced to single table in S/4 HANA S-FIN.
Traditional ECC 6 database tables:
- BKPF – SAP Accounting Header Table Data
- BSEG – SAP Cluster table used to store Accounting Document Segment data(Line item Data)
Agr_1251 Table In Sap Tutorial
Index Tables:
- BSIS – Accounting: Secondary Index for G/L Accounts data
- BSAS – Accounting: Secondary Index for G/L Accounts (Cleared Items)
- BSID – Accounting: Secondary Index for Customers data.
- BSIK – Accounting: Secondary Index for Vendors data
- BSAK – Accounting: Secondary Index for Vendors (Cleared Items)
- BSIM – Secondary Index, Documents for Material data
- FAGLBSIS – Accounting: Secondary Index for G/L Accounts data
- FAGLBSAS – Accounting: Secondary Index for G/L Accounts (Cleared Items)
Aggregated Tables:
- GLT0 – G/L account master record transaction figures
- FAGLFLEXT – New General Ledger: Total Tables
- KNC1 – Customer master (transaction figures)
- LFC1 – Vendor master (transaction figures)
- KNC3 – Customer master (special G/L transaction figures) data
- LFC3 – Vendor master (special G/L transaction figures) data
- COSS – CO Object: Cost Totals for Internal Postings data
- COSP – CO Object: Cost Totals for External Postings data
Material Ledger Tables:
- MLIT, MLPP, MLPPF, MLCR, MLCD, CKM11, BSIM
Asset Accounting Tables:
- ANEK, ANEP, ANEA, ANLP, ANLC
SAP S/4 HANA(Simple Finance):
About Author:
Agr_1251 Table In Sap Stand
- AGR1251 Authorization data for the activity group; AGR1252 Organizational elements for authorizations. ADR6 E-mail addresses of sap user; Other Tables.
- Go to agr1251 table and check the field value of Column 'whether object is' select status 'Manually' and since this question is to check for manually added tcodes in roles so put object STCODE and its corresponding value TCD as any tcode for which you want to check it.
- SAP Agr 1251 Tables: AGR1251 — Authorization data for the activity group, AGR1252 — Organizational elements for authorizations, AGRTCODES — Assignment of roles to Tcodes, AGRCUSTOM — Role Customizing objects, AGRHIER — Table for Structure Information for Menu, AGRUSERS — Assignment of roles to users, and more. View the full list of Tables for Agr 1251.
AGR1251 AGR1251 is a standard ABAP Authorization and Role Management Transparent Table in SAP Basis application, which stores Authorization data for the activity group data.
Hari Boda is working as a Senior BW-HANA consultant at TekLink Software Pvt Ltd (www.teklink.com) and has worked on multiple assignments in BW-HANA analytics domain.
With S/4 HANA is growing in SAP world there are many questions looming regarding the impact/changes and disruptions. This post mainly outlines the impact on traditional SAP tables after migration to ‘S/4 HANA Simple Finance' as it contains fewer database tables.
Brief about S/4 HANA:
- S/4 HANA is an abbreviation for SAP Business Suite (4th generation) SAP HANA. S = Simple and 4 = 4th generation of SAP Enterprise software.
- R/1,R/2,R/3 are the previous generations Enterprise Central Component (ECC)
- SAP S/4 runs only on SAP HANA platform unlike ECC which can work on other databases like IBM, Oracle etc.
- SAP S/4 HANA has advantage of HANA's in memory capability
- OLTP and OLAP capabilities in same system with real time reporting and predictive analytics
Tables in ECC which are being reduced to single table in S/4 HANA S-FIN.
Traditional ECC 6 database tables:
- BKPF – SAP Accounting Header Table Data
- BSEG – SAP Cluster table used to store Accounting Document Segment data(Line item Data)
Agr_1251 Table In Sap Tutorial
Index Tables:
- BSIS – Accounting: Secondary Index for G/L Accounts data
- BSAS – Accounting: Secondary Index for G/L Accounts (Cleared Items)
- BSID – Accounting: Secondary Index for Customers data.
- BSIK – Accounting: Secondary Index for Vendors data
- BSAK – Accounting: Secondary Index for Vendors (Cleared Items)
- BSIM – Secondary Index, Documents for Material data
- FAGLBSIS – Accounting: Secondary Index for G/L Accounts data
- FAGLBSAS – Accounting: Secondary Index for G/L Accounts (Cleared Items)
Aggregated Tables:
- GLT0 – G/L account master record transaction figures
- FAGLFLEXT – New General Ledger: Total Tables
- KNC1 – Customer master (transaction figures)
- LFC1 – Vendor master (transaction figures)
- KNC3 – Customer master (special G/L transaction figures) data
- LFC3 – Vendor master (special G/L transaction figures) data
- COSS – CO Object: Cost Totals for Internal Postings data
- COSP – CO Object: Cost Totals for External Postings data
Material Ledger Tables:
- MLIT, MLPP, MLPPF, MLCR, MLCD, CKM11, BSIM
Asset Accounting Tables:
- ANEK, ANEP, ANEA, ANLP, ANLC
SAP S/4 HANA(Simple Finance):
SAP Released SAP S/4 in 2015 named as ‘Smart Finance' and later it changed the name to ‘Simple Finance(S-FIN)' and thereafter it was renamed as ‘S/4 HANA Finance'. S/4 HANA Finance provides a database table 'ACDOCA'(Universal Journal) is which contains all the documents types from FI, CO, MM, SD, PP applications. All the postings to these applications are written in single ACDOCA table (so it's a replacement table for existing traditional tables like BKPF,BSEG etc). This way system avoids data redundancy to a great extent.
Agr_1251 Table In Sap Sql
What if we still need to access traditional tables? The traditional tables from system are replaced by HANA CDS(Core Data Services) views, which will be referencing and fetching data from ACDOCA(Universal Journal table). In this way SAP has ensured that the traditional tables are converted to database views so the existing programs using those as tables will not be impacted even after migration to S/4 HANA S-FIN. Ableton live 9 osx torrent version. There still might be a minimal need to align and re-adjust some ABAP syntaxes which can be easily analyzed by doing syntax checks.
Agr_1251 Table In Sap Table
It will be user's choice to either use ACDOCA or use CDS views to build reports/programs going forward after the migration. In my next blog I will try to explain practical use cases for ACDOCA table vs CDS views, so stay tuned!
Agr_1251 Table Sap
Thank you for reading my blog. Comments and feedback are welcome!
