A_SalesQuotation

DDL: A_SALESQUOTATION Type: view COMPOSITE

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)

SourceAliasJoin Type
I_SalesQuotationEnhanced SalesQuotation from

Associations (8)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/