CRMXIF_BT_OPPORT_ITEM SAP (XIF Opportunity Item) Structure details
Description: XIF Opportunity 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_TASK | IF Business Transaction: Method Flag Item | CRMXIF_BT_ITEM_TASK | CHAR | 1 | CRMXIF_BT_OBJECT_TASK | ||||
ITEM_GUID | Item GUID for External Interface | CRMXIF_ITEM_GUID | CHAR | 32 | SYSUUID_C | ||||
ITEM_NUMBER | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | CRM_ITEM_NO | ||||
ITEM_NUMBER_EXT | External Item Number | CRMT_ITEM_NO_EXT | NUMC | 10 | |||||
CREATED_AT | Transaction was Created at this Time | CRMT_CREATED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
CREATED_BY | User that Created the Transaction | CRMT_CREATED_BY | CHAR | 12 | UNAME | USER_ADDR | |||
CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC | 15 | TSTPS | BCOS_TSTMP | |||
CHANGED_BY | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR | 12 | UNAME | ||||
OBJECT_TYPE | CRM Item Object Type | CRMT_SWO_OBJTYP_PROCESS_ITEM | CHAR | 10 | CRMC_SUBOB_CAT_I | CRM_OJ_NAME_PROCESS_ITEM | |||
ITEM_TYPE | Item Category | CRMT_ITEM_TYPE | CHAR | 4 | CRMC_ITEM_TYPE | CRM_ITEM_TYPE | CRM_ITEM_TYPE | ||
PARENT_ITEM | Item GUID for External Interface | CRMXIF_ITEM_GUID | CHAR | 32 | SYSUUID_C | ||||
NUMBER_PARENT | Higher-Level Item Number in Document | CRMT_ITEM_NO_PARENT | NUMC | 10 | CRM_ITEM_NO | ||||
ALTERNATIVE_ITEM | Item GUID for External Interface | CRMXIF_ITEM_GUID | CHAR | 32 | SYSUUID_C | ||||
NUMBER_ALTERN | Item for Which This Item is an Alternative in the Document | CRMT_ITEM_NO_ALTERNATIVE | NUMC | 10 | CRM_ITEM_NO | ||||
ITEM_LANGUAGE | Short Text Language for an Item | CRMT_ITEM_LANGU | LANG | 1 | ISOLA | SYLANGU | |||
ITEM_LANGUAGE_ISO | Language Key (ISO) | CRMXIF_LANGUAGE_ISO | CHAR | 2 | LAISO | ||||
ORDER_DATE | Posting Date | CRMT_ORDER_DATE | DEC | 15 | TSTPS | BCOS_TSTMP | |||
SUBSTITUT_REASON | Reason for Product Substitution | CRMT_ITEM_SUBSTITUTION | CHAR | 4 | Assigned to domain | CRM_ITEM_SUBSTITUTION | |||
ITEM_USAGE | Usage of Higher-Level Item | CRMT_ITEM_USAGE | CHAR | 2 | CRM_ITEM_USAGE | ||||
ITEM_TYPE_USAGE | Item Category Usage | CRMT_IT_TYPE_USAGE | CHAR | 4 | Assigned to domain | CRM_IT_TYPE_USAGE | |||
ORDERED_PRODUCT | Product Name Entered | CRMT_ORDERED_PROD | CHAR | 54 | CRM_ORDERED_PROD | CRM_ORDERED_PRODUCT | |||
PRODUCT_DESCRIPTION | Product Description | COMT_PRSHTEXTX | CHAR | 40 | PRSHTEXT40 | ||||
PRODUCT_GTIN | Global Trade Item Number (GTIN) | COMT_GTIN | CHAR | 40 | GTIN1 | COM_GTIN | |||
DESCRIPTION_UC | Product Description in Uppercase for F4 Help | COMT_PRSHTEXTG | CHAR | 40 | PRSHTEXTG40 | ||||
PRODUCT_GUID | Product Number (Internal) | CRMXIF_PRODUCT_GUID | CHAR | 32 | SYSUUID_C | ||||
PRODUCT_ID | Product ID | COMT_PRODUCT_ID | CHAR | 40 | PRID1 | COM_PRODUCT_ID | COM_PR_COLLECTION | ||
PRODUCT_ID_40 | Value of a Product ID or Individual Object | COMT_ALTID_VALUE_UI | CHAR | 54 | COM_ALTID_VALUE_SHORT | COM_PR_ALTID | |||
PARTNER_PROD | Product Number of Business Partner | CRMT_ITEM_DESCR_PARTNER | CHAR | 40 | PRSHTEXT40 | ||||
PRODUCT_KIND | Technnical Type of Product | CRMT_PRODUCT_KIND | CHAR | 1 | CRM_PRODUCT_KIND | ||||
CAT_ID | Catalog | COMT_CATALOG | CHAR | 2 | Assigned to domain | COM_CATALOG | QKT | ||
CONFIGURATION | 0 | ||||||||
DATA | 0 | ||||||||
CONSIST | SCE consistency | SMO_CONSIS | CHAR | 1 | SMO_TEXT1 | ||||
COMPLETE | Complete ? | SMO_COMPLT | CHAR | 1 | SMO_LOGICL | ||||
SPRAS | Language | SMO_LANGU | CHAR | 2 | SMO_LANGU | ||||
KBPROFILE | SCE: Profile of Knowledge base | SMO_PROFNM | CHAR | 30 | SMO_TXT30 | ||||
KBBUILD | Build Counter knowledge base | SMO_KBUILD | CHAR | 8 | SMO_CHOI8 | ||||
KBNAME | Name of knowledge base (lang. inedependent) | SMO_KBNAME | CHAR | 72 | SMO_TEXT72 | ||||
KBVERS | Knowledge base version | SMO_KBVERS | CHAR | 30 | SMO_TXT30 | ||||
SCEVERS | SCE version | SMO_SPEVER | CHAR | 8 | SMO_TXT8 | ||||
CFGINFO | CFG Information | SMO_CFGINF | CHAR | 250 | SMO_TXT250 | ||||
INSTANCE | 0 | ||||||||
INPUT_FIELDS | 0 | ||||||||
CONSIST | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
COMPLETE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SPRAS | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KBPROFILE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KBBUILD | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KBNAME | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
KBVERS | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SCEVERS | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CFGINFO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICING_RESULT | 0 | ||||||||
DATA | 0 | ||||||||
TAX_DEPART_CTY | Tax Departure Country | CRMT_TAX_DEPART_CTY | CHAR | 3 | LAND1 | ||||
TAX_DEPART_CTY_ISO | Country Key (ISO) | CRMXIF_LAND_ISO | CHAR | 2 | INTCA | ||||
TAX_DEPART_REG | Departure Region for Tax | CRMT_TAX_DEPART_REG | CHAR | 3 | REGIO | ||||
TAXJURCODE_FROM | Tax Jurisdiction Code (Structure for tax calculation) | CRMT_TAXJURCODE | CHAR | 15 | TXJCD | CRM_TAX_SH_TAXJURCODE | |||
TAX_GROUP_P | Product Tax Group | CRMT_TAX_GROUP | CHAR | 20 | CRM_TAX_GROUP | ||||
TAX_TARIFF_CODE | Tax Tariff Code | CRMT_TAX_TARIFF_CODE | CHAR | 16 | CHAR16 | ||||
STATISTICAL | Statistical values | CRMT_STATISTICAL | CHAR | 1 | CRM_STATISTICAL | ||||
PRC_INDICATOR | Pricing indicator | CRMT_PRICING_INDICATOR | CHAR | 1 | CRM_PRICING_INDICATOR | ||||
NET_VALUE | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
NET_PRICE | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
TAX_AMOUNT | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
FREIGHT | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
GROSS_VALUE | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
NET_WO_FREIGHT | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
SUBTOTAL1 | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
SUBTOTAL2 | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
SUBTOTAL3 | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
SUBTOTAL4 | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
SUBTOTAL5 | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
SUBTOTAL6 | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
CREDIT_INDICATOR | Credit Debit Indicator | CRMT_CREDIT_INDICATOR | CHAR | 1 | CRMT_CREDIT_INDICATOR | ||||
NET_VALUE_MAN | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
TARGET_VALUE | Currency amount in BAPI interfaces | BAPICURR_D | DEC | 23(4) | BAPICURR | ||||
CASHFLOW_TYPE | Flow Category | CRMT_CASHFLOW_TYPE | CHAR | 4 | CRMT_CASHFLOW_TYPE | ||||
NETPR_PRIC_UNIT | Condition Pricing Unit | PRCT_COND_PRICING_UNIT | DEC | 5 | PRC_CONDITION_PRICING_UNIT | ||||
NETPR_UOM | Condition Unit | PRCT_COND_UOM | UNIT | 3 | CUNIT | MEINS | |||
INPUT_FIELDS | 0 | ||||||||
TAX_DEPART_CTY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_DEPART_CTY_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_DEPART_REG | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAXJURCODE_FROM | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_GROUP_P | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_TARIFF_CODE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
STATISTICAL | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRC_INDICATOR | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NET_VALUE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NET_PRICE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_AMOUNT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
FREIGHT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
GROSS_VALUE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NET_WO_FREIGHT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SUBTOTAL1 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SUBTOTAL2 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SUBTOTAL3 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SUBTOTAL4 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SUBTOTAL5 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SUBTOTAL6 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CREDIT_INDICATOR | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NET_VALUE_MAN | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TARGET_VALUE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CASHFLOW_TYPE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NETPR_PRIC_UNIT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NETPR_UOM | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRODUCT_DATA | 0 | ||||||||
DATA | 0 | ||||||||
GROSS_WEIGHT | Gross Weight | CRMT_GROSS_WEIGHT | QUAN | 15(3) | MENG15 | ||||
NET_WEIGHT | Net Weight | CRMT_NET_WEIGHT | QUAN | 15(3) | MENG15 | ||||
WEIGHT_UNIT | Weight Unit | COMT_WEIGHT_UNIT | UNIT | 3 | CUNIT | MEINS | |||
WEIGHT_UNIT_ISO | Unit of Measurement (IS0) | CRMXIF_UNIT_ISO | CHAR | 3 | ISOCD_UNIT | ||||
VOLUME | Volume Occupied by the Product per Volume Unit | CRMT_VOLUME | QUAN | 15(3) | MENG15 | ||||
VOLUME_UNIT | Unit for the Volume of a Product | COMT_VOLUME_UNIT | UNIT | 3 | CUNIT | MEINS | |||
VOLUME_UNIT_ISO | Unit of Measurement (IS0) | CRMXIF_UNIT_ISO | CHAR | 3 | ISOCD_UNIT | ||||
PRICE_PRODUCT | Pricing Reference Product Globally Unique Identifier | CRMT_PRICE_PRODUCT | RAW | 16 | SYSUUID | ||||
PRICE_PRODUCT_ID | Pricing Reference Product | CRMT_PRICE_PRODUCT_ID | CHAR | 40 | PRID1 | COM_PRODUCT_ID | |||
PROCESS_QTY_NUM | Numerator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_NUM | INT4 | 10 | CRM_PROCESS_QTY_NUM | ||||
PROCESS_QTY_DEN | Denominator (factor) for conversion trans. quantity in BME | CRMT_PROCESS_QTY_DEN | INT4 | 10 | CRM_PROCESS_QTY_DEN | ||||
EXPONENT10 | 10 Exponent for Quantity Conversion | CRMT_EXPONENT10 | INT2 | 5 | CRM_EXPONENT10 | ||||
PROCESS_QTY_UNIT | Unit of Measure in Which the Product Is Sold | CRMT_PROCESS_QTY_UNIT | UNIT | 3 | CUNIT | MEINS | |||
PROCESS_QTY_UNIT_ISO | Unit of Measurement (IS0) | CRMXIF_UNIT_ISO | CHAR | 3 | ISOCD_UNIT | ||||
COMM_GROUP | Commission Group | CRMT_COMM_GROUP | CHAR | 2 | CRM_COMM_GROUP | ||||
REBATE_GROUP | Volume Rebate Group | CRMT_REBATE_GROUP | CHAR | 2 | CRM_REBATE_GROUP | ||||
CASH_DISC | Specifies Whether a Cash Discount Can Be Given for the Prod. | CRMT_CASH_DISC | CHAR | 1 | XFELD | ||||
PROD_PR_GROUP | Product Group | CRMT_PROD_PR_GROUP | CHAR | 2 | CRM_PROD_PR_GROUP | ||||
PRC_GROUP1 | Product Group 1 | CRMT_PRC_GROUP1 | CHAR | 3 | CRM_PRC_GROUP1 | ||||
PRC_GROUP2 | Product Group 2 | CRMT_PRC_GROUP2 | CHAR | 3 | CRM_PRC_GROUP2 | ||||
PRC_GROUP3 | Product Group 3 | CRMT_PRC_GROUP3 | CHAR | 3 | CRM_PRC_GROUP3 | ||||
PRC_GROUP4 | Product Group 4 | CRMT_PRC_GROUP4 | CHAR | 3 | CRM_PRC_GROUP4 | ||||
PRC_GROUP5 | Product Group 5 | CRMT_PRC_GROUP5 | CHAR | 3 | CRM_PRC_GROUP5 | ||||
PROD_HIERARCHY | Product Category | CRMT_PROD_HIERARCHY | CHAR | 20 | COM_CATEGORY_ID | COM_CAT_SALES | |||
RESID_VALUE_ST | Residual Value Strategy | CRMT_RESID_VALUE_ST | CHAR | 3 | CRMT_RESID_VALUE_ST | ||||
RESID_VALUE_GRP | Residual Value Curve | CRMT_RESID_VALUE_GRP | CHAR | 3 | CRMT_RESID_VALUE_GRP | ||||
BASE_QTY_UNIT | Base Unit of Measure of Product | COMT_PRODUCT_BASE_UOM | UNIT | 3 | CUNIT | MEINS | |||
BASE_QTY_UNIT_ISO | Unit of Measurement (IS0) | CRMXIF_UNIT_ISO | CHAR | 3 | ISOCD_UNIT | ||||
BATCH_ID | Batch Number | CRMT_BATCH_ID | CHAR | 10 | BATCH_ID | CHA | |||
INT_INSPECTION | Internal Quality Inspection | CRMT_INT_INSPECTION | CHAR | 4 | CRM_ITEM_INSPECTION | ||||
INPUT_FIELDS | 0 | ||||||||
GROSS_WEIGHT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NET_WEIGHT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WEIGHT_UNIT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
WEIGHT_UNIT_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VOLUME | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VOLUME_UNIT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VOLUME_UNIT_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICE_PRODUCT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICE_PRODUCT_ID | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PROCESS_QTY_NUM | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PROCESS_QTY_DEN | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EXPONENT10 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PROCESS_QTY_UNIT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PROCESS_QTY_UNIT_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
COMM_GROUP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
REBATE_GROUP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CASH_DISC | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PROD_PR_GROUP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRC_GROUP1 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRC_GROUP2 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRC_GROUP3 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRC_GROUP4 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRC_GROUP5 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PROD_HIERARCHY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
RESID_VALUE_ST | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
RESID_VALUE_GRP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
BASE_QTY_UNIT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
BASE_QTY_UNIT_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
BATCH_ID | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
INT_INSPECTION | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
CUSTOMER_I | 0 | ||||||||
DATA | 0 | ||||||||
CUSTOMER_INT | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
CUSTOMER_EXT | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
STATUS | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
DOC_FLOW | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
TEXT | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
SCHEDULE_LINES | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
TOTAL_QUANTITY | 0 | ||||||||
DATA | 0 | ||||||||
ORDER_QTY | CRM: Order Quantity | CRMT_QTY_ORDER | QUAN | 13(3) | MENG13 | ||||
CONFIRMED_QTY | CRM: Confirmed Quantity | CRMT_QTY_CONFIRMED | QUAN | 13(3) | MENG13 | ||||
NUMBER_CONFIRMED | CRM Number Confirmation Schedule Line | CRMT_SCHEDLIN_COUNT_CONFIRMED | INT2 | 5 | CRM_SCHEDLIN_COUNT | ||||
LATEST_TIME_CONF | Latest Confirmation Date for an Item | CRMT_SCHEDLIN_LTIME_CONFIRMED | DEC | 15 | TSTPS | BCOS_TSTMP | |||
INPUT_FIELDS | 0 | ||||||||
ORDER_QTY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CONFIRMED_QTY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
NUMBER_CONFIRMED | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
LATEST_TIME_CONF | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORGDATA | 0 | ||||||||
DATA | 0 | ||||||||
SALES_ORG | Sales Organization | CRMT_SALES_ORG | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_ORG | |||
SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_OFFICE | |||
SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SALES_GROUP | |||
SALES_ORG_RESP | Organizational Unit (Sales) | CRMT_SALES_ORG_RESP | CHAR | 14 | HROBJEC_14 | ||||
DIS_CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR | 2 | CRM_DISTRIBUTION_CHANNEL | CRM_ORGMAN_DIS_CHANNEL | |||
DIVISION | Division | CRMT_DIVISION | CHAR | 2 | CRM_DIVISION | CRM_DIVISION | |||
SERVICE_ORG | Service Organization | CRMT_SERVICE_ORG | CHAR | 14 | HROBJEC_14 | CRM_ORGMAN_SERVICE_ORG | |||
SERV_ORG_SHORT | Service Organization Identifier | CRMT_SERVICE_ORG_SHORT | CHAR | 12 | TEXT12 | ||||
SERVICE_ORG_RESP | Organizational Unit (Service) | CRMT_SERVICE_ORG_RESP | CHAR | 14 | HROBJEC_14 | ||||
SER_ORGRESP_SHT | Abbreviation: Responsible Organizational Unit (Service) | CRMT_SERVICE_ORG_RESP_SHORT | CHAR | 12 | TEXT12 | ||||
PURCH_ORG | Purchasing Organization | CRMT_PURCH_ORG | CHAR | 14 | HROBJEC_14 | ||||
PURCH_GROUP | Purchasing Group | CRMT_PURCH_GROUP | CHAR | 14 | HROBJEC_14 | ||||
PURCH_ORG_RESP | Organizational Unit (Purchasing) | CRMT_PURCH_ORG_RESP | CHAR | 14 | HROBJEC_14 | ||||
DISTRICT | District | CRMT_DISTRICT | CHAR | 6 | CRM_DISTRICT | ||||
ORGUNIT_SAL_SEL | Concatenated Identification (Type and ID) of Org.Objects | HROBJEC_14 | CHAR | 14 | HROBJEC_14 | ||||
ORGUNIT_SER_SEL | Concatenated Identification (Type and ID) of Org.Objects | HROBJEC_14 | CHAR | 14 | HROBJEC_14 | ||||
DIS_CHANNEL_SEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | CHAR | 2 | CRM_DISTRIBUTION_CHANNEL | CRM_ORGMAN_DIS_CHANNEL | |||
INPUT_FIELDS | 0 | ||||||||
SALES_ORG | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SALES_OFFICE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SALES_GROUP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SALES_ORG_RESP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DIS_CHANNEL | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DIVISION | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SERVICE_ORG | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SERV_ORG_SHORT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SERVICE_ORG_RESP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
SER_ORGRESP_SHT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PURCH_ORG | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PURCH_GROUP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PURCH_ORG_RESP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DISTRICT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORGUNIT_SAL_SEL | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ORGUNIT_SER_SEL | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DIS_CHANNEL_SEL | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICING_PARAMS | 0 | ||||||||
DATA | 0 | ||||||||
TAXJURCODE | Tax Jurisdiction Code (Structure for tax calculation) | CRMT_TAXJURCODE | CHAR | 15 | TXJCD | CRM_TAX_SH_TAXJURCODE | |||
CUST_PRIC_PROC | Customer Pricing Procedure | CRMT_CUST_PRIC_PROC | CHAR | 1 | CRM_CUST_PRIC_PROC | ||||
PRICE_DATE | Pricing Date | CRMT_PRICE_DATE | DATS | 8 | CRM_PRICE_DATE | ||||
PAYMENT_TERMS | Terms of Payment | CRMT_PMNTTRMS | CHAR | 4 | CRM_PMNTTRMS | ||||
DAYS_FROM_1 | Days From Payment Deadline Base Date 1st Level | CRMT_DAYS_FROM_1 | NUMC | 3 | NUM03 | ||||
PERCENTAGE_1 | Cash Discount Rate, Level 1 | CRMT_PERCENTAGE_1 | DEC | 5(3) | PRZ23 | ||||
DAYS_FROM_2 | Days from payment deadline base date, 2nd level | CRMT_DAYS_FROM_2 | NUMC | 3 | NUM03 | ||||
PERCENTAGE_2 | Casn Discount Rate, Level 2 | CRMT_PERCENTAGE_2 | DEC | 5(3) | PRZ23 | ||||
DAYS_FROM_3 | Days from Payment Deadline Base Date (Due Date Net Payment) | CRMT_DAYS_FROM_3 | NUMC | 3 | NUM03 | ||||
PRICE_GRP | Customer Price Group | CRMT_PRICE_GRP | CHAR | 2 | CRM_PRICE_GRP | CRM_PRICE_GRP | |||
PRICE_LIST | Price List Type | CRMT_PRICE_LIST | CHAR | 2 | CRM_PRICE_LIST | CRM_PRICE_LIST | |||
CUST_GROUP | Customer Group | CRMT_CUST_GROUP | CHAR | 2 | CRM_CUST_GROUP | ||||
TAX_DEST_CTY | Tax Destination Country | CRMT_TAX_DEST_CTY | CHAR | 3 | LAND1 | ||||
TAX_DEST_CTY_ISO | Country Key (ISO) | CRMXIF_LAND_ISO | CHAR | 2 | INTCA | ||||
TAX_DEST_REG | Region (State, Province, County) | CRMT_REGION | CHAR | 3 | REGIO | ||||
VAT_REG_NO | Sales tax registration number | CRMT_VAT_REG_NO | CHAR | 20 | |||||
EXCHG_TYPE | Exchange Rate Type | CRMT_EXCHG_TYPE | CHAR | 4 | KURST | ||||
EXCHG_DATE | Exchange Rate Date | CRMT_EXCHG_DATE | DATS | 8 | CRM_EXCHG_DATE | ||||
REF_CURRENCY | Reference Currency | CRMT_REF_CURRENCY | CUKY | 5 | WAERS | ||||
REF_CURRENCY_ISO | Currency Key | CRMXIF_CURRENCY_ISO | CHAR | 3 | ISOCD | ||||
CURRENCY | Currency | CRMT_CURRENCY | CUKY | 5 | WAERS | FWS | |||
CURRENCY_ISO | Currency Key | CRMXIF_CURRENCY_ISO | CHAR | 3 | ISOCD | ||||
EXCHG_RATE | Exchange Rate | CRMT_EXCHG_RATE | DEC | 9(5) | EXCRT | CRM_EXCHG_RATE | |||
ETAX_HAND_TYPE | Excise Tax Handling Type (Denotes Use of Material) | CRMT_ETAX_HAND_TYPE | CHAR | 2 | CRM_ETAX_HAND_TYPE | ||||
ETAX_SOURCE | Source of Excise Tax Rates | CRMT_ETAX_SOURCE | CHAR | 2 | CRM_ETAX_SOURCE | ||||
GRADE | Rating | BP_GRADE | CHAR | 10 | BP_GRADE | ||||
AC_INDICATOR | Accounting Indicator | CRMT_AC_INDICATOR | CHAR | 2 | CRMT_AC_INDICATOR | ||||
CFOP_CODE | CFOP Code and Extension | ITL_CFOP | CHAR | 10 | CFOBR | ITL_CFOP | |||
ICMS_TAXLAW | ICMS Tax Law ID | ITL_TAXLAW1 | CHAR | 3 | ALPHA | ITL_TAXLAW1 | |||
IPI_TAXLAW | IPI Tax Law ID | ITL_TAXLAW2 | CHAR | 3 | ALPHA | ITL_TAXLAW2 | |||
TAX_MAT_USAGE | Material Usage | TAX_MAT_USAGE | CHAR | 1 | TAX_MAT_USAGE | ||||
VALID_FROM | Time Dependency: Validity Start Date | CRMT_VALID_FROM | DEC | 15 | TSTPS | BCOS_TSTMP | |||
VALID_TO | Time Dependency: Validity End Date | CRMT_VALID_TO | DEC | 15 | TSTPS | BCOS_TSTMP | |||
TRANS_TIME | Time Last Change was Made | CRMT_TRANS_TIME | DEC | 15 | TSTPS | BCOS_TSTMP | |||
INPUT_FIELDS | 0 | ||||||||
TAXJURCODE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CUST_PRIC_PROC | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICE_DATE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PAYMENT_TERMS | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DAYS_FROM_1 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PERCENTAGE_1 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DAYS_FROM_2 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PERCENTAGE_2 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DAYS_FROM_3 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICE_GRP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICE_LIST | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CUST_GROUP | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_DEST_CTY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_DEST_CTY_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_DEST_REG | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VAT_REG_NO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EXCHG_TYPE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EXCHG_DATE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
REF_CURRENCY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
REF_CURRENCY_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CURRENCY | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CURRENCY_ISO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
EXCHG_RATE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ETAX_HAND_TYPE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ETAX_SOURCE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
GRADE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
AC_INDICATOR | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
CFOP_CODE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
ICMS_TAXLAW | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
IPI_TAXLAW | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TAX_MAT_USAGE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VALID_FROM | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
VALID_TO | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
TRANS_TIME | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
PARTNER | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRICE_CONDITIONS | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
DATES | 0 | ||||||||
DATA | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE | ||||
PRODUCT_LIST | 0 | ||||||||
DATA | 0 | ||||||||
PRODUCTS | 0 | ||||||||
OBJECTS | 0 | ||||||||
DATAX | Information on Changes to Transaction Data Structure/Table | CRMXIF_BT_UPDATE | CHAR | 1 | BAPIUPDATE |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects