domingo, 18 de janeiro de 2015

Conciliação bancária com contas transitórias


Contas e subcontas bancárias 

Utilização
É aconselhável usar subcontas bancárias para lançar entrada e saída de pagamentos.
Se não usar subcontas, configurar contas bancárias standard no menu de configuração do programa de pagamento. Consultar
Como selecionar o banco da empresa
Isso inclui as contas para cheques emitidos, transferências de saída, cheques recebidos e cobrança bancária (consultar a figura abaixo).




O uso de subcontas traz a seguinte vantagem: a possibilidade de reconciliar, a qualquer momento, o saldo da conta no banco com o saldo da conta do Razão correspondente. As subcontas garantem que todas as entradas e saídas de pagamentos sejam lançadas na conta bancária do Razão somente quando o dinheiro for realmente debitado/creditado na conta bancária. Essa transferência lançada da conta transitória para a conta bancária é executada ao receber o extrato de conta pertinente do banco.
Contas bancárias e subcontas bancárias: exemplo
Pré-requisitos
Para usar a função das subcontas bancárias, criar subcontas com qualquer grau de diferenciação necessário. É possível, por exemplo, criar uma subconta bancária para cada banco ou para cada banco e um grupo de formas de pagamento. Os planos de contas oferecidos com esse pacote fornecem uma referência para essa diferenciação.



As subcontas são geralmente administradas com base em partidas em aberto e com a exibição das partidas individuais, uma vez que é preciso ver, por meio dessas contas e a qualquer momento, se uma operação contábil foi concluída.
Observações sobre a seqüência de ordenação de itens em subcontas bancárias
Se as subcontas que são normalmente lançadas pelo programa de pagamento (por exemplo, a conta para transferências internacionais) possuírem uma seqüência de ordenação especial, será mais fácil processá-las ao lançar o extrato de conta bancária.
Os documentos do programa de execução de pagamento contêm, no cabeçalho do documento (campo BKTXT), a data e o número de identificação (por exemplo, 19940301-ID) da execução. O sistema poderá transferir automaticamente essa informação para o campo Atribuição
no item do documento, se for definida uma regra de ordenação do item correspondente, e entrar esse item no registro mestre da conta do Razão.
Posteriormente, é possível, ao entrar o extrato de conta bancária, marcar por meio do campo Atribuição todas as transferências internacionais de um determinado ciclo de pagamento para compensá-las.
Como lançar separadamente por divisão
Se tiver sido determinado que os pagamentos para uma determinada empresa devem ser feitos separadamente por divisão, o lançamento bancário é feito para a divisão das partidas pagas.
Se não separar os pagamentos por divisão, é possível especificar que os lançamentos bancários devem ser feitos para uma certa divisão. Para isso, especificar a divisão requerida para a conta bancária (consultar a figura acima).



by Allan Eduardo Favaron
SAP FI Consultant

sábado, 3 de janeiro de 2015

Tabelas - Mestre de Fornecedor



