SAP ABAP Table BEAS_SAPRO (Product with Sales Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-NPL (Application Component) Price List
⤷ BEA_CLASS_N1 (Package) BE Application - Objects of Price List Class
⤷ CRM-MD-NPL (Application Component) Price List
⤷ BEA_CLASS_N1 (Package) BE Application - Objects of Price List Class
Basic Data
Table Category | INTTAB | Structure |
Structure | BEAS_SAPRO | Table Relationship Diagram |
Short Description | Product with Sales Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
2 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
3 | SHORT_TEXT | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
4 | .INCLUDE | 0 | 0 | Sales Data (Product): Interface for Order | |||||
5 | PRODUCT_TYPE | COMT_PRODUCT_TYPE | COM_PRODUCT_TYPE | CHAR | 2 | 0 | Product Type | COMC_PR_TYPE | |
6 | .INCLUDE | 0 | 0 | General Material Data (Data Part) | |||||
7 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | CRMC_DIVISION | |
8 | ITEM_CAT_GROUP | CRMT_ITEM_CAT_GROUP | CRM_ITEM_CAT_GROUP | CHAR | 4 | 0 | Item Category Group | CRMC_ITEM_CAT_GR | |
9 | .INCLUDE | 0 | 0 | Sales Data on Product: Control Fields, Quantities (w/o Key) | |||||
10 | PROCESS_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | T006 | |
11 | CASH_DISC | CRMT_CASH_DISC | XFELD | CHAR | 1 | 0 | Specifies Whether a Cash Discount Can Be Given for the Prod. | ||
12 | MIN_ORDER | CRMT_MIN_ORDER | MENG13 | QUAN | 13 | 3 | Minimum Order Quantity in Base Unit of Measure | ||
13 | PRICE_PRODUCT | CRMT_PRICE_PRODUCT | SYSUUID | RAW | 16 | 0 | Pricing Reference Product Globally Unique Identifier | ||
14 | S_ITEM_CAT_GROUP | CRMT_SALES_ITEM_CAT_GROUP | CRM_ITEM_CAT_GROUP | CHAR | 4 | 0 | Distribution-Chain-Dependent Item Category Group | CRMC_ITEM_CAT_GR | |
15 | UNDEL | CRMT_UNDEL | MEINS | UNIT | 3 | 0 | Unit of Measure of Delivery Unit | * | |
16 | DELY_UNIT | CRMT_DELY_UNIT | MENG13 | QUAN | 13 | 3 | Delivery Unit | ||
17 | UNSALE_NOT_VAR | CRMT_UNSALE_NOT_VAR | XFELD | CHAR | 1 | 0 | Variable Sales Unit Not Allowed | ||
18 | LOC_BUPA | INVENT_LOC_BUPA | BU_PARTNER | CHAR | 10 | 0 | Delivering Location | * | |
19 | O_ITEM_CAT_GROUP | CRMT_IND_OBJ_ITEM_CAT_GROUP | CRM_ITEM_CAT_GROUP | CHAR | 4 | 0 | Item Category Group for Individual Objects | * | |
20 | .INCLUDE | 0 | 0 | Sales Data on Product: Groupings (Without Key) | |||||
21 | PROD_PR_GROUP | CRMT_PROD_PR_GROUP | CRM_PROD_PR_GROUP | CHAR | 2 | 0 | Product Group | CRMC_PRC_PRGRP | |
22 | PRC_GROUP1 | CRMT_PRC_GROUP1 | CRM_PRC_GROUP1 | CHAR | 3 | 0 | Product Group 1 | CRMC_PRC_GRP1 | |
23 | PRC_GROUP2 | CRMT_PRC_GROUP2 | CRM_PRC_GROUP2 | CHAR | 3 | 0 | Product Group 2 | CRMC_PRC_GRP2 | |
24 | PRC_GROUP3 | CRMT_PRC_GROUP3 | CRM_PRC_GROUP3 | CHAR | 3 | 0 | Product Group 3 | CRMC_PRC_GRP3 | |
25 | PRC_GROUP4 | CRMT_PRC_GROUP4 | CRM_PRC_GROUP4 | CHAR | 3 | 0 | Product Group 4 | CRMC_PRC_GRP4 | |
26 | PRC_GROUP5 | CRMT_PRC_GROUP5 | CRM_PRC_GROUP5 | CHAR | 3 | 0 | Product Group 5 | CRMC_PRC_GRP5 | |
27 | REBATE_GROUP | CRMT_REBATE_GROUP | CRM_REBATE_GROUP | CHAR | 2 | 0 | Volume Rebate Group | CRMC_REBATEGRP | |
28 | COMM_GROUP | CRMT_COMM_GROUP | CRM_COMM_GROUP | CHAR | 2 | 0 | Commission Group | CRMC_COMM_GRP | |
29 | ACCTGRP_PROD | CRMT_ACCTGRPPROD | CRM_ACCTGRPPROD | CHAR | 2 | 0 | Account Assignment Group for Product | CRMC_ACGRPPROD | |
30 | SALESCAT_GUID | CRMT_SALESCAT_GUID | SYSUUID | RAW | 16 | 0 | Distribution Chain Dependent Category | ||
31 | STATUS_OBJECT | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
32 | PROD_HIERARCHY | CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
33 | CONF_PROD_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
34 | CUOBJ | CRMT_INT_OBJ_NO | IB_INSTANCE | NUMC | 18 | 0 | Configuration (Internal Object Number) | ||
35 | .INCLUDE | 0 | 0 | Type of Configurable Product | |||||
36 | CONFIG | COMT_PRODUCT_CONFIGURABLE | COM_PRODUCT_CONFIGURABLE | CHAR | 1 | 0 | Determines Whether a Product Is Configurable | * | |
37 | R3_CONFIG | COMT_R3_CONFIG | XFELD | CHAR | 1 | 0 | Indicator: ERP-Type Configuration | ||
38 | USE_IPC | COMT_USE_IPC | XFELD | CHAR | 1 | 0 | Indicator: IPC Used for Configuration | ||
39 | ONLY_VAR_FIND | COMT_ONLY_VAR_FIND | XFELD | CHAR | 1 | 0 | Indicator: Perform Variant Matching Only in Configuration | ||
40 | BATCH_DEDICATED | COMT_BATCH_DEDICATED | COM_BOOLEAN | CHAR | 1 | 0 | Specifies Whether Batches Are Maintained for Product | ||
41 | BASE_UOM | COMT_MAT_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure of a Material | T006 | |
42 | USE_IPC_VAR | COMT_USE_IPC_VAR | XFELD | CHAR | 1 | 0 | Indicator: Variants of a Generic Article |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BEAS_SAPRO | ACCTGRP_PROD | CRMC_ACGRPPROD | ACCTGRP_PROD | |||
2 | BEAS_SAPRO | BASE_UOM | T006 | MSEHI | |||
3 | BEAS_SAPRO | COMM_GROUP | CRMC_COMM_GRP | COMM_GROUP | |||
4 | BEAS_SAPRO | DIVISION | CRMC_DIVISION | DIVISION | |||
5 | BEAS_SAPRO | ITEM_CAT_GROUP | CRMC_ITEM_CAT_GR | ITEM_CAT_GROUP | |||
6 | BEAS_SAPRO | PRC_GROUP1 | CRMC_PRC_GRP1 | PRC_GROUP1 | |||
7 | BEAS_SAPRO | PRC_GROUP2 | CRMC_PRC_GRP2 | PRC_GROUP2 | |||
8 | BEAS_SAPRO | PRC_GROUP3 | CRMC_PRC_GRP3 | PRC_GROUP3 | |||
9 | BEAS_SAPRO | PRC_GROUP4 | CRMC_PRC_GRP4 | PRC_GROUP4 | |||
10 | BEAS_SAPRO | PRC_GROUP5 | CRMC_PRC_GRP5 | PRC_GROUP5 | |||
11 | BEAS_SAPRO | PROCESS_UNIT | T006 | MSEHI | |||
12 | BEAS_SAPRO | PRODUCT_TYPE | COMC_PR_TYPE | PRODUCT_TYPE | |||
13 | BEAS_SAPRO | PROD_PR_GROUP | CRMC_PRC_PRGRP | PRC_PR_GROUP | |||
14 | BEAS_SAPRO | REBATE_GROUP | CRMC_REBATEGRP | REBATE_GROUP | |||
15 | BEAS_SAPRO | S_ITEM_CAT_GROUP | CRMC_ITEM_CAT_GR | ITEM_CAT_GROUP |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 400 |