Yuanyuan Gao

Elevate your data manipulation skills with targeted substring extraction. Check below👇 w/ Dinesh Selvaraj https://lnkd.in/g6pGxvrE 📌Ready to level up your SQL HANA skills? Let's explore the world of substring isolation together! 💡🔍 #SAP #SQLQueries #DataAnalysis #ProfessionalDevelopment #technology #sapb1 #HANAIntegration #SAPHANA #S4HANA #DigitalTransformation #SAPBusinessOne 👩‍💻

13

4 Popular Business Analyst Qlik Sense Courses, Check Out this:- https://shorturl.at/kDFTV #BusinessAnalyst #BusinessAnalystTraining #BusinessAnalystOnlineCourse #BusinessAnalystCertification #QlikSense #QlikSenseTraining #QlikSenseCertification #CromaCampus #Education #Learning #Onlinecourse #Certification #training

2

𝗦𝗔𝗣 𝗠𝗠 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝟮𝟲 😄 --> List of Important SAP MM Tables 𝗣𝘂𝗿𝗰𝗵𝗮𝘀𝗶𝗻𝗴: EKPO - Purchasing Document Item EKKO - Purchasing Document Header EBAN - Purchase Requisition EKBE - History per Purchasing Document EKET - Scheduling Agreement Schedule Lines EINE - PIR: Purchasing Organization Data EINA - PIR: General Data EBKN - Purchase Requisition Account Assignment EORD - Purchasing Source List T024 - Purchasing Groups 𝗠𝗮𝘁𝗲𝗿𝗶𝗮𝗹 𝗠𝗮𝘀𝘁𝗲𝗿 𝗗𝗮𝘁𝗮: MARA - Material General Data MAKT- Material Descriptions MARM- Conversion Factors MVKE - Material Sales Org Data MARC - Material Plant Data MBEW - Material Valuation MVER - Warehouse Management Storage Type MAPR - Material Index for Forecast MARD - Storage Location Data for Material 𝗜𝗻𝘃𝗲𝗻𝘁𝗼𝗿𝘆 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: MSEG - Document Segment: Material MKPF - Header: Material Document RESB - Reservation/dependent requirements ISEG - Physical Inventory Document Items RKPF - Document Header: Reservation T156T - Movement Type Text T156S - Movement Type: Quantities/Value Posting T156W - Posting string values 𝗜𝗻𝘃𝗼𝗶𝗰𝗲 𝗖𝗼𝗻𝘁𝗿𝗼𝗹: RSEG - Document Item: Incoming Invoice RBKP - Document Header: Invoice Receipt BSIM - Secondary Index, Documents for Material RKWA - Consignment Withdrawals RBCO - Document Item, Incoming Invoice, Account Assignment RBKP_V - Generierte Tabelle zu einem View T149D - Global Valuation Types RBTX - Taxes: Incoming Invoice RBKPB - Invoice Document Header

72

4 Kommentare

🚀 HANA Performance Troubleshooting: Key Tips for Optimal Performance 🔍 Identify Bottlenecks: - 🔍 Analyze workload using SQL trace - 🕵️ Check expensive statements 📊 Optimise Queries: - 📌 Use proper indexing - ✂️ Avoid unnecessary calculations 🔧 System Configuration: - 💾 Ensure sufficient memory allocation - ⚙️ Optimise CPU usage 🛠️ Regular Maintenance: - 📈 Update statistics regularly - 🩺 Perform regular system health checks 💡 Proactive Monitoring: - 🖥️ Use HANA cockpit for real-time monitoring - 🔔 Set up alerts for critical metrics 📄 Detailed Guide Available! For an in-depth guide on HANA performance troubleshooting. 👉 👇 👈 🔗 Stay tuned for more insights on SAP HANA performance! 💬 Have questions? Share them in the comments below!

58