LFA1 - vendor master (General Section) FI - Financial Accounting
LFB1 - vendor master (Company Code) FI - Financial Accounting
LFBK - vendor master (Bank Details) FI - Financial Accounting
LFM1 - vendor master record purchasing organization data Logistics - Vendor Master
J_1IMOVEND - vendor master Excise Additional Data FI - Localization
LFC1 - vendor master (transaction figures) FI - Financial Accounting
LFBW - vendor master record (withholding tax types) X FI - Basic Functions
LFB5 - vendor master (dunning data) FI - Financial Accounting
LFC3 - vendor master (special G/L transaction figures) FI - Financial Accounting
LFM2 - vendor master Record: Purchasing Data Logistics - Vendor Master
LFAS - vendor master (VAT registration numbers general section) FI - Financial Accounting
LFAT - vendor master record (tax groupings) FI - Basic Functions
LFEI - vendor master: Preference for Import and Export SD - Basic Functions
LFLR - vendor master Record: Supply Regions Logistics - Vendor Master
LFMC - vendor master (short texts for condition types) SD - Conditions
T078K - Transaction-dependent screen selection for vendor master FI - Payment Transactions
TVENDCUST_SCGRT - Texts for Screen Groups for Customer and vendor master Data FI - Basic Functions
TXW_S_LFC1 - Retrieve archived vendor master (transaction figures) data Cross Application - Data Retention Tool
FMFG_LFACCR - vendor master Central Contractor Registry (CCR) PSM - Functions for U.S. Federal Government
FMFG_CCRFDDISP - CCR Fields to be "Display only" in vendor master Change PSM - Functions for U.S. Federal Government
ADRC - Addresses (Business Address Services) Basis - Address Management/Business Address
ADR6 - E-Mail Addresses (Business Address Services) Basis - Address Management/Business Address
PORG - Organizational Priorities MM - Materials Management
MARA - General Material Data Logistics - Material Master
MARC - Plant Data for Material Logistics - Material Master
KNA1 - General Data in Customer master Logistics - Customer Master
MAKT - Material Descriptions Logistics - Material Master
CDHDR - Change document header Basis - Change Documents
MBEW - Material Valuation Logistics - Material Master
BSIK - Accounting: Secondary Index for vendors FI - Financial Accounting
MVKE - Sales Data for Material Logistics - Material Master
BSAK - Accounting: Secondary Index for vendors (Cleared Items) FI - Financial Accounting
KNVV - Customer master Sales Data Logistics - Customer Master
MAST - Material to BOM Link Logistics - Bills of Material
KNB1 - Customer master (Company Code) FI - Financial Accounting
EINA - Purchasing Info Record: General Data MM - Purchasing
BNKA - Bank master record Cross Application - Bank
KNC1 - Customer master (transaction figures) FI - Financial Accounting
ADR2 - Telephone Numbers (Business Address Services) Basis - Address Management/Business Address
WYT3 - Partner Functions Logistics - Vendor Master
KNC3 - Customer master (special G/L transaction figures) FI - Financial Accounting
CRMSUBTAB - Subscription Table for Upload and Download Objects Cross Application - Cross-Application Components
T077K - vendor account groups FI - Payment Transactions
TSADOBJ - Assignments of BOR object types to address reference types Basis - Address Management/Business Address
LFMH - vendor hierarchy Logistics - Vendor Master



by Allan Eduardo Favaron
SAP FI Consultant 

Tabelas - Código de Imposto


T059Z - Withholding tax code (enhanced functions) FI - Basic Functions
T007V - tax codes to be Transported FI - Financial Accounting
J_1ICONDTAX - tax codes for Excise Duties Using Condition Technique FI - Localization
A399 - Withholding tax code - country-specific SD - Billing
J_1IEWT_ECFLAG - Separate tax code for Ecess FI - Localization
J_1IEWTSURC - Surcharge tax codes FI - Localization
T059ZT - Text table: Withholding tax codes FI - Basic Functions
TE011 - Code for tax code Determination FI - Contract Accounts Receivable and Payable
T076M - EDI: Conversion of External Tax Rate <-> tax code FI - Financial Accounting
T007AC - tax code Selection for Transactions FI - Financial Accounting
J_1IEXMPTCODE - VAT Exempted tax code FI - Localization
J_1IEWT_MIGRATE - Map Classic tax code to EWT Tax type - tax codes FI - Localization
J_1ITCJCMAP - tax code and Jurisdiction code mapping FI - Localization
J_1BTXSDC - SD tax codes FI - Localization
T059ZZINS - Withholding tax code for interest calculation FI - Basic Functions
T5VS5 - tax codes - text table Payroll - Norway
TFK007FK - Tax Item Categories for Other tax code FI - Contract Accounts Receivable and Payable
TFK007FKT - Tax Item Categories for Other tax code FI - Contract Accounts Receivable and Payable
KONP - Conditions (Item) SD - Conditions
WITH_ITEM - Witholding tax info per W/tax type and FI line item FI - Basic Functions
A003 - tax Classification SD - Conditions
V_T7INP1 - Generated Table for View V_T7INP1 Personnel Mgmt - India
EKKO - Purchasing Document Header MM - Purchasing
BKPF - Accounting Document Header FI - Financial Accounting
LFA1 - Vendor Master (General Section) FI - Financial Accounting
TADIR - Directory of Repository Objects Basis - Transport Organizer
TSTC - SAP Transaction codes Basis - ABAP Runtime Environment
ADRC - Addresses (Business Address Services) Basis - Address Management/Business Address
TRDIR - Generierte Tabelle zu einem View Basis - Syntax, Compiler, Runtime
T001W - Plants/Branches Logistics - Plant Master
LFB1 - Vendor Master (Company code) FI - Financial Accounting
TSTCT - Transaction code Texts Basis - ABAP Runtime Environment
PROP - Forecast parameters MM - Inventory Controlling
V_512W_D - Generated Table for View V_512W_D Payroll - Payroll: General Parts
J_1IMOVEND - Vendor Master Excise Additional Data FI - Localization
V_T7INT9 - Generated Table for View V_T7INT9 Personnel Mgmt - India
V_T7INA9 - Generated Table for View V_T7INA9 Personnel Mgmt - India
LFBW - Vendor master record (withholding tax types) X FI - Basic Functions
KNVI - Customer Master tax Indicator SD - Billing
T683S - Pricing Procedure: Data SD - Conditions
T005S - taxes: Region (Province) Key Basis - Address Management/Business Address
V_T7INP3 - Generated Table for View V_T7INP3 Personnel Mgmt - India
V_T7INP4 - Generated Table for View V_T7INP4 Personnel Mgmt - India
J_1IEWTNUMGR_1 - Number Groups For Internal Challan Numbers-EWT India:SECCO FI - Localization
V_T7INT3 - Generated Table for View V_T7INT3 Personnel Mgmt - India
J_1BTAXCODEV - Generierte Tabelle zu einem View FI - Localization
J_1IEWTNUMGR_N - Number Groups For Internal Challan Numbers-EWT India:SECCO FI - Localization
J_1IT030K_V - Generated Table for View J_1IT030K_V FI - Localization
J_1IEWT_CERTNO - Number Ranges for Withholding tax Certificates FI - Localization
T059Q - Withholding tax FI - Financial Accounting
V_T005S - Generated Table for View V_T005S Basis - Address Management/Business Address
J_1IMATEXP - Exceptional materials excise rates FI - Localization
V_T7INT5 - Generated Table for View V_T7INT5 Personnel Mgmt - India



