CRMT_BW_SALES_ORDER_I SAP (BW: Datasource for CRM Sales Orders - Item Data) Structure details

Dictionary Type: Structure
Description: BW: Datasource for CRM Sales Orders - Item Data




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




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

CRMT_BW_SALES_ORDER_I 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 "BW: Datasource for CRM Sales Orders - Item Data" 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_CRMT_BW_SALES_ORDER_I TYPE CRMT_BW_SALES_ORDER_I.

The CRMT_BW_SALES_ORDER_I table consists of various fields, each holding specific information or linking keys about BW: Datasource for CRM Sales Orders - Item Data data available in SAP. These include CLIENT (Client), GUID (GUID for a Transaction), OBJECT_ID (Transaction ID), PROCESS_TYPE (Business Transaction Type).. 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 CRMT_BW_SALES_ORDER_I 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
OBJECT_IDTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPECHAR4Assigned to domainCRM_PROCESS_TYPECRM_PROCESS_TYPECRM_PROCESS_TYPE
POSTING_DATEPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
DESCRIPTION_UCTransaction Description (Upper Case) CRMT_PROCESS_DESCRIPTION_UCCHAR40CRM_PROCESS_DESCRIPTION_UC
DESCR_LANGUAGELanguage Key of Description CRMT_PROCESS_DESCRIPTION_LANGULANG1Assigned to domainISOLASPRAS
LOGICAL_SYSTEMLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
OBJECT_TYPEBusiness Transaction Category CRMT_SUBOBJECT_CATEGORYCHAR10CRMC_SUBOB_CATCRM_OJ_NAME_PROCESSCRM_SUBOBJ_CATEGORYCRM_OBJECT_TYPE_PROCESS
CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
CHANGED_ATTime of Last Change to the Transaction CRMT_OPPT_CHANGED_ATDATS8DATUM
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
RECORDMODEBW Delta Process: Record Mode RODMUPDMODCHAR1RODMUPDMOD
NUM_OF_HEADOrder Header Number CRMT_NUMBER_OF_HINT410INT4
OCCURRENCECounter: Document Cat. Appears at Least Once in Document CRMT_OCC_AT_LEAST_ONCECHAR1CRM_BOOLEAN
SCENARIOScenario Identity CRMT_SCENARIOCHAR10CRM_SCENARIO
TEMPLATE_TYPETemplate Type of CRM Transaction CRMT_TEMPLATE_TYPE_DBCHAR1CRM_TEMPLATE_TYPE
OCCURR_QUOTCounter: Document Cat. Appears at Least Once in Document CRMT_QUO_AT_LEAST_ONCECHAR1CRM_BOOLEAN
OCCURR_CONTCounter: Document Cat. Appears at Least Once in Document CRMT_CON_AT_LEAST_ONCECHAR1CRM_BOOLEAN
REF_UPDATEFlag: Ref. Update (Extract Structure Only Partially Filled) CRMT_FLG_REF_UPDATE_BWCHAR1XFELD
ITEM_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
ITEM_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
ITEM_CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
ITEM_CHANGED_ATTime of Last Change to the Transaction CRMT_OPPT_CHANGED_ATDATS8DATUM
ITEM_CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
ORDER_DATEPosting Date CRMT_OPPT_ORDER_DATEDATS8DATUM
NUMBER_INTItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
ITEM_OBJECT_TYPECRM Item Object Type CRMT_SWO_OBJTYP_PROCESS_ITEMCHAR10Assigned to domainCRM_OJ_NAME_PROCESS_ITEM
ITM_TYPEItem Category CRMT_ITEM_TYPECHAR4Assigned to domainCRM_ITEM_TYPECRM_ITEM_TYPE
NUMBER_OF_IOrder Item Number CRMT_NUMBER_OF_IINT410INT4
BW_ASSIGNAssign BW and CO CRMT_BW_ASSIGNCHAR1CRMT_BW_ASSIGN
ITM_USAGEUsage of Higher-Level Item CRMT_ITEM_USAGECHAR2CRM_ITEM_USAGE
ITM_TYPE_USAGEItem Category Usage CRMT_IT_TYPE_USAGECHAR4Assigned to domainCRM_IT_TYPE_USAGE
ALTERNATIVEGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PARENTGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
SOLD_TO_PARTYSold-To Party CRMT_SOLD_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
SHIP_TO_PARTYShip-To Party CRMT_SHIP_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
BILL_TO_PARTYBill-To Party CRMT_BILL_TO_PARTCHAR10Assigned to domainALPHABU_PARTNER
PAYERPayer CRMT_RP_PAYERCHAR10Assigned to domainALPHABU_PARTNER
SOLD_FROMSalesperson ID CRMT_SOLD_FROM_PARTY_IDCHAR10Assigned to domainALPHABU_PARTNERBUPA
INSTALL_ATInstalled At CRMT_INSTALL_AT_PARTCHAR10Assigned to domainALPHABU_PARTNER
INSTALL_AT_LISTInstalled At - Name CRMT_INSTALL_AT_LISTCHAR80CHAR80
RESPONS_AT_PARTNERPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
END_CUSTOMEREnd Customer (Channel Management) CRMT_END_CUSTOMERCHAR10Assigned to domainALPHABU_PARTNER
RESP_AT_PARTPerson Responsible at Partners (Channel Management) CRMT_RESPONSIBLE_AT_PARTNERCHAR10Assigned to domainALPHABU_PARTNER
SALES_EMPLOYEEEmployee CRMT_SALES_EMPLOYEECHAR10Assigned to domainALPHABU_PARTNER
PERSON_RESPEmployee Responsible CRMT_PERSON_RESPCHAR10Assigned to domainALPHABU_PARTNER
CONTACT_PERSONCustomer Contact Person CRMT_CONTACT_PERSONCHAR10Assigned to domainALPHABU_PARTNER
SALESPARTNERSales Partners CRMT_SALESPARTNERCHAR10Assigned to domainALPHABU_PARTNER
EXECUTING_CCExecuting Interaction Center CRMT_EXECUTING_CCCHAR10Assigned to domainALPHABU_PARTNER
RESP_GROUPResponsible Group CRMT_RESPONSIBLE_GROUPCHAR10Assigned to domainALPHABU_PARTNER
SALES_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
SALES_ORGObject ID OBJEKTIDNUMC8NUM08PON
SALES_OFFICEObject ID OBJEKTIDNUMC8NUM08PON
SALES_GROUPObject ID OBJEKTIDNUMC8NUM08PON
DIS_CHANNELDistribution Channel CRMT_DISTRIBUTION_CHANNELCHAR2Assigned to domainCRM_DISTRIBUTION_CHANNELCRM_ORGMAN_DIS_CHANNEL
DIVISIONDivision CRMT_DIVISIONCHAR2Assigned to domainCRM_DIVISIONCRM_DIVISION
SERVICE_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
SERVICE_ORGObject ID OBJEKTIDNUMC8NUM08PON
PURCH_ORG_RESPObject ID OBJEKTIDNUMC8NUM08PON
PURCH_ORGObject ID OBJEKTIDNUMC8NUM08PON
PURCH_GROUPObject ID OBJEKTIDNUMC8NUM08PON
CUST_GROUP1Customer Group 1 CRMT_CUST_GROUP1CHAR3Assigned to domainCRM_CUST_GROUP1
CUST_GROUP2Customer Group 2 CRMT_CUST_GROUP2CHAR3Assigned to domainCRM_CUST_GROUP2
CUST_GROUP3Dishonour Reason CRMT_CUST_GROUP3CHAR3Assigned to domainCRM_CUST_GROUP3
CUST_GROUP4Customer Group 4 CRMT_CUST_GROUP4CHAR3Assigned to domainCRM_CUST_GROUP4
CUST_GROUP5Customer Group 5 CRMT_CUST_GROUP5CHAR3Assigned to domainCRM_CUST_GROUP5
INDUSTRYIndustry Sector CRMT_INDUSTRYCHAR4Assigned to domainCRM_INDUSTRY
REJECTIONCancellation Reason Code CRMT_REJECTION_CODECHAR2Assigned to domainCRM_REJECTION_CODE
PROBABILITYOrder Probability CRMT_ORDER_PROBABILITYNUMC3CRM_PROBABILITY
PCAT_HDR_IDProduct Catalog Number COMT_PCAT_IDCHAR30COM_PCAT_OBJECTIDCOM_PRDCATCOM_PCAT_HDR_ID
PCAT_VRT_IDCatalog Variant Number COMT_PCAT_VRT_IDCHAR30COM_PCAT_OBJECTID
PCAT_CTY_IDCatalog Area Number COMT_PCAT_CTY_IDCHAR30COM_PCAT_OBJECTIDCOM_PCAT_CTY_ID
ABNORMAL_DEMANDAbnormal Demand CRMT_ABNORMAL_DEMANDCHAR1CRM_ABNORMAL_DEMAND
DLV_RELEVANCEDelivery-Relevant CRMT_DELIVERY_RELEVANTCHAR1CRM_DELIVERY_RELEVANT
DATE_QTY_FIXEDFixed Date and Quantity CRMT_DATE_QTY_FIXEDCHAR1CRM_BOOLEAN
PRODUCT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
PRODUCT_GUIDGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
MATERIALDistribution CRM -> R/3: Material CRMT_R3_MATERIALCHAR18CRM_R3_MATERIAL
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
CATEGORY_GUIDCategory GUID COMT_CATEGORY_GUIDRAW16SYSUUID
SHORT_TEXT_UCProduct Description COMT_PRSHTEXTX_UPCHAR40PRSHTEXTG40
CATALOG_IDCatalog ID, from Which the Line PPR Was Selected CATALOG_PLCHAR20Assigned to domainKATALOGID
CATALOG_ITEM_IDCatalog Item (Unique Key) CRMT_CATALOGITEMCHAR40CRM_CATALOGITEM
PARTNER_PRODProduct Number of Business Partner CRMT_ITEM_DESCR_PARTNERCHAR40PRSHTEXT40
PARENT_PRODUCTGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
COMPETITOR_PRODGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
REPLACED_PRODGUID for Product CHAR32 CRMT_PRODUCT_GUID_32CHAR32SYSUUID_C
GROSS_WEIGHTGross Weight CRMT_GROSS_WEIGHTQUAN15(3) MENG15
NET_WEIGHTNet Weight CRMT_NET_WEIGHTQUAN15(3) MENG15
WEIGHT_UNITWeight Unit COMT_WEIGHT_UNITUNIT3Assigned to domainCUNITMEINS
VOLUMEVolume Occupied by the Product per Volume Unit CRMT_VOLUMEQUAN15(3) MENG15
VOLUME_UNITUnit for the Volume of a Product COMT_VOLUME_UNITUNIT3Assigned to domainCUNITMEINS
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_UNITUNIT3Assigned to domainCUNITMEINS
PROD_PR_GROUPProduct Group CRMT_PROD_PR_GROUPCHAR2Assigned to domainCRM_PROD_PR_GROUP
PRC_GROUP1Product Group 1 CRMT_PRC_GROUP1CHAR3Assigned to domainCRM_PRC_GROUP1
PRC_GROUP2Product Group 2 CRMT_PRC_GROUP2CHAR3Assigned to domainCRM_PRC_GROUP2
PRC_GROUP3Product Group 3 CRMT_PRC_GROUP3CHAR3Assigned to domainCRM_PRC_GROUP3
PRC_GROUP4Product Group 4 CRMT_PRC_GROUP4CHAR3Assigned to domainCRM_PRC_GROUP4
PRC_GROUP5Product Group 5 CRMT_PRC_GROUP5CHAR3Assigned to domainCRM_PRC_GROUP5
BASE_QTY_UNITBase Unit of Measure of Product COMT_PRODUCT_BASE_UOMUNIT3Assigned to domainCUNITMEINS
EXCHG_TYPEExchange Rate Type CRMT_EXCHG_TYPECHAR4Assigned to domainKURST
EXCHG_DATEExchange Rate Date CRMT_EXCHG_DATEDATS8CRM_EXCHG_DATE
EXCHG_RATEExchange Rate CRMT_EXCHG_RATEDEC9(5) EXCRTCRM_EXCHG_RATE
CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS
PRICE_DATEPricing Date CRMT_PRICE_DATEDATS8CRM_PRICE_DATE
REF_CURRENCYReference Currency CRMT_REF_CURRENCYCUKY5Assigned to domainWAERS
PMNTTRMSTerms of Payment CRMT_PMNTTRMSCHAR4Assigned to domainCRM_PMNTTRMS
CUST_GROUPCustomer Group CRMT_CUST_GROUPCHAR2Assigned to domainCRM_CUST_GROUP
CUSTOMER_TYPEBusiness Partner Type CRMT_CUSTOMER_TYPECHAR4Assigned to domainBU_KIND
NET_VALUE_MANTotal Expected Net Value Products in Document Currency CRMT_NET_VALUE_MANCURR15(2) WERTV8
TARGET_VALUETarget Value for Value Contract CRMT_TARGET_VALUECURR19(2) WERTV10
NET_PRICENet Price CRMT_NET_PRICECURR15(2) WERTV8
NET_VALUENet Value CRMT_NET_VALUECURR15(2) WERTV8
TAX_AMOUNTTax amount in document currency CRMT_TAX_AMOUNTCURR15(2) WERTV8
FREIGHTShipment costs in document currency CRMT_FREIGHTCURR15(2) WERTV8
SUBTOTAL1Subtotal 1 from pricing procedure for condition CRMT_SUBTOTAL1CURR15(2) WERTV8
SUBTOTAL2Subtotal 2 from pricing procedure for condition CRMT_SUBTOTAL2CURR15(2) WERTV8
SUBTOTAL3Subtotal 3 from pricing procedure for condition CRMT_SUBTOTAL3CURR15(2) WERTV8
SUBTOTAL4Subtotal 4 from pricing procedure for condition CRMT_SUBTOTAL4CURR15(2) WERTV8
SUBTOTAL5Subtotal 5 from pricing procedure for condition CRMT_SUBTOTAL5CURR15(2) WERTV8
SUBTOTAL6Subtotal 6 from pricing procedure for condition CRMT_SUBTOTAL6CURR15(2) WERTV8
CREDIT_INDICATORCredit Debit Indicator CRMT_CREDIT_INDICATORCHAR1CRMT_CREDIT_INDICATOR
GROSS_VALUEGross Order Value in PO Currency CRMT_GROSS_VALUECURR15(2) WERTV8
REQUESTED_DATEOrder Date CRMT_REQUESTED_DATEDATS8CRM_RPRTNG_DATE
CONFIRMED_DATELatest Confirmation Date for Item Schedule Line CRMT_CONFIRMED_DATEDATS8CRM_RPRTNG_DATE
BEGIN_DATEContract Start Date CRMT_BEGIN_DATEDATS8CRM_RPRTNG_DATE
ENDING_DATEContract End Date CRMT_ENDING_DATEDATS8CRM_RPRTNG_DATE
START_OF_BILLINGStart Date of Billing Plan CRMT_START_OF_BILLINGDATS8CRM_RPRTNG_DATE
VALID_FROM_DATEQuotation Valid from Date CRMT_VALID_FROM_DATEDATS8CRM_RPRTNG_DATE
VALID_TO_DATEQuotation: Valid to Date CRMT_VALID_TO_DATEDATS8CRM_RPRTNG_DATE
BW_POST_DATEPosting Date for BW Reporting CRMT_BW_POST_DATEDATS8CRM_RPRTNG_DATE
PLANNED_TS_FROMTime Stamp: Planned Date/Time from CRMT_PLANNED_TS_FROMDEC15TSTPSBCOS_TSTMP
PLANNED_TS_TOTime Stamp: Planned Date/Time to CRMT_PLANNED_TS_TODEC15TSTPSBCOS_TSTMP
ACTUAL_TS_FROMTime Stamp: Actual Date/Time from CRMT_ACTUAL_TS_FROMDEC15TSTPSBCOS_TSTMP
ACTUAL_TS_TOTime Stamp: Actual Date/Time to CRMT_ACTUAL_TS_TODEC15TSTPSBCOS_TSTMP
PLANNED_FROMPlanned Date from CRMT_PLANNED_FROMDATS8CRM_RPRTNG_DATE
PLANNED_TOPlanned Date to CRMT_PLANNED_TODATS8CRM_RPRTNG_DATE
ACTUAL_FROMActual Date from CRMT_ACTUAL_FROMDATS8CRM_RPRTNG_DATE
ACTUAL_TOActual Date to CRMT_ACTUAL_TODATS8CRM_RPRTNG_DATE
EARLIEST_CONFIRMEarliest Confirmation Date Still Not Delivered CRMT_EARLIEST_CONFIRMEDDATS8CRM_RPRTNG_DATE
DURADuration of Contract/Quotation CRMT_BW_DURATIONDEC13TIMEDURA
DURA_FULLFILLDuration Until Fulfillment of Contract CRMT_BW_DURA_FULLFILLDEC13TIMEDURA
DURA_UNITTime Unit for Duration of Contract/Quotation in Days CRMT_BW_DURA_UNITCHAR12Assigned to domainTIMEUNITNA
BEGIN_TO_COMPLETDuration Start to Conversion or Cancellation of a Quotation CRMT_BW_BEGIN_TO_COMPLETEDEC13TIMEDURA
COMPLETE_TO_ENDDuration Conversion or Cancellation Before End of Quotation CRMT_BW_COMPLETE_TO_ENDDEC13TIMEDURA
REL_TO_BEGINTime Relation: Time to Completion / Validity Interval CRMT_BW_REL_TO_BEGINDEC5(2)
REL_BEFORE_ENDTime Relation: Time Completed Before End / Validity Interval CRMT_BW_REL_BEFORE_ENDDEC5(2)
REQ_DLV_DATETime Stamp: Last Required Delivery Date CRMT_REQ_DELIVERY_DATEDEC15TSTPSBCOS_TSTMP
LAST_DLV_DATETime Stamp: Last Delivery Date CRMT_LAST_DELIVERY_DATEDEC15TSTPSBCOS_TSTMP
LAST_QI_ACT_DATETime Stamp: Last Actual Goods Issue Data CRMT_LAST_QI_ACTUAL_DATEDEC15TSTPSBCOS_TSTMP
LAST_REQ_AVA_DATTime Stamp: Last Material Availability Date (Requested) CRMT_LAST_REQ_AVAILABLE_DATEDEC15TSTPSBCOS_TSTMP
LAST_CONF_AV_DATTime Stamp: Last Material Availability Date (Confirmed) CRMT_LAST_CONF_AVAILABLE_DATEDEC15TSTPSBCOS_TSTMP
LAST_REQ_QI_PLDATime Stamp: Last Planned Goods Issue Date (Requested) CRMT_LAST_REQ_QI_PLANNED_DATEDEC15TSTPSBCOS_TSTMP
LAST_CONF_QI_PLDTime Stamp: Last Planned Goods Issue Date (Confirmed) CRMT_LAST_CONF_QI_PLANNED_DATEDEC15TSTPSBCOS_TSTMP
CALL_OF_CURR_CUMCurrency for Value Called CRMT_CALL_OF_CURRENCY_CUMCUKY5Assigned to domainWAERS
CALL_OF_QTY_CUMQuantity Retrieved for a Contract CRMT_CALL_OF_QTY_CUMQUAN15(3) CRM_MENGV15
CALL_OF_UNIT_CUMQuantity Unit Called CRMT_CALL_OF_QTY_UNIT_CUMUNIT3Assigned to domainCUNITMEINS
CALL_OF_VAL_CUMReleased Value for a Contract CRMT_CALL_OF_VALUE_CUMCURR19(2) CRM_COND_VALUE
COMPL_CURR_CUMCurrency of Actual Referenced Value CRMT_COMPLETED_CURRENCY_CUMCUKY5Assigned to domainWAERS
COMPL_QTY_CUMActual Referenced Quantity for a Quotation CRMT_COMPLETED_QTY_CUMQUAN15(3) CRM_MENGV15
COMPL_UNIT_CUMUnit for Actual Referenced Quantity CRMT_COMPLETED_QTY_UNIT_CUMUNIT3Assigned to domainCUNITMEINS
COMPL_VALUE_CUMActual Referenced Value for a Quotation CRMT_COMPLETED_VALUE_CUMCURR15(2) WERTV8
TARGET_QUAN_CUMTarget Quantity Cumulated CRMT_TARGET_QUAN_CUMQUAN13(3) MENG13
TGT_QTY_UNIT_CUMUnit for a Target Quantity CRMT_TARGET_QTY_UNIT_CUMUNIT3Assigned to domainCUNITMEINS
DELIVERY_QTY_CUMDelivered Quantity for an Item CRMT_DELIVERED_QTY_CUMQUAN15(3) CRM_MENGV15
INVOICED_QTY_CUMBilled Quantity for an Item CRMT_INVOICED_QTY_CUMQUAN15(3) CRM_MENGV15
O_CALLOF_QTY_CUMOpen Releasable Quantity for Item CRMT_O_CALLOF_QTY_CUMQUAN15(3) CRM_MENGV15
O_INV_QTY_CUMOpen Item Quantity for Billing CRMT_OPEN_INV_QTY_CUMQUAN15(3) CRM_MENGV15
O_ORDER_QTY_CUMOpen Order Quantity for Item CRMT_OPEN_ORD_QTY_CUMQUAN15(3) CRM_MENGV15
DELIVERY_VAL_CUMDelivered Value for an Item CRMT_DELIVERED_VAL_CUMCURR15(2) WERTV8
INVOICED_VAL_CUMBilled Value of an Item CRMT_INVOICED_VAL_CUMCURR15(2) WERTV8
O_CALLOF_VAL_CUMOpen Releasable Value for Item CRMT_O_CALLOF_VAL_CUMCURR19(2) PRC_COND_VALUE
O_INV_VAL_CUMOpen Item Value for Billing CRMT_OPEN_INV_VAL_CUMCURR15(2) WERTV8
O_ORDER_VAL_CUMOpen Order Value for Item CRMT_OPEN_ORD_VAL_CUMCURR15(2) WERTV8
FULLFILL_QTYDegree of Fulfillment: Target/Quantity CRMT_FULLFILLMENT_TGTDEC5(2)
FULLFILL_VALDegree of Fulfillment: Target/Quantity CRMT_FULLFILLMENT_TGTDEC5(2)
CUMULAT_UNIT_CUMUnit of Cumulated Quantity CRMT_CUMULAT_QTY_UNIT_CUMUNIT3Assigned to domainCUNITMEINS
CUMULAT_CURR_CUMCurrency of Cumulated Value CRMT_CUMULAT_CURR_CUMCUKY5Assigned to domainWAERS
QUOT_VAL_CUMQuotation Value for an Item CRMT_QUOT_VAL_CUMCURR15(2) WERTV8
QUOT_QTY_CUMQuotation Quantity for Item CRMT_QUOT_QTY_CUMQUAN15(3) CRM_MENGV15
GI_QTY_CUMGoods Issue Quantity for an Item CRMT_GOODS_ISSUE_QTY_CUMQUAN15(3) CRM_MENGV15
GI_QTY_SINGLEGoods Issue Quantity for an Item CRMT_GOODS_ISSUE_QTY_CUMQUAN15(3) CRM_MENGV15
DELIV_QTY_SINGLEDelivered Quantity for an Item CRMT_DELIVERED_QTY_CUMQUAN15(3) CRM_MENGV15
INCOTERMS1Incoterms (Part 1) CRMT_INCOTERMS1CHAR3Assigned to domainCRM_INCOTERMS1
INCOTERMS2Incoterms (Part 2) CRMT_INCOTERMS2CHAR28CRM_INCOTERMS2
BILLING_DATEBilling Date CRMT_BW_BILL_DATEDATS8CRM_RPRTNG_DATE
BILLING_BLOCKBusiness Partner (CRM): Billing Block Reason CRMT_BUS_BILL_BLOCK_REASONCHAR2Assigned to domainCRM_BILLING_BLOCK
STATUS_INQUIRYStatus of Inquiry CRMT_STATUS_INQUIRYCHAR1BOOLEAN
STATUS_QUOTATIONQuotation Status CRMT_STATUS_QUOTATIONCHAR1CRM_BOOLEAN
STATUS_ERRORIndicates Whether Document is Incorrect CRMT_STATUS_ERRORCHAR1CRM_BOOLEAN
STATUS_INVOICEDBilling Status CRMT_STATUS_INVOICEDCHAR1CRM_BOOLEAN
STATUS_ACCEPTEDStatus: Quotation Accepted CRMT_STATUS_ACCEPTEDCHAR1BOOLEAN
STATUS_COMPLETEDStatus: Completed CRMT_STATUS_COMPLETEDCHAR1BOOLEAN
STATUS_CANCELLEDRejection Status CRMT_STATUS_CANCELLEDCHAR1BOOLEAN
STATUS_DOC_SYSObject Status CRM_J_STATUSCHAR5CRM_J_STATUS
STATUS_DELIVEREDDelivery Status (Use for BW Only) CRMT_DELIVERY_STATCHAR1CRMT_BW_DELIVERY_STAT_DOM
STATUS_EXPIREDStatus End of Validity Period (Quotation) CRMT_STATUS_EXPIREDCHAR1BOOLEAN
KATALOGARTCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
CODEGRUPPECode Group QCODEGRPCHAR8Assigned to domainQCODEGRPCGP
CODECode QCODECHAR4Assigned to domainQCODEQCODE
ACT_REASON_CATCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
ACT_REASON_GROUPCode Group QCODEGRPCHAR8Assigned to domainQCODEGRPCGP
ACT_REASON_CODECode QCODECHAR4Assigned to domainQCODEQCODE
EXT_REFOBJExternal Reference Object CRMT_EXT_REFOBJCHAR40CHAR40
CALDAYCalendar Day SMOCALDAYDATS8DATUM
PREDEC_OBJKEYGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
PREDEC_OBJTYPEObject Type of a Preceding Document CRMT_PRED_OBJECT_TYPECHAR10Assigned to domainOJ_NAME
LOGSYS_PREDLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
MKT_ELEMENTMarketing Plan Element CRM_MKTPL_MKT_PLAN_TASKIDCHAR24CGPL_EXTID
PRED_LEAD_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
LEAD_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
PRED_OPPT_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
OPPT_CREATED_ATTransaction Was Created at This Time CRMT_OPPT_CREATED_ATDATS8DATUM
PRED_ACT_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
ACT_CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3Assigned to domainCRM_ACTIVITY_CATEGORY
ACT_DIRECTIONDirection of an Activity CRMT_DIRECTIONCHAR1CRM_DIRECTION
QUOTATION_GUIDGUID for a Transaction CRMT_PROCESS_GUID_32CHAR32SYSUUID_C
QUOT_VALID_FROMQuotation Valid from Date CRMT_VALID_FROM_DATEDATS8CRM_RPRTNG_DATE
PROCESS_CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3Assigned to domainCRM_ACTIVITY_CATEGORY
PROCESS_CATALOGCatalog COMT_CATALOGCHAR2Assigned to domainCOM_CATALOGQKT
PROCESS_CODEGRCode Group QCODEGRPCHAR8Assigned to domainQCODEGRPCGP
PROCESS_CODECode QCODECHAR4Assigned to domainQCODEQCODE
PROCESS_OBJTYPEObject Type of a Preceding Document CRMT_PRED_OBJECT_TYPECHAR10Assigned to domainOJ_NAME
PO_NUMBERTransaction ID CRMT_OBJECT_IDCHAR10ALPHACRM_OBJECT_IDCRM_OBJECT_IDCRM_ORDER_OBJECT_ID
PO_ITEM_NUMBERItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
ORDER_QTYCRM: Order Quantity CRMT_QTY_ORDERQUAN13(3) MENG13
CONFIRMED_QTYCRM: Confirmed Quantity CRMT_QTY_CONFIRMEDQUAN13(3) MENG13
BWSTONESYS0BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS1BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS2BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS3BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS4BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS5BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS6BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS7BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS8BW Status CRMBWSTNUMC2J_STONR
BWSTONESYS9BW Status CRMBWSTNUMC2J_STONR
BWSTONESYSABW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS0BW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS1BW Status CRMBWSTNUMC2J_STONR
BWSTTECSYS2BW Status CRMBWSTNUMC2J_STONR
BWSTLOCSYS0BW Status CRMBWSTNUMC2J_STONR
BWSTLOCSYS1BW Status CRMBWSTNUMC2J_STONR
BWSTLOCSYS2BW Status CRMBWSTNUMC2J_STONR
BWSTONESYSBBW Status CRMBWSTNUMC2J_STONR
GROSS_VALUE_HTotal Gross Value of Document in Document Currency CRMT_GROSS_VALUE_CUMCURR15(2) WERTV8
NET_VALUE_HTotal Net Value of Document in Document Currency CRMT_NET_VALUE_CUMCURR15(2) WERTV8
NET_VALUE_MAN_HExpected Total Net Value of Products in Document Currency CRMT_NET_VALUE_MAN_CUMCURR15(2) WERTV8
PATH_GUIDPath GUID of Territory 32 CRMT_PATH_GUID_32CHAR32SYSUUID_C
TERR_GUIDTerritory GUID 32 CRMT_TERR_GUID_32CHAR32SYSUUID_C
HOM_FLAGIndicator of an order from Hosted Order Management scenario CRMT_HOM_FLAGCHAR1CRM_BOOLEAN
IOBJECT_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
IOBJECT_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
CONFPROD_IDProduct ID COMT_PRODUCT_IDCHAR40PRID1COM_PRODUCT_IDCOM_PR_COLLECTION
CONFPROD_GUIDInternal Unique ID of Product COMT_PRODUCT_GUIDRAW16SYSUUID
PROD_OBJ_FAMObject Family COMT_PRODUCT_OBJECT_FAMILYCHAR4Assigned to domainCOM_PRODUCT_OBJECT_FAMILYCOM_OBJFAM_PRTYP
BATCH_IDBatch Number CRMT_BATCH_IDCHAR10BATCH_IDCHA
SAMPLESample Indicator CRMT_SAMPLE_INVCHAR1CRM_BOOLEAN
SAMPLE_SPECSample CRMT_SAMPLE_SPECCHAR1CRMBWSAMPLE
SAMPLE_QTY_ALLOWNumber of samples CRM_ACT_NUMBER_OF_SAMPLESDEC4DEC4
CUOBJConfiguration (Internal Object Number) CRMT_INT_OBJ_NONUMC18ALPHAIB_INSTANCE
FLAG_ALT_ITMBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
FLAG_STATBoolean Variable (X=True, -=False, Space=Unknown) BOOLEANCHAR1BOOLEAN
RJCTRSReason for Rejection CRMT_RJCTRSCHAR3Assigned to domainCRM_RJCTRS
EXE_LOC_NUMBERChar 20 CHAR20CHAR20CHAR20
EXE_LOC_TYPENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
FACING_LOCATIONChar 20 CHAR20CHAR20CHAR20
FACING_LOCTYPENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
FIRSTS_LOCATIONChar 20 CHAR20CHAR20CHAR20
FIRSTS_LOC_TYPENot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
OVERRIDE_LOCChar 20 CHAR20CHAR20CHAR20
EXELOC_BPBusiness Partner of the Executing Location CRMT_EXELOC_BPCHAR10Assigned to domainALPHABU_PARTNER
FACLOC_BPBusiness Partner for Facing Location CRMT_FACLOC_BPCHAR10Assigned to domainALPHABU_PARTNER

Key field Non-key field



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

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

How to access SAP table CRMT_BW_SALES_ORDER_I

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