SAP ABAP Table CRMC_NFDET (Sales Document Item Category table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC (Application Component) Localization
     ⤷ CRM_LOC_BRAZIL (Package) CRM Localization Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_NFDET	Table Relationship Diagram
Short Description	Sales Document Item Category table

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PROCESS_TYPE	☑	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
3	ITM_TYPE	☑	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	CRMC_ITEM_TYPE
4	NF_ITEM_TYPE	☐	ITL_NFITMTYP	ITL_NFITMTYP	CHAR	2	0	Nota Fiscal Item Type	COMC_NFITMTYP
5	SUB_TRIB	☐	ITL_SUBTRIB	ITL_SUBTRIB	CHAR	2	0	Substituição Tributária
6	NF_PARTNER	☐	ITL_NF_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Nota Fiscal Main Partner Function	CRMC_PARTNER_FCT
7	R3_USAGE	☐	LOC_R3_USAGE	LOC_R3_USAGE	CHAR	3	0	Material Usage (SAP R/3)	CRMC_R3_USAGE
8	TAX_MAT_USAGE	☐	TAX_MAT_USAGE	TAX_MAT_USAGE	CHAR	1	0	Material Usage
9	ICMS_STAT	☐	ITL_ICMS_STAT	XFELD	CHAR	1	0	Indicator: ICMS tax statistical
10	ICMS_LAW	☐	ITL_TAXLAW1	ITL_TAXLAW1	CHAR	3	0	ICMS Tax Law ID	COMC_TAX_LAW_1
11	IPI_STAT	☐	ITL_IPI_STAT	XFELD	CHAR	1	0	Indicator: IPI tax statistical
12	IPI_LAW	☐	ITL_TAXLAW2	ITL_TAXLAW2	CHAR	3	0	IPI Tax Law ID	COMC_TAX_LAW_2

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_NFDET	ICMS_LAW	COMC_TAX_LAW_1	TAX_LAW
2	CRMC_NFDET	IPI_LAW	COMC_TAX_LAW_2	TAX_LAW
3	CRMC_NFDET	ITM_TYPE	CRMC_ITEM_TYPE	ITM_TYPE
4	CRMC_NFDET	NF_ITEM_TYPE	COMC_NFITMTYP	NF_ITEM_TYPE
5	CRMC_NFDET	NF_PARTNER	CRMC_PARTNER_FCT	PARTNER_FCT
6	CRMC_NFDET	PROCESS_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE
7	CRMC_NFDET	R3_USAGE	CRMC_R3_USAGE	R3_USAGE

History

Last changed by/on	SAP	20041011
SAP Release Created in	400