Configuring Material Types in SAP MM: Tcode: OMS2 Define Material Types: Define the different material types that align with your organization's requirements. This includes specifying attributes such as industry sector, material group, valuation class, and procurement category. Assign Number Ranges: Assign number ranges to each material type to ensure unique material numbers are generated for materials belonging to different categories. This helps maintain data integrity and simplifies identification. Configure Default Settings: Set default values for various fields such as purchasing group, valuation class, and tax classification for each material type. This ensures consistency and streamlines the procurement process. Define Account Assignment Categories: Specify account assignment categories for different material types to determine how costs are allocated and accounted for during procurement and consumption. Customize Screen Layouts: Customize the screen layouts for each material type to include relevant fields and hide unnecessary ones. This enhances user experience and ensures that only relevant information is captured. Activate Business Functions: Activate relevant business functions or features related to material types, such as batch management, serial number management, or quality management, based on organizational requirements.

16

Deprecation of AutoML in Power BI using Dataflows V1 https://lnkd.in/geNeB_CJ #PowerBI #Microsoft

17

Does ABAP RAP / Fiori Elements best supports OData V4 or OData v2 ??

62

1 Kommentar

Navigating IDOC Configuration Steps IDOCs, or Intermediate Documents, play a vital role in data migration between SAP systems or bridging SAP and legacy systems. This post delves into the intricacies of configuring a new IDOC, providing insight into the transactions essential for IDOC management. The classification of IDOCs into Inbound and Outbound streams is also explored.

10

💣 Sequence in Routing Master Data in SAP PP: In SAP PP, routing master data defines the sequence of operations needed to produce a material. The sequence in routing master data refers to the order in which these operations are to be performed during the production process. 1. **Routing Header**: Contains general information about the routing, such as the material number, plant, usage, status, and validity dates. 2. **Operations**: A list of tasks or steps that need to be performed to manufacture the product. Each operation includes details such as operation number, work center, control key, description, and standard values (setup time, machine time, labor time). 3. **Sequence**: Defines the order in which the operations are carried out. There are different types of sequences:   - **Standard Sequence**: The default order of operations.   - **Parallel Sequence**: Operations that can be performed simultaneously.   - **Alternative Sequence**: An alternate path for the production process, which can be used under specific conditions. 4. **Relationships**: Links between operations that define dependencies and constraints. For example, an operation may need to wait until a preceding operation is completed. 5. **Work Centers**: Locations where the operations are performed. Each work center is associated with specific resources and capacities. 6. **Inspection Characteristics**: Quality control measures that need to be checked during or after certain operations. ### Creating and Managing Routing Master Data To create or manage routing master data in SAP PP, the following transactions are typically used: - **CA01**: Create Routing - **CA02**: Change Routing - **CA03**: Display Routing ### Example of a Routing Sequence 1. **Operation 0010**: Cutting   - Work Center: WC1   - Control Key: PP01   - Standard Values: Setup time, machine time, labor time 2. **Operation 0020**: Welding   - Work Center: WC2   - Control Key: PP02   - Standard Values: Setup time, machine time, labor time 3. **Operation 0030**: Painting   - Work Center: WC3   - Control Key: PP03   - Standard Values: Setup time, machine time, labor time ### Steps to Define Routing Sequence 1. **Create Routing Header**: Enter basic information about the routing. 2. **Define Operations**: List all operations required for production. 3. **Set Sequences**: Determine the order of operations (standard, parallel, alternative). 4. **Establish Relationships**: Link operations based on dependencies. 5. **Assign Work Centers**: Specify the work centers where each operation will be performed. 6. **Input Standard Values**: Enter time and resource requirements for each operation. #comradestech #sap #sapmm #sappm #sapsd #sappp #sapcommunity #saphana #sapfiori #sapprojectmanager #saptraining #sapcertification #s4hana #students #training #erp #procurement #production #plantmaintenance #sales #technology #usa #canada #uk #ksa #uae #southafrica #malaysia #indonesia #australia #pakistan #india

43

2 Kommentare

