Scribd Logo
Upload

Welcome to Scribd!

  • 3K views

    Vbak FPLTC: Links Between Different Tables That We Use

    Uploaded by

    Sandeep Kethepalli
    The document describes the table links between sales orders (VBAK, VBAP), deliveries (LIKP, LIPS), billing documents (VBRK, VBRP), and accounting documents (BKPF, BSEG, BSEGC). Key fields like VBELN (document number) and VGBEL (delivery number) are used to link the tables. Payment details are stored in FPLTC linked to VBAK via RPLNR. When invoices are created, open items are stored in BSIS, BSID, BKPF, BSEG and taxes in BSET. Clear items update BSAD, BSAS, BSID, BKPF, BSEG.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Vbak FPLTC: Links Between Different Tables That We Use

    Uploaded by

    Sandeep Kethepalli
    3K views5 pages
    The document describes the table links between sales orders (VBAK, VBAP), deliveries (LIKP, LIPS), billing documents (VBRK, VBRP), and accounting documents (BKPF, BSEG, BSEGC). Key fields like VBELN (document number) and VGBEL (delivery number) are used to link the tables. Payment details are stored in FPLTC linked to VBAK via RPLNR. When invoices are created, open items are stored in BSIS, BSID, BKPF, BSEG and taxes in BSET. Clear items update BSAD, BSAS, BSID, BKPF, BSEG.

    Original Title

    Tables Links

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the table links between sales orders (VBAK, VBAP), deliveries (LIKP, LIPS), billing documents (VBRK, VBRP), and accounting documents (BKPF, BSEG, BSEGC). Key fields like VBELN (document number) and VGBEL (delivery number) are used to link the tables. Payment details are stored in FPLTC linked to VBAK via RPLNR. When invoices are created, open items are stored in BSIS, BSID, BKPF, BSEG and taxes in BSET. Clear items update BSAD, BSAS, BSID, BKPF, BSEG.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    3K views5 pages

    Vbak FPLTC: Links Between Different Tables That We Use

    Uploaded by

    Sandeep Kethepalli
    The document describes the table links between sales orders (VBAK, VBAP), deliveries (LIKP, LIPS), billing documents (VBRK, VBRP), and accounting documents (BKPF, BSEG, BSEGC). Key fields like VBELN (document number) and VGBEL (delivery number) are used to link the tables. Payment details are stored in FPLTC linked to VBAK via RPLNR. When invoices are created, open items are stored in BSIS, BSID, BKPF, BSEG and taxes in BSET. Clear items update BSAD, BSAS, BSID, BKPF, BSEG.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    Links between different tables that we use

    Sales order (VA01):

    Whenever a sales order is created using transaction VA01. The tables which get
    updated with the entered data are VBAK, VBAP.

    VBAK-VBELN, VBAP-VBELN: Sales order number.

    Payment card details are stored in table FPLTC; RPLNR is the field name in VBAK
    that connects VBAK to FPLTC table through the relation.

    VBAK-RPLNR = FPLTC-FPLNR.

    FPLTC table contains the data like Tokenized card number, card type and so on.

    VBAK FPLTC

    VBELN VBAK-RPLNR = FPLTC-FPLNR

    RPLNR FPLNR

    Here Sales Order is created in VBAK(Header Data) and VBAP(Item Data) tables:

    VBAK VBAP
    Sales Order Number

    VBELN VBELN
    Delivery data:

    After the sales order is created we deliver the goods in the sales order whenever we
    deliver the goods; LIKP, LIPS are the tables that get updated with the entered data.

    LIKP-VBELN, LIPS-VBELN: Delivery Number.

    Link between sales order tables and delivery tables, VGBEL is the field name in LIPS
    that links VBAK with LIPS table. VGBEL contains the sales order number for which
    we had made delivery.

    LIPS-VGBEL = VBAK-VBELN (Sales order number).

    LIPS_VBELN = LIKP_VBELN (Delivery number).

    LIPS VBAK

    LIPS-VGBEL = VBAK-VBELN
    VBELN VBELN

    VGBEL RPLNR

    LIPS LIKP
    Delivery Number

    VBELN VBELN

    VGBEL

    Delivery number stored in these two tables.


    Billing Document details (VF01):

    After the delivery is done we create a billing document for the delivered document
    whenever we create a Billing document VBRK and VBRP are the tables that get
    updated.

    VBRK-VBELN, VBRP-VBELN: Billing Document Number.

    From these tables we have a link to sales order tables and delivery tables; VGBEL
    field in the VBRP table links billing data to delivery data. This VGBEL field contains
    the delivery number for which billing document was created.

    VBRP-VGBEL = LIKP-VBELN (Delivery Number).

    AUBEL is the field in the VBRP table that links billing data to sales order data;
    AUBEL field contains the sales order number.

    VBRP-AUBEL = VBAK-VBELN (Seles order number).

    LIKP

    (Delivery Number)
    VBELN
    LIKP-VBELN = VBRP-VGBEL
    VBRP Billing Document
    Number
    VBELN

    VGBEL

    AUBEL
    VBAK

    VBAK-VBELN = VBRP-AUBEL
    VBELN
    (Sales Order)

    Note : VBRP-VBELN = VBRK-VBELN

    Accounting Document details:


    Whenever a billing document is created SAP itself generates an accounting
    document. These details are stored in BKPF, BSEG, BSEGC tables. We are having a
    link between billing document number and accounting document number.

    BKPF-BELNR, BSEG-BELNR and BSEGC-BELNR: Accounting document number.

    AWKEY is the field in BKPF table that contains the billing document number which
    links to the accounting document number.

    BKPF-AWKEY = VBRK-VBELN.

    Settlement run number is also stored in BSEGC; with the accounting document
    number (BELNR) in BSEGC we can get the settlement run number CCBTC.

    BKPF-CCBTC: Settlement run number.

    VBAK BKPF Accounting


    document
    number

    VBELN BELNR

    AWKEY

    BSEGC
    Note : Here BKPF-belnr = BSEGC-belnr.

    BSEGC-ccbtc = Settlement run number.


    BELNR

    CCBTC

    Table Links for Open Items and Clear Items in FI:


    Whenever we run the transaction using F-22 to create customer invoices open
    amount documents are created and these documents are stored in the following
    tables,

    BSIS, BSID, BKPF, BSEG.

    BKPF-BELNR, BSEG-BELNR, BSID-BELNR, BSIS-BELNR: Accounting Document


    Number.

    If at all we maintain taxes for the invoices BSET table gets updated with the values
    BSET (Tax)
    BSET-BELNR: Accounting Document Number.

    Whenever we clear the open items using the transaction F-26 the newly created
    accounting document number are stored in the following tables.

    BSAD, BSAS, BSID, BKPF, BSEG.

    BKPF-BELNR, BSEG-BELNR, BSID-BELNR, BSAS-BELNR, BSAD-BELNR: Accounting


    Document Number.

    You might also like