CRMXIF_BT_OPPORT_ITEM SAP (XIF Opportunity Item) Structure details

Dictionary Type: Structure
Description: XIF Opportunity Item




ABAP Code to SELECT data from CRMXIF_BT_OPPORT_ITEM
Related tables to CRMXIF_BT_OPPORT_ITEM
Access table CRMXIF_BT_OPPORT_ITEM




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

CRMXIF_BT_OPPORT_ITEM 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 "XIF Opportunity 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_CRMXIF_BT_OPPORT_ITEM TYPE CRMXIF_BT_OPPORT_ITEM.

The CRMXIF_BT_OPPORT_ITEM table consists of various fields, each holding specific information or linking keys about XIF Opportunity Item data available in SAP. These include OBJECT_TASK (IF Business Transaction: Method Flag Item), ITEM_GUID (Item GUID for External Interface), ITEM_NUMBER (Item Number in Document), ITEM_NUMBER_EXT (External Item 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CRMXIF_BT_OPPORT_ITEM 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
OBJECT_TASKIF Business Transaction: Method Flag Item CRMXIF_BT_ITEM_TASKCHAR1CRMXIF_BT_OBJECT_TASK
ITEM_GUIDItem GUID for External Interface CRMXIF_ITEM_GUIDCHAR32SYSUUID_C
ITEM_NUMBERItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
ITEM_NUMBER_EXTExternal Item Number CRMT_ITEM_NO_EXTNUMC10
CREATED_ATTransaction was Created at this Time CRMT_CREATED_ATDEC15TSTPSBCOS_TSTMP
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
CHANGED_ATTime of Last Change to the Transaction CRMT_CHANGED_ATDEC15TSTPSBCOS_TSTMP
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
OBJECT_TYPECRM Item Object Type CRMT_SWO_OBJTYP_PROCESS_ITEMCHAR10CRMC_SUBOB_CAT_ICRM_OJ_NAME_PROCESS_ITEM
ITEM_TYPEItem Category CRMT_ITEM_TYPECHAR4CRMC_ITEM_TYPECRM_ITEM_TYPECRM_ITEM_TYPE
PARENT_ITEMItem GUID for External Interface CRMXIF_ITEM_GUIDCHAR32SYSUUID_C
NUMBER_PARENTHigher-Level Item Number in Document CRMT_ITEM_NO_PARENTNUMC10CRM_ITEM_NO
ALTERNATIVE_ITEMItem GUID for External Interface CRMXIF_ITEM_GUIDCHAR32SYSUUID_C
NUMBER_ALTERNItem for Which This Item is an Alternative in the Document CRMT_ITEM_NO_ALTERNATIVENUMC10CRM_ITEM_NO
ITEM_LANGUAGEShort Text Language for an Item CRMT_ITEM_LANGULANG1ISOLASYLANGU
ITEM_LANGUAGE_ISOLanguage Key (ISO) CRMXIF_LANGUAGE_ISOCHAR2LAISO
ORDER_DATEPosting Date CRMT_ORDER_DATEDEC15TSTPSBCOS_TSTMP
SUBSTITUT_REASONReason for Product Substitution CRMT_ITEM_SUBSTITUTIONCHAR4Assigned to domainCRM_ITEM_SUBSTITUTION
ITEM_USAGEUsage of Higher-Level Item CRMT_ITEM_USAGECHAR2CRM_ITEM_USAGE
ITEM_TYPE_USAGEItem Category Usage CRMT_IT_TYPE_USAGECHAR4Assigned to domainCRM_IT_TYPE_USAGE
ORDERED_PRODUCTProduct Name Entered CRMT_ORDERED_PRODCHAR54CRM_ORDERED_PRODCRM_ORDERED_PRODUCT
PRODUCT_DESCRIPTIONProduct Description COMT_PRSHTEXTXCHAR40PRSHTEXT40
PRODUCT_GTINGlobal Trade Item Number (GTIN) COMT_GTINCHAR40GTIN1COM_GTIN
DESCRIPTION_UCProduct Description in Uppercase for F4 Help COMT_PRSHTEXTGCHAR40PRSHTEXTG40
PRODUCT_GUIDProduct Number (Internal) CRMXIF_PRODUCT_GUIDCHAR32SYSUUID_C
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
PRODUCT_ID_40Value of a Product ID or Individual Object COMT_ALTID_VALUE_UICHAR54COM_ALTID_VALUE_SHORTCOM_PR_ALTID
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
PRODUCT_KINDTechnnical Type of Product CRMT_PRODUCT_KINDCHAR1CRM_PRODUCT_KIND
CAT_IDCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
CONFIGURATION 0
DATA 0
CONSISTSCE consistency SMO_CONSISCHAR1SMO_TEXT1
COMPLETEComplete ? SMO_COMPLTCHAR1SMO_LOGICL
SPRASLanguage SMO_LANGUCHAR2SMO_LANGU
KBPROFILESCE: Profile of Knowledge base SMO_PROFNMCHAR30SMO_TXT30
KBBUILDBuild Counter knowledge base SMO_KBUILDCHAR8SMO_CHOI8
KBNAMEName of knowledge base (lang. inedependent) SMO_KBNAMECHAR72SMO_TEXT72
KBVERSKnowledge base version SMO_KBVERSCHAR30SMO_TXT30
SCEVERSSCE version SMO_SPEVERCHAR8SMO_TXT8
CFGINFOCFG Information SMO_CFGINFCHAR250SMO_TXT250
INSTANCE 0
INPUT_FIELDS 0
CONSISTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COMPLETEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SPRASUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KBPROFILEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KBBUILDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KBNAMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KBVERSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SCEVERSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CFGINFOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
PRICING_RESULT 0
DATA 0
TAX_DEPART_CTYTax Departure Country CRMT_TAX_DEPART_CTYCHAR3LAND1
TAX_DEPART_CTY_ISOCountry Key (ISO) CRMXIF_LAND_ISOCHAR2INTCA
TAX_DEPART_REGDeparture Region for Tax CRMT_TAX_DEPART_REGCHAR3REGIO
TAXJURCODE_FROMTax Jurisdiction Code (Structure for tax calculation) CRMT_TAXJURCODECHAR15TXJCDCRM_TAX_SH_TAXJURCODE
TAX_GROUP_PProduct Tax Group CRMT_TAX_GROUPCHAR20CRM_TAX_GROUP
TAX_TARIFF_CODETax Tariff Code CRMT_TAX_TARIFF_CODECHAR16CHAR16
STATISTICALStatistical values CRMT_STATISTICALCHAR1CRM_STATISTICAL
PRC_INDICATORPricing indicator CRMT_PRICING_INDICATORCHAR1CRM_PRICING_INDICATOR
NET_VALUECurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
NET_PRICECurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
TAX_AMOUNTCurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
FREIGHTCurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
GROSS_VALUECurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
NET_WO_FREIGHTCurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
SUBTOTAL1Currency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
SUBTOTAL2Currency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
SUBTOTAL3Currency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
SUBTOTAL4Currency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
SUBTOTAL5Currency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
SUBTOTAL6Currency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
CREDIT_INDICATORCredit Debit Indicator CRMT_CREDIT_INDICATORCHAR1CRMT_CREDIT_INDICATOR
NET_VALUE_MANCurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
TARGET_VALUECurrency amount in BAPI interfaces BAPICURR_DDEC23(4) BAPICURR
CASHFLOW_TYPEFlow Category CRMT_CASHFLOW_TYPECHAR4CRMT_CASHFLOW_TYPE
NETPR_PRIC_UNITCondition Pricing Unit PRCT_COND_PRICING_UNITDEC5PRC_CONDITION_PRICING_UNIT
NETPR_UOMCondition Unit PRCT_COND_UOMUNIT3CUNITMEINS
INPUT_FIELDS 0
TAX_DEPART_CTYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_DEPART_CTY_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_DEPART_REGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAXJURCODE_FROMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_GROUP_PUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_TARIFF_CODEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
STATISTICALUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRC_INDICATORUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_VALUEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_PRICEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_AMOUNTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FREIGHTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GROSS_VALUEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_WO_FREIGHTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SUBTOTAL1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SUBTOTAL2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SUBTOTAL3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SUBTOTAL4Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SUBTOTAL5Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SUBTOTAL6Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CREDIT_INDICATORUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_VALUE_MANUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TARGET_VALUEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CASHFLOW_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NETPR_PRIC_UNITUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NETPR_UOMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
PRODUCT_DATA 0
DATA 0
GROSS_WEIGHTGross Weight CRMT_GROSS_WEIGHTQUAN15(3) MENG15
NET_WEIGHTNet Weight CRMT_NET_WEIGHTQUAN15(3) MENG15
WEIGHT_UNITWeight Unit COMT_WEIGHT_UNITUNIT3CUNITMEINS
WEIGHT_UNIT_ISOUnit of Measurement (IS0) CRMXIF_UNIT_ISOCHAR3ISOCD_UNIT
VOLUMEVolume Occupied by the Product per Volume Unit CRMT_VOLUMEQUAN15(3) MENG15
VOLUME_UNITUnit for the Volume of a Product COMT_VOLUME_UNITUNIT3CUNITMEINS
VOLUME_UNIT_ISOUnit of Measurement (IS0) CRMXIF_UNIT_ISOCHAR3ISOCD_UNIT
PRICE_PRODUCTPricing Reference Product Globally Unique Identifier CRMT_PRICE_PRODUCTRAW16SYSUUID
PRICE_PRODUCT_IDPricing Reference Product CRMT_PRICE_PRODUCT_IDCHAR40PRID1COM_PRODUCT_ID
PROCESS_QTY_NUMNumerator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_NUMINT410CRM_PROCESS_QTY_NUM
PROCESS_QTY_DENDenominator (factor) for conversion trans. quantity in BME CRMT_PROCESS_QTY_DENINT410CRM_PROCESS_QTY_DEN
EXPONENT1010 Exponent for Quantity Conversion CRMT_EXPONENT10INT25CRM_EXPONENT10
PROCESS_QTY_UNITUnit of Measure in Which the Product Is Sold CRMT_PROCESS_QTY_UNITUNIT3CUNITMEINS
PROCESS_QTY_UNIT_ISOUnit of Measurement (IS0) CRMXIF_UNIT_ISOCHAR3ISOCD_UNIT
COMM_GROUPCommission Group CRMT_COMM_GROUPCHAR2CRM_COMM_GROUP
REBATE_GROUPVolume Rebate Group CRMT_REBATE_GROUPCHAR2CRM_REBATE_GROUP
CASH_DISCSpecifies Whether a Cash Discount Can Be Given for the Prod. CRMT_CASH_DISCCHAR1XFELD
PROD_PR_GROUPProduct Group CRMT_PROD_PR_GROUPCHAR2CRM_PROD_PR_GROUP
PRC_GROUP1Product Group 1 CRMT_PRC_GROUP1CHAR3CRM_PRC_GROUP1
PRC_GROUP2Product Group 2 CRMT_PRC_GROUP2CHAR3CRM_PRC_GROUP2
PRC_GROUP3Product Group 3 CRMT_PRC_GROUP3CHAR3CRM_PRC_GROUP3
PRC_GROUP4Product Group 4 CRMT_PRC_GROUP4CHAR3CRM_PRC_GROUP4
PRC_GROUP5Product Group 5 CRMT_PRC_GROUP5CHAR3CRM_PRC_GROUP5
PROD_HIERARCHYProduct Category CRMT_PROD_HIERARCHYCHAR20COM_CATEGORY_IDCOM_CAT_SALES
RESID_VALUE_STResidual Value Strategy CRMT_RESID_VALUE_STCHAR3CRMT_RESID_VALUE_ST
RESID_VALUE_GRPResidual Value Curve CRMT_RESID_VALUE_GRPCHAR3CRMT_RESID_VALUE_GRP
BASE_QTY_UNITBase Unit of Measure of Product COMT_PRODUCT_BASE_UOMUNIT3CUNITMEINS
BASE_QTY_UNIT_ISOUnit of Measurement (IS0) CRMXIF_UNIT_ISOCHAR3ISOCD_UNIT
BATCH_IDBatch Number CRMT_BATCH_IDCHAR10BATCH_IDCHA
INT_INSPECTIONInternal Quality Inspection CRMT_INT_INSPECTIONCHAR4CRM_ITEM_INSPECTION
INPUT_FIELDS 0
GROSS_WEIGHTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NET_WEIGHTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
WEIGHT_UNITUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
WEIGHT_UNIT_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VOLUMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VOLUME_UNITUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VOLUME_UNIT_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRICE_PRODUCTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRICE_PRODUCT_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROCESS_QTY_NUMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROCESS_QTY_DENUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
EXPONENT10Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROCESS_QTY_UNITUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROCESS_QTY_UNIT_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
COMM_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REBATE_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CASH_DISCUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROD_PR_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRC_GROUP1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRC_GROUP2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRC_GROUP3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRC_GROUP4Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRC_GROUP5Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PROD_HIERARCHYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
RESID_VALUE_STUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
RESID_VALUE_GRPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BASE_QTY_UNITUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BASE_QTY_UNIT_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BATCH_IDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INT_INSPECTIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
CUSTOMER_I 0
DATA 0
CUSTOMER_INTDummy function in length 1 DUMMYCHAR1DUMMY
CUSTOMER_EXTDummy function in length 1 DUMMYCHAR1DUMMY
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
STATUS 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
DOC_FLOW 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
TEXT 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
SCHEDULE_LINES 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
TOTAL_QUANTITY 0
DATA 0
ORDER_QTYCRM: Order Quantity CRMT_QTY_ORDERQUAN13(3) MENG13
CONFIRMED_QTYCRM: Confirmed Quantity CRMT_QTY_CONFIRMEDQUAN13(3) MENG13
NUMBER_CONFIRMEDCRM Number Confirmation Schedule Line CRMT_SCHEDLIN_COUNT_CONFIRMEDINT25CRM_SCHEDLIN_COUNT
LATEST_TIME_CONFLatest Confirmation Date for an Item CRMT_SCHEDLIN_LTIME_CONFIRMEDDEC15TSTPSBCOS_TSTMP
INPUT_FIELDS 0
ORDER_QTYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CONFIRMED_QTYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
NUMBER_CONFIRMEDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LATEST_TIME_CONFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
ORGDATA 0
DATA 0
SALES_ORGSales Organization CRMT_SALES_ORGCHAR14HROBJEC_14CRM_ORGMAN_SALES_ORG
SALES_OFFICESales Office CRMT_SALES_OFFICECHAR14HROBJEC_14CRM_ORGMAN_SALES_OFFICE
SALES_GROUPSales Group CRMT_SALES_GROUPCHAR14HROBJEC_14CRM_ORGMAN_SALES_GROUP
SALES_ORG_RESPOrganizational Unit (Sales) CRMT_SALES_ORG_RESPCHAR14HROBJEC_14
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2CRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2CRM_DIVISIONCRM_DIVISION
SERVICE_ORGService Organization CRMT_SERVICE_ORGCHAR14HROBJEC_14CRM_ORGMAN_SERVICE_ORG
SERV_ORG_SHORTService Organization Identifier CRMT_SERVICE_ORG_SHORTCHAR12TEXT12
SERVICE_ORG_RESPOrganizational Unit (Service) CRMT_SERVICE_ORG_RESPCHAR14HROBJEC_14
SER_ORGRESP_SHTAbbreviation: Responsible Organizational Unit (Service) CRMT_SERVICE_ORG_RESP_SHORTCHAR12TEXT12
PURCH_ORGPurchasing Organization CRMT_PURCH_ORGCHAR14HROBJEC_14
PURCH_GROUPPurchasing Group CRMT_PURCH_GROUPCHAR14HROBJEC_14
PURCH_ORG_RESPOrganizational Unit (Purchasing) CRMT_PURCH_ORG_RESPCHAR14HROBJEC_14
DISTRICTDistrict CRMT_DISTRICTCHAR6CRM_DISTRICT
ORGUNIT_SAL_SELConcatenated Identification (Type and ID) of Org.Objects HROBJEC_14CHAR14HROBJEC_14
ORGUNIT_SER_SELConcatenated Identification (Type and ID) of Org.Objects HROBJEC_14CHAR14HROBJEC_14
DIS_CHANNEL_SELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2CRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
INPUT_FIELDS 0
SALES_ORGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SALES_OFFICEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SALES_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SALES_ORG_RESPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DIS_CHANNELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DIVISIONUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SERVICE_ORGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SERV_ORG_SHORTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SERVICE_ORG_RESPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SER_ORGRESP_SHTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PURCH_ORGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PURCH_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PURCH_ORG_RESPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DISTRICTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ORGUNIT_SAL_SELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ORGUNIT_SER_SELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DIS_CHANNEL_SELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
PRICING_PARAMS 0
DATA 0
TAXJURCODETax Jurisdiction Code (Structure for tax calculation) CRMT_TAXJURCODECHAR15TXJCDCRM_TAX_SH_TAXJURCODE
CUST_PRIC_PROCCustomer Pricing Procedure CRMT_CUST_PRIC_PROCCHAR1CRM_CUST_PRIC_PROC
PRICE_DATEPricing Date CRMT_PRICE_DATEDATS8CRM_PRICE_DATE
PAYMENT_TERMSTerms of Payment CRMT_PMNTTRMSCHAR4CRM_PMNTTRMS
DAYS_FROM_1Days From Payment Deadline Base Date 1st Level CRMT_DAYS_FROM_1NUMC3NUM03
PERCENTAGE_1Cash Discount Rate, Level 1 CRMT_PERCENTAGE_1DEC5(3) PRZ23
DAYS_FROM_2Days from payment deadline base date, 2nd level CRMT_DAYS_FROM_2NUMC3NUM03
PERCENTAGE_2Casn Discount Rate, Level 2 CRMT_PERCENTAGE_2DEC5(3) PRZ23
DAYS_FROM_3Days from Payment Deadline Base Date (Due Date Net Payment) CRMT_DAYS_FROM_3NUMC3NUM03
PRICE_GRPCustomer Price Group CRMT_PRICE_GRPCHAR2CRM_PRICE_GRPCRM_PRICE_GRP
PRICE_LISTPrice List Type CRMT_PRICE_LISTCHAR2CRM_PRICE_LISTCRM_PRICE_LIST
CUST_GROUPCustomer Group CRMT_CUST_GROUPCHAR2CRM_CUST_GROUP
TAX_DEST_CTYTax Destination Country CRMT_TAX_DEST_CTYCHAR3LAND1
TAX_DEST_CTY_ISOCountry Key (ISO) CRMXIF_LAND_ISOCHAR2INTCA
TAX_DEST_REGRegion (State, Province, County) CRMT_REGIONCHAR3REGIO
VAT_REG_NOSales tax registration number CRMT_VAT_REG_NOCHAR20
EXCHG_TYPEExchange Rate Type CRMT_EXCHG_TYPECHAR4KURST
EXCHG_DATEExchange Rate Date CRMT_EXCHG_DATEDATS8CRM_EXCHG_DATE
REF_CURRENCYReference Currency CRMT_REF_CURRENCYCUKY5WAERS
REF_CURRENCY_ISOCurrency Key CRMXIF_CURRENCY_ISOCHAR3ISOCD
CURRENCYCurrency CRMT_CURRENCYCUKY5WAERSFWS
CURRENCY_ISOCurrency Key CRMXIF_CURRENCY_ISOCHAR3ISOCD
EXCHG_RATEExchange Rate CRMT_EXCHG_RATEDEC9(5) EXCRTCRM_EXCHG_RATE
ETAX_HAND_TYPEExcise Tax Handling Type (Denotes Use of Material) CRMT_ETAX_HAND_TYPECHAR2CRM_ETAX_HAND_TYPE
ETAX_SOURCESource of Excise Tax Rates CRMT_ETAX_SOURCECHAR2CRM_ETAX_SOURCE
GRADERating BP_GRADECHAR10BP_GRADE
AC_INDICATORAccounting Indicator CRMT_AC_INDICATORCHAR2CRMT_AC_INDICATOR
CFOP_CODECFOP Code and Extension ITL_CFOPCHAR10CFOBRITL_CFOP
ICMS_TAXLAWICMS Tax Law ID ITL_TAXLAW1CHAR3ALPHAITL_TAXLAW1
IPI_TAXLAWIPI Tax Law ID ITL_TAXLAW2CHAR3ALPHAITL_TAXLAW2
TAX_MAT_USAGEMaterial Usage TAX_MAT_USAGECHAR1TAX_MAT_USAGE
VALID_FROMTime Dependency: Validity Start Date CRMT_VALID_FROMDEC15TSTPSBCOS_TSTMP
VALID_TOTime Dependency: Validity End Date CRMT_VALID_TODEC15TSTPSBCOS_TSTMP
TRANS_TIMETime Last Change was Made CRMT_TRANS_TIMEDEC15TSTPSBCOS_TSTMP
INPUT_FIELDS 0
TAXJURCODEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CUST_PRIC_PROCUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRICE_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PAYMENT_TERMSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DAYS_FROM_1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERCENTAGE_1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DAYS_FROM_2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERCENTAGE_2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DAYS_FROM_3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRICE_GRPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRICE_LISTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CUST_GROUPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_DEST_CTYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_DEST_CTY_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_DEST_REGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VAT_REG_NOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
EXCHG_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
EXCHG_DATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REF_CURRENCYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REF_CURRENCY_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CURRENCYUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CURRENCY_ISOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
EXCHG_RATEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ETAX_HAND_TYPEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ETAX_SOURCEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
GRADEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
AC_INDICATORUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CFOP_CODEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ICMS_TAXLAWUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
IPI_TAXLAWUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TAX_MAT_USAGEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VALID_FROMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VALID_TOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TRANS_TIMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
PARTNER 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
PRICE_CONDITIONS 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
DATES 0
DATA 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE
PRODUCT_LIST 0
DATA 0
PRODUCTS 0
OBJECTS 0
DATAXInformation on Changes to Transaction Data Structure/Table CRMXIF_BT_UPDATECHAR1BAPIUPDATE

Key field Non-key field



How do I retrieve data from SAP structure CRMXIF_BT_OPPORT_ITEM using ABAP code?

As CRMXIF_BT_OPPORT_ITEM 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 CRMXIF_BT_OPPORT_ITEM as there is no data to select.

How to access SAP table CRMXIF_BT_OPPORT_ITEM

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