Oss Notes SAP TM #sap  #saptm 3459185 Purchase for TM relevance BADI_LO_TM_PUR not working in change mode - ME22N 3459351 Transportation cockpit provides equipment type / group (of assigned capacity document) in requirement document lists - Enhancements 3454389 Dump CX_FSBP_PARTNER_INCONSISTENT in org management 3453757 Sales Order Document Flow: TM documents are missing 3192807 TC: The column for product description is missing in the FU / PU / CU lists - enhancements 2786778 Transportation Cockpit: additional field for execution document of subsequent stage in PU, FU stages lists and hierarchies 3459101 The Email of Carrier is not shown in the Business Partner Tab of Freight Order 3457208 Charge calculation when charge types are assigned to service types? 3457206 Charge calculation on Forwarding order raises Error: 'Charge Calculation Failed; document is incomplete for the action' 3456518 Goods Movement Status is not updated in Freight Orders 3453866 Limitation of the direct TM-EWM integration for basic TM license 3453219 Automatic Load Planning is not performed for Resources with Compartments during optimizer planning 3440830 Can not add multiple business partner with same function/role 3391747 Multiple Transportation Allocations (TALs) are updated for the same Freight Order 3391705 Organizational unit defaulting not working from forwarding order to Freight unit 3391613 Freight Order Execution Status on LOAD_END event 3380691 Driver-specific fields and tab are not shown on FO UI when stages are not in a linear sequence 3313366 Freight Orders query of FO POWL violates Transportation Mode criteria 3168458 TM Charge type mapping Error in LBN integration 2788649 What Time is Used to Select Unplanned FU Stages in TC using Time-Related Selection Attributes in SAP Transportation Management? 2543568 Uploading Freight Agreement through Excel fails

11

1 Kommentar

Feature Matrix: Data Modeling with ABAP Core Data Services

26

Understand the ABAP RESTful Application Programming Model (RAP) with ABAP Cloud https://sap.to/61873u4DU

1

How to create API to upload file to Azure Blob by Integration Suite #sapintegrationsuite #sapintegration https://lnkd.in/gau_cRQ6

21

How to ? Create Material (Product) Master Data - Accounting Data (Valuation Area Data). by Imane Dendane Here's a breakdown of the process: Transaction Selection: Access the SAP system and navigate to the MM01 transaction. This transaction is specifically designed for creating and maintaining material master records. Material Selection: Enter the material number for which you want to extend the valuation data. This will retrieve the existing material master record. Accounting View Selection: Within the MM01 transaction, you'll find different view categories for the material master record. Select the "Accounting 1" view. This view specifically deals with valuation data for the material. Adding Valuation Data: In the "Accounting 1" view, you'll find a section dedicated to valuation areas. Here, you can add new entries for valuation areas and their corresponding valuation types. Valuation Area: This defines a specific location or department within your organization where you manage the value of the material stock. You can assign a unique code to each valuation area. Valuation Type: This allows you to manage different value calculations for the same material within a particular valuation area. For instance, you might have separate valuation types for standard costing and moving average costing. By adding new valuation areas and types, you gain more granular control over how material value is tracked and managed in your SAP system. Here are some additional points to consider: Understanding Valuation Needs: Carefully consider why you need to extend the valuation data. Adding unnecessary valuation types or areas can increase complexity. Authorization: Make sure you have the necessary authorization within SAP to modify material master records. Data Consistency: Ensure consistency between the new valuation data and existing data in the material master record. If you'd like to explore the specific steps with screenshots or delve deeper into valuation types and areas, let me know!

26

1 Kommentar

ABAP Tools for Clean ABAP This blog provides you with an overview of ABAP tools which have been developed in the context of Clean ABAP projects led by SAP in the open-source community and gives you guidance for their usage scenarios. #abap #cleancore

13

🚀 Visualize your data with Chart.js! 📊 You can easily include other open-source libraries in abap2UI5 and access them from the backend purely in ABAP. Check out the sample code👇  https://lnkd.in/gKiax7bA Explore Chart.js 🧭 https://www.chartjs.org/ Big thanks to the contributor choper725 🙏  https://lnkd.in/gRrZrXSU Happy ABAPing 💻 #abap2UI5 #abap #sapUI5 #abapGit #OpenSource

118

10 Kommentare