Monday, 24 April 2017

Customer / Vendor / GL concepts and Read Text from



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 adrnrkunnr 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_duedatWHERE 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