Show TOC

Sales Contract Query (VDM-Based) Locate this document in the navigation structure

Query Query: /CRMBW/SLC_V01_001

 

This query provides you with an overview of sales contracts. The query contains characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Sales Contracts (Based on SAP HANA VDM).

For information about the report areas in SAP CRM, see Report Areas for Interactive Reports Based on SAP HANA VDM

This query is based on the InfoProvider /CRMBW/SLC_V01.

To use this query, you must activate the business functions SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB) and Interactive Reporting Based on SAP HANA VDM (CRM_ANA_VDM) .

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Report Area

/CRMBW/REPORTA

Sales Contract (SALESCONTRACT_VDM)

Characteristic Characteristic

Selection GUID

/CRMBW/SELGUID

Technical filter that is generated at runtime

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Sold-To Party

/CRMBW/SLO_STP

SAP HANA VDM Field: SoldToParty

Characteristic Characteristic

Cancellation Party

/CRMBW/CANCPAR

SAP HANA VDM Field: CancelledByParty

Characteristic Characteristic

Reason for Cancellation

/CRMBW/CANC_RE

SAP HANA VDM Field: CancellationReason

Characteristic Characteristic

Cancellation Party (Item)

/CRMBW/CANCPAI

SAP HANA VDM Field: ItemCancelledByParty

Characteristic Characteristic

Cancellation Reason (Item)

/CRMBW/CANC_RI

SAP HANA VDM Field: CancellationReason, ItemCancellationReason

Characteristic Characteristic

Channel Partner

/CRMBW/CHA_PAR

SAP HANA VDM Field: ChannelPartner

Characteristic Characteristic

Channel Partner Program

/CRMBW/CP_PROG

SAP HANA VDM Field: ChannelPartnerProgram

Characteristic Characteristic

Channel Partner Status

/CRMBW/CP_STAT

SAP HANA VDM Field: ChannelPartnerStatus

Characteristic Characteristic

Responsible Person at Partner

/CRMBW/RES_ATP

SAP HANA VDM Field: ResponsibleEmployeeAtPartner

Characteristic Characteristic

Channel Partner Type

/CRMBW/CP_TYPE

SAP HANA VDM Field: ChannelPartnerType

Characteristic Characteristic

Distribution Channel

/CRMBW/DIS_CHA

SAP HANA VDM Field: DistributionChannel

Characteristic Characteristic

Responsible Sales Org. Unit

/CRMBW/SLS_RES

SAP HANA VDM Field: ResponsibleSalesOrganization

Characteristic Characteristic

Sales Organization

/CRMBW/SLS_ORG

SAP HANA VDM Field: SalesOrganization

Characteristic Characteristic

Contact

/CRMBW/CONTACT

SAP HANA VDM Field: ContactPerson

Characteristic Characteristic

Territory

/CRMBW/TERRITO

SAP HANA VDM Field: Territory

Characteristic Characteristic

Territory ID

/CRMBW/TERR_ID

SAP HANA VDM Field: Territory

Characteristic Characteristic

Country

/CRMBW/SOL_COU

SAP HANA VDM Field: SoldToPartyCountry

Characteristic Characteristic

Region

/CRMBW/SLQ_REG

SAP HANA VDM Field: SoldToPartyRegion

Characteristic Characteristic

Week (Valid To)

/CRMBW/CALYWEE

SAP HANA VDM Field: ValidityEndDateYearWeek

Characteristic Characteristic

Month (Valid To)

/CRMBW/CALYMON

SAP HANA VDM Field: ValidityEndDateYearMonth

Characteristic Characteristic

Quarter (Valid To)

/CRMBW/CALYQTR

SAP HANA VDM Field: ValidityEndDateYearQuarter

Characteristic Characteristic

Year (Valid To)

/CRMBW/CALYEAR

SAP HANA VDM Field: ValidityEndDateYear

Characteristic Characteristic

Valid From

/CRMBW/VALID_F

SAP HANA VDM Field: ValidityStartDate

Characteristic Characteristic

Valid To

/CRMBW/VALID_T

SAP HANA VDM Field: ValidityEndDate

Characteristic Characteristic

Status

/CRMBW/SLC_STC

SAP HANA VDM Field: GeneralStatus

Characteristic Characteristic

Credit Status

/CRMBW/CREDSTH

SAP HANA VDM Field: CreditWorthinessIsGranted

Characteristic Characteristic

Status: Credit OK

/CRMBW/STAT_CR

SAP HANA VDM Field: ItemCreditWorthinessIsGranted

Characteristic Characteristic

Division

/CRMBW/DIVISIO

SAP HANA VDM Field: Division

Characteristic Characteristic

Employee Responsible

/CRMBW/PERSON

SAP HANA VDM Field: ResponsibleEmployee

Characteristic Characteristic

External Reference Number

/CRMBW/PO_NUMB

SAP HANA VDM Field: SoldToPartyExtRefID

Characteristic Characteristic

Product

/CRMBW/PROD_GU

SAP HANA VDM Field: ProductUUID

