SAP ABAP Table BBP_IV_ITEM (Item structure for BBP IV)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP-INV (Application Component) Invoicing
     ⤷ BBP_IV1 (Package) Lean MM Invoicing Application

Basic Data

Table Category	INTTAB	Structure
Structure	BBP_IV_ITEM	Table Relationship Diagram
Short Description	Item structure for BBP IV

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 Invoice GetDetail-Case Interface
2	.INCLUDE	☐				0	0	Item Data Invoice Create/Check/Change-Case Interface
3	.INCLUDE	☐				0	0	Item Data for All Doucments in All Cases Interface
4	GUID	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
5	PARENT	☐	BBP_PGUID	SYSUUID	RAW	16	0	Parent GUID
6	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
7	NUMBER_INT	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
8	NUMBER_EXT	☐	BBP_ITEM_NO_EXT		NUMC	10	0	External Item Number
9	PRODUCT	☐	BBP_PRODUCT	SYSUUID	RAW	16	0	Product GUID
10	DESCRIPTION	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
11	CATEGORY	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
12	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
13	SCHEMA_TYPE	☐	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
14	CT_CATEGORY_ID	☐	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
15	ITM_EX_CT_UN_ID	☐	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
16	MANU_PROD	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
17	MFR_NO_EXT	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
18	CATALOGID	☐	CATALOG	KATALOGID	CHAR	20	0	Catalog ID from which the line was selected	*
19	CATALOGITEM	☐	CATALOGITEM	CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
20	EXT_QUOTE_ID	☐	BBP_EXT_QUOTE_ID		CHAR	35	0	Number of External Bid
21	EXT_QUOTE_ITEM	☐	BBP_EXT_QUOTE_ITEM		NUMC	10	0	Item for an External Bid
22	QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
23	UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
24	DEL_IND	☐	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
25	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
26	PRODUCT_SRC_SYS	☐	BBP_LOGSYS	CHAR10	CHAR	10	0	Business Document Service: ID of Logical System
27	PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
28	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
29	SUBTYPE	☐	BBP_I_SUBTYPE	BBP_I_SUBTYPE	CHAR	2	0	Specification Purchase Item (e.g. Direct Material/Hierarch.)
30	SRC_OBJECT_TYPE	☐	BBP_SRC_I_OBJ_TYP	OJ_NAME	CHAR	10	0	Object Type of Reference Item	*
31	SRC_GUID	☐	BBP_SRC_I_GUID	SYSUUID	RAW	16	0	Reference Item GUID
32	VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
33	TAX_CODE	☐	BBP_MWSKZ	BBP_MWSKZ	CHAR	2	0	Tax Code
34	PARTNER_PROD	☐	BBP_PARTNER_PROD	PRSHTEXT40	CHAR	40	0	Product Number of Vendor
35	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
36	CTR_GUID	☐	BBP_CTR_I_GUID	SYSUUID	RAW	16	0	Contract Template Item GUID
37	CTR_ITEM_NUMBER	☐	BBP_CTR_ITEM	CRM_ITEM_NO	NUMC	10	0	Number of Contract Item
38	CTR_HDR_NUMBER	☐	BBP_CTR_ID	CRM_OBJECT_ID	CHAR	10	0	Contract Number
39	CTR_HDR_GUID	☐	BBP_CTR_H_GUID	SYSUUID	RAW	16	0	GUID Contract
40	.INCLUDE	☐				0	0	Include Item Data Purchasing Backend-Specific
41	BE_LOG_SYSTEM	☐	BE_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System of Logistics Backend	*
42	BE_OBJ_ITEM	☐	BE_OBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Follow-On Object Item in Backend System
43	BE_OBJECT_TYPE	☐	BE_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Follow-On Document Object Type in Backend System	*
44	BE_OBJECT_ID	☐	BE_OBJECT_ID	BBP_BE_OBJECT_ID	CHAR	20	0	Follow-On Document Object ID in Backend
45	BE_REFOBJ_TYPE	☐	BE_REFOBJ_TYPE	OJ_NAME	CHAR	10	0	Reference Object Type in Backend System	*
46	BE_REFOBJ	☐	BE_REFOBJ	BBP_BE_OBJECT_ID	CHAR	20	0	Reference Object in Backend System
47	BE_REFOBJ_ITEM	☐	BE_REFOBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Reference Object Item in Backend System
48	BE_REFOBJ_SBITM	☐	BE_REFOBJ_SBITM	CHAR20	CHAR	20	0	Reference Object Sub-Position in Backend System
49	BE_REFOBJ_TYPE2	☐	BE_REFOBJ_TYPE	OJ_NAME	CHAR	10	0	Reference Object Type in Backend System	*
50	BE_REFOBJ2	☐	BE_REFOBJ	BBP_BE_OBJECT_ID	CHAR	20	0	Reference Object in Backend System
51	BE_REFOBJ_ITEM2	☐	BE_REFOBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Reference Object Item in Backend System
52	BE_REFOBJ_FYEAR2	☐	BE_FI_YEAR	GJAHR	NUMC	4	0	Reference Document Object- Fiscal Year in Backend System
53	BE_STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
54	BE_PLANT	☐	BE_EWERK	WERKS	CHAR	4	0	Plant	*
55	BE_BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
56	BE_VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
57	BE_MOVE_REAS	☐	BE_GRBEW	MB_GRBEW	NUMC	4	0	Reason for Movement	*
58	BE_EXPERYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
59	BE_PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
60	BE_PUR_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
61	BE_CO_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
62	BE_DOC_TYPE	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	*
63	BE_ACCREQUIRED	☐	BE_ACCREQUIRED	BE_ACCREQUIRED	CHAR	1	0	Account Assignment for Logical Backend Required
64	BE_SP_STK_IND	☐	BBPCIF_CIFSSKEY	BBPCIF_CIFSSKEY	CHAR	16	0	Key for Special Stock Section
65	BE_INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
66	BE_MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
67	BE_PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
68	BE_INTROW	☐	INTROW	NUMC10	NUMC	10	0	Internal line number for limits
69	BE_ITEM_TEXT	☐	BBP_BE_ITEM_TEXT	CHAR40	CHAR	40	0	Short Text of a Service Purchase Order Item
70	BE_PO_PRICE	☐	BBP_BE_PO_PRICE	BPUEB	CHAR	1	0	Price from Backend
71	BE_UNLOAD_PT	☐	BBP_UNLOAD_PT	CHAR25	CHAR	25	0	Unloading Point in Backend
72	BE_DEL_IND	☐	BBP_BE_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator in Backend Documents
73	BE_TRACKING_NO	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
74	DCIND	☐	BBP_DCIND	BBP_DCIND	CHAR	1	0	Debit/credit Indicator
75	DEDUCT_IND	☐	BBP_DEDUCT_IND	XFELD	CHAR	1	0	Discount/Rejection Indicator at Item Level
76	VPER_START	☐	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
77	VPER_END	☐	BBP_VPER_END	DATUM	DATS	8	0	Validity period
78	TIME_FROM	☐	BBP_TIME_FROM	TIME	TIMS	6	0	Start Time
79	TIME_TO	☐	BBP_TIME_TO	TIME	TIMS	6	0	Finish Time
80	.INCLUDE	☐				0	0	Data Buffered for UI But not Saved
81	SELECTED	☐	BBP_SELECTED	CHAR1	CHAR	1	0	Indicator: If Item is Selected on UI
82	.INCLUDE	☐				0	0
83	TAX_CODE_ORIGIN	☐	BBP_TAX_CODE_ORIGIN	BBP_TAX_CODE_ORIGIN	CHAR	1	0	Origin Tax Code Indicator (Determination/Manual Entry)
84	.INCLUDE	☐				0	0	Item Data for All Documents in GetDetail Case Interface
85	HEADER	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
86	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
87	CREATED_AT	☐	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
88	CHANGED_BY	☐	BBP_CHNAM	USNAM	CHAR	12	0	Name of Person Responsible for Changing Object
89	CHANGED_AT	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
90	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
91	.INCLUDE	☐				0	0	Include for item structure for BBP IV online fields
92	STEPL	☐			INT4	10	0
93	DEL_NOTE_NUMBER	☐			CHAR	16	0
94	DELIVERY_DATE	☐	BBP_DOC_DATE	DATUM	DATS	8	0	Document Date
95	ACC_CAT_TXT	☐	BBP_ACCCAT_D	CHAR_30	CHAR	30	0	Account Assignment Category Description in Enterprise Buyer
96	TAX_CODE_TEXT	☐	CHAR64	CHAR64	CHAR	64	0	Character field, length 64
97	G_L_ACCT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
98	MAX_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
99	MAX_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
100	NOQUANTITY	☐			CHAR	1	0
101	PO_PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
102	PO_PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
103	PO_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
104	PO_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
105	PO_VALIDITY_FROM	☐	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
106	PO_VALIDITY_TO	☐	BBP_VPER_END	DATUM	DATS	8	0	Validity period
107	CF_PRICE	☐	BBP_PRICE	WERT7	CURR	13	2	Net Price
108	CF_PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
109	CF_QUANTITY	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
110	CF_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
111	IV_QUANTITY_E	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
112	IV_VALUE_E	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
113	BE_LIMIT	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
114	CATEGORY_TEXT	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
115	DEL_NOTE_ITEM_NO	☐	BBP_ITEM_NO_EXT		NUMC	10	0	External Item Number
116	.INCLUDE	☐				0	0	Contains all Fields of the Online Structures from CF and IV
117	ACC_CAT	☐	BBP_ACC_CAT	BBP_ACCCAT	CHAR	5	0	Account Assignment Category in Enterprise Buyer
118	GENERIC_ACC	☐	BBP_ACC_GENERIC	CHAR64	CHAR	64	0	Generic Account Assignment
119	UNIT_TEXT	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
120	MULTI	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
121	UNPLANNED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
122	NOT_ALLOWED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
123	NO_DETAIL	☐	XFELD	XFELD	CHAR	1	0	Checkbox
124	NO_COPY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
125	EXPANDED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
126	HIER_GROUP	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
127	LIM_GROUP	☐	BBP_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item number
128	NUMBER_INT_EXT	☐	CHAR21	CHAR21	CHAR	21	0	Field Name
129	INITIAL_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
130	PARTNER_CHANGE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
131	PARTNER_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
132	PARTNER_NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
133	INCOTERM_KEY	☐	BBP_INCOTERM_KEY	BBP_INCOTERM_KEY	CHAR	3	0	Incoterm Key	*
134	INCOTERM_LOC	☐	BBP_INCOTERM_LOCATION	BBP_INCOTERM_LOCATION	CHAR	28	0	Incoterm Location

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BBP_IV_ITEM	ICC_BR_CFOP	COMC_CFOP_CODE	CFOP_CODE	KEY	1	CN
2	BBP_IV_ITEM	ICC_BR_ICMSLAW	COMC_TAX_LAW_1	TAX_LAW	KEY	1	CN
3	BBP_IV_ITEM	ICC_BR_IPILAW	COMC_TAX_LAW_2	TAX_LAW	KEY	1	CN
4	BBP_IV_ITEM	ICC_BR_STEUC	CRMC_TAX_TCODE	TAX_TARIFF_CODE

History

Last changed by/on	SAP	20110908
SAP Release Created in