/1MD/MD______09W SAP (BP At/Rel BP_HEADER / COMPNY) Table details

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




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




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

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

The /1MD/MD______09W table consists of various fields, each holding specific information or linking keys about BP At/Rel BP_HEADER / COMPNY data available in SAP. These include USMDKBPBP_HEADER (Technical Key), /1MD/BPCOMPANY (Company Code), /1MD/BPASSGNM_ID (Multiple Assignment ID (Number)), 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______09W 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/BPCOMPANYCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
/1MD/BPASSGNM_IDMultiple Assignment ID (Number) MDG_BP_ASSIGNMENT_IDNUMC12MDG_BP_ASSIGNMENT_ID
USMD_ACTIVEActive/Inactive Data Record USMD_ACTIVECHAR1USMD_ACTIVE
/1MD/BPCUS_AKONTReconciliation Account in General Ledger AKONTCHAR10Assigned to domainALPHASAKNR
/1MD/BPCUS_BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
/1MD/BPCUS_BROBJAuthorization object BROBJCHAR10Assigned to domainXUOBJECT
/1MD/BPCUS_BUSABAccounting clerk BUSABCHAR2Assigned to domainBUSAB
/1MD/BPCUS_BWBERValuation Area for FI Year-End Closing BWBERCHAR2Assigned to domainBWBERBWB
/1MD/BPCUS_CESSNAccounts Receivable Pledging Indicator CESSION_KZCHAR2Assigned to domainCESSION_KZ
/1MD/BPCUS_FUTURFuture FFUTURECHAR1XFELD
/1MD/BPCUS_HBKIDShort Key for a House Bank HBKIDCHAR5Assigned to domainHBKID
/1MD/BPCUS_KTOPLChart of Accounts KTOPLCHAR4Assigned to domainKTOPLKPLC_KTOPL
/1MD/BPCUS_LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
/1MD/BPLOCKBKey of the Lockbox to Which the Customer Is To Pay LOCKBCHAR7Assigned to domainLCKID
/1MD/BPCUS_OVDUEDays Overdue OVDUENUMC3NUMC3
/1MD/BPCUS_TOGRUTolerance group for the business partner/G/L account TOGRUCHAR4Assigned to domainTOGRU
/1MD/BPWBRSLValue Adjustment Key WBRSLCHAR2Assigned to domainWBRSL
USMD_O_BP_CUS_CCObsolete Data Record USMD_OBSOLETECHAR1USMD_FLG
/1MD/BPCUS_ALTKNPrevious Master Record Number ALTKNCHAR10CHAR10
/1MD/BPCUS_BLNKZ(Obsolete) Subsidy Ind. for Determining the Reduction Rate MDG_BP_BLNKZCHAR2CHAR2
/1MD/BPCUS_DATLZDate of the last interest calculation run DATLZDATS8DATUM
/1MD/BPCUS_EIKTOOur account number at customer EIKTO_DCHAR12CHAR12
/1MD/BPCUS_FDGRVPlanning group FDGRVCHAR10Assigned to domainALPHAFDGRP
/1MD/BPCUS_FRGRPRelease Approval Group FRGRPCHAR4Assigned to domainFRGRP
/1MD/BPCUS_GUZTEPayment Terms Key for Credit Memos GUZTECHAR4ZTERM
/1MD/BPCUS_HWAERCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
/1MD/BPCUS_INTADInternet address of partner company clerk INTADCHAR130TXT130
/1MD/BPCUS_KULTGProbable time until check is paid KULTGDEC3PACK2
/1MD/BPCUS_KVERMMemo KVERMCHAR30TEXT30
/1MD/BPCUS_LOEVBDeletion Flag for Master Record (Company Code Level) LOEVM_BCHAR1XFELD
/1MD/BPCUS_MGRUPKey for dunning notice grouping MGRUPCHAR2Assigned to domainMGRUP
/1MD/BPCUS_NDELCDeletion bock for master record (company code level) NODEL_BCHAR1XFELD
/1MD/BPCUS_PERNRPersonnel Number PERNR_DNUMC8PERNRPER
/1MD/BPCUS_SPERBPosting block for company code SPERB_BCHAR1XFELD
/1MD/BPCUS_TLFNSAccounting clerk's telephone number at business partner TLFNSCHAR30CHAR30
/1MD/BPCUS_TLFXSAccounting clerk's fax number at the customer/vendor TLFXSCHAR31TEXT31
/1MD/BPCUS_UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
/1MD/BPCUS_VZSKZInterest calculation indicator VZSKZCHAR2Assigned to domainVZSKZ
/1MD/BPCUS_WEBTRBill of exchange limit (in local currency) WEBTRCURR13(2) WERT7
/1MD/BPCUS_XAUSZIndicator for periodic account statements XAUSZCHAR1Assigned to domainAUSZG
/1MD/BPCUS_XDEZVIndicator: Local processing? XDEZVCHAR1XFELD
/1MD/BPCUS_XEDIPIndicator: Send Payment Advices by EDI XEDIPCHAR1XFELD
/1MD/BPCUS_XPOREIndicator: Pay all items separately ? XPORECHAR1XFELD
/1MD/BPCUS_XVERRIndicator: Clearing between customer and vendor ? XVERR_KNB1CHAR1XFELD
/1MD/BPCUS_ZAHLSBlock Key for Payment DZAHLSCHAR1Assigned to domainZAHLS
/1MD/BPCUS_ZGRUPKey for Payment Grouping DZGRUPCHAR2Assigned to domainZGRUP
/1MD/BPCUS_ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
/1MD/BPCUS_ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
/1MD/BPCUS_ZSABEUser at customer DZSABE_DCHAR15TEXT15
/1MD/BPCUS_ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
/1MD/BPCUS_ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3Assigned to domainZUAWA
/1MD/BPCUS_ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
/1MD/BPEKVBDAccount Number of Buying Group EKVBDCHAR10Assigned to domainALPHAKUNNR
/1MD/BPKNRZBAccount number of an alternative payer KNRZBCHAR10Assigned to domainALPHAKUNNR
/1MD/BPKNRZEHead office account number (in branch accounts) KNRZECHAR10Assigned to domainALPHAKUNNR
/1MD/BPPERKZCollective invoice variant PERKZ_KNB1CHAR1PERKZ_KNB1
/1MD/BPREMITNext payee REMITCHAR10Assigned to domainALPHAKUNNR
/1MD/BPSREGLSelection Rule for Payment Advices SREGLCHAR3Assigned to domainSREGL
/1MD/BPURLIDShort Key for Known/Negotiated Leave URLIDCHAR4Assigned to domainURLID
/1MD/BPVERDTInsurance validity date VERDTDATS8DATUM
/1MD/BPVLIBBAmount Insured VLIBBCURR13(2) WERT7
/1MD/BPVRBKZExport credit insurance institution number VRBKZCHAR2VRBKZ
/1MD/BPVRSDGReason Code Conversion Version VRSDGCHAR3Assigned to domainVRSDG
/1MD/BPVRSNRInsurance number VRSNRCHAR10CHAR10
/1MD/BPVRSPRDeductible percentage rate VRSPRDEC3PACK2
/1MD/BPVRSZLInsurance lead months VRSZLDEC3PACK2
/1MD/BPWAKONTerms of payment key for bill of exchange charges WAKONCHAR4ZTERM
/1MD/BPXZVERIndicator: Record Payment History ? XZVERCHAR1XFELD
/1MD/BPZAMIBIndicator: Payment notice to the accounting department ? DZAMIBCHAR1XFELD
/1MD/BPZAMIMIndicator: Payment notice to customer (with cleared items)? DZAMIMCHAR1XFELD
/1MD/BPZAMIOIndicator: payment notice to customer (w/o cleared items)? DZAMIOCHAR1XFELD
/1MD/BPZAMIRIndicator: payment notice to legal department? DZAMIRCHAR1XFELD
/1MD/BPZAMIVIndicator: payment notice to sales department? DZAMIVCHAR1XFELD

Key field Non-key field



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

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

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

How to access SAP table /1MD/MD______09W

Within an ECC or HANA version of SAP you can also view further information about /1MD/MD______09W 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!