Introduction:
This blog post explains you the procedure to perform initial stock upload for materials which are batch managed, handling unit managed and also serial number managed into SAP Extended Warehouse Management for SAP S/4HANA Cloud, extended edition. SAP S/4HANA Cloud, extended edition has embedded warehouse management in it. SAP note 2483936 provides templates for uploading initial stock into SAP S/4HANA embedded extended warehouse management system. These templates contain an example for uploading initial stock for a non-serialized material, but they doesn’t provide an example for a material which is Batch managed, Handling unit managed and also Serialized material. The template provided in the above mentioned SAP note has 64 fields available in it for populating data and not all of them are mandatory to be populated in every scenario. Depending on the scenario, there are few fields which are to be populated mandatorily, otherwise stock upload results in errors.
Stock upload program does validation on data present in input file and doesn’t allow stock upload if the validation on the data present in input file fails.
This blog post helps you to identify the minimum mandatory fields to be populated and dependency between fields in input file for the purpose of uploading initial stock of a material which is handling unit managed, batch managed and also serialized material. So that you can save time and avoid hit and try method. Here, I have also mentioned the configuration settings to be in place as a pre-requisite for successful upload of initial stock.
Main content:
Here, I am considering an example of a material which is batch managed , handling unit managed and serial number managed. In this example, I am considering to upload stock for this material which has one batch with quantity of 2 and a separate serial number is assigned to each of the pieces. External serial number is considered. In this, I will tell you the minimum mandatory fields to be populated, number of rows to be used in input file to upload stock for this material which is batch managed and serial number managed.
Configuration settings to be in place:
SPRO: Integration with Other SAP Components--> Extended Warehouse Management --> Additional Material Attributes --> Attribute Values for Additional Material Master Fields --> Define Serial Number Profile. Here, serial number profile must be configured and field 'serial number requirement' must be set with a value as per business requirement, for example: serialization requirement at warehouse level and also field 'Base Unit' must be set with a value.
SPRO: SCM Extended Warehouse Management --> Extended Warehouse Management --> Master Data--> Product --> Define Serial Number Profiles --> Define Warehouse Number-Dependent Serial Number Profiles. Here, serial number profile configured in the above mentioned node must also be configured here. Fields 'serial number requirement' and 'Base Unit' must be set with the same values as done in the configuration node mentioned above.
SPRO: SCM Extended Warehouse Management --> Extended Warehouse Management --> Master Data--> Product --> Define Serial Number Profiles --> Serial Numbers: Settings for Warehouse Number. Here, for the warehouse under consideration, set the serial number length.
Example: Material number: ABCXYZ, Batch number: BAT5678, Quantity: 2, Handling Unit: HU11-1, Serial numbers: S0001, S0002
In this example, I have considered serialization profile, which is set to external number range. Due to this reason, I have to provide serial numbers in the input file.
From the SAP note mentioned above, download the template file as use it as input file. In the downloaded input file, keep the header record and delete the remaining rows and enter data in the rows as follows:
In ROW NUMBER: 1
Populate the below fields: POSTYPE, HUTYP, LGPLA, PMAT, EXTNO, HUIDENT, TOPHUIDENT, ROW
POSTYPE should be populated with value 1. POSTYPE represents item category and value 1 means 'Highest-level HU'.
HUTYP is to be populated with Handling Unit Type value.
LGPLA is to be populated with storage bin value.
PMAT is to be populated with packaging material number value.
EXTNO is set to X.
HUIDENT is to be populated with Handling Unit number.
TOPHUIDENT is to be populated with Highest level HU.
ROW should be populated with value 1 as this is the first row. Remaining fields can be populated as per your dataset.
In ROW NUMBER:2
Populate the below fields: POSTYPE, MATNR, OWNER, OWNER_ROLE, BATCH, CAT, ENTITELED, ENTITLED_ROLE, QUAN, UNIT, LGPLA, HUIDENT, TOPHUIDENT, ROW
POSTYPE must be populated with value 4. POSTYPE represents item category and value 4 means 'Material'.
MATNR is to be populated with material number value.
OWNER is to be populated with owner value.
OWNER_ROLE is to be populated with partner role value (as BP).
BATCH is to be populated with Batch number value.
CAT is to be populated with stock type value.
ENTITELED is to be populated with Party Entitled to Dispose.
ENTITLED_ROLE is to be populated with partner role
QUAN is to be populated with quantity value. (in this example, it will be 2)
UNIT is to be populated with unit of measure
LGPLA is to be populated with storage bin value.
HUIDENT is to be populated with Handling Unit number.
TOPHUIDENT is to be populated with Highest level HU.
ROW should be populated with value 2 as this is the second row. Remaining fields must be populated as per your dataset.
As there are two pieces in the batch to be uploaded, we have to consider including row number 3 and row number 4.
In ROW NUMBER:3
Populate the below fields: POSTYPE, MATNR, OWNER, OWNER_ROLE, BATCH, CAT, ENTITELED, ENTITLED_ROLE, QUAN, UNIT, HUIDENT, TOPHUIDENT, ROW, REFROW, SERNR
POSTYPE should be populated with value 6. POSTYPE represents item category and value 6 means 'Serial Number'.
MATNR is to be populated with material number value.
OWNER is to be populated with owner value.
OWNER_ROLE is to be populated with partner role value (as BP).
BATCH is to be populated with Batch number value.
CAT is to be populated with stock type value.
ENTITELED is to be populated with Party Entitled to Dispose.
ENTITLED_ROLE is to be populated with partner role
QUAN is to be populated with quantity value. (in this example, it will be 1)
UNIT is to be populated with unit of measure
HUIDENT is to be populated with Handling Unit number.
TOPHUIDENT is to be populated with Highest level HU.
ROW should be populated with value 3 as this is the third row.
REFROW should be populated with value 2 as this serial number refers to material & batch mentioned in ROW number 2.
SERNR should be populated with first serial number present for this material in the considered batch.
In ROW NUMBER: 4
Populate the below fields: POSTYPE, MATNR, OWNER, OWNER_ROLE, BATCH, CAT, ENTITELED, ENTITLED_ROLE, QUAN, UNIT, HUIDENT, TOPHUIDENT, ROW, REFROW, SERNR
POSTYPE should be populated with value 6. POSTYPE represents item category and value 6 means 'Serial Number'.
MATNR is to be populated with material number value.
OWNER is to be populated with owner value.
OWNER_ROLE is to be populated with partner role value (as BP).
BATCH is to be populated with Batch number value.
CAT is to be populated with stock type value.
ENTITELED is to be populated with Party Entitled to Dispose.
ENTITLED_ROLE is to be populated with partner role.
QUAN is to be populated with quantity value. (in this example, it will be 1)
UNIT is to be populated with unit of measure
HUIDENT is to be populated with Handling Unit number.
TOPHUIDENT is to be populated with Highest level HU.
ROW should be populated with value 4 as this is the fourth row.
REFROW should be populated with value 2 as this serial number refers to material & batch mentioned in ROW number 2.
SERNR should be populated with second serial number present for this material in the considered batch.
Save this file as a CSV file.
Use the transaction code /SCWM/ISU or you can also use the fiori app: EWM - Data Exchange to upload data into system. Here, upload the CSV file created in the above steps.
Upon successful upload and execution, new warehouse task gets created. Depending on your system settings, this warehouse task may get confirmed automatically. Once the warehouse task is confirmed, you can view the status of stock situation in warehouse.
Use the fiori app: warehouse monitor and on the pop-up screen enter warehouse number and execute. Here, use the 'stock overview' option to view the stock level. Use the option 'Serial Number On Whse Level' to view the serial numbers loaded into EWM system.
Conclusion:
The procedure mentioned above identifies the minimum mandatory fields to be populated to perform initial stock upload for a material which is batch managed, Handling unit managed and serial number managed into SAP Extended Warehouse Management for SAP S/4HANA Cloud, extended edition. This will help you to upload the files without error and you can also save time by avoiding the hit and try method as using the materials which are batch managed, handling unit managed and serialized is common.
