former_member1240068
Explorer
Member since ‎2020 Apr 15

User Statistics

  • 10 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

How to get Open Sales Orders? What are different exclusions?

2020 Aug 15
I am using VBAK, VBAP, VBFA, VBUK, VBUP tables to create Open Sales order report ( which are sold to customers not samples, free of charge etc). The numbers are coming way too high than expectation. I am considering Standard order from VBAK. From VBA...

How to match G/L Account balance from FAGL003 using BSEG and BSIS?

2020 Aug 03
Our trial balance numbers are matching to FAGL003. But, when I am pulling data from BSEG and BSIS for last 20 years and doing the cumulative sum, its not matching. Please advise how can we get balance sheet account ending balance using BSEG and BSIS ...

Production order/ CAUHV/ AFKO/AFPO/AFRU/TECO

2020 May 15
Hi rupesh.brahmankar3 Thanks a ton for helping. I have another query in this regard. In COOIS, there is a field called "System Status". This system status takes its value from JEST (Status field) and description from Tj02T table.In TJ02T, i can se...

Production Order Completion field in SAP Table and Object Class/functional Area/AFKO?AFPO/AUFK/AFRU

2020 May 14
I am building a report of Production order for my business. I am using AFKO, AFPO and AUFK tables from SAP. Do I need to choose all object class and functional area to get all manufacturing orders/production orders? Also, Is there any field in ANY ...

Planned Production Order versus Actual Production Orders (COOIS)

2020 Apr 15
I want to build a report which shows what is planned production orders and what is actually produced from those Planned? Most of people are using COOIS. Can some body tell me what all SE16N table i should use? How should I join these SE16N TABLES ( u...