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