C_Salesorderomparamdet

DDL: C_SALESORDEROMPARAMDET SQL: CSDSLSORDOMPRM Type: view CONSUMPTION
53 Fields 1 Data Sources 1 Associations

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.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocument SalesDocument from

Associations (1)

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

Annotations (7)

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
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesDocumentType SalesDocumentType Sales Doc. Type
SDDocumentCategory SDDocumentCategory Document Cat.
SDDocumentReason SDDocumentReason Order Reason
SalesDocumentDate SalesDocumentDate Document Date
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
TransactionCurrency TransactionCurrency Transaction Currency
SalesDistrict SalesDistrict Sales District
ReceivingPoint ReceivingPoint Recv. Point
ShippingCondition ShippingCondition Shipping Conditions
ShippingType ShippingType Shipping Type
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv POD-relevant
IncotermsClassification IncotermsClassification Incoterms
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CustomerPurchaseOrderType CustomerPurchaseOrderType
CreditControlArea CreditControlArea Credit Control Area
PaymentMethod PaymentMethod Pymt Meth.
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
BillingCompanyCode BillingCompanyCode CCodeToBeBilled
CustomerGroup CustomerGroup Customer Group
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
DeliveryBlockReason DeliveryBlockReason Delivery Block
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Salesorderomparamdet.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CSDSLSORDOMPRM

CREATE VIEW C_Salesorderomparamdet AS
SELECT
  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 AS OverallDeliveryStatus,
  SalesDocApprovalStatus
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument = _Extension.SalesDocument  -- association [0..1]
;

Learn More