SAP ABAP Table BBP_INV_BW_GET_TD_STRUC (Extraction Structure: Movement Data SAP BBP Invoice)
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_INV_BW_GET_TD_STRUC   Table Relationship Diagram
Short Description Extraction Structure: Movement Data SAP BBP Invoice    
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_INV_H_GUID SYSUUID_C CHAR 32   0   INV GUID 32 Char.  
3 INV_NUMBER BBP_BW_INV_NUMBER CRM_OBJECT_ID CHAR 10   0   Invoice Number  
4 PROCESS_TYPE CRMT_PROCESS_TYPE CRM_PROCESS_TYPE CHAR 4   0   Business Transaction Type *
5 DOC_DATE DOC_DATE DATE DATS 8   0   Document 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 BUP_ORDERER_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
13 BUP_ORDERER_GUID BBP_BW_ORD_GUID_32 SYSUUID_C CHAR 32   0   Company GUID 32 Char.  
14 BUP_VENDOR_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
15 BUP_VENDOR_GUID BBP_BW_VEND_GUID_32 SYSUUID_C CHAR 32   0   Vendor GUID 32 Char.  
16 REF_DOC_NO XBLNR XBLNR CHAR 16   0   Reference Document Number  
17 POSTING_DATE_FI POSTING_DATE_FI DATUM DATS 8   0   Transaction Posting Date in Accounting  
18 CO_CODE BBP_CO_CODE BUKRS CHAR 4   0   Company Code in FI System *
19 BBP_LOG_SYSTEM BBP_LOG_SYS LOGSYS CHAR 10   0   Logical System EBP *
20 BE_LOG_SYSTEM BE_LOG_SYSTEM LOGSYS CHAR 10   0   Logical System of Logistics Backend *
21 LOGSYS_FI BBP_LOGSYS_FI LOGSYS CHAR 10   0   Logical System of FI System *
22 CURRENCY WAERS WAERS CUKY 5   0   Currency Key *
23 GROSS_AMOUNT BBP_IV_AMOUNT WERT8 CURR 15   2   Gross invoice amount in document currency  
24 REASON_CODE BBP_PD_REASON CHAR4 CHAR 4   0   Reason for Rejection  
25 TAX_AMOUNT BBP_TAX_AMOUNT WERT8 CURR 15   2   Tax Amount  
26 FRT_AMOUNT BBP_FRT_AMOUNT WERT8 CURR 15   2   Shipment Costs  
27 FRT_TAX_CODE BBP_MWSKZ BBP_MWSKZ CHAR 2   0   Tax Code  
28 INP_TYPE BBP_INP_TYPE BBP_INP_TYPE CHAR 1   0   Creation Indictaor (Dialog, XML and so on)  
29 SUBTYPE BBP_H_SUBTYPE BBP_H_SUBTYPE CHAR 2   0   Specification of a Purchasing Doc.(e.g. Credit Memo/Invoice)  
30 IS_BBP BBP_BW_IS_BBP   CHAR 1   0   Flag for Update in BBP (X = TRUE ) or Backend Systems  
31 INV_COUNT BBP_BW_PO_CNT COUNTER NUMC 1   0   Counter for Number of Document Headers  
32 STAT_PROCESS J_STATUS J_STATUS CHAR 5   0   Object status  
33 STAT_RELEASE J_STATUS J_STATUS CHAR 5   0   Object status  
34 STAT_TRANSFER J_STATUS J_STATUS CHAR 5   0   Object status  
35 ITM_GUID BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
36 ITM_CREATED_AT BBP_BW_CR_AT   DATS 8   0   Creation Date of Document  
37 ITM_CHANGED_AT BBP_BW_CHNG_AT   DATS 8   0   Change Date of Document  
38 ITM_CREATED_BY CRMT_CREATED_BY UNAME CHAR 12   0   User that Created the Transaction  
39 ITM_CHANGED_BY CRMT_CHANGED_BY UNAME CHAR 12   0   Transaction Last Changed By  
40 ITM_PARENT BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
41 ITM_PRODUCT_GUID BBP_BW_PROD_GUID_32 SYSUUID_C CHAR 32   0   Product Guid 32 Char.  
42 ITM_PRODUCT_ID CRMT_ORDERED_PROD CRM_ORDERED_PROD CHAR 54   0   Product Name Entered  
43 ITM_DESCRIPTION COMT_PRSHTEXTX PRSHTEXT40 CHAR 40   0   Product Description  
44 ITM_DESCRIP_UC COMT_PRSHTEXTG PRSHTEXTG40 CHAR 40   0   Product Description in Uppercase for F4 Help  
45 ITM_NUMBER CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
46 ITM_TYPE CRMT_ITEM_TYPE CRM_ITEM_TYPE CHAR 4   0   Item Category *
47 ITM_CAT_GUID BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
48 ITM_CATEGORY_ID COMT_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Category ID  
49 ITM_SCHEMA_TYPE SCHEMA_TYPE COM_SCHEMA_TYPE CHAR 10   0   Standard Schema Type *
50 ITM_EX_CT_UN_ID BBP_ITM_EX_CT_UN_ID CHAR40 CHAR 40   0   Unique Key in External Category  
51 ITM_CT_CAT_ID BBP_CT_CATEGORY_ID CHAR60 CHAR 60   0   Category Name  
52 ITM_MANU_PROD BBP_MFRPN CHAR40 CHAR 40   0   Manufacturer Part Number  
53 ITM_MFR_NO_EXT EMNFR CHAR10 CHAR 10   0   External manufacturer code name or number  
54 ITM_CATALOGID CATALOG KATALOGID CHAR 20   0   Catalog ID from which the line was selected *
55 ITM_PRODUCT_TYPE COMT_PRODUCT_TYPE COM_PRODUCT_TYPE CHAR 2   0   Product Type *
56 ITM_PROD_SRC_SYS CRMT_PRODUCT_SRC_SYS LOGSYS CHAR 10   0   Logical System from Which Product Originates *
57 ITM_SYS_TYPE BBP_SYSTEM_TYPE BBP_SYSTEM_TYPE CHAR 10   0   System type  
58 ITM_SLD_SYS_NAME BBP_SLD_SYS_NAME TEXT60 CHAR 60   0   Name of a System im System Landscape Directory (SLD)  
59 ITM_QUANTITY BBP_MNG MENG13 QUAN 13   3   Quantity in Order Unit  
60 ITM_UNIT BBP_UNIT MEINS UNIT 3   0   Purchase Order Unit *
61 ITM_PRICE BBP_PRICE WERT7 CURR 13   2   Net Price  
62 ITM_PRICE_UNIT EPEIN DEC5 DEC 5   0   Price unit  
63 ITM_VALUE BBP_VALUE WERT8 CURR 15   2   Net Value  
64 ITM_REQUEST_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
65 ITM_REQUEST_GUID BBP_BW_REQU_GUID_32 SYSUUID_C CHAR 32   0   Requester GUID 32 Char.  
66 ITM_RECIPNT_ID BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
67 ITM_RECIPNT_GUID BBP_BW_RCPT_GUID_32 SYSUUID_C CHAR 32   0   Goods Recipient GUID 32 Char  
68 ITM_LOC_ID BBP_LOCATION_NO BU_PARTNER CHAR 10   0   Plant Number *
69 ITM_LOC_GUID BBP_LOC_GUID_32 SYSUUID_C CHAR 32   0   Plant GUID 32 Char  
70 ITM_WORKER_ID BBP_SRV_PROVIDER BU_PARTNER CHAR 10   0   Service Provider Number *
71 ITM_WORKER_GUID BBP_BW_SRV_GUID_32 SYSUUID_C CHAR 32   0   Service Provider GUID 32 Char.  
72 ITM_WRKR_SRC_SYS COMT_PARTNER_SRC_SYS LOGSYS CHAR 10   0   Logical System from Which Partner Originates *
73 ITM_WORKER_NAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
74 ITM_WRK_NO_TYPE CRMT_PARTNER_NO_TYPE COMT_PARTNER_NO_TYPE CHAR 2   0   Partner Number Type (e.g. GUID, Pers. No., ...), Internal  
75 ITM_CUSTOMER_ID BBP_CUSTOMER BU_PARTNER CHAR 10   0   Customer Number (Third Party PO) *
76 ITM_CUST_GUID BBP_BW_CUST_GUID_32 SYSUUID_C CHAR 32   0   Customer GUID 32 Char. (Third Party PO)  
77 ITM_CUST_SRC_SYS COMT_PARTNER_SRC_SYS LOGSYS CHAR 10   0   Logical System from Which Partner Originates *
78 ITM_CUST_NAME BU_MCNAME1 CHAR35 CHAR 35   0   Search Help Field 1 (Name 1/Last Name)  
79 ITM_CUST_NO_TYPE CRMT_PARTNER_NO_TYPE COMT_PARTNER_NO_TYPE CHAR 2   0   Partner Number Type (e.g. GUID, Pers. No., ...), Internal  
80 ITM_TAX_CODE BBP_MWSKZ BBP_MWSKZ CHAR 2   0   Tax Code  
81 ITM_PO_GUID BBP_BW_PO_H_GUID SYSUUID_C CHAR 32   0   PO GUID 32 Char.  
82 ITM_PO_NUMBER BBP_BW_PO_NUMBER CRM_OBJECT_ID CHAR 10   0   Purchase Order Number  
83 ITM_PO_ITM_GUID BBP_BW_PO_I_GUID SYSUUID_C CHAR 32   0   PO Item GUID 32 Char.  
84 ITM_PO_ITEM_NO CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
85 ITM_CONF_GUID BBP_BW_CONF_H_GUID SYSUUID_C CHAR 32   0   CONF GUID 32 Char.  
86 ITM_CONF_NUMBER BBP_BW_CONF_NUMBER CRM_OBJECT_ID CHAR 10   0   Confirmation Number  
87 ITM_CONF_ITMGUID BBP_BW_CONF_I_GUID SYSUUID_C CHAR 32   0   CONF Item GUID 32 Char.  
88 ITM_CONF_ITM_NO CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
89 ITM_CTR_GUID BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
90 ITM_CTR_NUMBER BBP_CTR_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Contract Number  
91 ITM_CTR_ITMGUID BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
92 ITM_CTR_ITM_NO CRMT_ITEM_NO CRM_ITEM_NO NUMC 10   0   Item Number in Document  
93 ITM_DEL_IND BBP_DEL_IND XFELD CHAR 1   0   Deletion Indicator EBP Purchasing Document  
94 ITM_COUNT BBP_BW_ITEM_CNT   DEC 5   4   Counter for Number of Items  
95 ACC_GUID BBP_GUID_32 SYSUUID_C CHAR 32   0   Globally Unique Identifier in 32-Character Display  
96 ACC_NO BBP_ACC_NO BBP_ACCNO NUMC 4   0   Sequential Account Assignment No. in EBP Purchase Document  
97 ACC_CAT BBP_ACC_CAT BBP_ACCCAT CHAR 5   0   Account Assignment Category in Enterprise Buyer  
98 ACC_DISTR_PERC BBP_VPROZ BBP_VPROZ DEC 5   2   Distribution Percentage in the Case of Multiple Acct Assgt  
99 ACC_G_L_ACCT SAKNR SAKNR CHAR 10   0   G/L Account Number *
100 ACC_BUS_AREA GSBER GSBER CHAR 4   0   Business Area *
101 ACC_CO_AREA KOKRS CACCD CHAR 4   0   Controlling Area *
102 ACC_COST_CTR KOSTL KOSTL CHAR 10   0   Cost Center *
103 ACC_ASSET_NO ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
104 ACC_SUB_NUMBER ANLN2 ANLN2 CHAR 4   0   Asset Subnumber *
105 ACC_ORDER_NO AUFNR AUFNR CHAR 12   0   Order Number *
106 ACC_PROFIT_CTR PRCTR PRCTR CHAR 10   0   Profit Center  
107 ACC_WBS_ELEM_E WBS_ELEM PS_POSID CHAR 24   0   Work breakdown structure element (WBS element)  
108 ACC_NETWORK NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
109 ACC_ACTIVITY VORNR VORNR CHAR 4   0   Operation/Activity Number  
110 ACC_STR BBP_ACC_GENERIC CHAR64 CHAR 64   0   Generic Account Assignment  
111 CMMT_ITEM FIPOS FIPOS CHAR 14   0   Commitment Item *
112 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
113 FUNDS_CTR FISTL FISTL CHAR 16   0   Funds Center *
114 FUND BP_GEBER BP_GEBER CHAR 10   0   Fund *
115 FUNC_AREA FKBER_SHORT FKBER_SHORT CHAR 4   0   Functional Area  
116 SD_DOC BBP_VBELN VBELN CHAR 10   0   Sales and Distribution Document Number  
117 SDOC_ITEM BBP_POSNR_VA POSNR NUMC 6   0   Sales Document Item  
118 SCHED_LINE BBP_ETENR ETENR NUMC 4   0   Schedule Line Number *
119 ORG_RESP_ORG BBP_PROG_ORG_RESP HROBJEC_14 CHAR 14   0   Responsible Organizational Unit (purchasing)  
120 ORG_PURCH_ORG BBP_PROC_ORG HROBJEC_14 CHAR 14   0   Responsible Purchasing Organization  
121 ORG_PURCH_GROUP BBP_PROC_GROUP HROBJEC_14 CHAR 14   0   Responsible Purchasing Group  
122 UPDMOD RODMUPDMOD RODMUPDMOD CHAR 1   0   BW Delta Process: Record Mode  
123 .INCLUDE       0   0   FM Fields Earmarked Funds  
124 FUNDS_RES KBLNR KBLNR CHAR 10   0   Document Number for Earmarked Funds *
125 RES_ITEM KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
History
Last changed by/on SAP  20110908 
SAP Release Created in 20A