SAP ABAP Table BBP_CTR_BW_GET_TD_STRUC (Extraction Structure: Transaction Data Purchase Contract)

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_CTR_BW_GET_TD_STRUC	Table Relationship Diagram
Short Description	Extraction Structure: Transaction Data Purchase Contract

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	☐	BBP_BW_CTR_GUID_32	SYSUUID_C	CHAR	32	0	Contract Header Guid 32 Char.
3	OBJECT_ID	☐	BBP_CTR_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Contract Number
4	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
5	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
6	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
7	BEGIN_DATE	☐	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
8	ENDING_DATE	☐	BBP_VPER_END	DATUM	DATS	8	0	Validity period
9	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
10	LOG_SYS_BP	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
11	CREATED_AT	☐	BBP_BW_CREATE_DATE		DATS	8	0	Posting Date for a Business Transaction
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
14	HDR_DELIV_DAYS	☐	BBP_DELIV_DAYS	NUMC3	NUMC	3	0	Delivery Time in Days
15	ITEM_GUID	☐	BBP_BW_CTR_I_GUID_32	SYSUUID_C	CHAR	32	0	Contract Item Guid 32 Char.
16	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
17	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
18	BASE_QTY_UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
19	CATALOG_ID	☐	CATALOG	KATALOGID	CHAR	20	0	Catalog ID from which the line was selected	*
20	CATEGORY_GUID	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
21	CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
22	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
23	PRODUCT_GUID	☐	BBP_BW_PROD_GUID_32	SYSUUID_C	CHAR	32	0	Product Guid 32 Char.
24	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
25	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
26	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
27	PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
28	SUBTYPE	☐	BBP_H_SUBTYPE	BBP_H_SUBTYPE	CHAR	2	0	Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)
29	INCOTERM_KEY	☐	BBP_INCOTERM_KEY	BBP_INCOTERM_KEY	CHAR	3	0	Incoterm Key	*
30	INCOTERM_LOC	☐	BBP_INCOTERM_LOCATION	BBP_INCOTERM_LOCATION	CHAR	28	0	Incoterm Location
31	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
32	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
33	ITM_DELIV_DAYS	☐	BBP_DELIV_DAYS	NUMC3	NUMC	3	0	Delivery Time in Days
34	TARGET_QUAN_CUM	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
35	TARGET_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
36	TGT_QTY_UNIT_CUM	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
37	CALL_OF_CURR_CUM	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
38	CALL_OF_QTY_CUM	☐	BBP_PO_QUANT_E	MENG15	QUAN	15	3	Quantity of POs/Confirmations/Invoices Created for Contract
39	CALL_OF_UNIT_CUM	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
40	CALL_OF_VAL_CUM	☐	BBP_PO_VALUE_E	WERT8	CURR	15	2	Value of POs/Confirmations/Invoices Created for Contract
41	VENDOR	☐	CRMT_VENDOR	BU_PARTNER	CHAR	10	0	Vendor	*
42	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
43	SOLD_TO_PARTY	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
44	PURCH_ORG	☐	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
45	PURCH_GROUP	☐	BBP_PROC_GROUP	HROBJEC_14	CHAR	14	0	Responsible Purchasing Group
46	PURCH_ORG_RESP	☐	BBP_PROG_ORG_RESP	HROBJEC_14	CHAR	14	0	Responsible Organizational Unit (purchasing)
47	STAT_PROCESS	☐	BBP_BW_PROC_STAT	J_STATUS	CHAR	5	0	Processing Status
48	STAT_RELEASE	☐	BBP_BW_REL_STAT	J_STATUS	CHAR	5	0	Release Status
49	STAT_LOCK	☐	BBP_BW_LOCK_STAT	J_STATUS	CHAR	5	0	Lock Status
50	STAT_ERROR	☐	BBP_BW_ERR_STAT	J_STATUS	CHAR	5	0	Error Status
51	ITM_RELEASED	☐	BBP_ITM_RELEASED	XFELD	CHAR	1	0	Indicator - Item is to be Released
52	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode

History

Last changed by/on	SAP	20110908
SAP Release Created in	30A