/SAPSRM/S_PDO_MDF_BO_AVL_IT SAP (Meta Data Configuration Fields for Vendor List Item) Structure details

Dictionary Type: Structure
Description: Meta Data Configuration Fields for Vendor List Item




ABAP Code to SELECT data from /SAPSRM/S_PDO_MDF_BO_AVL_IT
Related tables to /SAPSRM/S_PDO_MDF_BO_AVL_IT
Access table /SAPSRM/S_PDO_MDF_BO_AVL_IT




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

/SAPSRM/S_PDO_MDF_BO_AVL_IT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Meta Data Configuration Fields for Vendor List Item" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/SAPSRM/S_PDO_MDF_BO_AVL_IT TYPE /SAPSRM/S_PDO_MDF_BO_AVL_IT.

The /SAPSRM/S_PDO_MDF_BO_AVL_IT table consists of various fields, each holding specific information or linking keys about Meta Data Configuration Fields for Vendor List Item data available in SAP. These include GUID (Globally Unique identifier), PARENT (Parent GUID), NUMBER_INT (Item Number), CTR_GUID (Contract Template Item GUID).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP /SAPSRM/S_PDO_MDF_BO_AVL_IT structure 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
GUIDGlobally Unique identifier BBP_GUIDRAW16SYSUUID
PARENTParent GUID BBP_PGUIDRAW16SYSUUID
NUMBER_INTItem Number BBP_ITEM_NONUMC10CRM_ITEM_NO
CTR_GUIDContract Template Item GUID BBP_CTR_I_GUIDRAW16SYSUUID
CTR_HDR_GUIDGUID Contract BBP_CTR_H_GUIDRAW16SYSUUID
CTR_ITEM_NUMBERNumber of Contract Item BBP_CTR_ITEMNUMC10CRM_ITEM_NO
CTR_HDR_NUMBERContract Number BBP_CTR_IDCHAR10ALPHACRM_OBJECT_IDBBPH_CTR_LOCAL
CTR_LOG_SYSLogical System from Which the Contract Originates BBP_CTR_LOG_SYSTEMCHAR10Assigned to domainALPHALOGSYS
DEL_INDDeletion Indicator SRM Purchasing Document BBP_DEL_INDCHAR1XFELD
ITM_RELEASEDStatus of Item BBP_ITM_RELEASEDCHAR1BBP_ITM_RELEASED
DUMMY_EEW_PDISS_AVLDummy function in length 1 DUMMYCHAR1DUMMY
DUMMY_EEW_PDISC_AVLDummy function in length 1 DUMMYCHAR1DUMMY
TARGET_PERCENTTarget Percentage in Quota Arrangement BBP_TARGET_PERCENTAGEDEC5(2) BBP_VPROZ
QUOTA_BASE_AMTQuota Base Quantity BBP_QUOTA_BASE_AMOUNTQUAN13(3) MENG13
EXTERNAL_RANKVendor Rank BBP_EXTERNAL_RANK_AVLINT410INT4
COPY_OF_GUIDGUID Object is a Copy of BBP_COPY_OF_GUIDRAW16SYSUUID
HEADERGlobally Unique identifier BBP_GUIDRAW16SYSUUID
CREATED_BYName of Person who Created the Object ERNAMCHAR12USNAM
CREATED_ATTransaction was Created at this Time CRMT_CREATED_ATDEC15TSTPSBCOS_TSTMP
CHANGED_BYName of Person Responsible for Changing Object BBP_CHNAMCHAR12USNAM
CHANGED_ATTime of Last Change to the Transaction CRMT_CHANGED_ATDEC15TSTPSBCOS_TSTMP
DUMMY_EEW_PD_IT_SWD_AVLDummy function in length 1 DUMMYCHAR1DUMMY
DUMMY_EEW_PD_IT_CSD_AVLDummy function in length 1 DUMMYCHAR1DUMMY
VENDOR_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
VENDOR_NOBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
VENDOR_NAMESRM Business Partner Organization Name BBP_BP_NAME_ORGCHAR40BU_NAME
VENDOR_SETGlobally Unique identifier BBP_GUIDRAW16SYSUUID
MAINPARTNERMain Partner (For Ambiguous Partner Functions) CRMT_PARTNER_MAINCHAR1CRM_BOOLEAN
ADDR_TYPEAddress type (1=Organization, 2=Person, 3=Contact person) AD_ADRTYPECHAR1AD_ADRTYPE
ADDR_ORIGINOrigin for a Partner Address BBP_ADDR_ORIGINCHAR1BBP_ADDR_ORIGIN
EVAL_INDIndicator: Vendor Evaluation Active BBP_EVAL_INDCHAR1XFELD
EVAL_URLURL for Vendor Evaluation BBP_VE_URLCHAR1024CHAR1024
BASE_UNITUnit of Measure in Quota Arrangement BBP_QA_UNITUNIT3Assigned to domainCUNITMEINS
ACTUAL_PERCENTCurrent Percentage in Quota Arrangement BBP_ACTUAL_PERCENTAGEDEC5(2) BBP_VPROZ
GUARANTEED_MINGuaranteed Purchase Value (Public Sector ONLY!!) BBP_GUARANTEED_MINCURR15(2) WERT8
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
QUAN_PO_EQuantity of POs/Confirmations/Invoices Created for Contract BBP_PO_QUANT_EQUAN15(3) MENG15
FLAG_GM_FULFILLEDCheckbox XFELDCHAR1XFELD
CTR_DESCRIPTIONTransaction Description CRMT_PROCESS_DESCRIPTIONCHAR40CRM_PROCESS_DESCRIPTION
PERS_NOPerson number AD_PERSNUMCHAR10ADRPALPHAAD_PERSNUMCDTADDRESS
ADDR_NOAddress number AD_ADDRNUMCHAR10ADRCALPHAAD_ADDRNUMADR
TITLE_PTitle text AD_TITLETXCHAR30TEXT30
FIRSTNAMEFirst name AD_NAMEFIRCHAR40TEXT40
LASTNAMELast name AD_NAMELASCHAR40TEXT40
BIRTH_NAMEName of person at birth AD_NAME2_PCHAR40TEXT40
MIDDLENAMEMiddle name or second forename of a person AD_NAMEMIDCHAR40TEXT40
SECONDNAMESecond surname of a person AD_NAMLAS2CHAR40TEXT40
FULLNAMEFull Name of Person AD_NAMTEXTCHAR80TEXT80
FULLNAME_XStatus of Field 'Full Name' NAME_TEXT AD_NAMCONVCHAR1AD_NAMCONV
TITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
TITLE_ACA22nd academic title: written form AD_TITLE2TCHAR20TEXT20
PREFIX1Name prefix AD_PREFIXTCHAR20TEXT20
PREFIX22nd name prefix AD_PREFX2TCHAR20TEXT20
TITLE_SPPLName supplement, e.g. noble title (written form) AD_TITLESTCHAR20TEXT20
NICKNAMENickname or name used AD_NICKNAMCHAR40TEXT40
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
LANGU_PLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
LANGUP_ISO2-Character SAP Language Code LAISOCHAR2LAISO
SORT1_PSearch Term 1 AD_SORT1CHAR20CHAR20
SORT2_PSearch Term 2 AD_SORT2CHAR20CHAR20
DEPARTMENTDepartment AD_DPRTMNTCHAR40TEXT40
FUNCTIONFunction AD_FNCTNCHAR40TEXT40
BUILDING_PBuilding (number or code) AD_BLDNG_PCHAR10TEXT10
FLOOR_PFloor in building AD_FLOORCHAR10TEXT10
ROOM_NO_PRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
INITS_SIGShort name for correspondence AD_ID_CODECHAR10TEXT10
INHOUSE_MLInt. mail postal code AD_IH_MAILCHAR10TEXT10
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3TSACAD_COMM
TITLETitle text AD_TITLETXCHAR30TEXT30
NAMEName 1 AD_NAME1CHAR40TEXT40
NAME_2Name 2 AD_NAME2CHAR40TEXT40
NAME_3Name 3 AD_NAME3CHAR40TEXT40
NAME_4Name 4 AD_NAME4CHAR40TEXT40
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
CITY_NOCity code for city/street file AD_CITYNUMCHAR12ADRCITYALPHACITY_CODE
DISTRCT_NODistrict code for City and Street file AD_CITYPNMCHAR8ADRCITYPRTALPHACITYP_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PBOXCIT_NOCity PO box code (City file) AD_CIT2NUMCHAR12ADRCITYALPHACITY_CODE
DELIV_DIS(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10TZONEZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12ADRSTREETALPHASTRT_CODE
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGold: building (no. or abbreviation) AD_BLD_OLDCHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
LANGULanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
LANGU_ISO2-Character SAP Language Code LAISOCHAR2LAISO
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADR_NOTESAddress notes AD_REMARK1CHAR50TEXT50
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
BUILD_LONGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8Assigned to domainREGIOGROUP
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
HOMECITYNODifferent city for city/street file AD_CITYHNMCHAR12Assigned to domainALPHACITY_CODE
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3Assigned to domainREGIO
POBOX_CTRYPO box country AD_POBXCTYCHAR3Assigned to domainLAND1
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4Assigned to domainAD_NO_USE
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4Assigned to domainAD_NO_USE
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
LANGU_CR_PAddress record creation original language AD_LANGUCRLANG1Assigned to domainISOLASPRAS
LANGUCPISO2-Character SAP Language Code LAISOCHAR2LAISO
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DOC_PRIORITYDocument Priority BBP_DOC_PRIORITYCHAR4BBP_DOC_PRIORITY
PRIO_DESCRDescription of a Priority BBP_PRIO_DESCRIPTIONCHAR40BBP_PRIO_DESCRIPTION
PRIO_DISPLAYControl of Priority Display BBP_PRIO_DISPCHAR1Assigned to domainBBP_PRIO_DISP

Key field Non-key field



How do I retrieve data from SAP structure /SAPSRM/S_PDO_MDF_BO_AVL_IT using ABAP code?

As /SAPSRM/S_PDO_MDF_BO_AVL_IT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SAPSRM/S_PDO_MDF_BO_AVL_IT as there is no data to select.

How to access SAP table /SAPSRM/S_PDO_MDF_BO_AVL_IT

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