Current position:  Home > Default > How count number of item records in a File: Idoc to File scenario

How count number of item records in a File: Idoc to File scenario

Time:October 11
Advertisement
Hi All,
I am configuring an IDOC to File scenario.
Once all the IDOC data is dumped on a File, I need to calculate the number of Item records in this file and write this number at the end of the trailer record in the file.
Is theer a way to calculate the item data records(or say number of lines in the file) in the message mapping area. Or any other simple way to do it.
Appreciate your help on same.
Thanks
Shirin
Advertisement
hi,
Use the count function for ITEM node the assign this count value to the receiver field , keep the ITEM context to header!
Thanks,
Vijaya.

Number of items/records display

-0001-11-30

I want to set the number of items/records display base on query. I tried Set_Block_Property and Set_Item_Property, they don't have any option for me to set it dynamically. Any ideas? ThanksA couple: a) Set QUERY ALL RECORDS to YES, and programmatical

Count total no of records in csv file

-0001-11-30

hello i made a function which count total no of records in csv file. but it always return 0 goes in the exception when no data found which it also display the total no of records in another parameter. code is here CREATE OR REPLACE FUNCTION COUNT_REC

How to count number of items present in a data block

2015-10-11

hi all, how to count how many items present in a particular data block in oracle forms 10g. whether it is a text_item or display_item or list_item etc is there any method to do this. please reply....hi all, i have written this when-button pressed but

Ship to party PO number line item field updating in ORDERS IDOC

2015-10-11

Hi Experts,          We are in the process of creating the Sales order by receiving EDI data from customer and converting in to IDOC format and trying to create the sales order. While executing the ORDERS IDOC message type sales order is getting crea

Need help to count number of rows and display in file

2015-10-11

Hello, my scenario is IDOC to File......i am using XSLT mapping and using FCC parameters to convert the flat file. now new requirement is i need to count number of rows and add count value last of the file. Please let me know how to do it, thanks in

Count or "distinct count" number of items in SAP BI 3.5

2015-10-11

Hi all, I have a requirement that goes like this: In an ODS-object there are two characterisitics among others. Against each client there are several numbers of articles. 01. I have to count the number of articles against each client. 02. I have to c

How to count number of methods in a java file

2015-10-11

Is there any way to know the count of methods or variables (instance) in a java file or at least in main() of a java file? If yes , can we know about their access modifiers?raj440 wrote: Is there any way to know the count of methods or variables (ins

DOWNLOAD HEADER & ITEM RECORD INTO EXCEL FILE

-0001-11-30

I WANT TO KNOW THE LOGIC TO POPULATE HEADER DATA AND ITEM DATA INTO SAME INTERNAL TABLE AND AGAIN DOWNLOAD THE SAME TO EXCEL FILE . Header structure : rectyp ,hdnum ,sbank ,bankl ,accnr , paytp , crda ,iso. Item  structure    : rectyp ,valut ,cknum ,

Count number of lines

-0001-11-30

hi is there any method which counts number of the lines in a file?Grrrr @ stoopid requirements. OK, I'd create an array of some default size (not too large, not too small). Read from file and add to array. If it becomes full, create a new array of so

Counting number of records in a data block

-0001-11-30

hi folks, Simple question for you guys: How can I count number of records in a data block. In other words, say I have 10 detail records listed on a data block (one of my columns is a non-database item for entering a number). Now I just want to do som

Count for item records reaches 999 the second idoc gets triggered!

-0001-11-30

Hi Experts,      I have an issue. Sender is file and receiver is idoc with a header and item  level records. Only one header and n number of records can be there. Now we want to make  this way that as soon as the count for item records reaches 999 th

How to Count Number of completed line items in past 6 months / 12 months ?

2015-10-11

How to Count Number of completed line items in past 6 months / 12 months ? Hi, I am trying to count "Number of Completed Line Items in Purchase Order Document" for my Key Figure ZPO_CNT. Purchase Order document = ZEBELN Line Item = ZEBELP. I nee

Count number of records in a internal table

2015-10-11

hi i want to count number of records in internal table pls let me know how to count the number of records in a internal table. regards Arorahi one way is data field type i. Decribe table itab lines field. write: / field. displays the no of records in

Powershell script to count number of list and library items in site collection

2015-10-11

We are identifying large lists in our 2010 SP environment and I'm attempting to write code to output the total number of list items in a site collection.   I'm using the code below but it only displays column data for title and url.  What do I need t

To count number of records in an internal table for a condition

-0001-11-30

Hello All,         I want to count number of records in an internal table for a condition. For e.g. -- I have one internal table IT which having fields F1, F2, F3, F4, F5.                  Now, I want number of records in itnternal table IT where F1

Please let me know how to Count Number of completed line items in past 6 mo

-0001-11-30

How to Count Number of completed line items in past 6 months / 12 months ? Hi, I am trying to count "Number of Completed Line Items in Purchase Order Document" for my Key Figure ZPO_CNT. Purchase Order document = ZEBELN Line Item = ZEBELP. I nee

Counting the number of detail records at target side...

-0001-11-30

Hi I have a requirement where i need to caluclate the number of detail records formed and add it in trailer section...both at target side... The output will look like this : <Detail>     <Field></Field> </Detail>   <Detail>  

Use Windows PowerShell to count and list total number of items in Folders E-Mail in Office Outlook?

-0001-11-30

I have the need to generate a list of all outlook folders and the total number of items listed beside each folder name. I thought I could simply modify the script from " http://blogs.technet.com/b/heyscriptingguy/archive/2009/01/26/how-do-i-use-windo

Tutorials Announcment :: Counting Number of Records ::

-0001-11-30

Hi Every body i made anew and simple tutorials that lets you to count a how many records are attached to a category in your database. - how it works: - first will create a category table that allows us to insert category name into it. - second the sl