C_BillgDocRedacted
C_BillgDocRedacted is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 64 fields with key field BillingDocument. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BillingDocument | BillingDocument | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | C_SalesDocPaymentMethodVH | _PaymentMethod | $projection.PaymentMethod = _PaymentMethod.PaymentMethod and $projection.CompanyCode = _PaymentMethod.BillingCompanyCode |
| [0..*] | C_BillgDocItemRedacted | _Item | $projection.BillingDocument = _Item.BillingDocument |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CBDREDACTED | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.allowExtensions | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Search.searchable | true | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (64)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillingDocument | I_BillingDocument | BillingDocument | SD Document |
| BillingDocumentType | I_BillingDocument | BillingDocumentType | Billing Type | |
| BillingDocumentTypeName | ||||
| PayerParty | PayerBuPaIdentification | BPIdentificationNumber | Logical System | |
| OverallBillingStatus | I_BillingDocument | OverallBillingStatus | ||
| BillToParty | BillToPartyBuPaIdentification | BPIdentificationNumber | Logical System | |
| SoldToParty | SoldToPartyBuPaIdentification | BPIdentificationNumber | Logical System | |
| CompanyCode | I_BillingDocument | CompanyCode | Receiver Company Code | |
| SalesOrganization | I_BillingDocument | SalesOrganization | Sales Organization | |
| DistributionChannel | I_BillingDocument | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | I_BillingDocument | Division | Internal Division ID | |
| BillingDocumentDate | I_BillingDocument | BillingDocumentDate | Billing Date | |
| PaymentMethod | I_BillingDocument | PaymentMethod | Pymt Meth. | |
| CustomerPaymentTerms | I_BillingDocument | CustomerPaymentTerms | Pyt Terms | |
| IncotermsVersion | I_BillingDocument | IncotermsVersion | Inco. Version | |
| IncotermsClassification | I_BillingDocument | IncotermsClassification | Incoterms | |
| IncotermsLocation1 | I_BillingDocument | IncotermsLocation1 | Inco. Location1 | |
| IncotermsLocation2 | I_BillingDocument | IncotermsLocation2 | Inco. Location2 | |
| DocumentReferenceID | ||||
| AssignmentReference | I_BillingDocument | AssignmentReference | Assignment Reference | |
| TotalTaxAmount | I_BillingDocument | TotalTaxAmount | Tax Amount | |
| TotalNetAmount | I_BillingDocument | TotalNetAmount | Total Net Amount | |
| TotalGrossAmount | ||||
| TransactionCurrency | I_BillingDocument | TransactionCurrency | Transaction Currency | |
| AccountingDocument | ||||
| FiscalYear | I_BillingDocument | FiscalYear | G/L Fiscal Year | |
| CancelledBillingDocument | I_BillingDocument | CancelledBillingDocument | Canceld Bill.Dc | |
| BillingIssueType | I_BillingDocument | BillingIssueType | ||
| Country | I_BillingDocument | Country | Venue: Ctry/Reg | |
| TaxDepartureCountry | I_BillingDocument | TaxDepartureCountry | Tx Dep Ctry/Reg | |
| CustomerTaxClassification1 | I_BillingDocument | CustomerTaxClassification1 | ||
| CustomerTaxClassification2 | I_BillingDocument | CustomerTaxClassification2 | ||
| CustomerTaxClassification3 | I_BillingDocument | CustomerTaxClassification3 | ||
| CustomerTaxClassification4 | I_BillingDocument | CustomerTaxClassification4 | ||
| CustomerTaxClassification5 | I_BillingDocument | CustomerTaxClassification5 | ||
| CustomerTaxClassification6 | I_BillingDocument | CustomerTaxClassification6 | ||
| CustomerTaxClassification7 | I_BillingDocument | CustomerTaxClassification7 | ||
| CustomerTaxClassification8 | I_BillingDocument | CustomerTaxClassification8 | ||
| CustomerTaxClassification9 | I_BillingDocument | CustomerTaxClassification9 | ||
| CityCode | I_BillingDocument | CityCode | IATA: City | |
| County | I_BillingDocument | County | Wyoming County | |
| Region | I_BillingDocument | Region | Venue Region | |
| VATRegistrationCountry | I_BillingDocument | VATRegistrationCountry | CtryRgnSlsTxNo. | |
| VATRegistrationOrigin | I_BillingDocument | VATRegistrationOrigin | OriginSlsTxNo. | |
| IsEUTriangularDeal | I_BillingDocument | IsEUTriangularDeal | Is EU Triangular Deal | |
| _CompanyCode | I_BillingDocument | _CompanyCode | ||
| _SalesOrganization | I_BillingDocument | _SalesOrganization | ||
| _DistributionChannel | I_BillingDocument | _DistributionChannel | ||
| _Division | I_BillingDocument | _Division | ||
| _CustomerPaymentTerms | I_BillingDocument | _CustomerPaymentTerms | ||
| _IncotermsVersion | I_BillingDocument | _IncotermsVersion | ||
| _IncotermsClassification | I_BillingDocument | _IncotermsClassification | ||
| _BillingDocumentType | I_BillingDocument | _BillingDocumentType | ||
| _OverallBillingStatus | I_BillingDocument | _OverallBillingStatus | ||
| _BillingIssueType | I_BillingDocument | _BillingIssueType | ||
| _Country | I_BillingDocument | _Country | ||
| _TaxDepartureCountry | I_BillingDocument | _TaxDepartureCountry | ||
| _CityCode | I_BillingDocument | _CityCode | ||
| _County_2 | I_BillingDocument | _County_2 | ||
| _Region | I_BillingDocument | _Region | ||
| _VATRegistrationCountry | I_BillingDocument | _VATRegistrationCountry | ||
| _VATRegistrationOrigin | I_BillingDocument | _VATRegistrationOrigin | ||
| _PaymentMethod | _PaymentMethod | |||
| _Item | _Item |
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 C_BillgDocRedacted.
-- 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 C_BillgDocRedacted AS
SELECT
BillingDocument.BillingDocument AS BillingDocument,
BillingDocument.BillingDocumentType AS BillingDocumentType,
BillingDocument._BillingDocumentType._Text[1: Language=$session.system_language].BillingDocumentTypeName AS BillingDocumentTypeName,
PayerBuPaIdentification.BPIdentificationNumber AS PayerParty,
BillingDocument.OverallBillingStatus AS OverallBillingStatus,
BillToPartyBuPaIdentification.BPIdentificationNumber AS BillToParty,
SoldToPartyBuPaIdentification.BPIdentificationNumber AS SoldToParty,
BillingDocument.CompanyCode AS CompanyCode,
BillingDocument.SalesOrganization AS SalesOrganization,
BillingDocument.DistributionChannel AS DistributionChannel,
BillingDocument.Division AS Division,
BillingDocument.BillingDocumentDate AS BillingDocumentDate,
BillingDocument.PaymentMethod AS PaymentMethod,
BillingDocument.CustomerPaymentTerms AS CustomerPaymentTerms,
BillingDocument.IncotermsVersion AS IncotermsVersion,
BillingDocument.IncotermsClassification AS IncotermsClassification,
BillingDocument.IncotermsLocation1 AS IncotermsLocation1,
BillingDocument.IncotermsLocation2 AS IncotermsLocation2,
cast(BillingDocument.DocumentReferenceID as xblnr_v1_case_sensitive ) AS DocumentReferenceID,
BillingDocument.AssignmentReference AS AssignmentReference,
BillingDocument.TotalTaxAmount AS TotalTaxAmount,
BillingDocument.TotalNetAmount AS TotalNetAmount,
BillingDocument._EnhancedFields.TotalGrossAmount AS TotalGrossAmount,
BillingDocument.TransactionCurrency AS TransactionCurrency,
cast(BillingDocument.AccountingDocument as accounting_document_number preserving type ) AS AccountingDocument,
BillingDocument.FiscalYear AS FiscalYear,
BillingDocument.CancelledBillingDocument AS CancelledBillingDocument,
BillingDocument.BillingIssueType AS BillingIssueType,
BillingDocument.Country AS Country,
BillingDocument.TaxDepartureCountry AS TaxDepartureCountry,
BillingDocument.CustomerTaxClassification1 AS CustomerTaxClassification1,
BillingDocument.CustomerTaxClassification2 AS CustomerTaxClassification2,
BillingDocument.CustomerTaxClassification3 AS CustomerTaxClassification3,
BillingDocument.CustomerTaxClassification4 AS CustomerTaxClassification4,
BillingDocument.CustomerTaxClassification5 AS CustomerTaxClassification5,
BillingDocument.CustomerTaxClassification6 AS CustomerTaxClassification6,
BillingDocument.CustomerTaxClassification7 AS CustomerTaxClassification7,
BillingDocument.CustomerTaxClassification8 AS CustomerTaxClassification8,
BillingDocument.CustomerTaxClassification9 AS CustomerTaxClassification9,
BillingDocument.CityCode AS CityCode,
BillingDocument.County AS County,
BillingDocument.Region AS Region,
BillingDocument.VATRegistrationCountry AS VATRegistrationCountry,
BillingDocument.VATRegistrationOrigin AS VATRegistrationOrigin,
BillingDocument.IsEUTriangularDeal AS IsEUTriangularDeal,
BillingDocument._CompanyCode AS _CompanyCode,
BillingDocument._SalesOrganization AS _SalesOrganization,
BillingDocument._DistributionChannel AS _DistributionChannel,
BillingDocument._Division AS _Division,
BillingDocument._CustomerPaymentTerms AS _CustomerPaymentTerms,
BillingDocument._IncotermsVersion AS _IncotermsVersion,
BillingDocument._IncotermsClassification AS _IncotermsClassification,
BillingDocument._BillingDocumentType AS _BillingDocumentType,
BillingDocument._OverallBillingStatus AS _OverallBillingStatus,
BillingDocument._BillingIssueType AS _BillingIssueType,
BillingDocument._Country AS _Country,
BillingDocument._TaxDepartureCountry AS _TaxDepartureCountry,
BillingDocument._CityCode AS _CityCode,
BillingDocument._County_2 AS _County_2,
BillingDocument._Region AS _Region,
BillingDocument._VATRegistrationCountry AS _VATRegistrationCountry,
BillingDocument._VATRegistrationOrigin AS _VATRegistrationOrigin
FROM I_BillingDocument AS BillingDocument
LEFT OUTER JOIN C_SalesDocPaymentMethodVH AS _PaymentMethod ON PaymentMethod = _PaymentMethod.PaymentMethod AND CompanyCode = _PaymentMethod.BillingCompanyCode -- association [0..1]
LEFT OUTER JOIN C_BillgDocItemRedacted AS _Item ON BillingDocument = _Item.BillingDocument -- association [0..*]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA