I_BillingDocumentBasic

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_BillingDocumentBasic.
-- 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_BillingDocumentBasic AS
SELECT
  vbeln AS BillingDocument,
  vbtyp AS SDDocumentCategory,
  fktyp AS BillingDocumentCategory,
  fkart AS BillingDocumentType,
  fkara AS ProposedBillingDocumentType,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  erzet AS CreationTime,
  aedat AS LastChangeDate,
  changed_on AS LastChangeDateTime,
  logsys AS LogicalSystem,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  fkdat AS BillingDocumentDate,
  fksto AS BillingDocumentIsCancelled,
  sfakn AS CancelledBillingDocument,
  zukri AS BillingDocCombinationCriteria,
  mrnkz AS ManualInvoiceMaintIsRelevant,
  numpg AS NmbrOfPages,
  intra_rel AS IsIntrastatReportingRelevant,
  intra_excl AS IsIntrastatReportingExcluded,
  draft AS BillingDocumentIsTemporary,
  netwr AS TotalNetAmount,
  waerk AS TransactionCurrency,
  stwae AS StatisticsCurrency,
  mwsbk AS TotalTaxAmount,
  konda AS CustomerPriceGroup,
  pltyp AS PriceListType,
  landtx AS TaxDepartureCountry,
  stceg AS VATRegistration,
  stceg_h AS VATRegistrationOrigin,
  stceg_l AS VATRegistrationCountry,
  hityp_pr AS HierarchyTypePricing,
  taxk1 AS CustomerTaxClassification1,
  taxk2 AS CustomerTaxClassification2,
  taxk3 AS CustomerTaxClassification3,
  taxk4 AS CustomerTaxClassification4,
  taxk5 AS CustomerTaxClassification5,
  taxk6 AS CustomerTaxClassification6,
  taxk7 AS CustomerTaxClassification7,
  taxk8 AS CustomerTaxClassification8,
  taxk9 AS CustomerTaxClassification9,
  xegdr AS IsEUTriangularDeal,
  kalsm AS SDPricingProcedure,
  vsbed AS ShippingCondition,
  ico_lifnr AS PlantSupplier,
  incov AS IncotermsVersion,
  inco1 AS IncotermsClassification,
  inco2 AS IncotermsTransferLocation,
  inco2_l AS IncotermsLocation1,
  inco3_l AS IncotermsLocation2,
  kunrg AS PayerParty,
  vkont AS ContractAccount,
  zterm AS CustomerPaymentTerms,
  zlsch AS PaymentMethod,
  kidno AS PaymentReference,
  valdt AS FixedValueDate,
  valtg AS AdditionalValueDays,
  mndid AS SEPAMandate,
  bukrs AS CompanyCode,
  gjahr AS FiscalYear,
  belnr AS AccountingDocument,
  poper AS FiscalPeriod,
  ktgrd AS CustomerAccountAssignmentGroup,
  cpkur AS AccountingExchangeRateIsSet,
  cast(kurrf as kurrf_not_converted preserving type ) AS AccountingExchangeRate,
  kurrf_dat AS ExchangeRateDate,
  kurst AS ExchangeRateType,
  xblnr AS DocumentReferenceID,
  zuonr AS AssignmentReference,
  stgrd AS ReversalReason,
  maber AS DunningArea,
  mansp AS DunningBlockingReason,
  mschl AS DunningKey,
  lcnum AS InternalFinancialDocument,
  accrrel AS IsRelevantForAccrual,
  fkart_rl AS InvoiceListType,
  fkdat_rl AS InvoiceListBillingDate,
  bdr_ref AS BillingDocRequestReference,
  bdr_ref_logsys AS BillgDocReqRefLgclSyst,
  bdr_ref_vbtyp AS BillgDocReqRefSDDocCategory,
  kunag AS SoldToParty,
  vbund AS PartnerCompany,
  bstnk_vf AS PurchaseOrderByCustomer,
  kdgrp AS CustomerGroup,
  land1 AS Country,
  cityc AS CityCode,
  bzirk AS SalesDistrict,
  regio AS Region,
  counc AS County,
  kkber AS CreditControlArea,
  knuma AS CustomerRebateAgreement,
  knumv AS PricingDocument,
  gbstk AS OverallSDProcessStatus,
  vf_status AS OverallBillingStatus,
  buchk AS AccountingPostingStatus,
  rfbsk AS AccountingTransferStatus,
  vf_todo AS BillingIssueType,
  bdr_status AS OverallBillingDocReqStatus,
  relik AS InvoiceListStatus,
  uvals AS OvrlItmGeneralIncompletionSts,
  uvprs AS OverallPricingIncompletionSts,
  fksak AS OverallDocumentBillingStatus,
  pbd_status AS PrelimBillingDocumentStatus,
  clrst AS InvoiceClearingStatus,
  apm_approval_reason AS BillgProcDocApprovalReason,
  vbrk.apm_approval_status AS BillgProcDocApprovalStatus