by Allan Eduardo Favaron
SAP FI Consultant  

Tabelas - Mestre de Cliente


KNA1 - General Data in customer master Logistics - Customer Master
KNVV - customer master Sales Data Logistics - Customer Master
KNB1 - customer master (Company Code) FI - Financial Accounting
KNVP - customer master Partner Functions FI - Basic Functions
KNVK - customer master Contact Partner Logistics - Customer Master
KNKK - customer master credit management: Control area data FI - Basic Functions
KNC1 - customer master (transaction figures) FI - Financial Accounting
KNBK - customer master (Bank Details) FI - Financial Accounting
KNVI - customer master Tax Indicator SD - Billing
KNKA - customer master credit management: Central data FI - Basic Functions
KNVS - customer master Shipping Data Logistics Execution - Shipping
KNB5 - customer master (dunning data) FI - Financial Accounting
KNC3 - customer master (special G/L transaction figures) FI - Financial Accounting
KNVD - customer master record sales request form FI - Basic Functions
KNVA - customer master Unloading Points Logistics - Customer Master
KNVL - customer master Licenses SD - Billing
KNAS - customer master (VAT registration numbers general section) FI - Financial Accounting
J_1IMOCUST - customer master Excise Additional Data FI - Localization
TVKGGT - Texts for Customer Condition Groups (customer master) Logistics - Customer Master
KNBW - customer master record (withholding tax types) X FI - Basic Functions
ADRC - Addresses (Business Address Services) Basis - Address Management/Business Address
KNMT - customer-Material Info Record Data Table SD - Basic Functions
MARA - General Material Data Logistics - Material Master
MARC - Plant Data for Material Logistics - Material Master
LFA1 - Vendor master (General Section) FI - Financial Accounting
MAKT - Material Descriptions Logistics - Material Master
CDHDR - Change document header Basis - Change Documents
BSID - Accounting: Secondary Index for customers FI - Financial Accounting
MBEW - Material Valuation Logistics - Material Master
VBPA - Sales Document: Partner SD - Basic Functions
LFB1 - Vendor master (Company Code) FI - Financial Accounting
MVKE - Sales Data for Material Logistics - Material Master
BSAD - Accounting: Secondary Index for customers (Cleared Items) FI - Financial Accounting
MAST - Material to BOM Link Logistics - Bills of Material
ADR6 - E-Mail Addresses (Business Address Services) Basis - Address Management/Business Address
ANLU - Asset master Record: User Fields FI - Basic Functions
ADR2 - Telephone Numbers (Business Address Services) Basis - Address Management/Business Address
KNVH - customer Hierarchies SD - Basic Functions
KNB4 - customer Payment History FI - Financial Accounting
T077D - customer account groups FI - Payment Transactions




by Allan Eduardo Favaron
SAP FI Consultant