A_SalesQuotation
Sales Quotation Header
A_SalesQuotation is a Composite CDS View that provides data about "Sales Quotation Header" in SAP S/4HANA. It reads from 1 data source (I_SalesQuotationEnhanced) and exposes 62 fields with key field SalesQuotation. It has 8 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesQuotationEnhanced | SalesQuotation | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | A_SalesQuotationItem | _Item | _Item.SalesQuotation = $projection.SalesQuotation |
| [0..*] | A_SalesQuotationPartner | _Partner | _Partner.SalesQuotation = $projection.SalesQuotation |
| [0..*] | A_SalesQuotationPrcgElmnt | _PricingElement | _PricingElement.SalesQuotation = $projection.SalesQuotation |
| [0..*] | A_SalesQuotationText | _Text | _Text.SalesQuotation = $projection.SalesQuotation |
| [0..*] | A_SalesQuotationRelatedObject | _RelatedObject | _RelatedObject.SalesQuotation = $projection.SalesQuotation |
| [0..*] | A_SlsQtanPrecdgProcFlow | _PrecedingProcFlowDoc | _PrecedingProcFlowDoc.SalesQuotation = $projection.SalesQuotation |
| [0..*] | A_SlsQtanSubsqntProcFlow | _SubsequentProcFlowDoc | _SubsequentProcFlowDoc.SalesQuotation = $projection.SalesQuotation |
| [0..1] | E_SalesDocumentBasic | _Extension | $projection.SalesQuotation = _Extension.SalesDocument |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Sales Quotation Header | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.lifecycle.contract.type | #PUBLIC_REMOTE_API | view | |
| AbapCatalog.sqlViewName | ASALESQUOTATION | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | Salesquotation | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (62)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesQuotation | SalesQuotation | ||
| SalesQuotationType | SalesQuotationType | |||
| SalesOrganization | SalesOrganization | |||
| DistributionChannel | DistributionChannel | |||
| OrganizationDivision | OrganizationDivision | |||
| SalesGroup | SalesGroup | |||
| SalesOffice | SalesOffice | |||
| SalesDistrict | SalesDistrict | |||
| SoldToParty | SoldToParty | |||
| CreationDate | CreationDate | |||
| CreatedByUser | CreatedByUser | |||
| LastChangeDate | LastChangeDate | |||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | |||
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | |||
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | |||
| SalesQuotationDate | SalesQuotationDate | |||
| TotalNetAmount | TotalNetAmount | |||
| TransactionCurrency | TransactionCurrency | |||
| SDDocumentReason | SDDocumentReason | |||
| PricingDate | PricingDate | |||
| RequestedDeliveryDate | RequestedDeliveryDate | |||
| ShippingCondition | ShippingCondition | |||
| CompleteDeliveryIsDefined | CompleteDeliveryIsDefined | |||
| ShippingType | ShippingType | |||
| HeaderBillingBlockReason | HeaderBillingBlockReason | |||
| DeliveryBlockReason | DeliveryBlockReason | |||
| BindingPeriodValidityStartDate | BindingPeriodValidityStartDate | |||
| BindingPeriodValidityEndDate | BindingPeriodValidityEndDate | |||
| HdrOrderProbabilityInPercent | HdrOrderProbabilityInPercent | |||
| ExpectedOrderNetAmount | ExpectedOrderNetAmount | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| IncotermsVersion | IncotermsVersion | |||
| CustomerPaymentTerms | CustomerPaymentTerms | |||
| CustomerPriceGroup | CustomerPriceGroup | |||
| PriceListType | PriceListType | |||
| PaymentMethod | PaymentMethod | |||
| CustomerTaxClassification1 | CustomerTaxClassification1 | |||
| CustomerTaxClassification2 | CustomerTaxClassification2 | |||
| CustomerTaxClassification3 | CustomerTaxClassification3 | |||
| CustomerTaxClassification4 | CustomerTaxClassification4 | |||
| CustomerTaxClassification5 | CustomerTaxClassification5 | |||
| CustomerTaxClassification6 | CustomerTaxClassification6 | |||
| CustomerTaxClassification7 | CustomerTaxClassification7 | |||
| CustomerTaxClassification8 | CustomerTaxClassification8 | |||
| CustomerTaxClassification9 | CustomerTaxClassification9 | |||
| ReferenceSDDocument | ReferenceSDDocument | |||
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | |||
| SalesQuotationApprovalReason | SalesQuotationApprovalReason | |||
| SalesDocApprovalStatus | SalesDocApprovalStatus | |||
| OverallSDProcessStatus | OverallSDProcessStatus | |||
| TotalCreditCheckStatus | TotalCreditCheckStatus | |||
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | |||
| _Item | _Item | |||
| _Partner | _Partner | |||
| _PricingElement | _PricingElement | |||
| _Text | _Text | |||
| _RelatedObject | _RelatedObject | |||
| _PrecedingProcFlowDoc | _PrecedingProcFlowDoc | |||
| _SubsequentProcFlowDoc | _SubsequentProcFlowDoc |
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Sales Quotation Header'
@VDM: {
viewType: #COMPOSITE,
lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
sqlViewName: 'ASALESQUOTATION',
compiler.compareFilter: true
}
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
representativeKey: 'Salesquotation',
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #C,
sizeCategory: #XL
}
}
@Metadata.ignorePropagatedAnnotations: true
define view A_SalesQuotation
as select from I_SalesQuotationEnhanced as SalesQuotation
association [0..*] to A_SalesQuotationItem as _Item on _Item.SalesQuotation = $projection.SalesQuotation
association [0..*] to A_SalesQuotationPartner as _Partner on _Partner.SalesQuotation = $projection.SalesQuotation
association [0..*] to A_SalesQuotationPrcgElmnt as _PricingElement on _PricingElement.SalesQuotation = $projection.SalesQuotation
association [0..*] to A_SalesQuotationText as _Text on _Text.SalesQuotation = $projection.SalesQuotation
association [0..*] to A_SalesQuotationRelatedObject as _RelatedObject on _RelatedObject.SalesQuotation = $projection.SalesQuotation
association [0..*] to A_SlsQtanPrecdgProcFlow as _PrecedingProcFlowDoc on _PrecedingProcFlowDoc.SalesQuotation = $projection.SalesQuotation
association [0..*] to A_SlsQtanSubsqntProcFlow as _SubsequentProcFlowDoc on _SubsequentProcFlowDoc.SalesQuotation = $projection.SalesQuotation
//Extensibility
association [0..1] to E_SalesDocumentBasic as _Extension on $projection.SalesQuotation = _Extension.SalesDocument
{
key SalesQuotation,
@ObjectModel.sapObjectNodeTypeReference: 'SalesQuotationType'
SalesQuotationType,
SalesOrganization,
DistributionChannel,
OrganizationDivision,
SalesGroup,
SalesOffice,
SalesDistrict,
SoldToParty,
@ObjectModel.readOnly: true
CreationDate,
@ObjectModel.readOnly: true
CreatedByUser,
@ObjectModel.readOnly: true
LastChangeDate,
@ObjectModel.readOnly: true
case TSTMP_IS_VALID(LastChangeDateTime)
when 0 then cast( dats_tims_to_tstmp( CreationDate, CreationTime, 'UTC', $session.client, 'NULL' ) as timestampl )
else LastChangeDateTime
end as LastChangeDateTime,
PurchaseOrderByCustomer,
CustomerPurchaseOrderType,
CustomerPurchaseOrderDate,
SalesQuotationDate,
@ObjectModel.readOnly: true
@Semantics.amount.currencyCode: 'TransactionCurrency'
TotalNetAmount,
@Semantics.currencyCode: true
TransactionCurrency,
@ObjectModel.sapObjectNodeTypeReference: 'SalesDocumentReason'
SDDocumentReason,
PricingDate,
RequestedDeliveryDate,
ShippingCondition,
CompleteDeliveryIsDefined,
ShippingType,
HeaderBillingBlockReason,
DeliveryBlockReason,
BindingPeriodValidityStartDate,
BindingPeriodValidityEndDate,
@ObjectModel.readOnly: true
HdrOrderProbabilityInPercent,
@ObjectModel.readOnly: true
@Semantics.amount.currencyCode: 'TransactionCurrency'
ExpectedOrderNetAmount,
@ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
@ObjectModel.sapObjectNodeTypeReference: 'IncotermsVersion'
IncotermsVersion,
CustomerPaymentTerms,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerPriceGroup'
CustomerPriceGroup,
PriceListType,
@ObjectModel.sapObjectNodeTypeReference: 'PaymentMethod'
PaymentMethod,
//Tax Classfication
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification1,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification2,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification3,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification4,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification5,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification6,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification7,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification8,
@ObjectModel.sapObjectNodeTypeReference: 'CustomerTaxClassification'
CustomerTaxClassification9,
ReferenceSDDocument,
@ObjectModel.readOnly: true
ReferenceSDDocumentCategory,
@ObjectModel.readOnly: true
SalesQuotationApprovalReason,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'SalesDocApprovalStatus'
SalesDocApprovalStatus,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'OverallSDProcessStatus'
OverallSDProcessStatus,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'TotalCreditCheckStatus'
TotalCreditCheckStatus,
@ObjectModel.readOnly: true
@ObjectModel.sapObjectNodeTypeReference: 'OverallSDDocumentRejectionSts'
OverallSDDocumentRejectionSts,
// Expose own associations
_Item,
_Partner,
_PricingElement,
_Text,
_RelatedObject,
_PrecedingProcFlowDoc,
_SubsequentProcFlowDoc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESQUOTATIONENHANCED"
],
"ASSOCIATED":
[
"A_SALESQUOTATIONITEM",
"A_SALESQUOTATIONPARTNER",
"A_SALESQUOTATIONPRCGELMNT",
"A_SALESQUOTATIONRELATEDOBJECT",
"A_SALESQUOTATIONTEXT",
"A_SLSQTANPRECDGPROCFLOW",
"A_SLSQTANSUBSQNTPROCFLOW",
"E_SALESDOCUMENTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA