C_BillgDocToBePostedSituation

DDL: C_BILLGDOCTOBEPOSTEDSITUATION Type: view_entity CONSUMPTION

Billing Doc To Be Posted for Situation

C_BillgDocToBePostedSituation is a Consumption CDS View that provides data about "Billing Doc To Be Posted for Situation" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 22 fields with key field BillingDocument. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument BillingDocument from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BillingDocumentPartner _BillingDocumentPartner $projection.BillingDocument = _BillingDocumentPartner.BillingDocument and _BillingDocumentPartner.PartnerFunction = 'RE'
[0..1] I_BillingIssueTypeText _BillingIssueTypeText $projection.BillingIssueType = _BillingIssueTypeText.BillingIssueType and _BillingIssueTypeText.Language = $session.system_language
[0..1] I_BillingDocumentTypeText _BillingDocumentTypeText $projection.BillingDocumentType = _BillingDocumentTypeText.BillingDocumentType and _BillingDocumentTypeText.Language = $session.system_language
[0..1] I_SDDocumentCategoryText _SDDocumentCategoryText $projection.SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory and _SDDocumentCategoryText.Language = $session.system_language
[0..1] I_SalesOrganizationText _SalesOrganizationText $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization and _SalesOrganizationText.Language = $session.system_language

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Billing Doc To Be Posted for Situation view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument
BillingDocumentType I_BillingDocument BillingDocumentType
BillingDocumentTypeName _BillingDocumentTypeText BillingDocumentTypeName
SDDocumentCategory I_BillingDocument SDDocumentCategory
SDDocumentCategoryName _SDDocumentCategoryText SDDocumentCategoryName
PayerParty I_BillingDocument PayerParty
SoldToParty I_BillingDocument SoldToParty
BillToParty _BillingDocumentPartner Customer
TotalNetAmount I_BillingDocument TotalNetAmount
TransactionCurrency I_BillingDocument TransactionCurrency
SalesOrganization I_BillingDocument SalesOrganization
SalesOrganizationName _SalesOrganizationText SalesOrganizationName
BillingDocumentDate I_BillingDocument BillingDocumentDate
BillingIssueType I_BillingDocument BillingIssueType
BillingIssueTypeName _BillingIssueTypeText BillingIssueTypeName
CompanyCode I_BillingDocument CompanyCode
CreatedByUser I_BillingDocument CreatedByUser
_TransactionCurrency I_BillingDocument _TransactionCurrency
_BillingDocumentPartner _BillingDocumentPartner
_BillingIssueTypeText _BillingIssueTypeText
_BillingDocumentTypeText _BillingDocumentTypeText
_SDDocumentCategoryText _SDDocumentCategoryText
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{ usageType: { serviceQuality: #D, //#X

                            sizeCategory: #XL,
                            dataClass: #MIXED },

                semanticKey:  ['BillingDocument'],
                supportedCapabilities:  [ #SITUATION_ANCHOR,  #SITUATION_TRIGGER ]
}
@EndUserText.label: 'Billing Doc To Be Posted for Situation'
define view entity C_BillgDocToBePostedSituation
  as select from I_BillingDocument as BillingDocument
  association [0..1] to I_BillingDocumentPartner  as _BillingDocumentPartner  on  $projection.BillingDocument             = _BillingDocumentPartner.BillingDocument
                                                                              and _BillingDocumentPartner.PartnerFunction = 'RE'
  association [0..1] to I_BillingIssueTypeText    as _BillingIssueTypeText    on  $projection.BillingIssueType   = _BillingIssueTypeText.BillingIssueType
                                                                              and _BillingIssueTypeText.Language = $session.system_language
  association [0..1] to I_BillingDocumentTypeText as _BillingDocumentTypeText on  $projection.BillingDocumentType   = _BillingDocumentTypeText.BillingDocumentType
                                                                              and _BillingDocumentTypeText.Language = $session.system_language
  association [0..1] to I_SDDocumentCategoryText  as _SDDocumentCategoryText  on  $projection.SDDocumentCategory   = _SDDocumentCategoryText.SDDocumentCategory
                                                                              and _SDDocumentCategoryText.Language = $session.system_language
  association [0..1] to I_SalesOrganizationText  as _SalesOrganizationText  on  $projection.SalesOrganization   = _SalesOrganizationText.SalesOrganization
                                                                              and _SalesOrganizationText.Language = $session.system_language

{
        @Consumption.hidden: true
  key   BillingDocument.BillingDocument,

        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'C_BillingDocumentTypeVH',
                       element: 'BillingDocumentType' }
          }]
        BillingDocument.BillingDocumentType,

        @Consumption.hidden: true
        _BillingDocumentTypeText.BillingDocumentTypeName,

        @Consumption.valueHelpDefinition: [
          { entity:  { name: 'I_SDDocumentCategory',
                       element: 'SDDocumentCategory' }
          }]
        BillingDocument.SDDocumentCategory,

        @Consumption.hidden: true
        _SDDocumentCategoryText.SDDocumentCategoryName,

        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'C_SoldToValueHelp',
                       element: 'Customer' }
          }]
        BillingDocument.PayerParty,
        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'C_SoldToValueHelp',
                       element: 'Customer' }
          }]
        BillingDocument.SoldToParty,

        @EndUserText: {
           label: 'Bill-to Party',
           quickInfo: 'Bill-to Party'
         }
        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'C_SoldToValueHelp',
                       element: 'Customer' }
          }]
        _BillingDocumentPartner.Customer                           as BillToParty,

        @Semantics.amount.currencyCode: 'TransactionCurrency'
        BillingDocument.TotalNetAmount,

        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'I_CurrencyStdVH',
                       element: 'Currency' }
          }]
        BillingDocument.TransactionCurrency,

        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'C_SalesDocSalesOrganizationVH',
                       element: 'SalesOrganization' }
          }]
        BillingDocument.SalesOrganization,
        
        @Consumption.hidden: true
        _SalesOrganizationText.SalesOrganizationName,

        BillingDocument.BillingDocumentDate,

        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'I_BillingIssueType',
                       element: 'BillingIssueType' }
          }]
        BillingDocument.BillingIssueType,

        @Consumption.hidden: true
        _BillingIssueTypeText.BillingIssueTypeName                 as BillingIssueTypeName,

        @Consumption.valueHelpDefinition: [
          { entity:  { name:    'I_CompanyCodeVH',
                       element: 'CompanyCode' }
          }]
        BillingDocument.CompanyCode,

        @UI.hidden:true
        BillingDocument.CreatedByUser,



        BillingDocument._TransactionCurrency,
        _BillingDocumentPartner,
        _BillingIssueTypeText,
        _BillingDocumentTypeText,
        _SDDocumentCategoryText

}
where
      BillingDocument.BillingDocumentIsTemporary is initial
  and BillingDocument.OverallBillingStatus       = 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTPARTNER",
"I_BILLINGDOCUMENTTYPETEXT",
"I_BILLINGISSUETYPETEXT",
"I_SALESORGANIZATIONTEXT",
"I_SDDOCUMENTCATEGORYTEXT"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENTPARTNER",
"I_BILLINGDOCUMENTTYPETEXT",
"I_BILLINGISSUETYPETEXT",
"I_CURRENCY",
"I_SDDOCUMENTCATEGORYTEXT"
],
"BASE":
[
"I_BILLINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/