C_SalesDocWithCustExpdPrice

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_SalesDocWithCustExpdPrice.
-- 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: CSDOCWCUSTEXPPRC

CREATE VIEW C_SalesDocWithCustExpdPrice AS
SELECT
  SalesDocumentItem.SalesDocument AS SalesDocument,
  cast(SalesDocumentItem.SalesDocumentItem as posnr preserving type) AS SalesDocumentItem,
  _Condition.PricingDocument AS PricingDocument,
  _Condition.PricingDocumentItem AS PricingDocumentItem,
  _Condition.PricingProcedureStep AS PricingProcedureStep,
  _Condition.PricingProcedureCounter AS PricingProcedureCounter,
  _SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  _SalesDocument.SalesOffice AS SalesOffice,
  _SalesDocument.SalesGroup AS SalesGroup,
  _SalesDocument.SalesDocumentType AS SalesDocumentType,
  _SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  _SalesDocument.SoldToParty AS SoldToParty,
  cast(SalesDocumentItem.Material as productnumber preserving type ) AS Material,
  SalesDocumentItem._MaterialText[1:Language=$session.system_language].MaterialName AS MaterialName,
  SalesDocumentItem.SalesDocumentCondition AS SalesDocumentCondition,
  _SalesDocument.CreatedByUser AS CreatedByUser,
  _SalesDocument.CreationDate AS CreationDate,
  SalesDocumentItem.NetAmount AS NetAmount,
  SalesDocumentItem.TransactionCurrency AS TransactionCurrency,
  SalesDocumentItem.TargetQuantity AS TargetQuantity,
  SalesDocumentItem.TargetQuantityUnit AS TargetQuantityUnit,
  SalesDocumentItem.NetPriceAmount AS NetPriceAmount,
  cast(SalesDocumentItem.NetPriceQuantity as net_price_unit preserving type) AS NetPriceQuantity,
  SalesDocumentItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SalesDocumentItem.OrderQuantity AS OrderQuantity,
  SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesDocumentItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  _Condition.ConditionCurrency AS ConditionCurrency,
  cast(_Condition.ConditionQuantity as customer_price_unit preserving type) AS ConditionQuantity,
  _Condition.ConditionQuantityUnit AS ConditionQuantityUnit,
  _Condition.ConditionApplication AS ConditionApplication,
  _Condition.ConditionType AS ConditionType,
  _PricingConditionType._Text[1:Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  _SalesDocument._SalesOrganization AS _SalesOrganization
FROM I_SalesDocumentItem AS SalesDocumentItem
INNER JOIN P_CustExpPriceIncompletionLog AS _CustExpPriceIncompletionLog ON /* join condition not captured in parsed metadata */
INNER JOIN I_PricingElement AS _Condition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_SalesDocumentContactPerson AS _ContactPerson ON SalesDocument = _ContactPerson.SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SalesDocument = _SalesDocument.SalesDocument  -- association [0..1]
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON soldtoparty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_Dischannelvaluehelp AS _DistributionChannel ON salesorganization = _DistributionChannel.SalesOrganization AND distributionchannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN C_OrgDivisionValueHelp AS _OrganizationDivision ON salesorganization = _OrganizationDivision.SalesOrganization AND distributionchannel = _OrganizationDivision.DistributionChannel AND organizationdivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN C_Incompl_SalesDocCatVH AS _SalesDocumentCategory ON sddocumentcategory = _SalesDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN C_SalesOfficeValueHelp AS _SalesOffice ON salesorganization = _SalesOffice.SalesOrganization AND distributionchannel = _SalesOffice.DistributionChannel AND organizationdivision = _SalesOffice.OrganizationDivision AND salesoffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN C_Incompl_SalesDocTypeVH AS _SalesDocumentType ON sddocumentcategory = _SalesDocumentType.SDDocumentCategory AND salesdocumenttype = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN C_SalesGroupValueHelp AS _SalesGroup ON salesoffice = _SalesGroup.SalesOffice AND salesgroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON createdbyuser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionCurrency ON ConditionCurrency = _ConditionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionQuantityUnit ON ConditionQuantityUnit = _ConditionQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _TargetQuantityUnit ON TargetQuantityUnit = _TargetQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_PricingConditionType AS _PricingConditionType ON ConditionApplication = _PricingConditionType.ConditionApplication AND ConditionType = _PricingConditionType.ConditionType  -- association [0..1]
LEFT OUTER JOIN C_PricingConditionType_VH AS _PricingConditionTypeVH ON ConditionType = _PricingConditionTypeVH.ConditionType AND ConditionApplication = _PricingConditionTypeVH.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_ConditionCategory AS _ConditionCategory ON ConditionCategory = _ConditionCategory.ConditionCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON SalesDocumentRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN C_CustExpdPriceCondition AS _PricingElement ON SalesDocumentCondition = _PricingElement.PricingDocument AND SalesDocumentItem = _PricingElement.PricingDocumentItem  -- association [0..*]
;