C_Salesorderomparamdet

DDL: C_SALESORDEROMPARAMDET SQL: CSDSLSORDOMPRM Type: view CONSUMPTION

Output Parameter Determination for Sales

C_Salesorderomparamdet is a Consumption CDS View that provides data about "Output Parameter Determination for Sales" in SAP S/4HANA. It reads from 1 data source (I_SalesDocument) and exposes 53 fields with key field SalesDocument. It has 1 association to related views.

1 data source(s) 53 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocument SalesDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SalesDocumentBasic _Extension $projection.SalesDocument = _Extension.SalesDocument

Annotations (6)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CSDSLSORDOMPRM view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Output Parameter Determination for Sales view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesDocumentType SalesDocumentType
SDDocumentCategory SDDocumentCategory
SDDocumentReason SDDocumentReason
SalesDocumentDate SalesDocumentDate
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
TransactionCurrency TransactionCurrency
SalesDistrict SalesDistrict
ReceivingPoint ReceivingPoint
ShippingCondition ShippingCondition
ShippingType ShippingType
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv
IncotermsClassification IncotermsClassification
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
CustomerPaymentTerms CustomerPaymentTerms
CustomerPurchaseOrderType CustomerPurchaseOrderType
CreditControlArea CreditControlArea
PaymentMethod PaymentMethod
SalesGroup SalesGroup
SalesOffice SalesOffice
BillingCompanyCode BillingCompanyCode
CustomerGroup CustomerGroup
AdditionalCustomerGroup1 AdditionalCustomerGroup1
AdditionalCustomerGroup2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 AdditionalCustomerGroup3
AdditionalCustomerGroup4 AdditionalCustomerGroup4
AdditionalCustomerGroup5 AdditionalCustomerGroup5
DeliveryBlockReason DeliveryBlockReason
HeaderBillingBlockReason HeaderBillingBlockReason
OverallSDProcessStatus OverallSDProcessStatus
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus
OverallPurchaseConfStatus OverallPurchaseConfStatus
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts
TotalBlockStatus TotalBlockStatus
OverallDelivConfStatus OverallDelivConfStatus
OverallDeliveryBlockStatus OverallDeliveryBlockStatus
OverallBillingBlockStatus OverallBillingBlockStatus
TotalCreditCheckStatus TotalCreditCheckStatus
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts
HeaderDelivIncompletionStatus HeaderDelivIncompletionStatus
OvrlItmDelivIncompletionSts OvrlItmDelivIncompletionSts
OverallPricingIncompletionSts OverallPricingIncompletionSts
HeaderBillgIncompletionStatus HeaderBillgIncompletionStatus
OvrlItmBillingIncompletionSts OvrlItmBillingIncompletionSts
OverallDeliveryStatus I_SalesDocument OverallDeliveryStatus
SalesDocApprovalStatus SalesDocApprovalStatus 
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CSDSLSORDOMPRM'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Output Parameter Determination for Sales'
define view C_Salesorderomparamdet
  as select from I_SalesDocument as SalesDocument
  //Extensibility

  association [0..1] to E_SalesDocumentBasic as _Extension on $projection.SalesDocument = _Extension.SalesDocument
{
  key SalesDocument,

      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,
      SalesDocumentType,
      SDDocumentCategory,
      SDDocumentReason,
      SalesDocumentDate,
      CreatedByUser,
      CreationDate,
      CreationTime,
      TransactionCurrency,
      SalesDistrict,
      ReceivingPoint,
      ShippingCondition,
      ShippingType,
      SlsDocIsRlvtForProofOfDeliv,
      IncotermsClassification,
      IncotermsLocation1,
      IncotermsLocation2,
      CustomerPaymentTerms,
      CustomerPurchaseOrderType,
      CreditControlArea,
      PaymentMethod,
      SalesGroup,
      SalesOffice,
      BillingCompanyCode,
      CustomerGroup,
      AdditionalCustomerGroup1,
      AdditionalCustomerGroup2,
      AdditionalCustomerGroup3,
      AdditionalCustomerGroup4,
      AdditionalCustomerGroup5,
      DeliveryBlockReason,
      HeaderBillingBlockReason,
      OverallSDProcessStatus,
      OverallOrdReltdBillgStatus,
      OverallPurchaseConfStatus,
      OverallSDDocumentRejectionSts,
      TotalBlockStatus,
      OverallDelivConfStatus,
      OverallDeliveryBlockStatus,
      OverallBillingBlockStatus,
      TotalCreditCheckStatus,
      HdrGeneralIncompletionStatus,
      OvrlItmGeneralIncompletionSts,
      HeaderDelivIncompletionStatus,
      OvrlItmDelivIncompletionSts,
      OverallPricingIncompletionSts,
      HeaderBillgIncompletionStatus,
      OvrlItmBillingIncompletionSts,
      SalesDocument.OverallDeliveryStatus,
      SalesDocApprovalStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More