EHSWAT_MNBP SAP table for – Waste Manifest/Delivery Note: Partners

Here we would like to draw your attention to EHSWAT_MNBP table in SAP. As we know it is being mainly used with the SAP EHS-WA (Waste Management in EHS) component which is coming under EHS module (Environment, Health and Safety). EHSWAT_MNBP is a SAP standard transp table used for storing Waste Manifest/Delivery Note: Partners related data in SAP. It comes under the package CBWA.

SAP EHSWAT_MNBP table

Table EHSWAT_MNBP technical data

TableEHSWAT_MNBP
Data storingWaste Manifest/Delivery Note: Partners
ModuleEHS
Sub ModuleEHS-WA
SAP PackageCBWA
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP EHSWAT_MNBP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in EHSWAT_MNBP table.

  • .INCLUDE : EHS: Standard Key Fields without Engin. Change Mgmt (ACTN)
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : GUID Number
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : EHS: Gen. Admin. Information without Engineering Change Mgmt
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : GUID Number
    Its data type is CHAR (Character String) with field length 32
  • .INCLUDE : Waste Manifest: Business Partner Structure
  • MNBPROLE : Business Partner Role in Waste Management
    Its data type is CHAR (Character String) with field length 6
  • MNRECNBP : Waste Management Business Partner (RECN)
    Its data type is CHAR (Character String) with field length 32
  • MNBPORD : Sequence of the Partners in the Disposal Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • MNBPIDCTRY : No. Assigned by a Transregional Authority
    Its data type is CHAR (Character String) with field length 15
  • MNBPIDST : No. Assigned by a Regional Authority
    Its data type is CHAR (Character String) with field length 15
  • MNDATEDEL : Handover Date for Disposal Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MNDATEADO : Takeover Date for Disposal Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MNSIGNBPMN : Signatory at Business Partner for Waste Management
    Its data type is CHAR (Character String) with field length 15
  • MNVHSIGN : License Plate Number
    Its data type is CHAR (Character String) with field length 15
  • MNDRIVER : Driver’s Name
    Its data type is CHAR (Character String) with field length 35
  • MNBAL : Waste Management Business Partner Is Relevant for Waste LCA
    Its data type is CHAR (Character String) with field length 1
  • MNORDNO : Order Number for Waste Management Business Partner
    Its data type is CHAR (Character String) with field length 20
  • WABPID_INH : Transreg. Auth.-Assigned No. Comes from Higher-Level Partner
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Address
  • NAME1 : Name 1
    Its data type is CHAR (Character String) with field length 40
  • NAME2 : Name 2
    Its data type is CHAR (Character String) with field length 40
  • NAME3 : Name 3
    Its data type is CHAR (Character String) with field length 40
  • NAME4 : Name 4
    Its data type is CHAR (Character String) with field length 40
  • CITY1 : City
    Its data type is CHAR (Character String) with field length 40
  • CITY2 : District
    Its data type is CHAR (Character String) with field length 40
  • POST_CODE1 : City postal code
    Its data type is CHAR (Character String) with field length 10
  • POST_CODE2 : PO Box postal code
    Its data type is CHAR (Character String) with field length 10
  • POST_CODE3 : Company postal code (for large customers)
    Its data type is CHAR (Character String) with field length 10
  • PO_BOX : PO Box
    Its data type is CHAR (Character String) with field length 10
  • PO_BOX_LOC : PO Box city
    Its data type is CHAR (Character String) with field length 40
  • STREET : Street
    Its data type is CHAR (Character String) with field length 60
  • HOUSE_NUM1 : House Number
    Its data type is CHAR (Character String) with field length 10
  • STR_SUPPL1 : Street 2
    Its data type is CHAR (Character String) with field length 40
  • STR_SUPPL2 : Street 3
    Its data type is CHAR (Character String) with field length 40
  • STR_SUPPL3 : Street 4
    Its data type is CHAR (Character String) with field length 40
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • REGION : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • HOUSE_NUM2 : House number supplement
    Its data type is CHAR (Character String) with field length 10
  • LOCATION : Street 5
    Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Address – Communication Data
  • TEL_NUMBER : First telephone no.: dialling code+number
    Its data type is CHAR (Character String) with field length 30
  • TEL_EXTENS : First Telephone No.: Extension
    Its data type is CHAR (Character String) with field length 10
  • FAX_NUMBER : First fax no.: dialling code+number
    Its data type is CHAR (Character String) with field length 30
  • FAX_EXTENS : First fax no.: extension
    Its data type is CHAR (Character String) with field length 10