/1MD/MD______07A SAP (BP At/Rel BP_HEADER / HASPOSTAL) Table details

Dictionary Type: Table
Description: BP At/Rel BP_HEADER / HASPOSTAL




ABAP Code to SELECT data from /1MD/MD______07A
Related tables to /1MD/MD______07A
Access table /1MD/MD______07A




Table field list including key, data, relationships and ABAP select examples

/1MD/MD______07A is a standard SAP Table which is used to store BP At/Rel BP_HEADER / HASPOSTAL data and is available within R/3 SAP systems depending on the version and release level.

The /1MD/MD______07A table consists of various fields, each holding specific information or linking keys about BP At/Rel BP_HEADER / HASPOSTAL data available in SAP. These include USMDKBPBP_HEADER (Technical Key), /1MD/BPAD_NATION (Version ID for International Addresses), USMDKBPADDRNO (Technical Key), USMD_ACTIVE (Active/Inactive Data Record).. 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______07A 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
MANDTClient MANDTCLNT3T000MANDT
USMDKBPBP_HEADERTechnical Key USMD_TECH_KEYINT410/1MD/MD______0B4INT4
/1MD/BPAD_NATIONVersion ID for International Addresses AD_NATIONCHAR1Assigned to domainAD_NATIONADDRESS_NATION
USMDKBPADDRNOTechnical Key USMD_TECH_KEYINT410INT4
USMD_ACTIVEActive/Inactive Data Record USMD_ACTIVECHAR1USMD_ACTIVE
/1MD/BPREF_PSTALCity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
/1MD/BPRF_POSTALDistrict code for City and Street file AD_CITYPNMCHAR8Assigned to domainALPHACITYP_CODE
/1MD/BPRFE_POSTACity PO box code (City file) AD_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
/1MD/BPCTY_CODECity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
/1MD/BPREF_POSTACountry Key LAND1CHAR3Assigned to domainLAND1LND
/1MD/BPRFE_PSTALRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
/1MD/BPRFE_POSTSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
/1MD/BPRFE_POSTLTransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
USMD_O_AD_POSTALObsolete Data Record USMD_OBSOLETECHAR1USMD_FLG
/1MD/BPBUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
/1MD/BPCHCKSTATUCity file test status AD_CHECKSTCHAR1AD_CHECKST
/1MD/BPCITY1City BS_UI_AD_CITY1CHAR40TEXT40
/1MD/BPCO_NAMEc/o name AD_NAME_COCHAR40TEXT40
/1MD/BPDEFLTCOMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3Assigned to domainAD_COMM
/1MD/BPDISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
/1MD/BPDLVSRV_NRNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
/1MD/BPDLVSRV_TYType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
/1MD/BPDONTUSE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4Assigned to domainAD_NO_USE
/1MD/BPDONTUSE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4Assigned to domainAD_NO_USE
/1MD/BPFLAGGROUPFlag: There are more address group assignments AD_FLGGPCHAR1XFELD
/1MD/BPFLOORFloor in building AD_FLOORCHAR10TEXT10
/1MD/BPHOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
/1MD/BPHOUSE_NR1House Number AD_HSNM1CHAR10TEXT10
/1MD/BPHOUSE_NR2House number supplement AD_HSNM2CHAR10TEXT10
/1MD/BPLANGU_COMLanguage Key (Technical) SPRASTCHAR1Assigned to domainISOLASPRASTSPRSTRALAN_LANGUAGE_TECHNICAL
/1MD/BPLOCATIONStreet 5 AD_LCTNCHAR40TEXT40
/1MD/BPMC_CITY1City name in upper case for search help AD_MC_CITYCHAR25CHAR25
/1MD/BPMC_STREETStreet name in upper case for search help AD_MC_STRTCHAR25CHAR25
/1MD/BPPERS_ADDRFlag: This is a personal address AD_PRSADDRCHAR1XFELD
/1MD/BPPOBOX_CTYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
/1MD/BPPOBOX_LBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
/1MD/BPPOBOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
/1MD/BPPOBOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
/1MD/BPPOST_COD1City postal code AD_PSTCD1CHAR10CHAR10
/1MD/BPPOST_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
/1MD/BPPOST_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
/1MD/BPPO_BOXPO Box AD_POBXCHAR10CHAR10
/1MD/BPREGIOGROURegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
/1MD/BPROOMNUMRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
/1MD/BPSORT1_ADSearch Term 1 AD_SORT1CHAR20CHAR20
/1MD/BPSORT2_ADSearch Term 2 AD_SORT2CHAR20CHAR20
/1MD/BPSTREETStreet BS_UI_AD_STREETCHAR60TEXT60
/1MD/BPSTRSUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
/1MD/BPSTRSUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
/1MD/BPSTRSUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
/1MD/BPTAXJURCODTax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
/1MD/BPTIME_ZONEAddress time zone AD_TZONECHAR6Assigned to domainTZNZONE

Key field Non-key field



How do I retrieve data from SAP table /1MD/MD______07A using ABAP code

The following ABAP code Example will allow you to do a basic selection on /1MD/MD______07A to SELECT all data from the table
DATA: WA_/1MD/MD______07A TYPE /1MD/MD______07A.

SELECT SINGLE *
FROM /1MD/MD______07A
INTO CORRESPONDING FIELDS OF WA_/1MD/MD______07A
WHERE...

How to access SAP table /1MD/MD______07A

Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______07A and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!