I_SalesDocument

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 I_SalesDocument.
-- 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.

CREATE VIEW I_SalesDocument AS
SELECT
  SalesDocument,
  SDDocumentCategory,
  SalesDocumentType,
  SalesDocumentProcessingType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  LastCustomerContactDate,
  SenderBusinessSystemName,
  ExternalDocumentID,
  ExternalDocLastChangeDateTime,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  vbkd.kdgrp AS CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  vbkd.podkz AS SlsDocIsRlvtForProofOfDeliv,
  CreditControlArea,
  CustomerRebateAgreement,
  SalesDocumentDate,
  vbkd.fbuda AS ServicesRenderedDate,
  SDDocumentReason,
  vbkd.bstkd AS PurchaseOrderByCustomer,
  vbkd.bstkd_e AS PurchaseOrderByShipToParty,
  SDDocumentCollectiveNumber,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  vbkd.bzirk AS SalesDistrict,
  StatisticsCurrency,
  vbkd.wminr AS ProductCatalog,
  RetsMgmtProcess,
  NextCreditCheckDate,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  HdrOrderProbabilityInPercent,
  veda.vuntdat AS SalesContractSignedDate,
  veda.vbedkue AS ContractPartnerCanclnDocDate,
  veda.vlaufz AS NmbrOfSalesContractValdtyPerd,
  veda.vlauez AS SalesContractValidityPerdUnit,
  veda.vlaufk AS SalesContractValidityPerdCat,
  veda.veindat AS SlsContractCanclnReqRcptDate,
  veda.vwundat AS RequestedCancellationDate,
  veda.vkuepar AS SalesContractCanclnParty,
  veda.vkuegru AS SalesContractCanclnReason,
  veda.vkuesch AS SalesContractCanclnProcedure,
  veda.vinsdat AS EquipmentInstallationDate,
  veda.vabndat AS EquipmentDeliveryAccptcDate,
  veda.vdemdat AS EquipmentDismantlingDate,
  veda.vaktsch AS SalesContractFollowUpAction,
  veda.vasda AS SlsContractFollowUpActionDate,
  veda.vbelkue AS CanclnDocByContrPartner,
  MasterSalesContract,
  SchedulingAgreementProfileCode,
  DelivSchedTypeMRPRlvnceCode,
  AgrmtValdtyStartDate,
  AgrmtValdtyEndDate,
  MatlUsageIndicator,
  TotalNetAmount,
  TransactionCurrency,
  vbkd.prsdt AS PricingDate,
  vbkd.waktion AS RetailPromotion,
  cast(vbkd.kursk as kursk_not_converted preserving type) AS PriceDetnExchangeRate,
  SalesDocumentCondition,
  SDPricingProcedure,
  vbkd.konda AS CustomerPriceGroup,
  vbkd.pltyp AS PriceListType,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  TaxDepartureCountry,
  VATRegistrationCountry,
  RequestedDeliveryDate,
  vbkd.vsart AS ShippingType,
  vbkd.empst AS ReceivingPoint,
  ShippingCondition,
  vbkd.inco1 AS IncotermsClassification,
  vbkd.inco2 AS IncotermsTransferLocation,
  vbkd.inco2_l AS IncotermsLocation1,
  vbkd.inco3_l AS IncotermsLocation2,
  vbkd.incov AS IncotermsVersion,
  vbkd.inco2_key AS IncotermsDestinationLocUUID,
  vbkd.inco3_key AS IncotermsDeliveryLocUUID,
  vbkd.inco4_key AS IncotermsDeviatingDestLocUUID,
  CompleteDeliveryIsDefined,
  vbkd.kzazu AS OrderCombinationIsAllowed,
  DeliveryBlockReason,
  vbkd.trmtyp AS MeansOfTransportRefMaterial,
  vbkd.traty AS MeansOfTransportType,
  vbkd.sdabw AS SpecialProcessingCode,
  FashionCancelDate,
  vbkd.fplnr AS BillingPlan,
  vbkd.fkdat AS BillingDocumentDate,
  ProposedBillingDocumentType,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  SalesDocApprovalReason,
  vbkd.zterm AS CustomerPaymentTerms,
  vbkd.zlsch AS PaymentMethod,
  vbkd.valdt AS FixedValueDate,
  vbkd.valtg AS AdditionalValueDays,
  vbkd.vkont AS ContractAccount,
  vbkd.gjahr AS FiscalYear,
  vbkd.poper AS FiscalPeriod,
  vbkd.abssc AS PaymentGuaranteeProcedure,
  vbkd.kursk_dat AS ExchangeRateDate,
  ExchangeRateType,
  vbkd.kurrf AS AccountingExchangeRate,
  BusinessArea,
  vbkd.ktgrd AS CustomerAccountAssignmentGroup,
  CostCenterBusinessArea,
  CostCenter,
  ControllingArea,
  OrderID,
  ControllingObject,
  AssignmentReference,
  PaymentPlan,
  CustomerCreditAccount,
  ControllingAreaCurrency,
  ReleasedCreditAmount,
  CreditBlockReleaseDate,
  NextShippingDate,
  ReferenceSDDocument,
  AccountingDocExternalReference,
  ReferenceSDDocumentCategory,
  SalesItemProposalDescription,
  CorrespncExternalReference,
  SlsDocSo2PLastContactPersnName,
  SlsDocSo2PLstCntctPersnTelNmbr,
  cast(vbkd.ihrez_e as sls_purg_doc_ext_ref preserving type ) AS POCorrespncExternalReference
