SAP ABAP Table BBP_SC_BW_GET_TD_STRUC (Extraction Structure: Trans. Data SAP EBP Shopping Cart)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

SRM-EBP-REP (Application Component) Reporting
⤷

BBP_BW (Package) BW Extractors and Development for BBP

Basic Data

Table Category	INTTAB	Structure
Structure	BBP_SC_BW_GET_TD_STRUC	Table Relationship Diagram
Short Description	Extraction Structure: Trans. Data SAP EBP Shopping Cart

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	BBP_BW_SC_H_GUID	SYSUUID_C	CHAR	32	0	SC GUID 32 Char.
3	SC_NUMBER	BBP_BW_SC_NUMBER	CRM_OBJECT_ID	CHAR	10	0	Shopping Cart Number
4	PROCESS_TYPE	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
5	SC_DATE	PO_DATE		DATS	8	0	Purchase Order Date
6	DESCRIPTION	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
7	DESCRIPTION_UC	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	CREATED_AT	BBP_BW_CREATE_DATE		DATS	8	0	Posting Date for a Business Transaction
9	CHANGED_AT	BBP_BW_CHNG_AT		DATS	8	0	Change Date of Document
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	BBP_LOG_SYSTEM	BBP_LOG_SYS	LOGSYS	CHAR	10	0	Logical System EBP	*
13	BE_LOG_SYSTEM	BE_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System of Logistics Backend	*
14	ORDERER_ID	BBP_ORDERER	BU_PARTNER	CHAR	10	0	Company Number	*
15	ORDERER_GUID	BBP_BW_ORD_GUID_32	SYSUUID_C	CHAR	32	0	Company GUID 32 Char.
16	STAT_PROCESS	BBP_BW_PROC_STAT	J_STATUS	CHAR	5	0	Processing Status
17	STAT_RELEASE	BBP_BW_REL_STAT	J_STATUS	CHAR	5	0	Release Status
18	VPER_START	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
19	VPER_END	BBP_VPER_END	DATUM	DATS	8	0	Validity period
20	CO_CODE	BBP_CO_CODE	BUKRS	CHAR	4	0	Company Code in FI System	*
21	LOGSYS_FI	BBP_LOGSYS_FI	LOGSYS	CHAR	10	0	Logical System of FI System	*
22	TOTAL_VALUE_APPR	BBP_TOTAL_VALUE_APPR	WERT8	CURR	15	2	Total Value of Shopping Cart at Time of Approval (BW)
23	CURRENCY	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	APPROVER_ID	BBP_APPROVER_NO	BU_PARTNER	CHAR	10	0	Approver Number	*
25	APPROVER_GUID	BBP_GUID_32	SYSUUID_C	CHAR	32	0	Globally Unique Identifier in 32-Character Display
26	APPROVAL_LIMIT	BBP_LIMIT	WERT8	CURR	15	2	Overall Limit
27	APPROVAL_CURR	WAERS	WAERS	CUKY	5	0	Currency Key	*
28	APPR_START_DATE	SWW_CD	SYDATS	DATS	8	0	Creation Date of Work Item
29	APPR_START_TIME	SWW_CT	SYTIME	TIMS	6	0	Creation Time of Work Item
30	APPR_END_DATE	SWW_AED	SYDATS	DATS	8	0	End Date of Work Item
31	APPR_END_TIME	SWW_AET	SYTIME	TIMS	6	0	Current end time of work item
32	CONF_IND	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
33	IR_IND	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
34	CONF_NON_VAL	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
35	CONF_BASEDIV	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
36	ERS	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
37	SC_COUNT	BBP_BW_SC_CNT		DEC	5	4	Counter for Number of Shopping Cart Headers
38	ITM_GUID	BBP_GUID_32	SYSUUID_C	CHAR	32	0	Globally Unique Identifier in 32-Character Display
39	ITM_CREATED_AT	BBP_BW_CR_AT		DATS	8	0	Creation Date of Document
40	ITM_CHANGED_AT	BBP_BW_CHNG_AT		DATS	8	0	Change Date of Document
41	ITM_CREATED_BY	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
42	ITM_CHANGED_BY	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
43	ITM_PARENT	BBP_GUID_32	SYSUUID_C	CHAR	32	0	Globally Unique Identifier in 32-Character Display
44	ITM_PRODUCT_GUID	BBP_BW_PROD_GUID_32	SYSUUID_C	CHAR	32	0	Product Guid 32 Char.
45	ITM_PRODUCT_ID	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
46	ITM_PARTNER_PROD	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
47	ITM_DESCRIPTION	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
48	ITM_DESCRIPT_UC	COMT_PRSHTEXTG	PRSHTEXTG40	CHAR	40	0	Product Description in Uppercase for F4 Help
49	ITM_NUMBER	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
50	ITM_TYPE	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
51	ITM_CAT_GUID	BBP_GUID_32	SYSUUID_C	CHAR	32	0	Globally Unique Identifier in 32-Character Display
52	ITM_CATEGORY_ID	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
53	ITM_SCHEMA_TYPE	SCHEMA_TYPE	COM_SCHEMA_TYPE	CHAR	10	0	Standard Schema Type	*
54	ITM_EX_CT_UN_ID	BBP_ITM_EX_CT_UN_ID	CHAR40	CHAR	40	0	Unique Key in External Category
55	ITM_CT_CAT_ID	BBP_CT_CATEGORY_ID	CHAR60	CHAR	60	0	Category Name
56	ITM_MANU_PROD	BBP_MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
57	ITM_MFR_NO_EXT	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
58	ITM_CATALOGID	CATALOG	KATALOGID	CHAR	20	0	Catalog ID from which the line was selected	*
59	ITM_PRODUCT_TYPE	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
60	ITM_DELIV_DATE	EINDT	DATUM	DATS	8	0	Item delivery date
61	ITM_QUANTITY	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
62	ITM_UNIT	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
63	ITM_PRICE	BBP_PRICE	WERT7	CURR	13	2	Net Price
64	ITM_PRICE_UNIT	EPEIN	DEC5	DEC	5	0	Price unit
65	ITM_VALUE	BBP_VALUE	WERT8	CURR	15	2	Net Value
66	ITM_BE_LOG_SYS	BE_LOG_SYSTEM	LOGSYS	CHAR	10	0	Logical System of Logistics Backend	*
67	ITM_BE_OBJ_ID	BE_OBJECT_ID	BBP_BE_OBJECT_ID	CHAR	20	0	Follow-On Document Object ID in Backend
68	ITM_BE_OBJ_ITM	BE_OBJ_ITEM	BBP_REF_ITEM	CHAR	10	0	Follow-On Object Item in Backend System
69	ITM_BE_OBJ_TYPE	BE_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Follow-On Document Object Type in Backend System	*
70	ITM_PROD_SRC_SYS	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
71	ITM_SYS_TYPE	BBP_SYSTEM_TYPE	BBP_SYSTEM_TYPE	CHAR	10	0	System type
72	ITM_SLD_SYS_NAME	BBP_SLD_SYS_NAME	TEXT60	CHAR	60	0	Name of a System im System Landscape Directory (SLD)
73	ITM_REQUEST_ID	BBP_REQUESTOR	BU_PARTNER	CHAR	10	0	Requester Number	*
74	ITM_REQUEST_GUID	BBP_BW_REQU_GUID_32	SYSUUID_C	CHAR	32	0	Requester GUID 32 Char.
75	ITM_VENDOR_ID	BBP_VENDOR_ID	BU_PARTNER	CHAR	10	0	Vendor ID	*
76	ITM_VENDOR_GUID	BBP_BW_VEND_GUID_32	SYSUUID_C	CHAR	32	0	Vendor GUID 32 Char.
77	ITM_RECIPNT_ID	BBP_RECIPIENT	BU_PARTNER	CHAR	10	0	Goods Recipient Number	*
78	ITM_RECIPNT_GUID	BBP_BW_RCPT_GUID_32	SYSUUID_C	CHAR	32	0	Goods Recipient GUID 32 Char
79	ITM_LOC_ID	BBP_LOCATION_NO	BU_PARTNER	CHAR	10	0	Plant Number	*
80	ITM_LOC_GUID	BBP_LOC_GUID_32	SYSUUID_C	CHAR	32	0	Plant GUID 32 Char
81	ITM_WORKER_ID	BBP_SRV_PROVIDER	BU_PARTNER	CHAR	10	0	Service Provider Number	*
82	ITM_WORKER_GUID	BBP_BW_SRV_GUID_32	SYSUUID_C	CHAR	32	0	Service Provider GUID 32 Char.
83	ITM_WRKR_SRC_SYS	COMT_PARTNER_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Partner Originates	*
84	ITM_WORKER_FNAME	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
85	ITM_WORKER_LNAME	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
86	ITM_WORKER_NAME	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
87	ITM_WRK_NO_TYPE	CRMT_PARTNER_NO_TYPE	COMT_PARTNER_NO_TYPE	CHAR	2	0	Partner Number Type (e.g. GUID, Pers. No., ...), Internal
88	ITM_STAT_TRANS	BBP_BW_TRANS_STAT	J_STATUS	CHAR	5	0	Transfer Status
89	ITM_TAX_CODE	BBP_MWSKZ	BBP_MWSKZ	CHAR	2	0	Tax Code
90	ITM_TAX_AMOUNT	BBP_TAX_AMOUNT	WERT8	CURR	15	2	Tax Amount
91	ITM_LIM_K	BBP_BW_LIMIT_K	WERT8	CURR	15	2	Contract Limit
92	ITM_LIM_S	BBP_BW_LIMIT_S	WERT8	CURR	15	2	Other Limit
93	ITM_LIM_G	BBP_LIMIT	WERT8	CURR	15	2	Overall Limit
94	ITM_UNLIMITED	BBP_UNLIMITED	CHAR01	CHAR	1	0	Undefined Limit
95	ITM_EXP_VALUE	BBP_EXP_VALUE	WERT8	CURR	15	2	Expected value
96	ITM_DEL_IND	BBP_DEL_IND	XFELD	CHAR	1	0	Deletion Indicator EBP Purchasing Document
97	ITM_FINAL_INV	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
98	ITM_FINAL_ENTRY	BBP_FINAL_ENTRY	XFELD	CHAR	1	0	Final Entry Indicator (Goods/Services)
99	ITM_CTR_GUID	BBP_BW_CTR_GUID_32	SYSUUID_C	CHAR	32	0	Contract Header Guid 32 Char.
100	ITM_CTR_NUMBER	BBP_CTR_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Contract Number
101	ITM_CTR_ITMGUID	BBP_BW_CTR_I_GUID_32	SYSUUID_C	CHAR	32	0	Contract Item Guid 32 Char.
102	ITM_CTR_ITM_NO	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
103	ACCEPT_QUANTITY	BBP_BW_ACCEPT_QUANT	MENG15	QUAN	15	3	Accepted Quantity
104	ITM_RESP_ORG	BBP_PROG_ORG_RESP	HROBJEC_14	CHAR	14	0	Responsible Organizational Unit (purchasing)
105	ITM_PURCH_ORG	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
106	ITM_PURCH_GROUP	BBP_PROC_GROUP	HROBJEC_14	CHAR	14	0	Responsible Purchasing Group
107	ITM_PCINS	BBPPCINS	BBPPCINS	CHAR	4	0	Procurement card company	*
108	ITM_PCNUM	BBPPCNUM	BBPPCNUM	CHAR	25	0	Procurement card number	*
109	ITM_SUBTYPE	BBP_I_SUBTYPE	BBP_I_SUBTYPE	CHAR	2	0	Specification Purchase Item (e.g. Direct Material/Hierarch.)
110	ITM_COUNT	BBP_BW_ITEM_CNT		DEC	5	4	Counter for Number of Items
111	ITM_REJECT_IND	BBP_DEDUCT_IND	XFELD	CHAR	1	0	Discount/Rejection Indicator at Item Level
112	ACC_GUID	BBP_GUID_32	SYSUUID_C	CHAR	32	0	Globally Unique Identifier in 32-Character Display
113	ACC_NO	BBP_ACC_NO	BBP_ACCNO	NUMC	4	0	Sequential Account Assignment No. in EBP Purchase Document
114	ACC_CAT	BBP_ACC_CAT	BBP_ACCCAT	CHAR	5	0	Account Assignment Category in Enterprise Buyer
115	ACC_DISTR_PERC	BBP_VPROZ	BBP_VPROZ	DEC	5	2	Distribution Percentage in the Case of Multiple Acct Assgt
116	ACC_G_L_ACCT	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
117	ACC_BUS_AREA	GSBER	GSBER	CHAR	4	0	Business Area	*
118	ACC_CO_AREA	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
119	ACC_COST_CTR	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
120	ACC_ASSET_NO	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
121	ACC_SUB_NUMBER	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
122	ACC_ORDER_NO	AUFNR	AUFNR	CHAR	12	0	Order Number	*
123	ACC_PROFIT_CTR	PRCTR	PRCTR	CHAR	10	0	Profit Center
124	ACC_WBS_ELEM_E	WBS_ELEM	PS_POSID	CHAR	24	0	Work breakdown structure element (WBS element)
125	ACC_NETWORK	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
126	ACC_ACTIVITY	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
127	ACC_STR	BBP_ACC_GENERIC	CHAR64	CHAR	64	0	Generic Account Assignment
128	CMMT_ITEM	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
129	GRANT_NBR	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
130	FUNDS_CTR	FISTL	FISTL	CHAR	16	0	Funds Center	*
131	FUND	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
132	FUNC_AREA	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
133	SD_DOC	BBP_VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
134	SDOC_ITEM	BBP_POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
135	SCHED_LINE	BBP_ETENR	ETENR	NUMC	4	0	Schedule Line Number	*
136	UPDMOD	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
137	.INCLUDE				0	0	FM Fields Earmarked Funds
138	FUNDS_RES	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
139	RES_ITEM	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*