C_SlsDocFlfmtBillgDoc

DDL: C_SLSDOCFLFMTBILLGDOC SQL: CSOFBILLGDOC Type: view CONSUMPTION
31 Fields 1 Data Sources 1 Associations

Sales Doc Fulfillment: Billing Document

C_SlsDocFlfmtBillgDoc is a Consumption CDS View that provides data about "Sales Doc Fulfillment: Billing Document" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 31 fields with key field BillingDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument BillingDocument from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_BillingDocument _Extension $projection.BillingDocument = _Extension.BillingDocument

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Sales Doc Fulfillment: Billing Document view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
Search.searchable false view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CSOFBILLGDOC view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument SD Document
BillingDocumentType I_BillingDocument BillingDocumentType Billing Type
BillingDocumentDate I_BillingDocument BillingDocumentDate Billing Date
TotalNetAmount I_BillingDocument TotalNetAmount Total Net Amount
TotalTaxAmount TotalTaxAmount Tax Amount
TransactionCurrency TransactionCurrency Transaction Currency
AccountingTransferStatus I_BillingDocument AccountingTransferStatus
BillingDocumentIsCancelled I_BillingDocument BillingDocumentIsCancelled Canceled
PurchaseOrderByCustomer I_BillingDocument PurchaseOrderByCustomer Purchase Order Number
SalesOrganization I_BillingDocument SalesOrganization Sales Organization
CustomerGroup I_BillingDocument CustomerGroup Customer Group
CustomerPaymentTerms I_BillingDocument CustomerPaymentTerms Pyt Terms
SoldToParty I_BillingDocument SoldToParty Sold-to Party
SoldToPartyName
AddressID
AddressID
AddressObjectType SoldToPartyAddressInfo AddressObjectType Address Type
AddressPersonID SoldToPartyAddressInfo AddressPersonID Person Number
PayerParty I_BillingDocument PayerParty Payer
PayerPartyName
BillToParty
BillToPartyName
ShipToParty
ShipToPartyName
int1asAccountingTransfStsCriticality
_BillingDocumentType _BillingDocumentType
_SalesOrganization _SalesOrganization
_CustomerGroup _CustomerGroup
_AccountingTransferStatus _AccountingTransferStatus
_CustomerPaymentTerms _CustomerPaymentTerms
_TransactionCurrency _TransactionCurrency

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_SlsDocFlfmtBillgDoc.
-- 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: CSOFBILLGDOC

CREATE VIEW C_SlsDocFlfmtBillgDoc AS
SELECT
  BillingDocument.BillingDocument AS BillingDocument,
  BillingDocument.BillingDocumentType AS BillingDocumentType,
  BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  BillingDocument.TotalNetAmount AS TotalNetAmount,
  TotalTaxAmount,
  TransactionCurrency,
  BillingDocument.AccountingTransferStatus AS AccountingTransferStatus,
  BillingDocument.BillingDocumentIsCancelled AS BillingDocumentIsCancelled,
  BillingDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  BillingDocument.SalesOrganization AS SalesOrganization,
  BillingDocument.CustomerGroup AS CustomerGroup,
  BillingDocument.CustomerPaymentTerms AS CustomerPaymentTerms,
  BillingDocument.SoldToParty AS SoldToParty,
  cast (Partner._SoldToParty.CustomerName as vdm_sold_to_name) AS SoldToPartyName,
  SoldToPartyAddressInfo.AddressObjectType AS AddressObjectType,
  SoldToPartyAddressInfo.AddressPersonID AS AddressPersonID,
  BillingDocument.PayerParty AS PayerParty,
  cast (Partner._PayerParty.CustomerName as payer_name) AS PayerPartyName,
  cast (Partner.BillToParty as kunre) AS BillToParty,
  cast (Partner._BillToParty.CustomerName as bill_to_name) AS BillToPartyName,
  cast (Partner.ShipToParty as kunwe) AS ShipToParty,
  cast (Partner._ShipToParty.CustomerName as ship_to_name) AS ShipToPartyName
FROM I_BillingDocument AS BillingDocument
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocument = _Extension.BillingDocument  -- association [0..1]
;

Learn More