I_BillingDocument

DDL: I_BILLINGDOCUMENT SQL: ISDBILLINGDOC Type: view BASIC
158 Fields 1 Data Sources 6 Associations

Billing Document

I_BillingDocument is a Basic CDS View (Dimension) that provides data about "Billing Document" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentBasic) and exposes 158 fields with key field BillingDocument. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentBasic I_BillingDocumentBasic from

Associations (6)

CardinalityTargetAliasCondition
[0..*] I_BillingDocumentItem _Item $projection.BillingDocument = _Item.BillingDocument
[1..*] I_BillingDocumentPartner _Partner $projection.BillingDocument = _Partner.BillingDocument
[0..*] I_BillingDocumentPrcgElmnt _PricingElement $projection.BillingDocument = _PricingElement.BillingDocument
[0..1] I_BillingDocument _CancelledBillingDocument $projection.CancelledBillingDocument = _CancelledBillingDocument.BillingDocument
[1..1] I_BillingDocEnhancedFields _EnhancedFields $projection.BillingDocument = _EnhancedFields.BillingDocument
[0..1] E_BillingDocument _Extension $projection.BillingDocument = _Extension.BillingDocument

Annotations (18)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey BillingDocument view
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name BillingDocument view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDBILLINGDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Billing Document view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (158)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
SDDocumentCategory SDDocumentCategory Document Cat.
BillingDocumentCategory BillingDocumentCategory BillingCategory
BillingDocumentType BillingDocumentType Billing Type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
LogicalSystem LogicalSystem Logical System
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
BillingDocumentDate BillingDocumentDate Billing Date
BillingDocumentIsCancelled BillingDocumentIsCancelled Canceled
CancelledBillingDocument CancelledBillingDocument Canceld Bill.Dc
BillingDocCombinationCriteria BillingDocCombinationCriteria Comb. Criteria
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant Man.Inv.Maint.
NmbrOfPages NmbrOfPages SDS Number of Pages
IsIntrastatReportingRelevant IsIntrastatReportingRelevant Intrastat rel.
IsIntrastatReportingExcluded IsIntrastatReportingExcluded exclude Intra
BillingDocumentIsTemporary BillingDocumentIsTemporary Max Vehicle Draft
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
StatisticsCurrency StatisticsCurrency Stats. Currency
ForeignTradeStstclCurrency ForeignTradeStstclCurrency
TotalTaxAmount TotalTaxAmount Tax Amount
CustomerPriceGroup CustomerPriceGroup CustPrice Group
PriceListType PriceListType Price List Tp.
TaxDepartureCountry TaxDepartureCountry Tx Dep Ctry/Reg
VATRegistration VATRegistration VAT Registration No.
VATRegistrationOrigin VATRegistrationOrigin OriginSlsTxNo.
VATRegistrationCountry VATRegistrationCountry CtryRgnSlsTxNo.
HierarchyTypePricing HierarchyTypePricing HierTypePricing
CustomerTaxClassification1 CustomerTaxClassification1 Tax Cls.1 Cust.
CustomerTaxClassification2 CustomerTaxClassification2 Tax Cls.2 Cust.
CustomerTaxClassification3 CustomerTaxClassification3 Tax Cls.3 Cust.
CustomerTaxClassification4 CustomerTaxClassification4 Tax Cls.4 Cust.
CustomerTaxClassification5 CustomerTaxClassification5 Tax Cls.5 Cust.
CustomerTaxClassification6 CustomerTaxClassification6 Tax Cls.6 Cust.
CustomerTaxClassification7 CustomerTaxClassification7 Tax Cls.7 Cust.
CustomerTaxClassification8 CustomerTaxClassification8 Tax Cls.8 Cust.
CustomerTaxClassification9 CustomerTaxClassification9 Tax Cls.9 Cust.
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
SDPricingProcedure SDPricingProcedure Pric. Procedure
ShippingCondition ShippingCondition Shipping Conditions
PlantSupplier PlantSupplier Sppl. No. Plnt
IncotermsVersion IncotermsVersion Inco. Version
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
PayerParty PayerParty Payer
ContractAccount ContractAccount Contract Acct
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
PaymentReference PaymentReference Payment Reference
FixedValueDate FixedValueDate Fixed Val. Date
AdditionalValueDays AdditionalValueDays Add. Value Days
SEPAMandate SEPAMandate SEPA Mandate
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
FiscalPeriod FiscalPeriod Tax period
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup AccAssmtGrpCust
AccountingExchangeRateIsSet AccountingExchangeRateIsSet Set Exchange Rt
AccountingExchangeRate AccountingExchangeRate Exch.Rate Acct.
ExchangeRateDate ExchangeRateDate Translatn Date
ExchangeRateType ExchangeRateType Exch. Rate Type
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
ReversalReason ReversalReason Reversal Reason
DunningArea DunningArea Dunning Area
DunningBlockingReason DunningBlockingReason Set Dunning Block
DunningKey DunningKey Dunning Key
InternalFinancialDocument InternalFinancialDocument Financ.Doc.No.
IsRelevantForAccrual IsRelevantForAccrual Accruals
SoldToParty SoldToParty Sold-to Party
PartnerCompany PartnerCompany Trading Partner
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerGroup CustomerGroup Customer Group
Country Country Venue: Ctry/Reg
CityCode CityCode IATA: City
SalesDistrict SalesDistrict Sales District
Region Region Venue Region
County County Wyoming County
CreditControlArea CreditControlArea Credit Control Area
CustomerRebateAgreement CustomerRebateAgreement Agreement
PricingDocument PricingDocument Document Condition
OverallSDProcessStatus OverallSDProcessStatus Overall Status
OverallBillingStatus OverallBillingStatus Status
AccountingPostingStatus AccountingPostingStatus Posting Status
AccountingTransferStatus AccountingTransferStatus Posting Status
BillingIssueType BillingIssueType Issue Type
InvoiceListStatus InvoiceListStatus Inv.List Status
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts All Items
OverallPricingIncompletionSts OverallPricingIncompletionSts Pricing – Item
InvoiceClearingStatus InvoiceClearingStatus Clearing Status
InvoiceListType InvoiceListType Inv. List Type
InvoiceListBillingDate InvoiceListBillingDate Inv.Lst Bill.Dt
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
_SDDocumentCategory _SDDocumentCategory
_BillingDocumentCategory _BillingDocumentCategory
_BillingDocumentType _BillingDocumentType
_CreatedByUser _CreatedByUser
_LogicalSystem _LogicalSystem
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_CancelledBillingDocument _CancelledBillingDocument
_TransactionCurrency _TransactionCurrency
_StatisticsCurrency _StatisticsCurrency
_ForeignTradeStstclCurrency _ForeignTradeStstclCurrency
_CustomerPriceGroup _CustomerPriceGroup
_PriceListType _PriceListType
_TaxDepartureCountry _TaxDepartureCountry
_VATRegistrationOrigin _VATRegistrationOrigin
_VATRegistrationCountry _VATRegistrationCountry
_SDPricingProcedure _SDPricingProcedure
_ShippingCondition _ShippingCondition
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_PayerParty _PayerParty
_CustomerPaymentTerms _CustomerPaymentTerms
_PaymentMethod _PaymentMethod
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccountingDocument _AccountingDocument
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup
_ExchangeRateType _ExchangeRateType
_ReversalReason _ReversalReason
_DunningArea _DunningArea
_DunningBlockingReason _DunningBlockingReason
_DunningKey _DunningKey
_InvoiceListType _InvoiceListType
_SoldToParty _SoldToParty
_CustomerGroup _CustomerGroup
_Country _Country
_CityCode _CityCode
_SalesDistrict _SalesDistrict
_Region _Region
_County _County
_County_2 _County_2
_CreditControlArea _CreditControlArea
_OverallSDProcessStatus _OverallSDProcessStatus
_OverallBillingStatus _OverallBillingStatus
_AccountingPostingStatus _AccountingPostingStatus
_AccountingTransferStatus _AccountingTransferStatus
_BillingIssueType _BillingIssueType
_InvoiceListStatus _InvoiceListStatus
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts
_OverallPricingIncompletionSts _OverallPricingIncompletionSts
_EnhancedFields _EnhancedFields
_InvoiceClearingStatus _InvoiceClearingStatus
_DunningAreaText _DunningAreaText
_CreditControlAreaText _CreditControlAreaText

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_BillingDocument.
-- 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: ISDBILLINGDOC

