R_BillingDocumentTP

@AccessControl: { authorizationCheck: #MANDATORY, personalData.blocking: #('TRANSACTIONAL_DATA') }

@EndUserText.label: 'Billing Document - TP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel: {
  sapObjectNodeType.name: 'BillingDocument',
  usageType: { 
    dataClass: #TRANSACTIONAL, 
    serviceQuality: #A, 
    sizeCategory: #L }
}

  
define root view entity R_BillingDocumentTP
  as select from I_BillingDocument as BillingDocument

  composition [0..*] of R_BillingDocumentItemTP as _Item
  
  //Extensibility

  association [0..1] to E_BillingDocument          as _Extension      on $projection.BillingDocument = _Extension.BillingDocument

{
  key BillingDocument,
      SDDocumentCategory,
      BillingDocumentCategory,
      BillingDocumentType,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangeDate,
      case tstmp_is_valid(cast(LastChangeDateTime as abap.dec(15,0)))
        when 0 then cast( dats_tims_to_tstmp( CreationDate, CreationTime, 'UTC', $session.client, 'NULL' ) as timestampl )
        else LastChangeDateTime
      end as LastChangeDateTime,
      LogicalSystem,
      SalesOrganization,
      DistributionChannel,
      Division,
      BillingDocumentDate,
      BillingDocumentIsCancelled,
      CancelledBillingDocument,
      BillingDocCombinationCriteria,
      ManualInvoiceMaintIsRelevant,
      NmbrOfPages,
      IsIntrastatReportingRelevant,
      IsIntrastatReportingExcluded,
      BillingDocumentIsTemporary,
      TotalNetAmount,
      TransactionCurrency,
      StatisticsCurrency,
      TotalTaxAmount,
      //_EnhancedFields.TotalGrossAmount, // expose?

      CustomerPriceGroup,
      PriceListType,
      TaxDepartureCountry,
      VATRegistration,
      VATRegistrationOrigin,
      VATRegistrationCountry,
      HierarchyTypePricing,
      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9,
      IsEUTriangularDeal,
      SDPricingProcedure,
      ShippingCondition,
      IncotermsVersion,
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      PayerParty,
      ContractAccount,
      CustomerPaymentTerms,
      // Wrong foreign key association is used in the basic interface view

      @ObjectModel.foreignKey.association: null      
      PaymentMethod,
      PaymentReference,
      FixedValueDate,
      AdditionalValueDays,
      SEPAMandate,
      CompanyCode,
      FiscalYear,
      AccountingDocument,
      FiscalPeriod,
      CustomerAccountAssignmentGroup,
      AccountingExchangeRateIsSet,  
      AccountingExchangeRate, // TBD: Which rate? AccountingExchangeRate or AbsltAccountingExchangeRate & AcctgExchangeRateIsIndrctQtan

      ExchangeRateDate,
      ExchangeRateType,
      DocumentReferenceID,
      AssignmentReference,
      ReversalReason,
      DunningArea,
      DunningBlockingReason,
      DunningKey,
      InternalFinancialDocument,
      IsRelevantForAccrual,
      SoldToParty,
      PartnerCompany,
      PurchaseOrderByCustomer,
      CustomerGroup,
      Country,
      CityCode,
      SalesDistrict,
      Region,
      @ObjectModel.foreignKey.association: '_County'
      County,
      CreditControlArea,
      CustomerRebateAgreement,
      PricingDocument,
      OverallSDProcessStatus,
      OverallBillingStatus,
      AccountingPostingStatus,
      AccountingTransferStatus,
      BillingIssueType,
      InvoiceListStatus,
      OvrlItmGeneralIncompletionSts,
      OverallPricingIncompletionSts,
      InvoiceClearingStatus,
      InvoiceListType,
      InvoiceListBillingDate,
      /* Associations */
      _AccountingDocument,
      _AccountingPostingStatus,
      _AccountingTransferStatus,
      _BillingDocumentCategory,
      _BillingDocumentType,
      _BillingIssueType,
      _CancelledBillingDocument,
      _CityCode,
      _CompanyCode,
      _Country,
      _County_2 as _County,
      _CreatedByUser,
      _CreditControlArea,
      //_CreditControlAreaText,

      _CustomerAccountAssgmtGroup,
      _CustomerGroup,
      _CustomerPaymentTerms,
      _CustomerPriceGroup,
      _DistributionChannel,
      _Division,
      _DunningArea,
      //_DunningAreaText,

      _DunningBlockingReason,
      _DunningKey,
      //_EnhancedFields,

      _ExchangeRateType,
      _FiscalYear,
      _IncotermsClassification,
      _IncotermsVersion,
      _InvoiceClearingStatus,
      _InvoiceListStatus,
      _InvoiceListType,
      _Item,
      _LogicalSystem,
      _OverallBillingStatus,
      _OverallPricingIncompletionSts,
      _OverallSDProcessStatus,
      _OvrlItmGeneralIncompletionSts,
      //_Partner,

      _PayerParty,
      _PriceListType,
      //_PricingElement,

      _Region,
      _ReversalReason,
      _SalesDistrict,
      _SalesOrganization,
      _SDDocumentCategory,
      _SDPricingProcedure,
      _ShippingCondition,
      _SoldToParty,
      _StatisticsCurrency,
      _TaxDepartureCountry,
      _TransactionCurrency,
      _VATRegistrationCountry,
      _VATRegistrationOrigin
}
where
  BillingDocumentIsTemporary = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENT",
"I_ACCOUNTINGPOSTINGSTATUS",
"I_ACCOUNTINGTRANSFERSTATUS",
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTCATEGORY",
"I_BILLINGDOCUMENTTYPE",
"I_BILLINGISSUETYPE",
"I_CITYCODE",
"I_COMPANYCODE",
"I_COUNTRY",
"I_CREDITCONTROLAREA",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPRICEGROUP",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_DUNNINGAREA",
"I_DUNNINGBLOCKINGREASONCODE",
"I_DUNNINGKEY",
"I_EXCHANGERATETYPE",
"I_FISCALYEARFORCOMPANYCODE",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_INVOICECLEARINGSTATUS",
"I_INVOICELISTSTATUS",
"I_LOGICALSYSTEM",
"I_OVERALLBILLINGSTATUS",
"I_OVERALLPRCINCOMPLETIONSTS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_PRICELISTTYPE",
"I_REGION",
"I_REVERSALREASON",
"I_SALESDISTRICT",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SHIPPINGCONDITION",
"I_SLSPRICINGPROCEDURE",
"I_TAXINGCOUNTY",
"I_USER",
"I_VATREGISTRATIONORIGIN",
"R_BILLINGDOCUMENTITEMTP"
],
"BASE":
[
"I_BILLINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/