SAP ABAP Table BAPI3007_2 (Transfer structure 1007/Customer/Line item)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBD (Package) Customers
Basic Data
Table Category INTTAB    Structure 
Structure BAPI3007_2   Table Relationship Diagram
Short Description Transfer structure 1007/Customer/Line item    
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 COMP_CODE BUKRS BUKRS CHAR 4   0   Company Code T001
2 CUSTOMER KUNNR KUNNR CHAR 10   0   Customer Number KNA1
3 SP_GL_IND UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
4 CLEAR_DATE AUGDT DATUM DATS 8   0   Clearing Date  
5 CLR_DOC_NO AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
6 ALLOC_NMBR DZUONR ZUONR CHAR 18   0   Assignment number  
7 FISC_YEAR GJAHR GJAHR NUMC 4   0   Fiscal Year  
8 DOC_NO BELNR_D BELNR CHAR 10   0   Accounting Document Number  
9 ITEM_NUM BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
10 PSTNG_DATE BUDAT DATUM DATS 8   0   Posting Date in the Document  
11 DOC_DATE BLDAT DATUM DATS 8   0   Document Date in Document  
12 ENTRY_DATE CPUDT DATUM DATS 8   0   Accounting document entry date  
13 CURRENCY WAERS WAERS CUKY 5   0   Currency Key TCURC
14 LOC_CURRCY HWAER WAERS CUKY 5   0   Local Currency TCURC
15 REF_DOC_NO XBLNR XBLNR CHAR 16   0   Reference Document Number  
16 DOC_TYPE BLART BLART CHAR 2   0   Document type T003
17 FIS_PERIOD MONAT MONAT NUMC 2   0   Fiscal period  
18 POST_KEY BSCHL BSCHL CHAR 2   0   Posting Key TBSL
19 DB_CR_IND SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
20 BUS_AREA GSBER GSBER CHAR 4   0   Business Area TGSB
21 TAX_CODE MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
22 LC_AMOUNT BAPIDMBTR BAPICURR DEC 23   4   Amount in Local Currency  
23 AMT_DOCCUR BAPIWRBTR BAPICURR DEC 23   4   Amount in document currency  
24 LC_TAX BAPIMWSTS BAPICURR DEC 23   4   Tax Amount in Local Currency  
25 TX_DOC_CUR BAPIWMWST BAPICURR DEC 23   4   Tax Amount in Document Currency  
26 ITEM_TEXT SGTXT TEXT50 CHAR 50   0   Item Text  
27 BRANCH FILKD MAXKK CHAR 10   0   Account Number of the Branch  
28 BLINE_DATE DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
29 PMNTTRMS DZTERM ZTERM CHAR 4   0   Terms of payment key  
30 DSCT_DAYS1 DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
31 DSCT_DAYS2 DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
32 NETTERMS DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
33 DSCT_PCT1 DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
34 DSCT_PCT2 DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
35 DISC_BASE BAPISKFBT BAPICURR DEC 23   4   Amount Eligible for Cash Discount in Document Currency  
36 DSC_AMT_LC BAPISKNTO BAPICURR DEC 23   4   Cash Discount Amount in Local Currency  
37 DSC_AMT_DC BAPIWSKTO BAPICURR DEC 23   4   Cash Discount Amount in Document Currency  
38 PYMT_METH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
39 PMNT_BLOCK DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
40 FIXEDTERMS DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
41 INV_REF REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
42 INV_YEAR REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
43 INV_ITEM REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
44 DUNN_BLOCK MANSP MANSP CHAR 1   0   Dunning block T040S
45 DUNN_KEY MSCHL MSCHL CHAR 1   0   Dunning key T040
46 LAST_DUNN MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
47 DUNN_LEVEL MAHNS_D MAHNS NUMC 1   0   Dunning Level  
48 DUNN_AREA MABER MABER CHAR 2   0   Dunning Area T047M
49 DOC_STATUS BSTAT_D BSTAT CHAR 1   0   Document Status  
50 NXT_DOCTYP REBZT REBZT CHAR 1   0   Follow-On Document Type  
51 VAT_REG_NO STCEG STCEG CHAR 20   0   VAT Registration Number  
52 REASON_CDE RSTGR RSTGR CHAR 3   0   Reason Code for Payments T053R
53 PMTMTHSUPL UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
54 REF_KEY_1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
55 REF_KEY_2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
56 T_CURRENCY PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures TCURC
57 AMOUNT BAPIPSWBT BAPICURR DEC 23   4   Amount for Updating in General Ledger  
58 NET_AMOUNT BAPINEBTR BAPICURR DEC 23   4   Net Payment Amount  
59 NAME NAME1_GP NAME CHAR 35   0   Name 1  
60 NAME_2 NAME2_GP NAME CHAR 35   0   Name 2  
61 NAME_3 NAME3_GP NAME CHAR 35   0   Name 3  
62 NAME_4 NAME4_GP NAME CHAR 35   0   Name 4  
63 POSTL_CODE PSTLZ PSTLZ CHAR 10   0   Postal Code  
64 CITY ORT01_GP TEXT35 CHAR 35   0   City  
65 COUNTRY LAND1_GP LAND1 CHAR 3   0   Country Key T005
66 STREET STRAS_GP TEXT35 CHAR 35   0   House number and street  
67 PO_BOX PFACH PFACH CHAR 10   0   PO Box  
68 POBX_PCD PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
69 POBK_CURAC PSKTO PSKTO CHAR 16   0   Account Number of Bank Account At Post Office  
70 BANK_ACCT BANKN BANKN CHAR 18   0   Bank account number  
71 BANK_KEY BANKK BANKK CHAR 15   0   Bank Keys  
72 BANK_CTRY BANKS LAND1 CHAR 3   0   Bank country key T005
73 TAX_NO_1 STCD1 STCD1 CHAR 16   0   Tax Number 1  
74 TAX_NO_2 STCD2 STCD2 CHAR 11   0   Tax Number 2  
75 TAX STKZU XFELD CHAR 1   0   Liable for VAT  
76 EQUAL_TAX STKZA STKZA CHAR 1   0   Indicator: Business Partner Subject to Equalization Tax?  
77 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
78 CTRL_KEY BKONT BKONT CHAR 2   0   Bank Control Key  
79 INSTR_KEY DTAWS DTAWS CHAR 2   0   Instruction key for data medium exchange T015W
80 PAYEE_CODE EMPFG EMPFG CHAR 16   0   Payee code  
81 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
82 BILL_LIFE WELGF PACK2 DEC 3   0   Life of a bill of exchange  
83 BE_TAXCODE WSTKZ WSTKZ CHAR 1   0   Bill of exchange tax code T046
84 BILLTAX_LC BAPIWSTHW BAPICURR DEC 23   4   Bill of Exchange Tax in Local Currency  
85 BILLTAX_FC BAPIWSTFW BAPICURR DEC 23   4   Bill of Exchange Tax in Foreign Currency  
86 LC_COL_CHG BAPIWINHW BAPICURR DEC 23   4   Charge for Bill of Exchange Collection (in Local Currency)  
87 COLL_CHARG BAPIWINFW BAPICURR DEC 23   4   Charge for Bill of Exchange Collection in Document Currency  
88 CHGS_TX_CD WMWKZ MWSKZ CHAR 2   0   Tax code for bill of exchange charges *
89 ISSUE_DATE WDATE DATUM DATS 8   0   Bill of Exchange Issue Date  
90 USAGEDATE WVERD DATUM DATS 8   0   Date of bill of exchange usage  
91 BILL_USAGE WEVWV WEVWV CHAR 1   0   Planned usage of the bill of exchange  
92 DOMICILE WBANK TEXT60 CHAR 60   0   Bank address where a bill of exchange can be paid (domestic)  
93 DRAWER WNAME TEXT30 CHAR 30   0   Name of bill of exchange drawer  
94 CTRBNK_LOC WLZBP TEXT60 CHAR 60   0   State central bank location  
95 DRAW_CITY1 WORT1 TEXT30 CHAR 30   0   City of bill of exchange drawer  
96 DRAWEE WBZOG TEXT30 CHAR 30   0   Bill of exchange drawee  
97 DRAW_CITY2 WORT2 TEXT30 CHAR 30   0   City of bill of exchange drawee  
98 DISCT_DAYS DISKT PACK2 DEC 3   0   Discount Days  
99 DISCT_RATE DISKP PRZ25 DEC 7   5   Percentage Rate for Bill of Exch. Disc. with Passed-On Chrgs  
100 ACCEPTED XAKTZ XFELD CHAR 1   0   Indicator: Bill of exchange was accepted  
101 BILLSTATUS WSTAT WSTAT CHAR 1   0   Bill of Exchange Status T031S
102 PRTEST_IND WGBKZ WGBKZ CHAR 1   0   Indicator for the bill of exchange protest  
103 BE_DEMAND XSIWE XFELD CHAR 1   0   Indicator: Bill on demand  
104 OBJ_TYPE AWTYP AWTYP CHAR 5   0   Reference procedure *
105 REF_DOC AWREF AWREF CHAR 10   0   Reference document number  
106 REF_ORG_UN AWORG AWORG CHAR 10   0   Reference organisational units  
107 REVERSAL_DOC STBLG BELNR CHAR 10   0   Reverse Document Number  
108 SP_GL_TYPE UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
109 NEG_POSTNG XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
110 REF_DOC_NO_LONG XBLNR_LONG XBLNR_LONG CHAR 35   0   Reference Document Number (for Dependencies see Long Text)  
111 BILL_DOC VBELN_VF VBELN CHAR 10   0   Billing document *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 BAPI3007_2 BANK_CTRY T005 LAND1    
2 BAPI3007_2 BE_TAXCODE T046 WSTKZ    
3 BAPI3007_2 BILLSTATUS T031S WSTAT    
4 BAPI3007_2 BUS_AREA TGSB GSBER    
5 BAPI3007_2 COMP_CODE T001 BUKRS    
6 BAPI3007_2 COUNTRY T005 LAND1    
7 BAPI3007_2 CURRENCY TCURC WAERS    
8 BAPI3007_2 CUSTOMER KNA1 KUNNR    
9 BAPI3007_2 DOC_TYPE T003 BLART    
10 BAPI3007_2 DUNN_AREA T047M MABER    
11 BAPI3007_2 DUNN_BLOCK T040S MANSP    
12 BAPI3007_2 DUNN_KEY T040 MSCHL    
13 BAPI3007_2 INSTR_KEY T015W DTAWS    
14 BAPI3007_2 LANGU T002 SPRAS    
15 BAPI3007_2 LOC_CURRCY TCURC WAERS    
16 BAPI3007_2 PMNT_BLOCK T008 ZAHLS    
17 BAPI3007_2 PMTMTHSUPL T042F UZAWE    
18 BAPI3007_2 POST_KEY TBSL BSCHL    
19 BAPI3007_2 PYMT_METH T042Z ZLSCH    
20 BAPI3007_2 REASON_CDE T053R RSTGR    
21 BAPI3007_2 REGION T005S BLAND    
22 BAPI3007_2 SP_GL_IND T074U UMSKZ    
23 BAPI3007_2 T_CURRENCY TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in