Material primary data staging table
Material primary data staging table lists the columns used in the staging table.
Table | Column name | Column label |
sn_psm_sap_int_prodct_stg | assignment_uom | Assignment Unit of Measurement |
sn_psm_sap_int_prodct_stg | base_quantity | Base quantity |
sn_psm_sap_int_prodct_stg | base_unit_of_measure | Base unit of measure |
sn_psm_sap_int_prodct_stg | base_unit_of_measure_desc | Base unit of measure description |
sn_psm_sap_int_prodct_stg | basic_material | Basic material |
sn_psm_sap_int_prodct_stg | blocked_stock | Blocked stock |
sn_psm_sap_int_prodct_stg | blocked_stock_returns | Blocked stock returns |
sn_psm_sap_int_prodct_stg | client | Client |
sn_psm_sap_int_prodct_stg | container_requirements | Container requirements |
sn_psm_sap_int_prodct_stg | conversion_group_oil_natural_gas | Conversion group oil natural gas |
sn_psm_sap_int_prodct_stg | created_on | Created on |
sn_psm_sap_int_prodct_stg | current_period_posting_period | Current period posting period |
sn_psm_sap_int_prodct_stg | current_planned_price | Current planned price |
sn_psm_sap_int_prodct_stg | dangerous_goods_indicator_profile | Dangerous goods indicator profile |
sn_psm_sap_int_prodct_stg | dangerous_goods_packaging_status | Dangerous goods packaging status |
sn_psm_sap_int_prodct_stg | data_division_marc | Data division marc |
sn_psm_sap_int_prodct_stg | data_division_marc_division_1 | Data division marc division 1 |
sn_psm_sap_int_prodct_stg | data_division_mard | Data division mard |
sn_psm_sap_int_prodct_stg | date_as_of_which_the_price_is_valid | Date as of which the price is valid |
sn_psm_sap_int_prodct_stg | date_from_which_future_planned_price_1_is_valid | Date from which future planned price 1 is valid |
sn_psm_sap_int_prodct_stg | date_from_which_future_planned_price_2_is_valid | Date from which future planned price 2 is valid |
sn_psm_sap_int_prodct_stg | date_from_which_future_planned_price_3_is_valid | Date from which future planned price 3 is valid |
sn_psm_sap_int_prodct_stg | date_from_which_the_plant_specific_material_status_is_valid | Date from which the plant specific material status is valid |
sn_psm_sap_int_prodct_stg | date_of_the_last_price_change | Date of the last price change |
sn_psm_sap_int_prodct_stg | default_storage_location_for_external_procurement | Default storage location for external procurement |
sn_psm_sap_int_prodct_stg | division | Division |
sn_psm_sap_int_prodct_stg | erp_source | Erp source |
sn_psm_sap_int_prodct_stg | fiscal_year_of_current_period | Fiscal year of current period |
sn_psm_sap_int_prodct_stg | future_planned_price | Future planned price |
sn_psm_sap_int_prodct_stg | future_planned_price_1 | Future planned price 1 |
sn_psm_sap_int_prodct_stg | future_planned_price_2 | Future planned price 2 |
sn_psm_sap_int_prodct_stg | future_planned_price_3 | Future planned price 3 |
sn_psm_sap_int_prodct_stg | future_price | Future price |
sn_psm_sap_int_prodct_stg | gross_weight | Gross weight |
sn_psm_sap_int_prodct_stg | handling_unit_type | Handling unit type |
sn_psm_sap_int_prodct_stg | hazardous_material_number | Hazardous material number |
sn_psm_sap_int_prodct_stg | height | Height |
sn_psm_sap_int_prodct_stg | industry_standard_description_such_as_ansi_or_iso | Industry standard description such as ansi or ISO |
sn_psm_sap_int_prodct_stg | issue_storage_location | Issue storage location |
sn_psm_sap_int_prodct_stg | language | Language |
sn_psm_sap_int_prodct_stg | length | Length |
sn_psm_sap_int_prodct_stg | loading_units | Loading units |
sn_psm_sap_int_prodct_stg | load_without_packaging_material_vso | Load without packaging material Vehicle Space Optimization |
sn_psm_sap_int_prodct_stg | maintenance_status | Maintenance status |
sn_psm_sap_int_prodct_stg | manufacturer_number | Manufacturer number |
sn_psm_sap_int_prodct_stg | material_category | Material category |
sn_psm_sap_int_prodct_stg | material_category_desc | Material category desc |
sn_psm_sap_int_prodct_stg | material_description | Material description |
sn_psm_sap_int_prodct_stg | material_freight_group | Material freight group |
sn_psm_sap_int_prodct_stg | material_group | Material group |
sn_psm_sap_int_prodct_stg | material_group_desc | Material group desc |
sn_psm_sap_int_prodct_stg | material_is_costed_with_quantity_structure | Material is costed with quantity structure |
sn_psm_sap_int_prodct_stg | material_is_locked | Material is locked |
sn_psm_sap_int_prodct_stg | material_mrp_profile | Material Material Requirements Planning Profile |
sn_psm_sap_int_prodct_stg | material_number | Material number |
sn_psm_sap_int_prodct_stg | material_type | Material type |
sn_psm_sap_int_prodct_stg | material_type_desc | Material type desc |
sn_psm_sap_int_prodct_stg | mrp_controller | Mrp controller |
sn_psm_sap_int_prodct_stg | mrp_group | Material Requirements Planning Group |
sn_psm_sap_int_prodct_stg | mrp_type | Material Requirements Planning Type |
sn_psm_sap_int_prodct_stg | name_of_person_who_created_the_object | Name of person who created the object |
sn_psm_sap_int_prodct_stg | net_contents | Net contents |
sn_psm_sap_int_prodct_stg | net_weight | Net weight |
sn_psm_sap_int_prodct_stg | packaging_code | Packaging code |
sn_psm_sap_int_prodct_stg | packaging_material_type | Packaging material type |
sn_psm_sap_int_prodct_stg | physical_inventory_blocking_indicator | Physical inventory blocking indicator |
sn_psm_sap_int_prodct_stg | physical_inventory_indicator_for_restricted_use_stock | Physical inventory indicator for restricted use stock |
sn_psm_sap_int_prodct_stg | physical_inventory_indicator_for_whse_stock_in_current_year | Physical inventory indicator for warehouse stock in current year |
sn_psm_sap_int_prodct_stg | phys_inventory_ind_f_stock_in_qual_insp_in_current_year | Phys Inventory ind F Stock in qual Insp In current year |
sn_psm_sap_int_prodct_stg | plant_field | Plant field |
sn_psm_sap_int_prodct_stg | plant_specific_material_status | Plant specific material status |
sn_psm_sap_int_prodct_stg | previous_price | Previous price |
sn_psm_sap_int_prodct_stg | price_control_indicator | Price control indicator |
sn_psm_sap_int_prodct_stg | price_unit | Price unit |
sn_psm_sap_int_prodct_stg | price_unit_of_previous_period | Price unit of previous period |
sn_psm_sap_int_prodct_stg | procurement_rule | Procurement rule |
sn_psm_sap_int_prodct_stg | procurement_type | Procurement type |
sn_psm_sap_int_prodct_stg | produced_in_house | Produced in house |
sn_psm_sap_int_prodct_stg | production_unit | Production unit |
sn_psm_sap_int_prodct_stg | product_category | Product category |
sn_psm_sap_int_prodct_stg | product_hierarchy | Product hierarchy |
sn_psm_sap_int_prodct_stg | profit_center | Profit center |
sn_psm_sap_int_prodct_stg | purchase_order_unit_of_measure | Purchase order unit of measure |
sn_psm_sap_int_prodct_stg | purchasing_group | Purchasing group |
sn_psm_sap_int_prodct_stg | purchasing_value_key | Purchasing value key |
sn_psm_sap_int_prodct_stg | relevant_for_hazardous_substances | Relevant for hazardous substances |
sn_psm_sap_int_prodct_stg | return_code | Return code |
sn_psm_sap_int_prodct_stg | return_to_logistics_level | Return to logistics level |
sn_psm_sap_int_prodct_stg | serial_number_profile | Serial number profile |
sn_psm_sap_int_prodct_stg | size_dimensions | Size dimensions |
sn_psm_sap_int_prodct_stg | source_of_supply | Source of supply |
sn_psm_sap_int_prodct_stg | special_procurement_type_at_storage_location_level | Special procurement type at storage location level |
sn_psm_sap_int_prodct_stg | standard_price | Standard price |
sn_psm_sap_int_prodct_stg | standard_price_in_the_previous_period | Standard price in the previous period |
sn_psm_sap_int_prodct_stg | stock_in_quality_inspection | Stock in quality inspection |
sn_psm_sap_int_prodct_stg | stock_in_transfer_plant_to_plant | Stock in transfer plant to plant |
sn_psm_sap_int_prodct_stg | stock_in_transit | Stock in transit |
sn_psm_sap_int_prodct_stg | stock_transfer_sales_value_plant_to_plant_for_vo_material | Stock transfer sales value plant to plant for valuation order material |
sn_psm_sap_int_prodct_stg | storage_bin | Storage bin |
sn_psm_sap_int_prodct_stg | storage_conditions | Storage conditions |
sn_psm_sap_int_prodct_stg | storage_location | Storage location |
sn_psm_sap_int_prodct_stg | storage_location_mrp_indicator | Storage Location Material Requirements Planning Indicator |
sn_psm_sap_int_prodct_stg | storage_percentage | Storage percentage |
sn_psm_sap_int_prodct_stg | total_stock_of_all_restricted_batches | Total stock of all restricted batches |
sn_psm_sap_int_prodct_stg | total_valuated_stock | Total valuated stock |
sn_psm_sap_int_prodct_stg | total_valuated_stock_in_previous_period | Total valuated stock in previous period |
sn_psm_sap_int_prodct_stg | unit_of_dimension_for_length_width_height | Unit of dimension for length width height |
sn_psm_sap_int_prodct_stg | unit_of_issue | Unit of issue |
sn_psm_sap_int_prodct_stg | unit_of_mearsure_group_oil_natural_gas | Unit of mearsure group oil natural gas |
sn_psm_sap_int_prodct_stg | unit_of_measure_for_maximum_packing_length_width_height | Unit of measure for maximum packing length width height |
sn_psm_sap_int_prodct_stg | utc_time_stamp_in_short_form_yyyymmddhhmmss | Utc time stamp in short form yyyymmddhhmmss |
sn_psm_sap_int_prodct_stg | valuated_unrestricted_use_stock | Valuated unrestricted use stock |
sn_psm_sap_int_prodct_stg | valuation_area | Valuation area |
sn_psm_sap_int_prodct_stg | valuation_category | Valuation category |
sn_psm_sap_int_prodct_stg | valuation_type | Valuation type |
sn_psm_sap_int_prodct_stg | value_of_total_valuated_stock | Value of total valuated stock |
sn_psm_sap_int_prodct_stg | value_of_total_valuated_stock_in_previous_period | Value of total valuated stock in previous period |
sn_psm_sap_int_prodct_stg | volume | Volume |
sn_psm_sap_int_prodct_stg | volume_unit | Volume unit |
sn_psm_sap_int_prodct_stg | weight_unit | Weight unit |
sn_psm_sap_int_prodct_stg | width | Width |