T001 - company code table (BUKRS)
T001K- valuation area (BWKEY) / company code table
T001W - Plant (werks) / valuation area or Branches (BWKEY)
BNKA - Bank master record
G/L Concepts and Table
1. FS10 - Balance Display for G/L
2. Fbl3n -GL Account line item Display
BSIS- Open items G/L table
BSAS- cleared items G/L table
BSEG - Account Document Segmet table (cluster)
BKPF - Account Document Header
Fb03 - To display single posting Document number
Customer Concepts and Table:
1. Xd01
- to create complete master data for customer ( all views available here)
2.FBl5n - Customer line item dispaly
BSID - Open items for customer
BSAD - cleared items for customers
KNA1 - Customer Master Table.
VBRK - Billing Document or Invoice Header table
VBRP - Billing Doumnet or Invoice Item Table
KNBK -Customer Master (Bank Details)
TVKO - Sales Organisations Master Table
In this table we can take sales Organisation company code and address Number and purchase Organisation and Purchase group and so on.
ADRC - Here we can take all adresses by passing address number
VBKD - Sales Document : BusinessTable
Here we can take customer Purchase Order number and purchase order date
T005U - Region (State, Province, County) text Table
T005T - Country names table
VBPA - Sales Document: Partner
SELECT SINGLE adrnr
, kunnr
FROM vbpa
INTO @DATA
(gv_vbpa
)
WHERE parvw
= 'WE' AND vbeln
IN ( SELECT vgbel
FROM vbrp
WHERE vbeln
= @gs_vbrk
-vbeln
).
KONV - Conditions type transaction Table.
KONP - Conditions Master table
VBRK-KUNAG = KNVV-Kunnr
KNVV - Customer Master Sales Data
Here we can fetch Customer group, Sales Office and pricing procedure for customer and so on.
TVKWZ- Allowed Plants per Sales Organization
J_1IMOCOMP - Company and Plant - Excise Additional Data
Here we can fetch VAT ,CST and PAN and Service Tax number
KNMT - Customer-Material Info Record Data Table
T052 -Terms of Payment
TVZBT - Customers: Terms of Payment Texts
SELECT SINGLE ztag1
FROM t052
INTO @DATA
(lv_duedat
) WHERE zterm
IN ( SELECT zterm
FROM vbrk
WHERE vbeln
= @gs_vbrk
-vbeln
AND rfbsk
= 'C').
IF lv_duedat
IS NOT INITIAL.
gv_duedate
= lv_duedat + gs_vbrk
-fkdat
.
ENDIF.
VCUST - Customer List Tcode.
How to read Item text ?
data:gt_line
TYPE TABLE OF tline
,
gs_line TYPE tline.
DATA : lv_id
TYPE thead
-tdid
,
lv_language
TYPE thead
-tdspras
,
lv_name
TYPE thead
-tdname
,
lv_object
TYPE thead
-tdobject
.
REFRESH : gt_line[].
CLEAR : lv_id,lv_language,lv_name,lv_object,gs_line.
lv_id = 'ZINV'.
lv_language = 'EN'.
lv_name = p_gs_vbrk_vbeln.
lv_object = 'VBBK'
*BREAK testabap.
CALL FUNCTION 'READ_TEXT'
EXPORTING
client = sy-mandt
id = lv_id
language = lv_language
name = lv_name
object = lv_object
TABLES
lines = gt_line
EXCEPTIONS
id = 1
language = 2
name = 3
not_found = 4
object = 5
reference_check = 6
wrong_access_to_archive = 7
OTHERS = 8.
IF sy-subrc = 0.
READ TABLE gt_line INTO gs_line INDEX 1.
gs_line-tdline
ENDIF.
Vendor Concepts and Table
Xk01
- to create complete master data for vendors ( all views available here)
LFA1 - Vendor Master (General Section)
LFB1 - Vendor Master (Company Code)
LFBK - Vendor Master (Bank Details)
J_1IMOVEND - Vendor Master Excise Additional Data
FIWTIN_TAN_EXEM- Table for mapping TAN and Exemption Number.
Vendor Master Standed Tcode and Table
BSIK - Vendor Open items Table
BSAK - Vendor Cleared items table
FBL1N - Vendor Line Item Display
FAGLFLEXA -- General Ledger: Actual Line Items ( for profit Center and Segment)