FROM I_SalesDocumentBasic AS SalesDocumentBasic
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _CostCenterBusinessAreaText ON CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentItem AS _Item ON SalesDocument = _Item.SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentPartner AS _Partner ON SalesDocument = _Partner.SalesDocument  -- association [1..*]
LEFT OUTER JOIN I_SalesDocumentStandardPartner AS _StandardPartner ON SalesDocument = _StandardPartner.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentPricingElement AS _PricingElement ON SalesDocument = _PricingElement.SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentBillingPlan AS _BillingPlan ON SalesDocument = _BillingPlan.SalesDocument AND BillingPlan = _BillingPlan.BillingPlan  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentPrecdgProcFlow AS _PrecedingProcFlowDoc ON _PrecedingProcFlowDoc.SalesDocument = SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentSubsqntProcFlow AS _SubsequentProcFlowDoc ON _SubsequentProcFlowDoc.SalesDocument = SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_SalesContrValdtyPerdUnit AS _SalesContractValidityPerdUnit ON SalesContractValidityPerdUnit = _SalesContractValidityPerdUnit.SalesContractValidityPerdUnit  -- association [0..1]
LEFT OUTER JOIN I_SlsContractValidityPerdCat AS _SalesContractValidityPerdCat ON SalesContractValidityPerdCat = _SalesContractValidityPerdCat.SalesContractValidityPerdCat  -- association [0..1]
LEFT OUTER JOIN I_SalesContractCanclnParty AS _SalesContractCanclnParty ON SalesContractCanclnParty = _SalesContractCanclnParty.SalesContractCanclnParty  -- association [0..1]
LEFT OUTER JOIN I_SalesContractCanclnReason AS _SalesContractCanclnReason ON SalesContractCanclnReason = _SalesContractCanclnReason.SalesContractCanclnReason  -- association [0..1]
LEFT OUTER JOIN I_SalesContractFollowUpAction AS _SalesContractFollowUpAction ON SalesContractFollowUpAction = _SalesContractFollowUpAction.SalesContractFollowUpAction  -- association [0..1]
LEFT OUTER JOIN I_ShippingType AS _ShippingType ON ShippingType = _ShippingType.ShippingType  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup ON CustomerAccountAssignmentGroup = _CustomerAccountAssgmtGroup.CustomerAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroup AS _CustomerPriceGroup ON CustomerPriceGroup = _CustomerPriceGroup.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_PriceListType AS _PriceListType ON PriceListType = _PriceListType.PriceListType  -- association [0..1]
LEFT OUTER JOIN I_CustomerConditionGroupVH AS _ConditionGroup1 ON CustomerConditionGroup1 = _ConditionGroup1.CustomerConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerConditionGroupVH AS _ConditionGroup2 ON CustomerConditionGroup2 = _ConditionGroup2.CustomerConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerConditionGroupVH AS _ConditionGroup3 ON CustomerConditionGroup3 = _ConditionGroup3.CustomerConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerConditionGroupVH AS _ConditionGroup4 ON CustomerConditionGroup4 = _ConditionGroup4.CustomerConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerConditionGroupVH AS _ConditionGroup5 ON CustomerConditionGroup5 = _ConditionGroup5.CustomerConditionGroup  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocumentBasic.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;