SAP ABAP Table FPIA_BBPS_BI_TD_PO (IoA Extraction Structure: Transact. Data SRM Purchase Order)
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_BBPS_BI_TD_PO   Table Relationship Diagram
Short Description IoA Extraction Structure: Transact. Data SRM Purchase Order    
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: Transactional Data SRM Purchase Order  
2 GUID BBP_BI_DOC_GUID SYSUUID_C CHAR 32   0   GUID of Document  
3 OBJECT_ID BBP_BI_DOC_NUMBER CRM_OBJECT_ID CHAR 10   0   Document Number  
4 PROCESS_TYPE BBP_BI_PROCESS_TYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type *
5 POSTING_DATE BBP_BI_POST_DATE DATE DATS 8   0   Posting Date  
6 DESCRIPTION BBP_BI_DOC_DESCR CRM_PROCESS_DESCRIPTION CHAR 40   0   Description of Document  
7 CREATED_AT BBP_BI_CREAT_DATE   DATS 8   0   Creation Date of Document  
8 CHANGED_AT BBP_BI_CHANG_DATE   DATS 8   0   Change Date of Document  
9 CREATED_BY BBP_BI_CREAT_BY UNAME CHAR 12   0   User That Created the Document  
10 CHANGED_BY BBP_BI_CHANG_BY UNAME CHAR 12   0   User That Changed the Document  
11 ORDERER_ID BBP_BI_ORDERER_ID BU_PARTNER CHAR 10   0   Orderer ID *
12 VENDOR_ID BBP_BI_VENDOR_ID BU_PARTNER CHAR 10   0   Supplier ID *
13 CO_CODE BBP_CO_CODE BUKRS CHAR 4   0   Company Code in FI System *
14 BBP_LOG_SYSTEM BBP_BI_LOG_SYS LOGSYS CHAR 10   0   Logical System for SRM *
15 BE_LOG_SYSTEM BE_LOG_SYSTEM LOGSYS CHAR 10   0   Logical System of Logistics Backend *
16 LOGSYS_FI BBP_LOGSYS_FI LOGSYS CHAR 10   0   Logical System of FI System *
17 TOTAL_VALUE_APPR BBP_TOTAL_VALUE_APPR WERT8 CURR 15   2   Total Value of Shopping Cart at Time of Approval (BW)  
18 CURRENCY BBP_BI_DOC_CURRENCY WAERS CUKY 5   0   Currency of Document *
19 VPER_START BBP_VPER_START DATUM DATS 8   0   Validity Period From  
20 VPER_END BBP_VPER_END DATUM DATS 8   0   Validity period  
21 PCINS BBPPCINS BBPPCINS CHAR 4   0   Procurement card company *
22 PCNUM BBPPCNUM BBPPCNUM CHAR 25   0   Procurement card number *
23 INCOTERM_KEY BBP_INCOTERM_KEY BBP_INCOTERM_KEY CHAR 3   0   Incoterm Key *
24 INCOTERM_LOC BBP_INCOTERM_LOCATION BBP_INCOTERM_LOCATION CHAR 28   0   Incoterm Location  
25 CONF_IND WEPOS XFELD CHAR 1   0   Goods Receipt Indicator  
26 IR_IND REPOS XFELD CHAR 1   0   Invoice receipt indicator  
27 CONF_NON_VAL WEUNB XFELD CHAR 1   0   Goods Receipt, Non-Valuated  
28 CONF_BASEDIV BBP_WEBRE XFELD CHAR 1   0   Indicator: GR-Based Invoice Verification  
29 ERS BBP_XERSY XFELD CHAR 1   0   Evaluated Receipt Settlement (ERS)  
30 DOC_COUNT BBP_BI_DOC_COUNT   DEC 5   4   Counter for Number of Documents  
31 STAT_PROCESS BBP_BI_DOC_STAT J_STATUS CHAR 5   0   Processing Status  
32 ITM_DELIV_DATE EINDT DATUM DATS 8   0   Item delivery date  
33 ITM_GUID BBP_BI_ITEM_GUID SYSUUID_C CHAR 32   0   GUID of Item  
34 ITM_CREATED_AT BBP_BI_ITEM_CREAT_DATE   DATS 8   0   Creation Date of Item  
35 ITM_CHANGED_AT BBP_BI_ITEM_CHANG_DATE   DATS 8   0   Change Date of Item  
36 ITM_CREATED_BY BBP_BI_ITEM_CREAT_BY UNAME CHAR 12   0   User That Created the Item  
37 ITM_CHANGED_BY BBP_BI_ITEM_CHANG_BY UNAME CHAR 12   0   User That Changed the Item  
38 ITM_PRODUCT_GUID BBP_BI_PROD_GUID SYSUUID_C CHAR 32   0   Product GUID  
39 ITM_PRODUCT_ID BBP_BI_PROD_ID CRM_ORDERED_PROD CHAR 54   0   Product ID  
40 ITM_PARTNER_PROD BBP_BI_PARTNER_PROD_ID PRSHTEXT40 CHAR 40   0   Product ID of Partner  
41 ITM_DESCRIPTION COMT_PRSHTEXTX PRSHTEXT40 CHAR 40   0   Product Description  
42 ITM_NUMBER BBP_BI_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number  
43 ITM_CAT_GUID BBP_CATEGORY_GUID_RAW SYSUUID RAW 16   0   Product Category GUID  
44 ITM_CATEGORY_ID BBP_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Product Category ID  
45 ITM_SCHEMA_TYPE SCHEMA_TYPE COM_SCHEMA_TYPE CHAR 10   0   Standard Schema Type *
46 ITM_EXT_CAT_ID BBP_ITM_EX_CT_UN_ID CHAR40 CHAR 40   0   Unique Key in External Category  
47 ITM_EXT_CAT_NAME BBP_CT_CATEGORY_ID CHAR60 CHAR 60   0   Category Name  
48 ITM_MANU_PROD_IN BBP_MFRPN CHAR40 CHAR 40   0   Manufacturer Part Number  
49 ITM_MANU_PROD_EX EMNFR CHAR10 CHAR 10   0   External manufacturer code name or number  
50 ITM_CATALOGID CATALOG BBP_WS_SERVICE_ID CHAR 20   0   Catalog ID from which the line was selected  
51 ITM_PRODUCT_TYPE BBP_PRODUCT_TYPE COM_PRODUCT_TYPE CHAR 2   0   Product Type *
52 ITM_QUANTITY BBP_MNG MENG13 QUAN 13   3   Quantity in Order Unit  
53 ITM_QUANTITY_BUM BBP_BI_QUANTITY_BASE_UNIT MENG13 QUAN 13   3   Quantity in Base Unit of Measurement  
54 ITM_CF_QUANTITY BBP_BI_REF_CF_I_QUAN MENG13 QUAN 13   3   Referenced Quantity of Confirmation in Order Unit  
55 ITM_CF_QUAN_BUM BBP_BI_REF_CF_QUAN_BASE_UNIT MENG13 QUAN 13   3   Referenced Quantity of Confirmation in Base UoM  
56 ITM_IV_QUANTITY BBP_BI_REF_IV_I_QUAN MENG13 QUAN 13   3   Referenced Quantity of Invoice in Order Unit  
57 ITM_IV_QUAN_BUM BBP_BI_REF_IV_QUAN_BASE_UNIT MENG13 QUAN 13   3   Referenced Quantity of Invoice in Base UoM  
58 ITM_UNIT BBP_UNIT MEINS UNIT 3   0   Purchase Order Unit *
59 ITM_BASE_UNIT BBP_BI_BASE_UNIT MEINS UNIT 3   0   Base Unit *
60 ITM_PRICE BBP_PRICE WERT7 CURR 13   2   Net Price  
61 ITM_PRICE_UNIT EPEIN DEC5 DEC 5   0   Price unit  
62 ITM_VALUE BBP_VALUE WERT8 CURR 15   2   Net Value  
63 ITM_CF_VALUE BBP_BI_REF_CF_I_VALUE WERT8 CURR 15   2   Referenced Item Net Value of Confirmation in PO Currency  
64 ITM_IV_VALUE BBP_BI_REF_IV_I_VALUE WERT8 CURR 15   2   Referenced Item Net Value of Invoice in Order Currency  
65 ITM_REQUEST_ID BBP_BI_REQUESTER_ID BU_PARTNER CHAR 10   0   Requester ID *
66 ITM_RECIPNT_ID BBP_BI_RECIPIENT_ID BU_PARTNER CHAR 10   0   Recipient ID *
67 ITM_LOC_ID BBP_BI_LOCATION_ID BU_PARTNER CHAR 10   0   Location ID *
68 ITM_WORKER_ID BBP_BI_SRV_PROVIDER_ID BU_PARTNER CHAR 10   0   Service Provider ID *
69 ITM_WRKR_SRC_SYS COMT_PARTNER_SRC_SYS LOGSYS CHAR 10   0   Logical System from Which Partner Originates *
70 ITM_WORKER_NAME BBP_BI_SRV_PROVIDER_FULLNAME TEXT80 CHAR 80   0   Service Provider's Full Name  
71 ITM_WRK_NO_TYPE BBP_BI_SRV_PROVIDER_NO_TYPE COMT_PARTNER_NO_TYPE CHAR 2   0   Internal Service Provider Type (for example, GUID, pers.no.)  
72 ITM_CUSTOMER_ID BBP_BI_CUSTOMER_ID BU_PARTNER CHAR 10   0   Customer ID *
73 ITM_CUST_SRC_SYS COMT_PARTNER_SRC_SYS LOGSYS CHAR 10   0   Logical System from Which Partner Originates *
74 ITM_CUST_NAME BBP_BI_CUSTOMER_FULLNAME CHAR35 CHAR 35   0   Customer's Full Name  
75 ITM_CUST_NO_TYPE BBP_BI_CUSTOMER_NO_TYPE COMT_PARTNER_NO_TYPE CHAR 2   0   Internal Customer No.Type (for example, GUID, pers. no.)  
76 ITM_TYPE BBP_BI_ITEM_TYPE CRM_ITEM_TYPE CHAR 4   0   Item Category *
77 ITM_LIM_GUID BBP_BI_LIMIT_GUID SYSUUID_C CHAR 32   0   GUID of Limit  
78 ITM_LIM_CTR BBP_BI_LIMIT_CONTRACT WERT8 CURR 15   2   Contract Limit  
79 ITM_LIM_OTHER BBP_BI_LIMIT_OTHER WERT8 CURR 15   2   Other Limit  
80 ITM_LIM_OVERALL BBP_BI_LIMIT_OVERALL WERT8 CURR 15   2   Overall Limit  
81 ITM_UNLIMITED BBP_UNLIMITED CHAR01 CHAR 1   0   Undefined Limit  
82 ITM_EXP_VALUE BBP_EXP_VALUE WERT8 CURR 15   2   Expected value  
83 ITM_TAX_CODE BBP_MWSKZ BBP_MWSKZ CHAR 2   0   Tax Code  
84 ITM_TAX_AMOUNT BBP_TAX_AMOUNT WERT8 CURR 15   2   Tax Amount  
85 ITM_PROD_SRC_SYS BBP_BI_PRODUCT_SRC_SYS LOGSYS CHAR 10   0   Original Logical System of Product *
86 ITM_SYS_TYPE BBP_SYSTEM_TYPE BBP_SYSTEM_TYPE CHAR 10   0   System type  
87 ITM_SLD_SYS_NAME BBP_SLD_SYS_NAME TEXT60 CHAR 60   0   Name of a System im System Landscape Directory (SLD)  
88 ITM_SC_NUMBER BBP_BI_REF_SC_NO CRM_OBJECT_ID CHAR 10   0   Referenced Shopping Cart Number  
89 ITM_SC_ITEM_NO BBP_BI_REF_SC_ITEM_NO CRM_ITEM_NO NUMC 10   0   Referenced Item Number of Shopping Cart  
90 ITM_DEL_IND BBP_DEL_IND XFELD CHAR 1   0   Deletion Indicator EBP Purchasing Document  
91 ITM_FINAL_INV BBP_EREKZ XFELD CHAR 1   0   Final invoice indicator  
92 ITM_FINAL_ENTRY BBP_BI_FINAL_ENTRY_PO XFELD CHAR 1   0   Final Entry Indicator (Goods/Services) in PO  
93 ITM_FIN_ENTRY_CF BBP_BI_FINAL_ENTRY_CF XFELD CHAR 1   0   Final Entry Indicator (Goods/Services) in CF  
94 ITM_CTR_NUMBER BBP_BI_REF_CTR_NO CRM_OBJECT_ID CHAR 10   0   Referenced Contract Number  
95 ITM_CTR_ITM_NO BBP_BI_REF_CTR_ITEM_NO CRM_ITEM_NO NUMC 10   0   Referenced Item Number of Contract  
96 ACCEPT_QUANTITY BBP_BI_ACCEPT_QUANT MENG15 QUAN 15   3   Accepted Quantity  
97 ACCEPT_QUAN_BUM BBP_BI_ACCEPT_QUANT_BASE_UNIT MENG15 QUAN 15   3   Accepted Quantity in Base Unit of Measurement  
98 ITM_SUBTYPE BBP_I_SUBTYPE BBP_I_SUBTYPE CHAR 2   0   Specification Purchase Item (e.g. Direct Material/Hierarch.)  
99 ITM_COUNT BBP_BI_ITEM_COUNT   DEC 5   4   Counter for Number of Items  
100 SCL_NO BBP_ETENR ETENR NUMC 4   0   Schedule Line Number *
101 SCL_CREATED_AT BBP_BI_SCL_CREAT_DATE   DATS 8   0   Creation Date of Schedule Line  
102 SCL_CHANGED_AT BBP_BI_SCL_CHANG_DATE   DATS 8   0   Change Date of Schedule Line  
103 SCL_COUNT BBP_BI_SCL_CNT   DEC 5   4   Counter for Number of Schedule Lines  
104 ORG_RESP_ORG BBP_PROG_ORG_RESP HROBJEC_14 CHAR 14   0   Responsible Organizational Unit (purchasing)  
105 ORG_PURCH_ORG BBP_PROC_ORG HROBJEC_14 CHAR 14   0   Responsible Purchasing Organization  
106 ORG_PURCH_GROUP BBP_PROC_GROUP HROBJEC_14 CHAR 14   0   Responsible Purchasing Group  
107 UPDMOD RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
108 ITM_PARENT BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
109 PS_HIER_TEMPL /SAPPSSRM/_HIERTEMPLATE /SAPPSSRM/_HIERTEMPLATE CHAR 10   0   Hierarchy Template *
110 PS_HL_ITEM /SAPPSSRM/_HL_ITEM SYSUUID RAW 16   0   Higher-Level Item GUID  
111 PS_HANDLE_ITM BBP_GUID SYSUUID RAW 16   0   Globally Unique identifier  
112 PS_EXSNR /SAPPSSRM/_EXSNR NUMC5 NUMC 5   0   External Sort Number  
113 PS_CTRL_KEY /SAPPSSRM/_PS_CTRL_KEY /SAPPSSRM/_PS_CTRL_KEY CHAR 4   0   Item Process Type Control Key *
114 .INCLUDE       0   0   FM Fields Earmarked Funds  
115 FUNDS_RES BBP_KBLNR KBLNR CHAR 10   0   Document number for earmarked funds *
116 RES_ITEM KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
117 ITM_REV_LEV CC_REVLV CC_REVLV CHAR 2   0   Revision Level  
118 .INCLU--AP       0   0   BW: IoA regarding Purchase Orders  
119 VZSKZ VZSKZ VZSKZ CHAR 2   0   Interest calculation indicator *
120 .INCLU--AP       0   0   Down Payments Append Extraction Structure  
121 PS_DP_TYPE /SAPPSSRM/_DP_TYPE /SAPPSSRM/_DP_TYPE CHAR 4   0   Down Payment Indicator *
122 PS_DP_AMOUNT /SAPPSSRM/_DP_AMOUNT WERT11 CURR 11   2   Down Payment  
123 PS_DP_PERCENT /SAPPSSRM/_DP_PERCENT /SAPPSSRM/_DP_PERCENT DEC 5   2   Down Payment Percentage  
124 PS_DP_DUE_DATE /SAPPSSRM/_DP_DUE_DATE DATS DATS 8   0   Down Payment Due Date  
125 PS_DP_TYPE_I /SAPPSSRM/_DP_TYPE /SAPPSSRM/_DP_TYPE CHAR 4   0   Down Payment Indicator *
126 PS_DP_AMOUNT_I /SAPPSSRM/_DP_AMOUNT WERT11 CURR 11   2   Down Payment  
127 PS_DP_PERCENT_I /SAPPSSRM/_DP_PERCENT /SAPPSSRM/_DP_PERCENT DEC 5   2   Down Payment Percentage  
128 PS_DP_DUE_DATE_I /SAPPSSRM/_DP_DUE_DATE DATS DATS 8   0   Down Payment Due Date  
129 CURRENCY_H WAERS WAERS CUKY 5   0   Currency Key *
130 CURRENCY_I WAERS WAERS CUKY 5   0   Currency Key *
131 .INCLU--AP       0   0   BI objects for Guaranteed Minimum  
132 PS_GUARANT_MIN BBP_GUARANTEED_MIN WERT8 CURR 15   2   Guaranteed Purchase Value (Public Sector ONLY!!)  
133 CURRENCY_GM WAERS WAERS CUKY 5   0   Currency Key *
134 .INCLU--AP       0   0   Field extensions for options  
135 PS_PO_OPEN_QUAN /SAPPSSRM/_PO_OPEN_QUAN MENG15 QUAN 15   3   Open Quantity of a Purchase Order  
136 PS_PO_QUAN_UNIT /SAPPSSRM/_PO_QUAN_UNIT MEINS UNIT 3   0   Purchase Order Unit *
137 .INCLU--AP       0   0   New Field extensions for options in PO and CTR  
138 OPT_CPLX_DOC BBP_OPT_CPLX_DOC BBP_OPT_CPLX_DOC CHAR 1   0   Documents Containing Options  
139 OPT_IND BBP_OPT_IND BBP_OPT_IND CHAR 1   0   Option Type  
140 OPT_STATUS BBP_OPT_STATUS BBP_OPT_STATUS CHAR 1   0   Option Status  
141 OPT_XPER_START BBP_OPT_XPER_START DATS DATS 8   0   Exercise Period Start Date  
142 OPT_XPER_END BBP_OPT_XPER_END DATS DATS 8   0   Exercise Period End Date  
143 OPT_REF_GUID BBP_OPT_REF_GUID SYSUUID RAW 16   0   Option Reference GUID  
144 OPT_POP_START BBP_OPT_POP_START DATS DATS 8   0   Option Period of Performance Start Date  
145 OPT_POP_END BBP_OPT_POP_END DATS DATS 8   0   Option Period of Performance End Date  
146 .INCLU--AP       0   0   Append for BI enhancements in PA - PO  
147 TOTAL_VALUE BBP_TOTAL_VALUE WERT8 CURR 15   2   Total Value of Shopping Cart (Net Excluding Taxes)  
148 PS_PA_CLNG_HDR /SAPPSSRM/_PA_CEILING_AMOUNT WERT8 CURR 15   2   Ceiling Amount  
149 PS_PA_ID_HDR /SAPPSSRM/_PA_STRUC_ID /SAPPSSRM/PA_STRUC_ID CHAR 4   0   Pricing Arrangement Identifier  
150 PS_PA_TOTL_AMT /SAPPSSRM/_PA_TOTAL_AMOUNT WERT8 CURR 15   2   Total Amount of Master Item  
151 PS_PA_COMP_TYPE /SAPPSSRM/_PA_COMP_TYPE /SAPPSSRM/PA_COMP_TYPE CHAR 1   0   Pricing Component Type *
152 VALUE BBP_VALUE WERT8 CURR 15   2   Net Value  
153 PS_PA_MAX_FEE /SAPPSSRM/_PA_MAXIMUM_FEE WERT7 CURR 13   2   Maximum Fee  
154 PS_PA_MIN_FEE /SAPPSSRM/_PA_MINIMUM_FEE WERT7 CURR 13   2   Minimum Fee  
155 PS_PA_CLNG_AMT /SAPPSSRM/_PA_CEILING_AMOUNT WERT8 CURR 15   2   Ceiling Amount  
156 PS_PA_GS_ABV /SAPPSSRM/_PA_GOV_SHARE_ABOVE /SAPPSSRM/PA_PERCENTAGE DEC 5   2   Government Share Above  
157 PS_PA_GS_BLW /SAPPSSRM/_PA_GOV_SHARE_BELOW /SAPPSSRM/PA_PERCENTAGE DEC 5   2   Government Share Below  
158 PS_PA_ID /SAPPSSRM/_PA_STRUC_ID /SAPPSSRM/PA_STRUC_ID CHAR 4   0   Pricing Arrangement Identifier  
159 PS_PA_NTE_IND /SAPPSSRM/_NTE_IND XFELD CHAR 1   0   Not to Exceed  
160 PS_PA_NSP_IND /SAPPSSRM/_NSP_IND XFELD CHAR 1   0   Not Separately Priced  
161 PS_PA_SS_ABV /SAPPSSRM/_PA_GOV_SHARE_ABOVE /SAPPSSRM/PA_PERCENTAGE DEC 5   2   Government Share Above  
162 PS_PA_SS_BLW /SAPPSSRM/_PA_GOV_SHARE_BELOW /SAPPSSRM/PA_PERCENTAGE DEC 5   2   Government Share Below  
163 PS_PA_UNCF_VALUE BBP_BI_REF_CF_I_VALUE WERT8 CURR 15   2   Referenced Item Net Value of Confirmation in PO Currency  
164 PS_PA_UNCF_QUAN BBP_BI_REF_CF_I_QUAN MENG13 QUAN 13   3   Referenced Quantity of Confirmation in Order Unit  
165 PS_PA_UNIV_VALUE BBP_BI_REF_IV_I_VALUE WERT8 CURR 15   2   Referenced Item Net Value of Invoice in Order Currency  
166 PS_PA_UNIV_QUAN BBP_BI_REF_IV_I_QUAN MENG13 QUAN 13   3   Referenced Quantity of Invoice in Order Unit  
167 PS_PA_CURRENCY WAERS WAERS CUKY 5   0   Currency Key *
168 PS_PA_UNIT BBP_UNIT MEINS UNIT 3   0   Purchase Order Unit *
169 .INCLU--AP       0   0   New field extensions in PO for thresholds  
170 PS_TH_EXCEEDED /SAPPSSRM/_TH_EXCEEDED XFELD CHAR 1   0   Threshold Exceeded  
171 .INCLU--AP       0   0   Retentions Append Extraction Structure  
172 PS_WH_PRCNT_HDR /SAPPSSRM/_WH_PERCENT /SAPPSSRM/_WH_PRZ32 DEC 5   2   Retention Value as Percentage  
173 PS_WH_IND /SAPPSSRM/_WH_IND /SAPPSSRM/_WH_IND CHAR 1   0   Retention Indicator  
174 PS_WH_PRCNT /SAPPSSRM/_WH_PERCENT /SAPPSSRM/_WH_PRZ32 DEC 5   2   Retention Value as Percentage  
175 PS_WH_IND_PA /SAPPSSRM/_WH_IND_PA /SAPPSSRM/_WH_IND_PA CHAR 1   0   Retention Indicator for Pricing Arrangments  
176 .INCLU--AP       0   0   ITEM HIER Field enh on EXTRACT Structure for BI datasource  
177 EXLIN /SAPPSSRM/_EXLIN /SAPPSSRM/_EXLIN CHAR 40   0   Configurable Line Item Number  
178 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