SAP ABAP Table CRMT_BSP_BTX_BRI_ITM_DATA_IL (Billing Plan Items: Item Overview)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF-FIN (Application Component) Financing
⤷ CRM_BSP_MODEL_IL_LEASING (Package) Model Implementation: Leasing
⤷ CRM-BTX-BF-FIN (Application Component) Financing
⤷ CRM_BSP_MODEL_IL_LEASING (Package) Model Implementation: Leasing
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BSP_BTX_BRI_ITM_DATA_IL | Table Relationship Diagram |
Short Description | Billing Plan Items: Item Overview |
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 | .INCLUDE | 0 | 0 | Item Data Detail Sales | |||||
2 | .INCLUDE | 0 | 0 | Management of Interface Structures | |||||
3 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
4 | HANDLE | CRMT_HANDLE | NUMC | 10 | 0 | Handle | |||
5 | ORDERED_PROD | CRMT_ORDERED_PROD | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
6 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
7 | PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
8 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
9 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
10 | SHORT_TEXT | CRMT_ITEM_DESCR | TEXT40 | CHAR | 40 | 0 | Short Text for Item | ||
11 | ITM_LANGUAGE | CRMT_ITEM_LANGU | SYLANGU | LANG | 1 | 0 | Short Text Language for an Item | ||
12 | ORDER_DATE | CRMT_ORDER_DATE | BCOS_TSTMP | DEC | 15 | 0 | Posting Date | ||
13 | ORDER_DATE_TZTF | TZTF_IO_FIELD | TZTF_IO_FIELD | CHAR | 26 | 0 | Field for Date Input | ||
14 | ITM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
15 | TAX_DEPART_CTY | CRMT_TAX_DEPART_CTY | LAND1 | CHAR | 3 | 0 | Tax Departure Country | * | |
16 | TAX_DEPART_CTY_T | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
17 | TAX_DEPART_REG | CRMT_TAX_DEPART_REG | REGIO | CHAR | 3 | 0 | Departure Region for Tax | T005S | |
18 | TAX_DEPART_REG_T | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
19 | STATISTICAL | CRMT_STATISTICAL | CRM_STATISTICAL | CHAR | 1 | 0 | Statistical values | ||
20 | PRC_INDICATOR | CRMT_PRICING_INDICATOR | CRM_PRICING_INDICATOR | CHAR | 1 | 0 | Pricing indicator | ||
21 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
22 | TAX_AMOUNT | CRMT_TAX_AMOUNT | WERTV8 | CURR | 15 | 2 | Tax amount in document currency | ||
23 | FREIGHT | CRMT_FREIGHT | WERTV8 | CURR | 15 | 2 | Shipment costs in document currency | ||
24 | GROSS_VALUE | CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
25 | SUBTOTAL1 | CRMT_SUBTOTAL1 | WERTV8 | CURR | 15 | 2 | Subtotal 1 from pricing procedure for condition | ||
26 | SUBTOTAL2 | CRMT_SUBTOTAL2 | WERTV8 | CURR | 15 | 2 | Subtotal 2 from pricing procedure for condition | ||
27 | SUBTOTAL3 | CRMT_SUBTOTAL3 | WERTV8 | CURR | 15 | 2 | Subtotal 3 from pricing procedure for condition | ||
28 | SUBTOTAL4 | CRMT_SUBTOTAL4 | WERTV8 | CURR | 15 | 2 | Subtotal 4 from pricing procedure for condition | ||
29 | SUBTOTAL5 | CRMT_SUBTOTAL5 | WERTV8 | CURR | 15 | 2 | Subtotal 5 from pricing procedure for condition | ||
30 | SUBTOTAL6 | CRMT_SUBTOTAL6 | WERTV8 | CURR | 15 | 2 | Subtotal 6 from pricing procedure for condition | ||
31 | PCAT_HDR_GUID | COMT_PCAT_HDR_GUID | SYSUUID | RAW | 16 | 0 | Product Catalog GUID (Header) | ||
32 | PCAT_VRT_GUID | COMT_PCAT_VRT_GUID | SYSUUID | RAW | 16 | 0 | Product Catalog Variant GUID | ||
33 | PCAT_ITM_GUID | COMT_PCAT_ITM_GUID | SYSUUID | RAW | 16 | 0 | GUID of Product Catalog Item | ||
34 | INCOTERMS1 | CRMT_INCOTERMS1 | CRM_INCOTERMS1 | CHAR | 3 | 0 | Incoterms (Part 1) | CRMC_INCOTERM | |
35 | INCOTERMS2 | CRMT_INCOTERMS2 | CRM_INCOTERMS2 | CHAR | 28 | 0 | Incoterms (Part 2) | ||
36 | SHIP_COND | CRMT_SHIP_COND | CRM_SHIP_COND | CHAR | 2 | 0 | Shipping Conditions | CRMC_SHIP_COND | |
37 | DELI_UNLIM_TOL | CRMT_DELI_UNLIM_TOL | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Unlimited Overdelivery Allowed | ||
38 | OVER_DLV_TOL | CRMT_OVER_DLV_TOL | PRZ21 | DEC | 3 | 1 | Overdelivery Tolerance Limit | ||
39 | UNDER_DLV_TOL | CRMT_UNDER_DLV_TOL | PRZ21 | DEC | 3 | 1 | Underdelivery Tolerance Limit | ||
40 | DLV_PRIO | CRMT_DLV_PRIO | CRM_DLV_PRIO | NUMC | 2 | 0 | Delivery Priority | CRMC_DLV_PRIO | |
41 | ORDERCOMBIND | CRMT_ORDERCOMBIND | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Order Combination | ||
42 | CREATED_AT | CRMT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Transaction was Created at this Time | ||
43 | CREATED_AT_TZTF | TZTF_IO_FIELD | TZTF_IO_FIELD | CHAR | 26 | 0 | Field for Date Input | ||
44 | CHANGED_AT | CRMT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change to the Transaction | ||
45 | CHANGED_AT_TZTF | TZTF_IO_FIELD | TZTF_IO_FIELD | CHAR | 26 | 0 | Field for Date Input | ||
46 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
47 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
48 | NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10 | 0 | External Item Number | |||
49 | CUST_GROUP | CRMT_CUST_GROUP | CRM_CUST_GROUP | CHAR | 2 | 0 | Customer Group | CRMC_CUSTGRP | |
50 | PRICE_LIST | CRMT_PRICE_LIST | CRM_PRICE_LIST | CHAR | 2 | 0 | Price List Type | * | |
51 | PRICE_GRP | CRMT_PRICE_GRP | CRM_PRICE_GRP | CHAR | 2 | 0 | Customer Price Group | * | |
52 | BATCH_ID | CRMT_BATCH_ID | BATCH_ID | CHAR | 10 | 0 | Batch Number | ||
53 | REPLACED_PROD | CRMT_REPLACED_PROD | CRM_REPLACED_PROD | CHAR | 40 | 0 | Product ID replaced by product substitution |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BSP_BTX_BRI_ITM_DATA_IL | CUST_GROUP | CRMC_CUSTGRP | CUST_GROUP | |||
2 | CRMT_BSP_BTX_BRI_ITM_DATA_IL | DLV_PRIO | CRMC_DLV_PRIO | DLV_PRIO | REF | C | CN |
3 | CRMT_BSP_BTX_BRI_ITM_DATA_IL | INCOTERMS1 | CRMC_INCOTERM | INCOTERMS1 | |||
4 | CRMT_BSP_BTX_BRI_ITM_DATA_IL | SHIP_COND | CRMC_SHIP_COND | SHIP_COND | REF | C | CN |
5 | CRMT_BSP_BTX_BRI_ITM_DATA_IL | TAX_DEPART_REG | T005S | BLAND |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in | 500 |