CREATE VIEW I_BillingDocument AS
SELECT
  BillingDocument,
  SDDocumentCategory,
  BillingDocumentCategory,
  BillingDocumentType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  LogicalSystem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentDate,
  BillingDocumentIsCancelled,
  CancelledBillingDocument,
  BillingDocCombinationCriteria,
  ManualInvoiceMaintIsRelevant,
  NmbrOfPages,
  IsIntrastatReportingRelevant,
  IsIntrastatReportingExcluded,
  BillingDocumentIsTemporary,
  TotalNetAmount,
  TransactionCurrency,
  StatisticsCurrency,
  ForeignTradeStstclCurrency,
  TotalTaxAmount,
  CustomerPriceGroup,
  PriceListType,
  TaxDepartureCountry,
  VATRegistration,
  VATRegistrationOrigin,
  VATRegistrationCountry,
  HierarchyTypePricing,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  IsEUTriangularDeal,
  SDPricingProcedure,
  ShippingCondition,
  PlantSupplier,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  PayerParty,
  ContractAccount,
  CustomerPaymentTerms,
  PaymentMethod,
  PaymentReference,
  FixedValueDate,
  AdditionalValueDays,
  SEPAMandate,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  FiscalPeriod,
  CustomerAccountAssignmentGroup,
  AccountingExchangeRateIsSet,
  AccountingExchangeRate,
  ExchangeRateDate,
  ExchangeRateType,
  DocumentReferenceID,
  AssignmentReference,
  ReversalReason,
  DunningArea,
  DunningBlockingReason,
  DunningKey,
  InternalFinancialDocument,
  IsRelevantForAccrual,
  SoldToParty,
  PartnerCompany,
  PurchaseOrderByCustomer,
  CustomerGroup,
  Country,
  CityCode,
  SalesDistrict,
  Region,
  County,
  CreditControlArea,
  CustomerRebateAgreement,
  PricingDocument,
  OverallSDProcessStatus,
  OverallBillingStatus,
  AccountingPostingStatus,
  AccountingTransferStatus,
  BillingIssueType,
  InvoiceListStatus,
  OvrlItmGeneralIncompletionSts,
  OverallPricingIncompletionSts,
  InvoiceClearingStatus,
  InvoiceListType,
  InvoiceListBillingDate
FROM I_BillingDocumentBasic
LEFT OUTER JOIN I_BillingDocumentItem AS _Item ON BillingDocument = _Item.BillingDocument  -- association [0..*]
LEFT OUTER JOIN I_BillingDocumentPartner AS _Partner ON BillingDocument = _Partner.BillingDocument  -- association [1..*]
LEFT OUTER JOIN I_BillingDocumentPrcgElmnt AS _PricingElement ON BillingDocument = _PricingElement.BillingDocument  -- association [0..*]
LEFT OUTER JOIN I_BillingDocument AS _CancelledBillingDocument ON CancelledBillingDocument = _CancelledBillingDocument.BillingDocument  -- association [0..1]
LEFT OUTER JOIN I_BillingDocEnhancedFields AS _EnhancedFields ON BillingDocument = _EnhancedFields.BillingDocument  -- association [1..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocument = _Extension.BillingDocument  -- association [0..1]
;

Learn More