I_SalesDocumentBasic

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_SalesDocumentBasic.
-- 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_SalesDocumentBasic AS
SELECT
  vbak.vbeln AS SalesDocument,
  vbak.vbtyp AS SDDocumentCategory,
  vbak.auart AS SalesDocumentType,
  vbak.vbklt AS SalesDocumentProcessingType,
  vbak.ernam AS CreatedByUser,
  vbak.last_changed_by_user AS LastChangedByUser,
  vbak.erdat AS CreationDate,
  cast( vbak.erzet as creation_time preserving type ) AS CreationTime,
  vbak.aedat AS LastChangeDate,
  vbak.upd_tmstmp AS LastChangeDateTime,
  vbak.mahdt AS LastCustomerContactDate,
  vbak.ext_bus_syst_id AS SenderBusinessSystemName,
  vbak.ext_ref_doc_id AS ExternalDocumentID,
  vbak.ext_rev_tmstmp AS ExternalDocLastChangeDateTime,
  vbak.vkorg AS SalesOrganization,
  vbak.vtweg AS DistributionChannel,
  vbak.spart AS OrganizationDivision,
  vbak.vkgrp AS SalesGroup,
  vbak.vkbur AS SalesOffice,
  vbak.kunnr AS SoldToParty,
  vbak.kvgr1 AS AdditionalCustomerGroup1,
  vbak.kvgr2 AS AdditionalCustomerGroup2,
  vbak.kvgr3 AS AdditionalCustomerGroup3,
  vbak.kvgr4 AS AdditionalCustomerGroup4,
  vbak.kvgr5 AS AdditionalCustomerGroup5,
  vbak.kkber AS CreditControlArea,
  vbak.knuma AS CustomerRebateAgreement,
  vbak.audat AS SalesDocumentDate,
  vbak.augru AS SDDocumentReason,
  vbak.submi AS SDDocumentCollectiveNumber,
  vbak.bsark AS CustomerPurchaseOrderType,
  vbak.bstdk AS CustomerPurchaseOrderDate,
  vbak.bstzd AS CustomerPurchaseOrderSuplmnt,
  vbak.stwae AS StatisticsCurrency,
  vbak.msr_id AS RetsMgmtProcess,
  vbak.cmnup AS NextCreditCheckDate,
  vbak.angdt AS BindingPeriodValidityStartDate,
  vbak.bnddt AS BindingPeriodValidityEndDate,
  vbak.awahr AS HdrOrderProbabilityInPercent,
  vbak.abdis AS SchedulingAgreementProfileCode,
  vbak.abdis AS DelivSchedTypeMRPRlvnceCode,
  vbak.guebg AS AgrmtValdtyStartDate,
  vbak.gueen AS AgrmtValdtyEndDate,
  vbak.abrvw AS MatlUsageIndicator,
  vbak.netwr AS TotalNetAmount,
  vbak.waerk AS TransactionCurrency,
  vbak.knumv AS SalesDocumentCondition,
  vbak.kalsm AS SDPricingProcedure,
  vbak.taxk1 AS CustomerTaxClassification1,
  vbak.taxk2 AS CustomerTaxClassification2,
  vbak.taxk3 AS CustomerTaxClassification3,
  vbak.taxk4 AS CustomerTaxClassification4,
  vbak.taxk5 AS CustomerTaxClassification5,
  vbak.taxk6 AS CustomerTaxClassification6,
  vbak.taxk7 AS CustomerTaxClassification7,
  vbak.taxk8 AS CustomerTaxClassification8,
  vbak.taxk9 AS CustomerTaxClassification9,
  vbak.landtx AS TaxDepartureCountry,
  vbak.stceg_l AS VATRegistrationCountry,
  cast(vbak.vdatu as reqd_delivery_date preserving type) AS RequestedDeliveryDate,
  vbak.vsbed AS ShippingCondition,
  vbak.autlf AS CompleteDeliveryIsDefined,
  vbak.lifsk AS DeliveryBlockReason,
  vbak.fsh_candate AS FashionCancelDate,
  vbak.bukrs_vf AS BillingCompanyCode,
  vbak.faksk AS HeaderBillingBlockReason,
  cast( vbak.apm_approval_reason as sd_apm_approval_reason_vdm preserving type ) AS SalesDocApprovalReason,
  vbak.fkara AS ProposedBillingDocumentType,
  vbak.kurst AS ExchangeRateType,
  vbak.gsber AS BusinessArea,
  vbak.gskst AS CostCenterBusinessArea,
  vbak.kostl AS CostCenter
FROM vbak
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_SalesDocumentItemBasic AS _ItemBasic ON SalesDocument = _ItemBasic.SalesDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SDDocumentReason ON SDDocumentReason = _SDDocumentReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerPurchaseOrderType AS _CustomerPurchaseOrderType ON CustomerPurchaseOrderType = _CustomerPurchaseOrderType.CustomerPurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcess AS _RetsMgmtProcess ON RetsMgmtProcess = _RetsMgmtProcess.RetsMgmtProcess  -- association [0..1]
LEFT OUTER JOIN I_DelivSchedTypeMRPRlvnceCode AS _DelivSchedTypeMRPRlvnceCode ON DelivSchedTypeMRPRlvnceCode = _DelivSchedTypeMRPRlvnceCode.DelivSchedTypeMRPRlvnceCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _BillingCompanyCode ON BillingCompanyCode = _BillingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDocApprovalReason AS _SalesDocApprovalReason ON SDDocumentCategory = _SalesDocApprovalReason.SDDocumentCategory AND SalesDocApprovalReason = _SalesDocApprovalReason.SalesDocApprovalReason  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateType ON ExchangeRateType = _ExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _CostCenterBusinessArea ON CostCenterBusinessArea = _CostCenterBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON CostCenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= SalesDocumentDate AND _CostCenter.ValidityStartDate <= SalesDocumentDate  -- association [0..1]
LEFT OUTER JOIN I_SlsPricingProcedure AS _SDPricingProcedure ON SDPricingProcedure = _SDPricingProcedure.PricingProcedure  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EngagementProjectItem AS _EngagementProjectItem ON SalesDocument = _EngagementProjectItem.EngagementProjectItem AND _EngagementProjectItem.EngagementProjectItemType = '0SOH'  -- association [0..*]
LEFT OUTER JOIN I_SalesArea AS _SalesArea ON SalesOrganization = _SalesArea.SalesOrganization AND DistributionChannel = _SalesArea.DistributionChannel AND OrganizationDivision = _SalesArea.Division  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallPurchaseConfStatus AS _OverallPurchaseConfStatus ON OverallPurchaseConfStatus = _OverallPurchaseConfStatus.OverallPurchaseConfStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallSDDocumentRjcnStatus AS _OverallSDDocumentRejectionSts ON OverallSDDocumentRejectionSts = _OverallSDDocumentRejectionSts.OverallSDDocumentRejectionSts  -- association [0..1]
LEFT OUTER JOIN I_TotalBlockStatus AS _TotalBlockStatus ON TotalBlockStatus = _TotalBlockStatus.TotalBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDelivConfStatus AS _OverallDelivConfStatus ON OverallDelivConfStatus = _OverallDelivConfStatus.OverallDelivConfStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallTotalDeliveryStatus AS _OverallTotalDeliveryStatus ON OverallTotalDeliveryStatus = _OverallTotalDeliveryStatus.OverallTotalDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDeliveryStatus AS _OverallDeliveryStatus ON OverallDeliveryStatus = _OverallDeliveryStatus.OverallDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDeliveryBlockStatus AS _OverallDeliveryBlockStatus ON OverallDeliveryBlockStatus = _OverallDeliveryBlockStatus.OverallDeliveryBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus ON OverallOrdReltdBillgStatus = _OverallOrdReltdBillgStatus.OverallOrdReltdBillgStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallBillingBlockStatus AS _OverallBillingBlockStatus ON OverallBillingBlockStatus = _OverallBillingBlockStatus.OverallBillingBlockStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallTotalSDDocRefStatus AS _OverallTotalSDDocRefStatus ON OverallTotalSDDocRefStatus = _OverallTotalSDDocRefStatus.OverallTotalSDDocRefStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus ON OverallSDDocReferenceStatus = _OverallSDDocReferenceStatus.OverallSDDocReferenceStatus  -- association [0..1]
LEFT OUTER JOIN I_TotalCreditCheckStatus AS _TotalCreditCheckStatus ON TotalCreditCheckStatus = _TotalCreditCheckStatus.TotalCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_MaxDocValueCreditCheckSts AS _MaxDocValueCreditCheckStatus ON MaxDocValueCreditCheckStatus = _MaxDocValueCreditCheckStatus.MaxDocValueCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermCreditCheckSts AS _PaymentTermCreditCheckStatus ON PaymentTermCreditCheckStatus = _PaymentTermCreditCheckStatus.PaymentTermCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_FinDocCreditCheckStatus AS _FinDocCreditCheckStatus ON FinDocCreditCheckStatus = _FinDocCreditCheckStatus.FinDocCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_ExprtInsurCreditCheckStatus AS _ExprtInsurCreditCheckStatus ON ExprtInsurCreditCheckStatus = _ExprtInsurCreditCheckStatus.ExprtInsurCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_PaytAuthsnCreditCheckSts AS _PaytAuthsnCreditCheckSts ON PaytAuthsnCreditCheckSts = _PaytAuthsnCreditCheckSts.PaytAuthsnCreditCheckSts  -- association [0..1]
LEFT OUTER JOIN I_CentralCreditCheckStatus AS _CentralCreditCheckStatus ON CentralCreditCheckStatus = _CentralCreditCheckStatus.CentralCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN I_CentralCreditChkTechErrSts AS _CentralCreditChkTechErrSts ON CentralCreditChkTechErrSts = _CentralCreditChkTechErrSts.CentralCreditChkTechErrSts  -- association [0..1]
LEFT OUTER JOIN I_HdrGenIncompletionStatus AS _HdrGeneralIncompletionStatus ON HdrGeneralIncompletionStatus = _HdrGeneralIncompletionStatus.HdrGeneralIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallPrcIncompletionSts AS _OverallPricingIncompletionSts ON OverallPricingIncompletionSts = _OverallPricingIncompletionSts.OverallPricingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_HdrDelivIncompletionStatus AS _HeaderDelivIncompletionStatus ON HeaderDelivIncompletionStatus = _HeaderDelivIncompletionStatus.HeaderDelivIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_HdrBillgIncompletionStatus AS _HeaderBillgIncompletionStatus ON HeaderBillgIncompletionStatus = _HeaderBillgIncompletionStatus.HeaderBillgIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmGenIncompletionSts AS _OvrlItmGeneralIncompletionSts ON OvrlItmGeneralIncompletionSts = _OvrlItmGeneralIncompletionSts.OvrlItmGeneralIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmBillgIncompltnSts AS _OvrlItmBillingIncompletionSts ON OvrlItmBillingIncompletionSts = _OvrlItmBillingIncompletionSts.OvrlItmBillingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts ON OvrlItmDelivIncompletionSts = _OvrlItmDelivIncompletionSts.OvrlItmDelivIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OverallChmlCmplncStatus AS _OverallChmlCmplncStatus ON OverallChmlCmplncStatus = _OverallChmlCmplncStatus.OverallChmlCmplncStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallDangerousGoodsStatus AS _OverallDangerousGoodsStatus ON OverallDangerousGoodsStatus = _OverallDangerousGoodsStatus.OverallDangerousGoodsStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlSftyDataSheetSts AS _OvrlSftyDataSheetSts ON OverallSafetyDataSheetStatus = _OvrlSftyDataSheetSts.OverallSafetyDataSheetStatus  -- association [0..1]
LEFT OUTER JOIN I_SalesDocApprovalStatus AS _SalesDocApprovalStatus ON SalesDocApprovalStatus = _SalesDocApprovalStatus.SalesDocApprovalStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlTradeCmplncEmbargoStatus AS _OvrlTradeCmplncEmbargoStatus ON OverallTrdCmplncEmbargoSts = _OvrlTradeCmplncEmbargoStatus.OverallTrdCmplncEmbargoSts  -- association [0..1]
LEFT OUTER JOIN I_OvTrdCmplncSnctndListChkSts AS _OvTrdCmplncSnctndListChkSts ON OvrlTrdCmplncSnctndListChkSts = _OvTrdCmplncSnctndListChkSts.OvrlTrdCmplncSnctndListChkSts  -- association [0..1]
LEFT OUTER JOIN I_OvrlTrdCmplncLegalCtrlChkSts AS _OvrlTrdCmplncLegalCtrlChkSts ON OvrlTrdCmplncLegalCtrlChkSts = _OvrlTrdCmplncLegalCtrlChkSts.OvrlTrdCmplncLegalCtrlChkSts  -- association [0..1]
LEFT OUTER JOIN I_OmniChnlSalesPromotionStatus AS _OmniChnlSalesPromotionStatus ON OmniChnlSalesPromotionStatus = _OmniChnlSalesPromotionStatus.OmniChnlSalesPromotionStatus  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerCreditAccount ON CustomerCreditAccount = _CustomerCreditAccount.Customer  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON ControllingAreaCurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _TaxDepartureCountry ON TaxDepartureCountry = _TaxDepartureCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _VATRegistrationCountry ON VATRegistrationCountry = _VATRegistrationCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_ContractDownPaymentStatus AS _DownPaymentStatus ON ContractDownPaymentStatus = _DownPaymentStatus.ContractDownPaymentStatus  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDateTypeRule AS _DeliveryDateTypeRule ON DeliveryDateTypeRule = _DeliveryDateTypeRule.DeliveryDateTypeRule  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _SolutionOrder ON BusinessSolutionOrder = _SolutionOrder.ServiceDocument AND _SolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
;