C_BillgDocToBePostedSituation
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BillingDocument | BillingDocument | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA