KNKA Customer Master Credit Management : KUNNR
Central Data
KNKK Customer Master Credit Management : KUNNR / KKBER
Control Area Data
KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL
RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2
Information System
FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General Sections
PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL
FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments
F111G Global Settings for Payment Program for MANDT
Payment Requests
FDZA Cash Management Line Items in Payment KEYNO
Requests
PAYRQ Payment Requests KEYNO
What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?
As far as general ledger master data is concerned, the following tables are involved :
Table name : SKB1 : G/L Account Master ( Company Code)
Fields:
BUKRS : Company Code
SAKNR : G/L Account
Table name : SKA1 : G/L Account Master ( Chart of Accounts )
Fields:
KTOPL : Char of Accounts
SAKNR : G/L Account
Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:
SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account
FI functional modules BAPI_GL_ACC_GETPERIODBALANCES - Posting period balances for each G/L account
FI_CHART_OF_ACCOUNT_DETERMINE
FI_COMPANY_CODE_CHECK
FI_COMPANY_CODE_DATA
FI_COUNTRY_CHECK
FI_COUNTRY_DATA - FI: return country data
FI_GL_ACCOUNT_CHECK
FI_GL_ACCOUNT_DATA
FI_VENDOR_CHECK
FI_VENDOR_DATA
FI_CUSTOMER_CHECK
FI_CUSTOMER_DATA
FI-SL Sets:
G_SET_GET_ALL_VALUES - Read All Values in a Set Hierarchy
Imports a set Id and table name and returns an internal table filled with elements of the set.
4.6C Example (retrieve set Id using G_SET_GET_ID_FROM_NAME).
Code:
DATA: BEGIN OF IT_SETVAL OCCURS 0.
INCLUDE STRUCTURE RGSB4.
DATA: END OF IT_SETVAL.
PARAMETERS: p_kostl like sethier-setid, "Cost Center Group
HP_KOSTL like sethier-setid NO-DISPLAY.
ranges: r_kostl for csks-kostl. "Cost center range
G_SET_TREE_IMPORT Importing a Set Hierarchy
Imports a set Id and table name and returns two internal tables filled with
elements of the set;
hierarchy tree of the set.
4.6C Example (retrieve set Id using G_SET_GET_ID_FROM_NAME).
Code:
*----- cost elements hierarchy -----------------------------------------
data: begin of ivalues occurs 0.
include structure setvalues.
data: end of ivalues.
data: begin of itree occurs 1.
include structure sethier.
data: end of itree.
parameters: p_kstar like sethier-setid, "Cost Element Group
hp_kstar like sethier-setid no-display,
p_kokrs like tka01-kokrs obligatory. "Controlling Area
G_SET_GET_ID_FROM_NAME Determining a Set ID from the Set Name and Other Information
Derives the internal set Id from the name that appears on the user interface, e.g. in order then to import the set (see the function group and function module documentation). To take in account changes in SET concept in 4.6C: see examples to G_SET_GET_ALL_VALUES and G_SET_TREE_IMPORT.
See also example reports:
RGSEX001 - Read-only access with G_SET_TREE_IMPORT
RGSEX000, RGSEX010, RGSEX020 - Access with modules from the function group GSSM
RGSEX030 - Create a set
Tables:
T800S - FI-SL Set Table (before Release 4.0)
CALCULATE_TAX_FROM_GROSSAMOUNT - calculate the tax amount and to get the correct tax account.
DATA: g_monat LIKE t009b-poper,
g_periv LIKE t001-periv.
g_monat = p_date+4(2).
SELECT SINGLE periv FROM t001 INTO g_periv
WHERE bukrs = p_bukrs.
IF sy-subrc IS INITIAL.
CALL FUNCTION 'DATE_TO_PERIOD_CONVERT'
EXPORTING
i_date = p_date
i_periv = g_periv "Version der Periodenermittlung
IMPORTING
e_buper = g_monat
EXCEPTIONS
input_false = 1
t009_notfound = 1
t009b_notfound = 1.
ENDIF.
SELECT *
FROM bsid
INTO CORRESPONDING FIELDS OF TABLE lt_bsid
WHERE bukrs = p_bukrs
AND kunnr IN s_kunnr
AND gjahr = p_date(4)
AND monat = g_monat.
FI_PERIOD_CHECK - check if the period is opened or closed
Code:
*&---------------------------------------------------------------------*
*& Form DETERMINAR_FECHA_CONTABLE
*&---------------------------------------------------------------------*
FORM determinar_fecha_contable USING pe_bldat
CHANGING ps_budat.
DATA: l_ejercicio_abierto LIKE bkpf-gjahr,
l_periodo_abierto LIKE t009b-poper,
l_salir LIKE sy-sUbrc.
l_salir = sy-subrc.
IF l_salir NE 0.
*Si el periodo está cerrado hay que calcular el siguiente abierto
CALL FUNCTION 'RE_ADD_MONTH_TO_DATE'
EXPORTING
months = 1
olddate = ps_budat
IMPORTING
newdate = ps_budat.
IF PS_BUDAT > '20990101'.
PS_BUDAT = PE_BLDAT.
EXIT.
ENDIF.
ENDWHILE.
ENDFORM. " DETERMINAR_FECHA_CONTABLE
CONVERT_TO_LOCAL_CURRENCY - Translate foreign currency amount to local currency
An amount in local currency is calculated from a specified foreign currency amount. For this, you may either specify the translation rate manually (Parameter RATE) or have the system determine it from table TCURR on the basis of the rate type, date and currency key. Because the ratios for the units of the currencies involved in the translation are significant for this translation, table TCURF is always read by the program, and there must be a valid entry there for the data specified. IF exchange rate fixing is defined for the exchange rate type TYPE_OF_RATE or an alternative exchange rate is defined for the currency pair, this information is transferred to the calling program.
When table TCURR is read, the foreign currency key is always taken as the first part of the key and the local currency as the second part.
*---------------------------------------------------------------------*
* FORM dev_periodo_ejerc *
*---------------------------------------------------------------------*
* Procedimiento que pasándole la fecha de contabilización *
* devuelve el ejercico y periodo *
*---------------------------------------------------------------------*
form dev_periodo_ejerc.
FUNCTION zexxfi_period_get.
*"----------------------------------------------------------------------
*"*"Local Interface:
*" IMPORTING
*" REFERENCE(BUKRS) TYPE BUKRS
*" REFERENCE(DATE) TYPE DATUM OPTIONAL
*" REFERENCE(MONAT) TYPE MONAT OPTIONAL
*" REFERENCE(GJAHR) TYPE GJAHR OPTIONAL
*" EXPORTING
*" REFERENCE(MONAT_MAX) TYPE MONAT
*" REFERENCE(MONAT_CUR) TYPE MONAT
*" REFERENCE(MONAT_POST_MAX) TYPE MONAT
*" REFERENCE(MONAT_SPEC_MAX) TYPE MONAT
*" REFERENCE(LAST_DAY) TYPE DATUM
*" REFERENCE(FIRST_DAY) TYPE DATUM
*" EXCEPTIONS
*" NO_ENTRY
*" INPUT_FALSE
*" T009_NOTFOUND
*" T009B_NOTFOUND
*"----------------------------------------------------------------------
STATICS: ct_t009 TYPE TABLE OF t009 WITH HEADER LINE.
DATA: l_poper TYPE t009b-poper,
l_monat TYPE bkpf-monat,
l_periv TYPE t001-periv,
ls_t001 TYPE t001.
IF NOT sy-subrc IS INITIAL.
RAISE no_entry.
ENDIF.
READ TABLE ct_t009 WITH KEY periv = ls_t001-periv.
IF NOT sy-subrc IS INITIAL.
SELECT SINGLE * INTO ct_t009
FROM t009
WHERE periv = ls_t001-periv.
APPEND ct_t009.
ENDIF.
monat_post_max = ct_t009-anzbp.
monat_spec_max = ct_t009-anzsp.
monat_max = monat_post_max + monat_spec_max.
IF NOT date IS INITIAL.
CALL FUNCTION 'DATE_TO_PERIOD_CONVERT'
EXPORTING
i_date = date
i_periv = l_periv "Version der Periodenermittlung
IMPORTING
e_buper = monat_cur
EXCEPTIONS
input_false = 1
t009_notfound = 2
t009b_notfound = 3.
CASE sy-subrc.
WHEN 1.
RAISE input_false.
WHEN 2.
RAISE t009_notfound.
WHEN 3.
RAISE t009b_notfound.
ENDCASE.
ENDIF.
IF NOT monat IS INITIAL AND
NOT gjahr IS INITIAL.
l_poper = monat.
CALL FUNCTION 'FIRST_DAY_IN_PERIOD_GET'
EXPORTING
i_gjahr = gjahr
i_periv = ls_t001-periv
i_poper = l_poper
IMPORTING
e_date = first_day
EXCEPTIONS
input_false = 1
t009_notfound = 2
t009b_notfound = 3.
CASE sy-subrc.
WHEN 1.
RAISE input_false.
WHEN 2.
RAISE t009_notfound.
WHEN 3.
RAISE t009b_notfound.
ENDCASE.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum
All product names are trademarks of their respective companies. SAPNET.RU websites are in no way affiliated with SAP AG. SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver and any other are registered trademarks of SAP AG. Every effort is made to ensure content integrity. Use information on this site at your own risk.
