Database Tables for PP

Table: SNUM  BOM explosion number

Field	Data Element	Data Type	length (Decimals)	Checktable	Description
MANDT	MANDT	CLNT	3	T000	Client
SERNR	SERNR	CHAR	8		BOM explosion number
BRUTR	BRUTR	DATS	8		Fixed key date By means of the BOM explosion number , you can define a common explosion date ( fixed key date) for all BOM levels. BOM explosion is then carried out with this fixed key date for all levels.
TECHS	TECHS	CHAR	12		Parameter Variant/Standard Variant
SONDB	SONDB	CHAR	1		Special stock allowed for the serial number
MATNR	MATNR	CHAR	18	MARA	Material Number
WERKS	WERKS_D	CHAR	4	T001W	Plant
SNTXT	SNTXT	CHAR	40		Short description of BOM explosion number
SNSTA	SNSTA	CHAR	1		BOM explosion number status
XLOEK	XLOEK	CHAR	1		Item is Deleted

Table: STKOB  BOM Header Document

Field	Component Type	Data Type	length (Decimals)	Checktable	Description
.INCLUDE	STKO				BOM Header
MANDT	MANDT	CLNT	3	T000	Client
STLTY	STLTY	CHAR	1		BOM category
STLNR	STNUM	CHAR	8		Bill of material
STLAL	STALT	CHAR	2		Alternative BOM
STKOZ	CIM_COUNT	NUMC	8		Internal counter
STKOB-DATUV	DATUV	DATS	8		Valid-From Date
TECHV	TECHV	CHAR	12		Technical status from
AENNR	AENNR	CHAR	12	AENR	Change Number
LKENZ	LKENZ	CHAR	1		Deletion Indicator
LOEKZ	LOKNZ	CHAR	1		Deletion flag for BOMs
VGKZL	VGKZL	NUMC	8		Previous header counter
ANDAT	ANDAT	DATS	8		Date record created on
ANNAM	ANNAM	CHAR	12		User who created record
AEDAT	AEDAT	DATS	8		Changed On
AENAM	AENAM	CHAR	12		Name of Person Who Changed Object
BMEIN	BASME	UNIT	3	T006	Base unit of measure for BOM
BMENG	BASMN	QUAN	13(3)		Base quantity
CADKZ	CADKZ	CHAR	1		CAD Indicator
LABOR	LABOR	CHAR	3	T024L	Laboratory/design office
LTXSP	LTXSP_CP	LANG	1	T002	Long Text Language, for Creation of a Change Document
STKTX	STKTX	CHAR	40		Alternative BOM Text
STLST	STLST	NUMC	2	T415S	BOM status
WRKAN	WRKAN	CHAR	4	T001W	Plant where BOM or alternative/variant created
DVDAT	DVDAT	DATS	8		Date of last date shift
DVNAM	DVNAM	CHAR	12		Name of the user who carried out the date shift
AEHLP	CC_AEHLP	NUMC	2		Date Shift Hierarchy Indicator
ALEKZ	CS_ALEKZ	CHAR	1		ALE indicator
GUIDX	CS_GUIDB	RAW	16		Global identification of a BOM header change status
ZFIELD32	LAND1	CHAR	3	*	Country Key
ZFIELD33	LIFNR	CHAR	10	*	Account Number of Vendor or Creditor
.INCLUDE	STKOS				STKO - Details
LTXPS	LTXPS	INT4	10		Long text working name
LTXVB	LVBKZ	CHAR	1		Long text update indicator
VBKZ	VBKZ	CHAR	1		Update indicator
MVBKZ	VBKZ	CHAR	1		Update indicator
DATUB	DATUB	DATS	8		Valid-to date
AENRA	AENRA	CHAR	12	*	Change Number To
AENKZ	SAENKZ	CHAR	1		Change indicator
SELKZ	CSSEL	CHAR	1		Selection of valid records
KZDOC	CS_KZDOC	CHAR	1		Indicator: Maintain document assignment in BOM complete
EFRNK	CC_EFRNK	NUMC	20		ECM: level during explosion

How to Create Production version in SAP PP

The production version is the link between a product BOM (Bill of Material) and the process Routing. It determines which alternative BOM is used together with which routing to produce a material or plan a material.

There may be different production versions based on the lot sizes and validity dates.

For example, there may be different versions if you want to produce 1 – 100 liter of paint than 100 – 1000 liter of paint, as such the different composition of BOM may be required in both cases.

• It comprises of the following data:

1. The assignment of routings to the production version

2. The assignment of the alternative BOM to the production version

• Production versions are used in material requirements planning (MRP), production order creation, and product costing to select the most suitable routing and the corresponding bill of material.

In order to create production version, perform the following steps-

Step 1) From SAP Easy access screen open transaction C223

1. Enter Plant Code.

2. Enter parent material for which production version needs to be created.

3. Enter Material code.

4. Input the production version code and text.

5. Input the validity dates of the production version.

6. Input the lot size range where it would be valid.

7. Input Alternative BOM and BOM usage as "1" for production BOM.

8. Enter Routing Group and Counter.

9. Enter type of task list, i.e., routing.

After filling in all the fields, click  or press Enter to go to the next screen.

Step 2) In this screen,

1. Select the line of the newly created production version.
2. Press "consistency check" to check whether BOM and routing are valid.

Step 3) In this screen, you can see the messages regarding the validity of BOM and routing for the material.

1. Check whether task list routing exists in the validity period (01.01.2015 – 31.12.9999) and lot sizes (0 – 99999999) of the production version.

2. Check whether BOM exists in the validity period (01.01.2015 – 31.12.9999) and lot sizes (0 – 9999999999999) of the production version.

Click or press F3 from the keyboard to the previous screen.

Step 4) In this screen, you can see the test status is indicated by green color.

1. You can see the consistency check status in green color.

Click  to save the new version, the system will show message " Production version saved" at the lower left corner.

Troubleshooting

• There might be the case where in BOM and Routing are not valid in production version validity time frame. Ensure that validity period of production falls between validity period for both BOM and Routing.