/1FB/MD___M800ZR SAP (BW-Attribute fuer Provisional Material) Table details

Dictionary Type: Table
Description: BW-Attribute fuer Provisional Material




ABAP Code to SELECT data from /1FB/MD___M800ZR
Related tables to /1FB/MD___M800ZR
Access table /1FB/MD___M800ZR




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

/1FB/MD___M800ZR is a standard SAP Table which is used to store BW-Attribute fuer Provisional Material data and is available within R/3 SAP systems depending on the version and release level.

The /1FB/MD___M800ZR table consists of various fields, each holding specific information or linking keys about BW-Attribute fuer Provisional Material data available in SAP. These include /1FB/CEPMAT (Provisional Material), /1FB/AF_COLOR (AFS Elementary Field 'Color'), /1FB/AF_FCOCO (AFS Fabric Content Code), /1FB/AF_GENDER (AFS Target Group).. 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: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP /1FB/MD___M800ZR 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
/1FB/CEPMATProvisional Material /1FB/MD_________M8300R6CHAR18/1FB/MD___M800QF
/1FB/AF_COLORAFS Elementary Field 'Color' /1FB/MD_________M8300UXCHAR5/1FB/MD___M800O5
/1FB/AF_FCOCOAFS Fabric Content Code /1FB/MD_________M8300YICHAR5/1FB/MD___M800O6
/1FB/AF_GENDERAFS Target Group /1FB/MD_________M8300YFCHAR2/1FB/MD___M800O7
/1FB/AF_GRIDAFS Grid /1FB/MD_________M8300XMCHAR18/1FB/MD___M800O8
/1FB/AF_STYLEAFS Style /1FB/MD_________M8300XFCHAR18
/1FB/APO_PRODProduct /1FB/MD_________M8300XOCHAR40/1FB/MD___M800OA
/1FB/BASE_UOMBase Unit of Measure /1FB/MD_________M8300YSUNIT3
/1FB/BASIC_MATLBasic Material /1FB/MD_________M8300Q8CHAR14
/1FB/BBP_PRODProduct /1FB/MD_________M8300R5CHAR32/1FB/MD___M800PW
/1FB/COMPETITORCompetitors /1FB/MD_________M8300HMCHAR10/1FB/MD___M800KQ
/1FB/CONT_UNITContent Unit /1FB/MD_________M8300HBUNIT3
/1FB/CREATEDONDate on which the record was created /1FB/MD_________M8300LTDATS8
/1FB/CRM_PRODProduct /1FB/MD_________M8300NUCHAR32/1FB/MD___M800KM
/1FB/DF_DGNRHazardous Material Number /1FB/MD_________M8300L9CHAR18
/1FB/DF_PROFILEProfile for Dangerous Goods Indicator /1FB/MD_________M8300L7CHAR3/1FB/MD___M800LE
/1FB/DIVISIONDivision /1FB/MD_________M8300L4CHAR2/1FB/MD___M800LG
/1FB/EANUPCEuropean Article Number/Universal Produc /1FB/MD_________M8300KZCHAR18/1FB/MD___M800LI
/1FB/EXTMATLGRPExternal Material Group /1FB/MD_________M8300JXCHAR18
/1FB/GROSS_CONTGross Content /1FB/MD_________M8300KDQUAN17(3)
/1FB/GROSS_WTGross weight /1FB/MD_________M8300KBQUAN17(3)
/1FB/HC_AGENT1Active Ingredient 1 (Main Active Ingredi /1FB/MD_________M8300K6CHAR20/1FB/MD___M800NE
/1FB/HC_AGENT2Active Ingredient 2 /1FB/MD_________M8300K5CHAR20/1FB/MD___M800NE
/1FB/HC_AGENT3Active Ingredient 3 /1FB/MD_________M8300K4CHAR20/1FB/MD___M800NE
/1FB/HC_ANESINDAnesthetic Indicator /1FB/MD_________M8300K7CHAR1
/1FB/HC_APPRTYPApproval Type /1FB/MD_________M8300K9CHAR2/1FB/MD___M800NF
/1FB/HC_ATCCODEATC Code /1FB/MD_________M8300KCCHAR20/1FB/MD___M800QM
/1FB/HC_ATCMTYPType of Med. Category for ATC Code /1FB/MD_________M8300KECHAR3/1FB/MD___M800MY
/1FB/HC_CATIND1Catalog 1 Indicator /1FB/MD_________M8300KHCHAR1
/1FB/HC_CATIND2Catalog 2 Indicator /1FB/MD_________M8300JRCHAR1
/1FB/HC_CATIND3Catalog 3 Indicator /1FB/MD_________M8300JUCHAR1
/1FB/HC_HAZMINDHazardous Substance Indicator /1FB/MD_________M8300JWCHAR1
/1FB/HC_IMPMINDImport Material Indicator /1FB/MD_________M8300JZCHAR1
/1FB/HEIGHTHeight /1FB/MD_________M8300KYQUAN17(3)
/1FB/IND_SECTORIndustry sector /1FB/MD_________M8300KVCHAR1
/1FB/LENGHTLength /1FB/MD_________M8300IGQUAN17(3)
/1FB/LOC_CURRCYLocal currency /1FB/MD_________M8300IJCUKY5
/1FB/LOGSYSSource System /1FB/MD_________M8300JECHAR10/1FB/MD___M800MS
/1FB/MANUFACTORManufacturer /1FB/MD_________M8300J4CHAR10/1FB/MD___M800LP
/1FB/MANU_MATNRManufacturer Part Number /1FB/MD_________M8300J6CHAR40
/1FB/MATL_CATMaterial Category /1FB/MD_________M8300NACHAR2/1FB/MD___M800MW
/1FB/MATL_GROUPMaterial group /1FB/MD_________M8300NCCHAR9/1FB/MD___M800MX
/1FB/MATL_TYPEMaterial type /1FB/MD_________M8300NFCHAR4/1FB/MD___M800MI
/1FB/MSA_USAGEUsage /1FB/MD_________M8300MXCHAR10/1FB/MD___M800NJ
/1FB/NET_CONTNet Content /1FB/MD_________M8300N7QUAN17(3)
/1FB/NET_WEIGHTNet Weight of Item /1FB/MD_________M8300O1QUAN17(3)
/1FB/PO_UNITOrder unit /1FB/MD_________M8300GOUNIT3
/1FB/PROD_HIERProduct hierarchy /1FB/MD_________M8300WCCHAR18/1FB/MD___M800LU
/1FB/RF_BNDIDBrand /1FB/MD_________M8300UVCHAR4/1FB/MD___M800MC
/1FB/RF_FRECHARGeneral Analysis Characteristic /1FB/MD_________M8300UBCHAR18
/1FB/RF_SIZE2Size 2 /1FB/MD_________M8300UECHAR18/1FB/MD___M800LQ
/1FB/RPA_WGH1Material Group Hierarchy Level 1 /1FB/MD_________M8300VLCHAR9/1FB/MD___M800LS
/1FB/RPA_WGH2Material Group Hierarchy Level 2 /1FB/MD_________M8300UZCHAR9/1FB/MD___M800LT
/1FB/RPA_WGH3Material Group Hierarchy Level 3 /1FB/MD_________M8300V2CHAR9/1FB/MD___M800M0
/1FB/RPA_WGH4Material Group Hierarchy Level 4 /1FB/MD_________M8300V6CHAR9/1FB/MD___M800P6
/1FB/RTPLCSTPlanned Purchase Price /1FB/MD_________M8300YLCURR17(2)
/1FB/RT_COLORColor /1FB/MD_________M8300YUCHAR18/1FB/MD___M800P7
/1FB/RT_CONFMATCross-Plant Configur. Material /1FB/MD_________M8300YHCHAR18
/1FB/RT_FASHGRDFashion Grade /1FB/MD_________M8300YMCHAR4/1FB/MD___M800P8
/1FB/RT_MDRELSTMaster Data Release Status /1FB/MD_________M8300XRCHAR1/1FB/MD___M800P9
/1FB/RT_PRBANDPrice Band Category /1FB/MD_________M8300XQCHAR2/1FB/MD___M800PA
/1FB/RT_PRRULEProcurement Rule /1FB/MD_________M8300Y3CHAR1/1FB/MD___M800PB
/1FB/RT_SEAROLLCollection /1FB/MD_________M8300XECHAR2/1FB/MD___M800RK
/1FB/RT_SEASONSeason Category /1FB/MD_________M8300YKCHAR4/1FB/MD___M800PC
/1FB/RT_SEASYRSeason Year /1FB/MD_________M8300YTNUMC4/1FB/MD___M800Q4
/1FB/RT_SEAYRSeason Year /1FB/MD_________M8300QACHAR4
/1FB/RT_SIZESize /1FB/MD_________M8300QECHAR18/1FB/MD___M800PD
/1FB/RT_SUPSSource of Supply /1FB/MD_________M8300QJCHAR1/1FB/MD___M800PT
/1FB/SIZE_DIMSize/Dimension /1FB/MD_________M8300P2CHAR32
/1FB/STD_DESCRIndustry Standard Description (such as D /1FB/MD_________M8300P8CHAR18
/1FB/UCCERTIFTYType of Certification /1FB/MD_________M8300T1CHAR2/1FB/MD___M800L6
/1FB/UCCONSTCLAConstruction Class /1FB/MD_________M8300TWCHAR8/1FB/MD___M800L7
/1FB/UCFUNCCLASFunction Class /1FB/MD_________M8300U0CHAR8/1FB/MD___M800L8
/1FB/UNIT_DIMUnit of Dimension for Length/Width/Heigh /1FB/MD_________M8300U5UNIT3
/1FB/UNIT_OF_WTWeight unit /1FB/MD_________M8300THUNIT3
/1FB/VENDORVendor /1FB/MD_________M8300RBCHAR10/1FB/MD___M800LP
/1FB/VOLUMEVolume /1FB/MD_________M8300SPQUAN17(3)
/1FB/VOLUMEUNITVolume unit /1FB/MD_________M8300S4UNIT3
/1FB/WIDTHWidth /1FB/MD_________M8300S6QUAN17(3)

Key field Non-key field



How do I retrieve data from SAP table /1FB/MD___M800ZR using ABAP code

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

SELECT SINGLE *
FROM /1FB/MD___M800ZR
INTO CORRESPONDING FIELDS OF WA_/1FB/MD___M800ZR
WHERE...

How to access SAP table /1FB/MD___M800ZR

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