Object status tables

[benitoenrique_figueroaflo]

Hi

Please, could you tell me what is the tables where the object status are storage from SD sales document for example?

Best Regards,

Enrique

[Former Member · Accepted solution]

Hi Benito Enrique,

Please have a look at below tables.

AUSP

Characteristic Values

CMFK

Storage Structure for the Error Log Header

CMFP

Storage Structure for Errors Collected

FMSU

FI-FM Totals Records

FPLA

Billing Plan

FPLT

Billing Plan: Dates

INOB

Link between Internal Number and Object

JCDO

Change Documents for Status Object (Table JSTO)

JCDS

Change Documents for System/User Statuses (Table JEST)

JEST

Object Status

JSTO

Status Object Information

KANZ

Assignment of Sales Order Items u2013 Costing Objects

KEKO

Product Costing - Header

KEPH

Product Costing: Cost Components for Cost of Goods Mfd

KNKO

Assignment of a Cost. Est. Number to Config. Object

KOCLU

Cluster for Conditions in Purchasing and Sales

KSSK

Allocation Table: Object to Class

NAST

Message Status

SADR

Address Management: Company Data

VBAK

Sales Documents: Header Data

VBAP

Sales Documents: Item Data

VBEH

Schedule Line History

VBEP

Sales Document: Schedule Line Data

VBEX

SD Document: Export Control: Data at Item Level

VBFCL

Sales Document Flow Cluster

VBLB

Sales Document: Release Order Data

VBSN

Change Status Relating to Scheduling Agreements

VBUK

Sales Document: Header Status and Administrative Data

VBUP

Sales Document: Item Status

VBUV

Sales Document: Incompleteness Log

VEDA

Contract Data

Thanks,

Swamy H P

[Former Member]

Hi,

For Overall Header status and administrative data you can check in VBUK table.

For overall Item status and administrative data you can check in "VBUP" table.

In both these cases you have to pass the order number number only in SE11/SE16 T.Code.

For object status you have to check in "JCDS" table.

In this initially you have to pass the order number in "VBAK" table and then fetch the "OBJNR" for that order.

Pass this OBJNR into "JCDS" to get the header object status in SE11/SE16 T.Code.

Regards,

Krishna.

[benitoenrique_figueroaflo]

Hi,

Thanks!, but now i have the following problem:

In the BS02 transaction I has configured the status profile Z0000W with the following status: DAD1 (with position 6), DAD2 (with position 2), DAD3 (with position 1), DAD4 (with position 3), DAD5 (with position 4) and DAD 6 (with position 5)

in the JCDS table, in JCDS - STAT show E0001, E0002, E0004, E0005, E0006 and E0007. The question is how to establish relationship between DAD"X" and E000"X", is in other table?

Regards

Enrique

[Shiva_Ram]

Hi,

Depending on your requirements, did you assign the status profile to sales document type (in T.code VOV8) or to item categories (T.code VOV7)?

Regards

[benitoenrique_figueroaflo]

To sales document type

[Shiva_Ram]

Hi,

It looks the JCDS table holds the data that are created with transaction codes.

For example, when you create the sales order that is assigned with status profiles, these status profiles are updated in this table with details on transaction codes like for example VA01, VA02 etc.

Check the E000x entries and corresponding t.codes in that table. Then you can understand.

Regards,

[Former Member]

Hi

check these tables and fields

VBUK-GBSTK

VBUK-ABSTK

VBUK-LFSTK

VBUK-SPSTG

regards