SAP ABAP Table CRMV_LNKPRISET_I (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRMV_LNKPRISET_I   Table Relationship Diagram
Short Description Generated Table for View    
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 CLIENT MANDT MANDT CLNT 3   0   Client  
2 GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
3 REF_GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
4 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type TCURV
5 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
6 TAXJURCODE CRMT_TAXJURCODE TXJCD CHAR 15   0   Tax Jurisdiction Code (Structure for tax calculation)  
7 CUST_PRIC_PROC CRMT_CUST_PRIC_PROC CRM_CUST_PRIC_PROC CHAR 1   0   Customer Pricing Procedure  
8 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency TCURC
9 ENT_STRATEGY CRMT_ENT_STRATEGY CRM_ENT_STRATEGY CHAR 1   0   Entitlement Strategy  
10 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency TCURC
11 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
12 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment  
13 PRICE_GRP CRMT_PRICE_GRP CRM_PRICE_GRP CHAR 2   0   Customer Price Group CRMC_PRICEGRP
14 PRICE_LIST CRMT_PRICE_LIST CRM_PRICE_LIST CHAR 2   0   Price List Type CRMC_PRICELIST
15 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group CRMC_CUSTGRP
16 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
17 TAX_DEST_CTY CRMT_TAX_DEST_CTY LAND1 CHAR 3   0   Tax Destination Country T005
18 TAX_DEST_REG CRMT_REGION REGIO CHAR 3   0   Region (State, Province, County)  
19 VAT_REG_NO CRMT_VAT_REG_NO   CHAR 20   0   Sales tax registration number  
20 ETAX_HAND_TYPE CRMT_ETAX_HAND_TYPE CRM_ETAX_HAND_TYPE CHAR 2   0   Excise Tax Handling Type (Denotes Use of Material)  
21 ETAX_SOURCE CRMT_ETAX_SOURCE CRM_ETAX_SOURCE CHAR 2   0   Source of Excise Tax Rates  
22 SCORE CRMT_SCORE CRM_SCORE CHAR 10   0   Result Value of an Internal Creditworthiness Check  
23 GRADE BP_GRADE BP_GRADE CHAR 10   0   Rating  
24 AC_INDICATOR CRMT_AC_INDICATOR CRMT_AC_INDICATOR CHAR 2   0   Accounting Indicator CRMC_AC_IND
25 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type  
26 CFOP_CODE ITL_CFOP ITL_CFOP CHAR 10   0   CFOP Code and Extension COMC_CFOP_CODE
27 ICMS_TAXLAW ITL_TAXLAW1 ITL_TAXLAW1 CHAR 3   0   ICMS Tax Law ID COMC_TAX_LAW_1
28 IPI_TAXLAW ITL_TAXLAW2 ITL_TAXLAW2 CHAR 3   0   IPI Tax Law ID COMC_TAX_LAW_2
29 TAX_MAT_USAGE TAX_MAT_USAGE TAX_MAT_USAGE CHAR 1   0   Material Usage  
30 LOC_TAXCAT LOC_TAXCAT LOC_TAXCAT CHAR 2   0   Tax Category CRMC_TAXCAT
31 LOC_ZEROVAT LOC_ZEROVAT LOC_ZEROVAT CHAR 1   0   Reason for Zero-Rated VAT CRMC_ZEROVAT
32 LOC_ACTCODE LOC_ACTCODE LOC_ACTCODE CHAR 2   0   Activity Code for Gross Income Tax CRMC_ACTCODE
33 LOC_DISTTYPE LOC_DISTTYPE LOC_DISTTYPE CHAR 2   0   Distribution Type for Employment Tax CRMC_DISTTYPE
34 LOC_TXRELCLAS LOC_TXRELCLAS LOC_TXRELCLAS CHAR 10   0   Tax Relevance Classification CRMC_TXRELCLAS
35 ISS_TAXLAW LOC_TAX_LAW3 LOC_TAX_LAW3 CHAR 3   0   ISS Tax Law  
36 COFINS_TAXLAW LOC_TAX_LAW4 LOC_TAX_LAW4 CHAR 3   0   COFINS Tax Law  
37 PIS_TAXLAW LOC_TAX_LAW5 LOC_TAX_LAW5 CHAR 3   0   PIS Tax Law  
38 PAYMENT_METHOD CRMT_BUAG_PAYMETH CRM_BUAG_PAYMETH CHAR 1   0   Payment Method  
39 SCRAP_VALUE CRMT_SPL_SCRAP_VALUE   CURR 10   2   Threshold for Further Action for New Parts  
40 SCRAP_CURRENCY CRMT_SPL_SCRAP_CUKY WAERS CUKY 5   0   Currency Key for Reuse Threshold Value  
41 SCRAP_INSTR_LOW CRMT_SPL_SCRAP_INSTR_LOW CRM_SPL_SCRAP_INSTRUCTION CHAR 1   0   Procedure for Values under Threshold  
42 SCRAP_INSTR_HIGH CRMT_SPL_SCRAP_INSTR_HIGH CRM_SPL_SCRAP_INSTRUCTION CHAR 1   0   Procedure for Values over Threshold  
43 LOY_MEMS_ID CRM_LOY_MEMS_ID CRM_LOY_MEMS_ID CHAR 10   0   Membership ID  
44 LOY_PSH_ID CRM_LOY_PSH_ID CRM_LOY_PSH_ID CHAR 10   0   Partnership ID  
45 FUND_EXCHG_TYPE CRMT_FUND_EXCHG_TYPE KURST CHAR 4   0   Fund Exchange Rate Type  
46 FUND_EXCHG_DATE CRMT_FUND_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Fund Exchange Date  
47 FUND_EXCHG_RATE CRMT_FUND_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Fund Exchange Rate  
48 FUND_EXCHG_R_TG CRMT_FUND_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Fund Exchange Rate  
49 PRICING_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
50 TAX_EXEMPT_GUID CRM_TAX_EXEMPT_HEADER_GUID SYSUUID RAW 16   0   Object Header GUID  
51 TAX_EXEMPT_ID CRM_TAX_EXEMPT_ID CRM_TAX_EXEMPT_ID CHAR 30   0   Customer Tax Exemption Certificate ID  
52 POINT_PMT_INDIC CRMT_LOY_POINT_PAYMENT CRM_LOY_POINT_PAYMENT CHAR 1   0   Point Payment Option  
53 POINT_PMT_AMT CRMT_LOY_PMT_AMT   DEC 10   2   Point Payment Amount - Header  
54 POINT_PMT_PTYPE CRMT_LOY_PMT_PTTYPE CRM_MKTPL_LOY_POINT_CODE CHAR 10   0   Payment Point Type  
55 VALID_FROM CRMT_VALID_FROM BCOS_TSTMP DEC 15   0   Time Dependency: Validity Start Date  
56 VALID_TO CRMT_VALID_TO BCOS_TSTMP DEC 15   0   Time Dependency: Validity End Date  
57 TRANS_TIME CRMT_TRANS_TIME BCOS_TSTMP DEC 15   0   Time Last Change was Made  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMV_LNKPRISET_I AC_INDICATOR CRMC_AC_IND AC_INDICATOR 1 CN
2 CRMV_LNKPRISET_I CFOP_CODE COMC_CFOP_CODE CFOP_CODE    
3 CRMV_LNKPRISET_I CURRENCY TCURC WAERS    
4 CRMV_LNKPRISET_I CUST_GROUP CRMC_CUSTGRP CUST_GROUP REF C CN
5 CRMV_LNKPRISET_I EXCHG_TYPE TCURV KURST    
6 CRMV_LNKPRISET_I ICMS_TAXLAW COMC_TAX_LAW_1 TAX_LAW    
7 CRMV_LNKPRISET_I IPI_TAXLAW COMC_TAX_LAW_2 TAX_LAW    
8 CRMV_LNKPRISET_I LOC_ACTCODE CRMC_ACTCODE LOC_ACTCODE    
9 CRMV_LNKPRISET_I LOC_DISTTYPE CRMC_DISTTYPE LOC_DISTTYPE    
10 CRMV_LNKPRISET_I LOC_TAXCAT CRMC_TAXCAT LOC_TAXCAT    
11 CRMV_LNKPRISET_I LOC_TXRELCLAS CRMC_TXRELCLAS LOC_TXRELCLAS    
12 CRMV_LNKPRISET_I LOC_ZEROVAT CRMC_ZEROVAT LOC_ZEROVAT    
13 CRMV_LNKPRISET_I PRICE_GRP CRMC_PRICEGRP PRICE_GROUP    
14 CRMV_LNKPRISET_I PRICE_LIST CRMC_PRICELIST PRICE_LIST REF C CN
15 CRMV_LNKPRISET_I REF_CURRENCY TCURC WAERS    
16 CRMV_LNKPRISET_I TAX_DEST_CTY T005 LAND1    
History
Last changed by/on SAP  20140117 
SAP Release Created in