FROM vbrk
LEFT OUTER JOIN I_DunningAreaText AS _DunningAreaText ON DunningArea = _DunningAreaText.DunningArea AND CompanyCode = _DunningAreaText.CompanyCode  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentItemBasic AS _ItemBasic ON BillingDocument = _ItemBasic.BillingDocument  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentPartnerBasic AS _PartnerBasic ON BillingDocument = _PartnerBasic.BillingDocument  -- association [1..*]
LEFT OUTER JOIN I_BillingDocPrcgElmntBasic AS _PricingElementBasic ON BillingDocument = _PricingElementBasic.BillingDocument  -- association [0..*]
LEFT OUTER JOIN I_SDDocumentCategory AS _SDDocumentCategory ON SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _BillgDocReqRefSDDocCategory ON BillgDocReqRefSDDocCategory = _BillgDocReqRefSDDocCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentCategory AS _BillingDocumentCategory ON BillingDocumentCategory = _BillingDocumentCategory.BillingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _ProposedBillingDocumentType ON ProposedBillingDocumentType = _ProposedBillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- 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 _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentBasic AS _CancelledBillingDocumentBasic ON CancelledBillingDocument = _CancelledBillingDocumentBasic.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- 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_Country AS _TaxDepartureCountry ON TaxDepartureCountry = _TaxDepartureCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_VATRegistrationOrigin AS _VATRegistrationOrigin ON VATRegistrationOrigin = _VATRegistrationOrigin.VATRegistrationOrigin  -- association [0..1]
LEFT OUTER JOIN I_Country AS _VATRegistrationCountry ON VATRegistrationCountry = _VATRegistrationCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_SlsPricingProcedure AS _SDPricingProcedure ON SDPricingProcedure = _SDPricingProcedure.PricingProcedure  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- 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_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND Country = _PaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND FiscalYear = _AccountingDocument.FiscalYear AND AccountingDocument = _AccountingDocument.AccountingDocument  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForCmpnyCode AS _FiscalPeriod ON CompanyCode = _FiscalPeriod.CompanyCode AND FiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod  -- association [1..1]
LEFT OUTER JOIN I_CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup ON CustomerAccountAssignmentGroup = _CustomerAccountAssgmtGroup.CustomerAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateType ON ExchangeRateType = _ExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_ReversalReason AS _ReversalReason ON ReversalReason = _ReversalReason.ReversalReason  -- association [0..1]
LEFT OUTER JOIN I_DunningArea AS _DunningArea ON DunningArea = _DunningArea.DunningArea AND CompanyCode = _DunningArea.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_DunningBlockingReasonCode AS _DunningBlockingReason ON DunningBlockingReason = _DunningBlockingReason.DunningBlockingReason  -- association [0..1]
LEFT OUTER JOIN I_DunningKey AS _DunningKey ON DunningKey = _DunningKey.DunningKey  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _InvoiceListType ON InvoiceListType = _InvoiceListType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_CityCode AS _CityCode ON CityCode = _CityCode.CityCode AND Country = _CityCode.Country AND Region = _CityCode.Region  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_CountyCode AS _County ON Country = _County.Country AND Region = _County.Region AND County = _County.County  -- association [0..1]
LEFT OUTER JOIN I_TaxingCounty AS _County_2 ON Country = _County_2.Country AND Region = _County_2.Region AND County = _County_2.TaxingCounty  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_OverallSDProcessStatus AS _OverallSDProcessStatus ON OverallSDProcessStatus = _OverallSDProcessStatus.OverallSDProcessStatus  -- association [0..1]
LEFT OUTER JOIN I_OverallBillingStatus AS _OverallBillingStatus ON OverallBillingStatus = _OverallBillingStatus.OverallBillingStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlBillingDocReqStatus AS _OvrlBillingDocReqStatus ON OverallBillingDocReqStatus = _OvrlBillingDocReqStatus.OverallBillingDocReqStatus  -- association [0..1]
LEFT OUTER JOIN I_PrelimBillgDocStatus AS _PrelimBillingDocumentStatus ON PrelimBillingDocumentStatus = _PrelimBillingDocumentStatus.PrelimBillingDocumentStatus  -- association [0..1]
LEFT OUTER JOIN I_AccountingPostingStatus AS _AccountingPostingStatus ON AccountingPostingStatus = _AccountingPostingStatus.AccountingPostingStatus  -- association [0..1]
LEFT OUTER JOIN I_AccountingTransferStatus AS _AccountingTransferStatus ON AccountingTransferStatus = _AccountingTransferStatus.AccountingTransferStatus  -- association [0..1]
LEFT OUTER JOIN I_BillingIssueType AS _BillingIssueType ON BillingIssueType = _BillingIssueType.BillingIssueType  -- association [0..1]
LEFT OUTER JOIN I_InvoiceListStatus AS _InvoiceListStatus ON InvoiceListStatus = _InvoiceListStatus.InvoiceListStatus  -- association [0..1]
LEFT OUTER JOIN I_OvrlItmGenIncompletionSts AS _OvrlItmGeneralIncompletionSts ON OvrlItmGeneralIncompletionSts = _OvrlItmGeneralIncompletionSts.OvrlItmGeneralIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_OverallPrcIncompletionSts AS _OverallPricingIncompletionSts ON OverallPricingIncompletionSts = _OverallPricingIncompletionSts.OverallPricingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN I_SDApprovalStatus AS _BillgProcDocApprovalStatus ON BillgProcDocApprovalStatus = _BillgProcDocApprovalStatus.SDApprovalStatus  -- association [0..1]
LEFT OUTER JOIN I_BillgProcDocApprovalReason AS _BillgProcDocApprovalReason ON SDDocumentCategory = _BillgProcDocApprovalReason.SDDocumentCategory AND BillgProcDocApprovalReason = _BillgProcDocApprovalReason.BillgProcDocApprovalReason  -- association [0..1]
LEFT OUTER JOIN I_SDApprovalStatusT AS _BillgProcDocApprovalStatusT ON BillgProcDocApprovalStatus = _BillgProcDocApprovalStatusT.SDApprovalStatus  -- association [0..*]
LEFT OUTER JOIN I_SDApprovalReasonT AS _BillgProcDocApprovalReasonT ON BillgProcDocApprovalReason = _BillgProcDocApprovalReasonT.SDApprovalReason  -- association [0..*]
LEFT OUTER JOIN I_InvoiceClearingStatus AS _InvoiceClearingStatus ON InvoiceClearingStatus = _InvoiceClearingStatus.InvoiceClearingStatus  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocument = _Extension.BillingDocument  -- association [0..1]
;