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)
No comments:
Post a Comment