Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    Sap Tables

    Uploaded by

    sapgouravguptagmail
    This document provides an overview of key SAP tables and structures used in SAP Sales and Distribution. It summarizes tables related to sales documents, deliveries, shipments, billing, customer and material masters, pricing, texts, and more. The tables contain header and item data for various documents and transactions throughout the order to cash process.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Sap Tables

    Uploaded by

    sapgouravguptagmail
    36 views5 pages
    This document provides an overview of key SAP tables and structures used in SAP Sales and Distribution. It summarizes tables related to sales documents, deliveries, shipments, billing, customer and material masters, pricing, texts, and more. The tables contain header and item data for various documents and transactions throughout the order to cash process.

    Original Description:

    Sap master data tables

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an overview of key SAP tables and structures used in SAP Sales and Distribution. It summarizes tables related to sales documents, deliveries, shipments, billing, customer and material masters, pricing, texts, and more. The tables contain header and item data for various documents and transactions throughout the order to cash process.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    36 views5 pages

    Sap Tables

    Uploaded by

    sapgouravguptagmail
    This document provides an overview of key SAP tables and structures used in SAP Sales and Distribution. It summarizes tables related to sales documents, deliveries, shipments, billing, customer and material masters, pricing, texts, and more. The tables contain header and item data for various documents and transactions throughout the order to cash process.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    Purpose

    This wiki page will discuss about SAP tables and structures used in SAP Sales and Distribution. This can be used a ready
    reference for writing FS or for data analysis.
    Sales Document
    Table/Structure Description
    VBAK Sales Document: Header Data
    VBAP Sales Document: Item Data
    VBKD Sales Document: Business Data/Sales district data
    VBPA Partners
    VAKPA Partner index
    VBFA Document Flow
    VBEP Sales Document: Schedule Line / Data related to line items, delivery lines
    VBAKUK Sales Document: Header and Status Data
    VBUP Sales Document: Item Status
    VBUK Header Status and Administrative Data
    VBBE Sales Requirements: Individual Records
    VBBS Summarized requirements
    VBUV Incompletion log
    VBLB Forecast delivery schedules
    VMVA Matchcodes
    VEDA Contract Data
    VBKA Sales activity
    Logical Database
    AK V Sales documents
    Delivery Documemt
    Table/Structure Description
    LIKP Delivery Document: Header data
    LIPS Delivery Document: Item data
    Shipping
    Table/Structure Description
    VTTK Shipment header
    VTTP Shipment item
    VTTS Stage in transport
    VTSP Stage in transport per shipment item
    VTPA Shipment partners
    VEKP Handling Unit - Header Table
    VEPO Packing: Handling Unit Item - Contents
    Billing Document
    Table/Structure Description
    VBRK Billing: Header data
    VBRP Billing: Item data
    Customer Master
    Table/Structure Description
    KNA1 Customer Master: General Data
    KNB1 Customer Master: Company Code Data
    KNB4 Customer Payment History
    KNB5 Customer Master: Dunning data
    KNBK Customer Master: Bank Details
    KNBW Customer Master: Wwithholding tax types
    Table/Structure Description
    KNKA Customer Master: Credit Mgmt.
    KNKK Customer Master: Credit Control Area Data - credit limits
    KNVA Customer Master: Loading/Unloading Points
    KNVD Customer Master: Record sales request form/documents
    KNVH Customer Hierarchies
    KNVI Customer Master: Tax Indicator
    KNVK Customer Master: Contact Partner
    KNVL Customer Master: Licenses
    KNVP Customer Master: Partner Functions
    KNVS Customer Master: Shipping Data
    KNVT Customer Master: Record Texts for Sales
    KNVV Customer Master: Sales Data
    KLPA Customer/Vendor Link
    Material Master
    Table/Structure Description
    MARA General Material Data
    MVKE Sales Data for Material
    MARC Plant Data for Material
    MARD Storage Location Data for Material
    MAKT Short texts
    MARM Conversion factors
    MVKE Sales data - for each sales organization and distribution channel
    MLAN Sales data - for each country
    MAEX Export licenses
    MBEW Valuation data
    Table/Structure Description
    MLGN Warehouse management inventory data
    MLGT Warehouse management inventory type data
    MVER Consumption data
    MAPR Pointers for forecast data
    MCHA Batches
    MCH1 Cross-plant Batches
    MCHB Batch stocks
    KNMTK Header table - for increased performance
    KNMT Data table
    Bill of Material (BOM)
    Table/Structure Description
    MAST Material assignment to BOM
    EQST Equipment assignment to BOM
    KDST Sales order assignment to BOM
    DOST Document assignment to BOM
    STST Standard object assignment to BOM
    TPST Functional location assignment to BOM
    STKO BOM header data
    STZU Time-independent STL data
    STAS BOM item selection
    STPO BOM item data
    STPU BOM sub-item data
    Logical Database for Material Master
    Table/Structure Description
    Table/Structure Description
    CKM Material master
    MSM Material master
    Pricing
    Table/Structure Description
    KOMK Pricing Communications: Header (Structure)
    KOMP Pricing Communication: Item (Structure)
    KONV Conditions: Transaction Data
    KONP Conditions: Item
    KONH Conditions: Header
    KOND Contracts
    VEDA Contract Data
    Output
    Table/Structure Description
    NAST Output: Message Status
    Text
    Table/Structure Description
    STXH Texts: Header
    STXL Texts: Line
    Others
    Table/Structure Description
    JSTO PP status
    SADR Address

    You might also like