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