SAP ABAP Table FPIA_BBP_CTR_BW_GET_TD (IoA Extraction Structure: Transact. Data Purchase Contract)

Hierarchy

☛ SRM_SERVER (Software Component) SRM_SERVER
   ⤷ SRM-LOC (Application Component) Localization - Country Versions
     ⤷ BBP_PD_COUNTRY_PPS_FR (Package) Country Specific Developments: Public Sector France

Basic Data

Table Category	INTTAB	Structure
Structure	FPIA_BBP_CTR_BW_GET_TD	Table Relationship Diagram
Short Description	IoA Extraction Structure: Transact. 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	.INCLUDE	☐				0	0	Extraction Structure: Transaction Data Purchase Contract
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	BBP_BW_CTR_GUID_32	SYSUUID_C	CHAR	32	0	Contract Header Guid 32 Char.
4	OBJECT_ID	☐	BBP_CTR_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Contract Number
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
7	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
8	BEGIN_DATE	☐	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
9	ENDING_DATE	☐	BBP_VPER_END	DATUM	DATS	8	0	Validity period
10	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
11	LOG_SYS_BP	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
12	CREATED_AT	☐	BBP_CREATED_AT	DATUM	DATS	8	0	Date of Creation
13	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
14	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
15	HDR_DELIV_DAYS	☐	BBP_DELIV_DAYS	NUMC3	NUMC	3	0	Delivery Time in Days
16	ITEM_GUID	☐	BBP_BW_CTR_I_GUID_32	SYSUUID_C	CHAR	32	0	Contract Item Guid 32 Char.
17	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
18	NUMBER_OF_I	☐	BBP_NUMBER_OF_I	INT4	INT4	10	0	Number of Purchase Order Items
19	BASE_QTY_UNIT	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
20	CATALOG_ID	☐	CATALOG	BBP_WS_SERVICE_ID	CHAR	20	0	Catalog ID from which the line was selected
21	CATEGORY_GUID	☐	BBP_CATEGORY_GUID_RAW	SYSUUID	RAW	16	0	Product Category GUID
22	CATEGORY_ID	☐	BBP_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Product Category ID
23	MATERIAL	☐	BBPMATNR_PI	BBPMATNR_PI	CHAR	18	0	Material Number
24	PRODUCT_GUID	☐	BBP_BW_PROD_GUID_32	SYSUUID_C	CHAR	32	0	Product Guid 32 Char.
25	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
26	SHORT_TEXT_UC	☐	BBP_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Short Text for Product in Capital Letters for BW
27	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
28	PRODUCT_TYPE	☐	BBP_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
29	SUBTYPE	☐	BBP_H_SUBTYPE	BBP_H_SUBTYPE	CHAR	2	0	Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)
30	INCOTERM_KEY	☐	BBP_INCOTERM_KEY	BBP_INCOTERM_KEY	CHAR	3	0	Incoterm Key	*
31	INCOTERM_LOC	☐	BBP_INCOTERM_LOCATION	BBP_INCOTERM_LOCATION	CHAR	28	0	Incoterm Location
32	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
33	CALDAY	☐	DATS	DATS	DATS	8	0	Field of type DATS
34	ITM_DELIV_DAYS	☐	BBP_DELIV_DAYS	NUMC3	NUMC	3	0	Delivery Time in Days
35	TARGET_QUAN_CUM	☐	BBP_MNG	MENG13	QUAN	13	3	Quantity in Order Unit
36	TARGET_VALUE	☐	BBP_VALUE	WERT8	CURR	15	2	Net Value
37	TGT_QTY_UNIT_CUM	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
38	CALL_OF_CURR_CUM	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
39	CALL_OF_QTY_CUM	☐	BBP_PO_QUANT_E	MENG15	QUAN	15	3	Quantity of POs/Confirmations/Invoices Created for Contract
40	CALL_OF_UNIT_CUM	☐	BBP_UNIT	MEINS	UNIT	3	0	Purchase Order Unit	*
41	CALL_OF_VAL_CUM	☐	BBP_PO_VALUE_E	WERT8	CURR	15	2	Value of POs/Confirmations/Invoices Created for Contract
42	CALL_OF_VAL_AGG	☐	BBP_PO_VALUE_E_AGG	WERT8	CURR	15	2	Entered Values for Contracts Aggregated at Hierarchy Level
43	VENDOR	☐	BBPLIFNR	BBPLIFNR	CHAR	10	0	Account Number of Supplier or Creditor
44	SALES_EMPLOYEE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
45	SOLD_TO_PARTY	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
46	PURCH_ORG	☐	BBP_PROC_ORG	HROBJEC_14	CHAR	14	0	Responsible Purchasing Organization
47	PURCH_GROUP	☐	BBP_PROC_GROUP	HROBJEC_14	CHAR	14	0	Responsible Purchasing Group
48	PURCH_ORG_RESP	☐	BBP_PROG_ORG_RESP	HROBJEC_14	CHAR	14	0	Responsible Organizational Unit (purchasing)
49	STAT_PROCESS	☐	BBP_BW_PROC_STAT	J_STATUS	CHAR	5	0	Processing Status
50	STAT_RELEASE	☐	BBP_BW_REL_STAT	J_STATUS	CHAR	5	0	Release Status
51	STAT_LOCK	☐	BBP_BW_LOCK_STAT	J_STATUS	CHAR	5	0	Lock Status
52	STAT_RENEW	☐	BBP_BW_RENEW_STAT	J_STATUS	CHAR	5	0	Renewal Status
53	STAT_ERROR	☐	BBP_BW_ERR_STAT	J_STATUS	CHAR	5	0	Error Status
54	ITM_RELEASED	☐	BBP_ITM_RELEASED	BBP_ITM_RELEASED	CHAR	1	0	Indicator - Item is to be Released
55	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
56	ITM_REV_LEV	☐	CC_REVLV	CC_REVLV	CHAR	2	0	Revision Level
57	DIST_IND	☐	BBP_DIST_FLAG	XFELD	CHAR	1	0	Distribution Flag
58	PS_HIER_TEMPL	☐	/SAPPSSRM/_HIERTEMPLATE	/SAPPSSRM/_HIERTEMPLATE	CHAR	10	0	Hierarchy Template	*
59	PS_HL_ITEM	☐	/SAPPSSRM/_HL_ITEM	SYSUUID	RAW	16	0	Higher-Level Item GUID
60	PS_HANDLE_ITM	☐	BBP_GUID	SYSUUID	RAW	16	0	Globally Unique identifier
61	PS_EXSNR	☐	/SAPPSSRM/_EXSNR	NUMC5	NUMC	5	0	External Sort Number
62	PS_CTRL_KEY	☐	/SAPPSSRM/_PS_CTRL_KEY	/SAPPSSRM/_PS_CTRL_KEY	CHAR	4	0	Item Process Type Control Key	*
63	ITM_PARENT	☐	BBP_GUID_32	SYSUUID_C	CHAR	32	0	Globally Unique Identifier in 32-Character Display
64	CALL_OF_VAL_HDR	☐	BBP_PO_VALUE_E	WERT8	CURR	15	2	Value of POs/Confirmations/Invoices Created for Contract
65	TGT_VAL_HDR	☐	BBP_PO_VALUE_E	WERT8	CURR	15	2	Value of POs/Confirmations/Invoices Created for Contract
66	.INCLU--AP	☐				0	0	BW: IoA regarding contracts
67	VZSKZ	☐	VZSKZ	VZSKZ	CHAR	2	0	Interest calculation indicator	*
68	.INCLU--AP	☐				0	0	New field extenions in Options for Contracts
69	OPT_CPLX_DOC	☐	BBP_OPT_CPLX_DOC	BBP_OPT_CPLX_DOC	CHAR	1	0	Documents Containing Options
70	OPT_IND	☐	BBP_OPT_IND	BBP_OPT_IND	CHAR	1	0	Option Type
71	OPT_STATUS	☐	BBP_OPT_STATUS	BBP_OPT_STATUS	CHAR	1	0	Option Status
72	OPT_XPER_START	☐	BBP_OPT_XPER_START	DATS	DATS	8	0	Exercise Period Start Date
73	OPT_XPER_END	☐	BBP_OPT_XPER_END	DATS	DATS	8	0	Exercise Period End Date
74	OPT_REF_GUID	☐	BBP_OPT_REF_GUID	SYSUUID	RAW	16	0	Option Reference GUID
75	OPT_POP_START	☐	BBP_OPT_POP_START	DATS	DATS	8	0	Option Period of Performance Start Date
76	OPT_POP_END	☐	BBP_OPT_POP_END	DATS	DATS	8	0	Option Period of Performance End Date
77	.INCLU--AP	☐				0	0	Append for BI enhancements in PA - CTR
78	TOTAL_VALUE	☐	BBP_TOTAL_VALUE	WERT8	CURR	15	2	Total Value of Shopping Cart (Net Excluding Taxes)
79	PS_PA_ID_HDR	☐	/SAPPSSRM/_PA_STRUC_ID	/SAPPSSRM/PA_STRUC_ID	CHAR	4	0	Pricing Arrangement Identifier
80	PS_PA_CLNG_AMT	☐	/SAPPSSRM/_PA_CEILING_AMOUNT	WERT8	CURR	15	2	Ceiling Amount
81	PS_PA_ID	☐	/SAPPSSRM/_PA_STRUC_ID	/SAPPSSRM/PA_STRUC_ID	CHAR	4	0	Pricing Arrangement Identifier
82	PS_PA_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
83	.INCLU--AP	☐				0	0	New field extensions for Ctr in thresholds
84	PS_TH_EXCEEDED	☐	/SAPPSSRM/_TH_EXCEEDED	XFELD	CHAR	1	0	Threshold Exceeded
85	PS_TH_NOT_REL	☐	/SAPPSSRM/_TH_NOT_RELEVANT	XFELD	CHAR	1	0	Threshold not Relevant
86	PS_TH_TYPE	☐	/SAPPSSRM/_TH_TYPE	/SAPPSSRM/_TH_TYPE	CHAR	10	0	Threshold Type	*
87	PS_TH_NUMBER	☐	/SAPPSSRM/_TH_NUM	NUMC10	NUMC	10	0	Threshold Number
88	PS_TH_AVAIL_AMT	☐	/SAPPSSRM/_TH_RM_AMNT	/SAPPSSRM/_TH_RM_AMNT	CURR	20	2	Remaining Threshold Amount
89	PS_TH_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
90	.INCLU--AP	☐				0	0	Retentions Contracts Append Extraction Structure
91	PS_WH_PRCNT_HDR	☐	/SAPPSSRM/_WH_PERCENT	/SAPPSSRM/_WH_PRZ32	DEC	5	2	Retention Value as Percentage
92	PS_WH_IND	☐	/SAPPSSRM/_WH_IND	/SAPPSSRM/_WH_IND	CHAR	1	0	Retention Indicator
93	PS_WH_PRCNT	☐	/SAPPSSRM/_WH_PERCENT	/SAPPSSRM/_WH_PRZ32	DEC	5	2	Retention Value as Percentage
94	PS_WH_IND_PA	☐	/SAPPSSRM/_WH_IND_PA	/SAPPSSRM/_WH_IND_PA	CHAR	1	0	Retention Indicator for Pricing Arrangments
95	VPER_START	☐	BBP_VPER_START	DATUM	DATS	8	0	Validity Period From
96	.INCLU--AP	☐				0	0	BI Append Structure for Guaranteed Munimum (GP)
97	GUARANTEED_MINH	☐	BBP_GUARANTEED_MIN	WERT8	CURR	15	2	Guaranteed Purchase Value (Public Sector ONLY!!)
98	GUARANTEED_MINI	☐	BBP_GUARANTEED_MIN	WERT8	CURR	15	2	Guaranteed Purchase Value (Public Sector ONLY!!)
99	CURRENCY_GM_H	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
100	CURRENCY_GM_I	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
101	.INCLU--AP	☐				0	0	Field Extension for contracts extract structure.
102	DUMMY	☐	INT4	INT4	INT4	10	0	Natural number
103	.INCLU--AP	☐				0	0	Field Extn for Item Hierarchies for CTR
104	EXLIN	☐	/SAPPSSRM/_EXLIN	/SAPPSSRM/_EXLIN	CHAR	40	0	Configurable Line Item Number
105	PS_IPT	☐	/SAPPSSRM/_IPT	/SAPPSSRM/_IPT	CHAR	10	0	Public Sector Item Type	*

History

Last changed by/on	SAP	20130528
SAP Release Created in	100