Characteristic Characteristic

Product Category

/CRMBW/PRO_CAT

SAP HANA VDM Field: ProductCategory

Characteristic Characteristic

Product ID

/CRMBW/PRODUCT

SAP HANA VDM Field: Product

Characteristic Characteristic

Sales Contract

/CRMBW/SLC_GUI

SAP HANA VDM Field: SalesContractUUID

Characteristic Characteristic

Sales Contract ID

/CRMBW/SLC_ID

SAP HANA VDM Field: SalesContract

Characteristic Characteristic

Transaction Type

/CRMBW/PROCESS

SAP HANA VDM Field: CRMBusinessTransactionType

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Open Expected Net Value

/CRMBW/OPEXNV

SAP HANA VDM Field: OpenExpectedNetAmount

Key Figure Key Figure

Open Released Value per Contract

/CRMBW/OPRV

SAP HANA VDM Field: OpenReleasedAmount

Key Figure Key Figure

Open Released Quantity per Contract

/CRMBW/OPRQ

SAP HANA VDM Field: ReleasedQuantityUnit, OpenReleasedQuantity

Key Figure Key Figure

Fulfillment Rate (Value)

/CRMBW/FURATTV

CRMBW_FURATTV NOERR( ( '[/CRMBW/REL_VAC] Released Value' %A '[/CRMBW/TARGETC] Target Value' ) )

Key Figure Key Figure

Fulfillment Rate (Quantity)

/CRMBW/FURATTQ

CRMBW_FURATTQ NOERR( ( '[/CRMBW/REL_QU] Released Quantity' %A '[/CRMBW/QUANTIT] Target Quantity' ) )

Key Figure Key Figure

Average Expected Total Value per Contract

/CRMBW/AVGEXTV

NOERR( ( '[/CRMBW/REL_NETVAMC] Expected Total Value' / '[/CRMBW/NUM_OF] No. of Contracts' ) )

Key Figure Key Figure

Average Target Quantity per Contract

/CRMBW/AVGTQ

CRMBW_AVGTQ NOERR( ( '[/CRMBW/QUANTIT] Target Quantity' / '[/CRMBW/NUM_OF] No. of Contracts' ) )

Key Figure Key Figure

Average Target Value per Contract

/CRMBW/AVGTV

NOERR( ( '[/CRMBW/TARGETC] Target Value' / '[/CRMBW/NUM_OF] No. of Contracts' ) )

Key Figure Key Figure

Expected Total Value of Cancelled Items (Document Currency)

/CRMBW/NET_VMC

SAP HANA VDM Field: CancelledItemExpectedAmount

Key Figure Key Figure

Expected Total Value (per Contract Item) (Document Currency)

/CRMBW/NET_VAL

SAP HANA VDM Field: ExpectedNetAmount

Key Figure Key Figure

Released Value (per Contract Item) (Document Currency)

/CRMBW/REL_VA

SAP HANA VDM Field: ReleasedAmount

Key Figure Key Figure

Target Value (per Contract Item) (Document Currency)

/CRMBW/TARGET

SAP HANA VDM Field: TargetAmount

Key Figure Key Figure

No. of Completed Contracts

/CRMBW/NUOF_CC

SAP HANA VDM Field: NmbrOfCompletedSalesContracts

Key Figure Key Figure

No. of Cancelled Contracts

/CRMBW/NUM_CH

SAP HANA VDM Field: NmbrOfCancelledSalesContracts

Key Figure Key Figure

No. of Cancelled Contract Items

/CRMBW/CCONITM

SAP HANA VDM Field: NmbrOfCancldSlsContractItems

Key Figure Key Figure

No. of Contract Items

/CRMBW/N_ITEM

SAP HANA VDM Field: NumberOfSalesContractItems

Key Figure Key Figure

No. of Release Orders

/CRMBW/NUMREOR

SAP HANA VDM Field: NumberOfReleasedOrders

Key Figure Key Figure

No. of Contracts

/CRMBW/NUM_OF

SAP HANA VDM Field: NumberOfSalesContracts

Key Figure Key Figure

Expected Total Value of Cancelled Items

/CRMBW/NETVMCC

SAP HANA VDM Field: CancldItemExpdAmtInDisplayCrcy

Key Figure Key Figure

Expected Total Value

/CRMBW/NETVAMC

SAP HANA VDM Field: ExpectedNetAmountInDisplayCrcy

Key Figure Key Figure

Target Quantity

/CRMBW/QUANTIT

SAP HANA VDM Field: TargetQuantity, TargetQuantityUnit

Key Figure Key Figure

Released Quantity

/CRMBW/REL_QU

SAP HANA VDM Field: ReleasedQuantity, ReleasedQuantityUnit

Key Figure Key Figure

Released Value

/CRMBW/REL_VAC

SAP HANA VDM Field: ReleasedAmountInDisplayCrcy

Key Figure Key Figure

Target Value

/CRMBW/TARGETC

SAP HANA VDM Field: TargetAmountInDisplayCurrency