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