SD - Principais tabelas

As vezes nos deparamos com algumas situações de erro nas transações standard do SAP em que não entendemos sua origem, uma das alternativas seria apelar para o debug verificando se o problema vem de algum registro corrompido ou incompleto de tabelas standard (já aconteceu comigo algumas vezes), e debugar programas standard trata-se de uma tarefa um pouco árdua principalmente para aqueles que não tem domínio sobre a linguagem abap.

Para facilitar, disponibilizamos uma lista das principais tabelas/visões dos documentos SD:


Clientes

KNA1 - General Data
KNB1 - Customer Master–CCode Data (payment method, recon. acct)
KNB4 - Customer Payment History
KNB5 - Customer Master – Dunning info
KNBK - Customer Master Bank Data
KNKA - Customer Master Credit Mgmt.
KNKK - Customer Master CCA Data (credit limits)
KNVV - Sales Area Data (terms, order probability)
KNVI - Customer Master Tax Indicator
KNVP - Customer master partner Function
KNVD - Output type
KNVS - Customer Master Ship Data
KLPA - Customer/Vendor Link
V_THIT - Customer Hierarchy Types
KNVH - Customer Hierarchies
KNVK - Customer master Contact partner

Ordens de venda
VBUK - Header Status and Administrative Data
VBAK - Sales Document – General Header Data
VBKA - Sales Activities
VBAKUK = VBAK + VBUK
VBKD - Sales Document - Business Header/Item Data
VBPA - Sales Document - Partners Header Data
VBUP - Item Status
VBPA - Sales Document – Partner Item Data
VBAP - Sales Document – General Item Data
FPLA - sales Document – Items Conditions data
VBFA - Document Flow
VBEP - Sales Document Schedule Line
VBBE - Sales Requirements: Individual Records
VEDA -Sales Contract Data
VBELN - Sales and Distribution Document Number

Entregas (Fornecimentos)
LIPS - Delivery Document item data, includes refer. PO
LIKP - Delivery Document Header data

Faturas
VBRK - Billing Document Header
VBRP - Billing Document Item

Conditions
KONP - Conditions Item
KONV - Condition for Transaction Data

Docs. Transporte
VTTK - Shipment Header
VTTP - Shipment Item
TVRO - Routes
TVTK - Shipment Types
VTRLK - Delivery in shipment: Header

Controle de cópia dos docs. de venda
TVAK - Sales Document Types
TVCPA - Sales Documents: Copying Control
T184 - Sales Documents: Item Category Determination
TVASP - Sales Documents: Blocking Reasons
TVCPF - Billing: Copying Control
TVCPL - Deliveries: Copying Control

Controle de cópia dos itens de docs. de venda
TVAPT - Sales document item categories: Texts
TVCPA - Sales Documents: Copying Control
TVCPF - Billing: Copying Control
TVCPL - Deliveries: Copying Control
TVEPZ - Sales Document: Schedule Line Category Determination
TVLP - Deliveries: Item Categories
TVPT - Sales documents: Item categories

Controle de cópia de Faturas
TVCPF - Billing: Copying Control
TVFSP - Billing: Blocking Reasons

Controle de cópia de Entregas (fornecimentos)
T184L - ales Documents: Item Category Determination
TVCPF - Billing: Copying Control
TVCPL - Deliveries: Copying Control
TVLSP - Delivery Blocks

Tabelas que possuem links de informações entre SD e FI
KNVP - Customer Master Partner Functions
KNVV - Customer Master Sales Data
KNVD - Customer master record sales request form
KNA1 - General Data in Customer Master
KNB1 - Customer Master (Company Code)
KNB5 - Customer master (dunning data)

Tabelas que possuem links de informações entre SD e MM
MARC - Plant data for material
MVKE - Sales data for material
MBEW - Material Valuation
MARD - Storage Location data for Material
T179 - Materials: product hierarchy
MLAN - Tax classification for material
MAKT - material description
MARA General material data
MARM Units of measure of material
MTART – Material Types

Estrutura SAP SD
VBDKA - Document Header View for Inquiry, Quotation, Order
VBDPA - Document Item View for Inquiries, Quotation, Order
KOMK - Communication Header for pricing
KOMP - Communication Item for pricing

Espero que ajude e até a próxima.

0 comentários:

Postar um comentário