Show TOC

BillingLocate this document in the navigation structure

Use

The following reuse views are included in this virtual data model:

  • Reuse view for billing document headers (BillingDocumentHeader)

  • Reuse view for invoice headers for customers (CustomerInvoiceHeader)

  • Reuse view for invoice cancellation headers for customers (CustomerInvoiceCancellationHeader)

  • Reuse view for credit memo headers (CreditMemoHeader)

  • Reuse view for debit memo headers (DebitMemoHeader)

  • Reuse view for billing document items (BillingDocumentItem)

  • Reuse view for invoice items for customers (CustomerInvoiceItem)

  • Reuse view for invoice cancellation items for customers (CustomerInvoiceCancellationItem)

  • Reuse view for credit memo items (CreditMemoItem)

  • Reuse view for debit memo items (DebitMemoItem)

  • Reuse view for billing document conditions (BillingDocumentCondition)

  • Reuse view for invoice conditions for customers (CustomerInvoiceCondition)

  • Reuse view for credit memo conditions (CreditMemoCondition)

  • Reuse view for debit memo conditions (DebitMemoCondition)

  • Reuse view for conditions of customer invoice cancellation (CustomerInvoiceCanclnCndn)

This virtual data model provides the prerequisites for answering the following business questions:

  • How many order items have been billed? What is the value? (view BillingDocumentItemQuery)

  • How many invoices are not posted to financial accounting? (view BillingDocumentQuery)

You can find examples of reports based on this virtual data model in the download area of SAP HANA Live for SAP Business Suite in SAP Service Marketplace.

Structure

To support the analysis possibilities listed above, the structure of this view hierarchy contains the following groupings of views:

  • Billing Document Header

  • Billing Document Item

  • Billing Condition Data

Billing Document Header

This group of views consists of the following main reuse views:

  • Reuse view for billing document headers (BillingDocumentHeader)

  • Reuse view for invoice headers for customers (CustomerInvoiceHeader)

  • Reuse view for invoice cancellation headers for customers (CustomerInvoiceCancellationHeader)

  • Reuse view for credit memo headers (CreditMemoHeader)

  • Reuse view for debit memo headers (DebitMemoHeader)

The views Reuse view for invoice headers for customers (CustomerInvoiceHeader), Reuse view for invoice cancellation headers for customers (CustomerInvoiceCancellationHeader), Reuse view for credit memo headers (CreditMemoHeader) and Reuse view for debit memo headers (DebitMemoheader) are based on the view Reuse view for billing document headers (BillingDocumentHeader). The views are grouped together since they contain header information you need to analyze your billing operation.

Business Objects

These views are built on the following business object:

  • Billing document

Measures and Attributes

Some important measures and attributes are the following:

  • Reuse view for billing document headers (BillingDocumentHeader)

    • The view provides general data such as company code, billing document type, billing document category, sold-to party, payer party, sales organization, creation date and user ID of creator.

    • The view provides information about values such as total net amount and tax amount.

  • Reuse view for invoice headers for customers (CustomerInvoiceHeader)

    • The view provides general data such as company code, customer invoice type, customer invoice category, sales organization, sold-to party, payer party, creation date and user ID of creator.

    • The view provides information about values such as total net amount and tax amount.

  • Reuse view for invoice cancellation headers for customers (CustomerInvoiceCancellationHeader)

    • The view provides general data such as company code, customer invoice cancellation type, customer invoice cancellation category, sales organization, sold-to party, payer party, user ID of creator and creation date.

    • The view provides information about values such as total net amount and tax amount.

  • Reuse view for credit memo headers (CreditMemoHeader)

    • The view provides general data such as company code, credit memo type, credit memo category, sales organization, sold-to party, payer party, user ID of creator and creation date.

    • The view provides information about values such as total net amount and tax amount.

  • Reuse view for debit memo headers (DebitMemoHeader)

    • The view provides general data such as company code, debit memo type, debit memo category, sales organization, sold-to party, payer party, user ID of creator and creation date.

    • The view provides information about values such as total net amount and tax amount.

Filters

The views use the following filters:

  • Reuse view for invoice headers for customers (CustomerInvoiceHeader)

    • Reuse view for invoice headers for customers (CustomerInvoiceHeader) filters billing document header (SDDocumentCategory M) from the Reuse view for billing document headers (BillingDocumentHeader).

  • Reuse view for invoice cancellation headers for customers (CustomerInvoiceHeader)

    • Reuse view for invoice cancellation headers for customers (CustomerInvoiceCancellationHeader) filters billing document header (SDDocumentCategory N) from the Reuse view for billing document headers (BillingDocumentHeader).

  • Reuse view for credit memo headers (CreditMemoHeader)

    • Reuse view for credit memo headers (CreditMemoHeader) filters billing document header (SDDocumentCategory O) from the Reuse view for billing document headers (BillingDocumentHeader).

  • Reuse view for debit memo headers (DebitMemoHeader)

    • Reuse view for debit memo headers (DebitMemoHeader) filters billing document header (SDDocumentCategory P) from the Reuse view for billing document headers (BillingDocumentHeader).

Used Tables and Views

The views mainly select data from the following tables, for example:

  • VBRK (billing document header)

  • VBUK (billing document header status)

Billing Document Item

This group of views consists of the following main reuse views:

  • Reuse view for billing document items (BillingDocumentItem)

  • Reuse view for invoice items for customers (CustomerInvoiceItem)

  • Reuse view for invoice cancellation items for customers (CustomerInvoiceCancellationItem)

  • Reuse view for credit memo items (CreditMemoItem)

  • Reuse view for debit memo items (DebitMemoItem)

The views Reuse view for invoice items for customers (CustomerInvoiceItem), Reuse view for invoice cancellation items for customers (CustomerInvoiceCancellationItem), Reuse view for credit memo items (CreditMemoItem) and Reuse view for debit memo items (DebitMemoItem) are based on the view Reuse view for billing document items (BillingDocumentItem). The views are grouped together since they contain item information you need to analyze your billing operation.

Business Objects

These views are built on the following business object:

  • Billing document

Measures and Attributes

Some important measures and attributes are the following:

  • Reuse view for billing document items (BillingDocumentItem)

    • The view provides general data such as company code, billing document type, billing document category, SD document category, sales organization, material, material group and creation date.

    • The view provides information about values such as gross value of the billing item in document currency, net value of the billing item in document currency, billing quantity, gross weight on item level and tax amount.

  • Reuse view for invoice items for customers (CustomerInvoiceItem)

    • The view provides general data such as company code, customer invoice type, customer invoice category, sales organization, material, material group and creation date.

    • The view provides information about values such as gross value of the billing item in document currency, net value of the billing item in document currency, billing quantity, gross weight on item level and tax amount.

  • Reuse view for invoice cancellation items for customers (CustomerInvoiceCancellationItem)

    • The view provides general data such as company code, customer invoice cancellation type, customer invoice cancellation category, sales organization, material, material group and creation date.

    • The view provides information about values such as gross value of the billing item in document currency, net value of the billing item in document currency, billing quantity, gross weight on item level and tax amount.

  • Reuse view for credit memo items (CreditMemoItem)

    • The view provides general data such as company code, credit memo type, credit memo category, sales organization, material, material group and creation date.

    • The view provides information about values such as gross value of the billing item in document currency, net value of the billing item in document currency, billing quantity, gross weight on item level and tax amount.

  • Reuse view for debit memo items (DebitMemoItem)

    • The view provides general data such as company code, debit memo type, debit memo category, sales organization, material, material group and creation date.

    • The view provides information about values such as gross value of the billing item in document currency, net value of the billing item in document currency, billing quantity, gross weight on item level and tax amount.

Filters

The views use the following filters:

  • Reuse view for invoice items for customers (CustomerInvoiceItem)

    • Reuse view for invoice items for customers (CustomerInvoiceItem) filters SD document category (SDDocumentCategory M) from the Reuse view for billing document items (BillingDocumentItem).

  • Reuse view for invoice cancellation items for customers (CustomerInvoiceItem)

    • Reuse view for invoice cancellation items for customers (CustomerInvoiceCancellationItem) filters SD document category (SDDocumentCategory N) from the Reuse view for billing document items (BillingDocumentItem).

  • Reuse view for credit memo items (CreditMemoItem)

    • Reuse view for credit memo items(CreditMemoItem) filters SD document category (SDDocumentCategory O) from the Reuse view for billing document items (BillingDocumentItem).

  • Reuse view for debit memo items (DebitMemoItem)

    • Reuse view for debit memo items (DebitMemoItem) filters SD document category (SDDocumentCategory P) from the Reuse view for billing document items (BillingDocumentItem).

Used Tables and Views

The views mainly select data from the following tables, for example:

  • VBRK (billing document header)

  • VBRP (billing document item)

Billing Condition Data

This group of views consists of the following main reuse views:

  • Reuse view for billing document conditions (BillingDocumentCondition)

  • Reuse view for invoice conditions for customers (CustomerInvoiceCondition)

  • Reuse view for credit memo conditions (CreditMemoCondition)

  • Reuse view for debit memo conditions (DebitMemoCondition)

  • Reuse view for conditions of customer invoice cancellation (CustomerInvoiceCanclnCndn)

The view Reuse view for invoice conditions for customers (CustomerInvoiceCondition), Reuse view for credit memo conditions (CreditMemoCondition, Reuse view for debit memo conditions (DebitMemoCondition, and Reuse view for conditions of customer invoice cancellation (CustomerInvoiceCanclnCndn is based on the view Reuse view for billing document conditions (BillingDocumentCondition). The views are grouped together since they contain billing document condition information you need to analyze your billing operation.

Business Objects

These views are built on the following business object:

  • Billing document

Measures and Attributes

Some important measures and attributes are the following:

  • Reuse view for billing document conditions (BillingDocumentCondition)

    • The view provides general data such as company code, billing document type, billing document category, condition type, condition category, material, material group and creation date.

    • The view provides information about values such as condition amount, and condition amount in alternative currency .

  • Reuse view for invoice conditions for customers (CustomerInvoiceCondition)

    • The view provides general data such as company code, billing document type, billing document category, condition type, condition category, material, material group and creation date.

    • The view provides information about values such as condition amount, and condition amount in alternative currency.

  • Reuse view for credit memo conditions (CreditMemoCondition

    • The view provides general data such as company code, billing document type, billing document category, condition type, condition category, material, material group and creation date.

    • The view provides information about values such as condition amount, and condition amount in alternative currency.

  • Reuse view for debit memo conditions (DebitMemoCondition

    • The view provides general data such as company code, billing document type, billing document category, condition type, condition category, material, material group and creation date.

    • The view provides information about values such as condition amount, and condition amount in alternative currency.

  • Reuse view for conditions of customer invoice cancellation (CustomerInvoiceCanclnCndn

    • The view provides general data such as company code, billing document type, billing document category, condition type, condition category, material, material group and creation date.

    • The view provides information about values such as condition amount, and condition amount in alternative currency.

Filters

The views use the following filters:

  • Reuse view for invoice conditions for customers (CustomerInvoiceCondition)

    • Reuse view for invoice conditions for customers (CustomerInvoiceCondition) filters SD document category (SDDocumentCategory M) from the Reuse view for billing document conditions (BillingDocumentCondition).

  • Reuse view for credit memo conditions (CreditMemoCondition

    • Reuse view for credit memo conditions (CreditMemoCondition) filters SD document category (SDDocumentCategory O) from the Reuse view for billing document conditions (BillingDocumentCondition).

  • Reuse view for debit memo conditions (DebitMemoCondition

    • Reuse view for debit memo conditions (DebitMemoCondition) filters SD document category (SDDocumentCategory P) from the Reuse view for billing document conditions (BillingDocumentCondition).

  • Reuse view for conditions of customer invoice cancellation (CustomerInvoiceCanclnCndn

    • Reuse view for conditions of customer invoice cancellation (CustomerInvoiceCanclnCndn) filters SD document category (SDDocumentCategory N) from the Reuse view for billing document conditions (BillingDocumentCondition).

Used Tables and Views

The views mainly select data from the following tables, for example:

  • VBRK (billing document header)

  • VBRP (billing document item)

  • KONV (conditions)