Where is Sales Delivery line LOC field stored in database?

SOLVED

From the screen I can see the value for LOC, but not in database, the value is empty.

Parents
  • +1
    verified answer

    When a document is allocated stock, the details are stored in STOALL joining to STOCK on column STOCOU. The STOALL entry also joins to the transactional table on VCRTYP, VCRNUM and VCRLIN. In the case of a processed stock transaction, that information is stored in STOJOU, TRSTYP indicating document type, VCRNUM and VCRLIN indicating the document generating the stock movement.

Reply
  • +1
    verified answer

    When a document is allocated stock, the details are stored in STOALL joining to STOCK on column STOCOU. The STOALL entry also joins to the transactional table on VCRTYP, VCRNUM and VCRLIN. In the case of a processed stock transaction, that information is stored in STOJOU, TRSTYP indicating document type, VCRNUM and VCRLIN indicating the document generating the stock movement.

Children