SNC Field names - Find tables.

[Former Member]

Hello Experts,

In which SNC tables we will find the following fields.

Act WOS

Actual price

Actual Receipt Date

Actual Received Quantity

ASN Time

Avail to ship Qty

Base UOM

Brand

C&D SAP Number

Capacity

CD owned or Consignment

Chep Quantity Received

Chep Quantity Shipped

CM

CM Name Location

Consignment Vendor Name

Consignment Vendor Number

Contract Manufacturer Name

Contract Manufacturer Number

Contract Manufacturer/Plant

Date of Shipment

Delivery Date

Delivery/Bill of Lading Number

Description

Dollar value

Domestic / International

Finished Material / WIP / Raw material

GR Quantity

Location

Manufacturer Part Number

Manufacturer SAP Number

Material

Material Description

Material Number

Obsolete

Old CD Part Number

Order UOM

Percent achieved

Physical Inventory Value

PIR Qty

PIR qty current month

Plan Quantity

Plan Spend

Planned Receipt Date

Planned waste%

PO Date

PO Number

PO price

PO Quantity

Price per Unit

Production Confirmation Qty

Production Confirmation Qty current month

Production Confirmation Qty current week

Purchasing Doc Number

Quantity

Quantity in SAP

Quantity on Hand

Quantity per

Receipt date

Release Number

Release Quantity

Release Required Delivery Date

Required Quantity in Units (Requirements in weekly buckets)

Requirement Quantity

Requirements Date

Safety Stock

SAP Inventory Dollar value

Schedule line Qty

Schedule line Qty current Month

Schedule Line Qty current week

Scheduled Quantity

Shipped Quantity

SKU

Slow Moving

Standard price (info record)

STO Qty

Supplier

Target WOS

Unit of Measure

Variance

Variance Dollar Value

Variance Quantity

Vendor Name

Vendor#

Vendor/Contract Manufacturer Name

Weeks of supply

Where used (FG SKU#)

Wks Low

[Former Member · Accepted solution]

Kapil,

Those fields may or may not exist in Tables. As you surely know, much of the data in SCM is not stored in tables as it is in R/3. Further, those fields that do occur in tables can exist in multiple places.

To review tables & fields in SCM (and much more), use the standard information repository transaction SE84.

Regards,

DB49

[Former Member]

I am not sure if you have the technical names for all of these fields.

If not, you may go to SE11 and do an F4 on Data Elements and enter the text in Description field.

You can get the Field name and then you may do a where used on the field to get the relevant table.

Alternatively, if you are aware of a report which uses these fields - the report could be a source of information to get the technical fields.

[Former Member]

Hi,

I agree with DB. Not all the below fields may not be stored in tables. How ever you can try to find the relevant tables if you can get their technical names. Here is how it is:

Go to transaction se80, click on "Repository information system"

Drill down to ABAP dictionary>Fields>Table Fields

enter the field technical name and search execute. This brings in all the tables where your field is used.

I am sure it is laborious...I wish you all the best.