/1MD/MD______07V SAP (BP At/Rel BP_REL / HASWFAX) Table details
Dictionary Type: Table
Description: BP At/Rel BP_REL / HASWFAX
Description: BP At/Rel BP_REL / HASWFAX
ABAP Code to SELECT data from /1MD/MD______07V
Related tables to /1MD/MD______07V
Access table /1MD/MD______07V
Related tables to /1MD/MD______07V
Access table /1MD/MD______07V
Table field list including key, data, relationships and ABAP select examples
/1MD/MD______07V is a standard SAP Table which is used to store BP At/Rel BP_REL / HASWFAX data and is available within R/3 SAP systems depending on the version and release level.
The /1MD/MD______07V table consists of various fields, each holding specific information or linking keys about BP At/Rel BP_REL / HASWFAX data available in SAP. These include USMDKBPPARTNER1 (Technical Key), USMDKBPPARTNER2 (Technical Key), /1MD/BPBP_REL (Business Partner Relationship Category), /1MD/BPAD_CONSNO (Sequence Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP /1MD/MD______07V table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
USMDKBPPARTNER1 | Technical Key | USMD_TECH_KEY | INT4 | 10 | INT4 | ||||
USMDKBPPARTNER2 | Technical Key | USMD_TECH_KEY | INT4 | 10 | INT4 | ||||
/1MD/BPBP_REL | Business Partner Relationship Category | BU_RELTYP | CHAR | 6 | /1MD/MD______07R | BU_RELTYP | |||
/1MD/BPAD_CONSNO | Sequence Number | AD_CONSNUM | NUMC | 3 | NUMC3 | ||||
USMDKBPADDRNO | Technical Key | USMD_TECH_KEY | INT4 | 10 | INT4 | ||||
USMD_ACTIVE | Active/Inactive Data Record | USMD_ACTIVE | CHAR | 1 | USMD_ACTIVE | ||||
USMD_O_WP_FAX | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
/1MD/BPF_COUNTRY | Country for telephone/fax number | AD_COMCTRY | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
/1MD/BPF_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
/1MD/BPF_FLGDEFT | Standard Sender Address in this Communication Type | AD_FLGDFNR | CHAR | 1 | XFELD | ||||
/1MD/BPF_FLGNOUS | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 1 | XFELD | ||||
/1MD/BPF_NR_CALL | Fax number for finding sender | AD_FAXNRCL | CHAR | 30 | CHAR30 | ||||
/1MD/BPF_NR_LONG | Complete number: dialling code+number+extension | AD_FXNRLNG | CHAR | 30 | CHAR30 | ||||
/1MD/BPF_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
/1MD/BPF_VALID_F | Validity Date (Valid From) | BU_DATFROM | DATS | 8 | DATUM | ||||
/1MD/BPF_VALID_T | Validity Date (Valid To) | BU_DATTO | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table /1MD/MD______07V using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1MD/MD______07V to SELECT all data from the tableDATA: WA_/1MD/MD______07V TYPE /1MD/MD______07V.
SELECT SINGLE *
FROM /1MD/MD______07V
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______07V
WHERE...
How to access SAP table /1MD/MD______07V
Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______07V and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects