Query 0BBP_INV_Q002 - Invoices per Vendor

(1)

Query 0BBP_INV_Q002 - Invoices per Vendor

Query Properties

System: BIC

Query: 0BBP_INV_Q002, Invoices per Vendor

Version: 7.x

InfoProvider: 0BBP_INV

Author: C5020319

Key Date: -

Last changed by: USER10

Last change: 27.07.2011 07:07:23 Timestamp of documentation: 20.07.2012 12:46:13

Query-COMPUID: 959K8XDE6WXENSRJDGGXR8YH6

Query-GENUNIID: 9SPJVKXXA42S8ORPPP9P0T18Q Display Options: Adjust Formatting after Refreshing: X

Hide Repeated Key Values: X

Display Scaling Factors for Key Figures: -

Document Links: Display Links for: InfoProv = false, Master = false, Meta = false Result Position: Bottom/right

Zeros Suppression: Suppress Rows and Columns as in 2.0 Display of +/- Signs: Plus/minus sign before: -123.45 Zero Display: (default) Zero with Unit Sequence of Input Variables: 0S_GNVND, 0I_DAYIN

Variables

0A_BUYID Buyer (Authorization)

General Information Details

InfoObject: 0BBP_BUYID Variable entry is: Optional Variable Entry

Last change/changed by: 14.07.2012 12:28:20, USER09 Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: Authorization Hierarchy, Version, Date to: Variable represents: Single value (parameters) Copy Personal. Data from:

Ready for Input: Offset-Start, Length: 0, 0

0A_COARE Controlling Area (Authorization)

InfoObject: 0CO_AREA Variable entry is: Optional Variable Entry

Last change/changed by: 06.06.2002 11:14:53, R000759 Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: Authorization Hierarchy, Version, Date to: Variable represents: Single value (parameters) Copy Personal. Data from:

0A_COSTC Cost Centers (Authorization)

InfoObject: 0COSTCENTER Variable entry is: Optional Variable Entry

Last change/changed by: 06.06.2002 11:14:53, R000759 Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: Authorization Hierarchy, Version, Date to: Variable represents: Selection option Copy Personal. Data from:

0A_PGRP Purchasing Group (Authorization)

InfoObject: 0BBP_PURGRP Variable entry is: Optional Variable Entry

Last change/changed by: 19.10.2004 05:18:40, SAP Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: Authorization Hierarchy, Version, Date to: Variable represents: Selection option Copy Personal. Data from:

(2)

Variables

0A_PORG Purchasing Organization (Authorization)

InfoObject: 0BBP_PURORG Variable entry is: Optional Variable Entry

Last change/changed by: 19.10.2004 05:18:40, SAP Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: Authorization Hierarchy, Version, Date to: Variable represents: Selection option Copy Personal. Data from:

0A_PTYPE Transaction Type (Authorization)

InfoObject: 0PROCTYPE Variable entry is: Optional Variable Entry

Last change/changed by: 06.08.2002 10:46:51, R000759 Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: Authorization Hierarchy, Version, Date to: Variable represents: Selection option Copy Personal. Data from:

0I_DAYIN Day Interval

InfoObject: 0CALDAY Variable entry is: Optional Variable Entry

Last change/changed by: 23.03.2005 11:03:09, CSG Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: User entry / default value Hierarchy, Version, Date to:

Variable represents: Interval Copy Personal. Data from:

Ready for Input: X Offset-Start, Length: 0, 0

0S_GNVND Vendor

InfoObject: 0GN_VENDOR Variable entry is: Optional Variable Entry

Last change/changed by: 27.01.2005 12:09:26, TENHOLTE Replace variable with: Type of Variable: Characteristic value Editable on navigation: Processing type: User entry / default value Hierarchy, Version, Date to: Variable represents: Selection option Copy Personal. Data from:

Ready for Input: X Offset-Start, Length: 0, 0

Calculated Key Figures

0BBP_INV_CK001 Delivery Costs

[0BBP_FREIGH] 'Freight Costs in Invoice' + [0BBP_TAXES] 'Tax Amount of Invoice in Purchase Order Currency'

Last change: 10.02.2010 06:07:57, DIETZA

Display: Hide: Always Show

Highlighting: Normal Display

Num. of Dec. Places: (Nothing defined) Scaling Factor: (Nothing defined)

Sign change: Keep +/- Sign

Aggregation: Except. Aggregation: SUM

Ref. Characteristic: -1

Calculations: Calculate Result As: (Nothing Defined) Calc. Single Values As: (Nothing Defined)

Cumulated: -

Also apply to results: X Calculation direction: -

Filter

[0GN_CAT_PUR] Category [#] Not assigned

Value Display: Display as: Text

(3)

Filter

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0GN_VENDOR] Vendor

[0S_GNVND] Vendor

Result Rows: Display if more than one value

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0PROCTYPE] Transaction Type

[0A_PTYPE] Transaction Type (Authorization)

Result Rows: Use Characteristic Setting

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0COSTCENTER] Cost Center

[0A_COSTC] Cost Centers (Authorization)

Value Display: Display as: Key and Text

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0CO_AREA] Controlling area

[0A_COARE] Controlling Area (Authorization)

Value Display: Display as: Key and Text

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0CALDAY] Calendar Day

[0I_DAYIN] Day Interval

Value Display: Display as: Key

Result Rows: Always Suppress

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_PURORG] Purchasing Organization

[0A_PORG] Purchasing Organization (Authorization)

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_PURGRP] Purchasing Group

[0A_PGRP] Purchasing Group (Authorization)

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_BUYID] Buyer ID

[0A_BUYID] Buyer (Authorization)

Value Display: Display as: Medium-Length Text

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_TPFLAG] Flag Third-Party Order

[#] Not assigned

(4)

Filter

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting

Free Characteristics

[0GN_CAT_PUR] Category [#] Not assigned

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_UCPROD] Product Description

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_PROINV] Processing Status Invoice

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_RELINV] Approval Status of Invoice

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_TRAINV] Transfer Status of Invoice

Elements in Rows

[0GN_VENDOR] Vendor

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_INV_ID] Invoice Number

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0BBP_DESCR] Name

Advanced: Access Type for Results: Use Characteristic Setting Filter Value Selection: Use Characteristic Setting [0CALDAY] Calendar Day

Elements in Columns

[0BBP_INV_QT04] Balanced Gross Invoice Amounts and Quantities Net Invoice Amount

(5)

[0BBP_SUBTYP] Document Characteristics [IV] IV

[#] Not assigned [1KYFNM] Key Figure

[0BBP_ASIVOC] Net Invoice Value in Purchase Order Currency

Display: Hide: Always Hide

Cumulated: -

Also apply to results: -

Calculation direction: Use Default Direction Net Credit Memo Amount

[0BBP_SUBTYP] Document Characteristics [CM] CM

[1KYFNM] Key Figure

[0BBP_ASIVOC] Net Invoice Value in Purchase Order Currency

Cumulated: -

Calculation direction: Use Default Direction

[0BBP_INV_CK001] Delivery Costs

[1KYFNM] Key Figure

[0BBP_INV_CK001] Delivery Costs

Num. of Dec. Places: 0,00

Scaling Factor: (Nothing defined)

Cumulated: -

Calculation direction: Use Default Direction Balanced Gross Invoice Amount

'Net Invoice Amount' + 'Delivery Costs' - 'Net Credit Memo Amount' + 'Delivery Costs'

(6)

Calculation direction: Use Default Direction Invoiced Quantity

[0BBP_SUBTYP] Document Characteristics [IV] IV

[#] Not assigned [1KYFNM] Key Figure

[0BBP_ASIQOU] Invoice Quantity in Purchase Order Unit

Cumulated: -

Calculation direction: Use Default Direction Credit Memo Quantity

[0BBP_SUBTYP] Document Characteristics [CM] CM

[1KYFNM] Key Figure

[0BBP_ASIQOU] Invoice Quantity in Purchase Order Unit

Cumulated: -

Calculation direction: Use Default Direction Balanced Invoice Amount

'Invoiced Quantity' - 'Credit Memo Quantity'

Cumulated: -