S_P00_07000139 - logic for data arrangement

[Former Member]

Hi all,

S_P00_07000139 is a veeery good trx. for transaction overview + opening and closing stock, but I can not find the logic, based on which is created the balance list. I tried to check the "Time of Entry" but, this is not the key, Material document either. Can somebody explain me the logic?

For data investigation is very good for me the list of issues, receipts and balance qty...but I do not understand based on what is created the list of all transaction during the day.

Thank you,

Zuzana

[tejyadav]

Check the Program for J_1HSTCD for the logic of pulling the data for T-code *S_P00_07000139 *,

       rmenge like mard-labst,         "Receipt by each trans.
       rdmbtr like mseg-dmbtr,         "Amount Receipt by each trans.
       imenge like mard-labst,         "Issue by each trans.
       idmbtr like mseg-dmbtr,         "Amount Issue by each trans.
       bmenge like mard-labst,         "Balance by each trans.
       bdmbtr like mseg-dmbtr,         "Amount Balance by each trans.
       pdmbtr like mseg-dmbtr,         "Unit of price
       xdmbtr like mseg-dmbtr,     "share dmbtr btw. Receiv. & Issues
       pbdmbt like mseg-dmbtr,         "Price of unit for balance
tables: bkpf,                         "Accounting voucher heading
         mara,                         "Material master data
         mard,                 "Materialbestände auf Lagerortebene
         mkpf,                         "Material document header
         mseg,                         "Material document line items
         t001,                         "Accounting company level
         t001w,                        "Plant
         t001l,                        "Storage Location
         t001k,                        "Valuation area 

[Former Member]

Dear,

This report is generated for internal and external audit purpose as well as presenting the report to Thailand Revenue Department if required.

Please find the application help available for the transaction:

Short text : Stock card and Inventory material report

Description:

According to Thai requirements, company must provide stock report to display receiving and issuing of goods of each material in each period.

Program "J_1HSTCD" will display data required by the Director-General ofthe Revenue Department of Thailand.

There are three reports that related to Thai requirements.

1. Stock card report

2. Inventory and raw material report

3. Stock balance report

4. Stock card for special stock

Output

- current stock balance (both quantity and value) of each material at plant level is equal to material master data when you enter selection date as a today.

- transactions that display in the stock card report for accounting, inventory and raw material report are only valuated stock.

- inventory and raw material report, stock balance report, stock card for accounting must have the same value of quantity and amount if you enter the same date.

- stock balance can summarize total value of every material by plant.

- inventory and raw material report, stock card report for accounting will display all accounting documents which have no material document but update only stock value without changing stock quantity for example changing material cost via material valuation, updating material cost via invoice verification.

- stock card for warehouse can display normal stock, return stock, stock intransit for plant, stock intransit for storage location

separately or together depending on what you select in the selection screen.

- stock card for warehouse for normal stock will display goods movement (receipt and issue) of stock type unrestricted-use, quality inspection, blocked stock.

- stock card for warehouse can display goods movements ( receipt and issue ) of materials which movements are related to in transit stock at storage location level.

- stock card for warehouse can display goods movements ( receipt and issue ) of materials which movements are related to in transit stock at plant level.

- stock card for warehouse can display goods movement ( receipt and issue) of materials which movements are related to return stock.

- we can display material movements by special stock.

Also check note: Note 1327549 - User specific layout not displayed in J_1HSTCD output-S_P00_07000139

Regards,

Syed Hussain.