I_BILLINGDOCUMENTBASIC

CDS View
41 Fields 33 CDS Views

Billing Document Basic

I_BILLINGDOCUMENTBASIC is a CDS View in S/4HANA. Billing Document Basic. It contains 41 fields. 33 CDS views read from this table.

CDS Views using this table (33)

ViewTypeJoinVDMDescription
/CCEE/SHSM_SIFIPE7INV view from
C_BillgDocItmPrcgElmntBscDEX view inner CONSUMPTION Data Extraction for Billing Doc Item Pricing Element Basic
C_BillgDocItmPrcgElmntBscDEX_1 view inner CONSUMPTION Data Extraction for Billing Doc Item Pricing Element Basic
C_BillingDocumentOMParamDet view from CONSUMPTION Billing Document Output Management: Parameter Determination
C_Cust360BillingDocReq view_entity from CONSUMPTION Customer 360 Billing Document Request
C_Cust360PreliminaryBillDoc view_entity from CONSUMPTION Customer 360 Preliminary Billing Document
C_Customer360InvoiceList view_entity from CONSUMPTION Customer 360 Invoice List
C_DisplayDocumentFlowBilling view_entity from CONSUMPTION Billing Document and Invoice List
C_EntProjProfnlSrvcBillgDoc view_entity inner CONSUMPTION
C_InhRepairItmProcFlwDebitMemo view from CONSUMPTION Process Flow Node for Debit Memo
C_PL_BillingDocument view from CONSUMPTION Billing Documents for Poland DownPayments
C_ReturnsReferenceInvoice view_entity from CONSUMPTION Customer Return Reference Invoice
C_ServiceOrderProcessFlow_2 view_entity inner CONSUMPTION Service Order Process Flow
C_ServiceQuotationProcessFlow view_entity inner CONSUMPTION Service Quotation Process Flow
C_SrvcOrdProcFlowBillgDocument view_entity from CONSUMPTION Billing Document Process Flow Node
C_US_SalesTaxBillingDoc view from CONSUMPTION USA Sales Tax Specific Billing Document Factsheet
I_BillingDocItemPrcgElmntBasic view inner BASIC Billing Doc Item Pricing Element Basic
I_BillingDocPrcgElmntBasic view inner BASIC Billing Document Pricing Element Basic
I_BillingDocument view from BASIC Billing Document
I_BillingDocumentBasicStdVH view from COMPOSITE Billing Document Basic
I_BillingDocumentPartnerBasic view inner BASIC Billing Document Partner Basic
I_BillingDocumentRequest view from BASIC Billing Document Request
I_IN_BillingDocHistory view from BASIC Billing Document History
I_InvoiceList view_entity from BASIC Invoice List
I_PrelimBillingDocument view from BASIC Preliminary Billing Document
I_VMSVehicleInvoiceBasic view inner BASIC Vehicle Invoice
P_AR_LengthOfRefDoc view union_all COMPOSITE
P_BillingDocProcFlow0 view from CONSUMPTION
P_GteeMBillingElmntEntrFlwDoc view inner COMPOSITE
P_IN_OutgInvcTxAttrib view_entity inner COMPOSITE
P_StRpSalesInvoiceItem view inner CONSUMPTION Private View for Sales Invoice List
R_CADocRecnclnBtwnSDBillDocTP view_entity from TRANSACTIONAL Reconcile SD Billing Documents
R_SettlmtMgmtBillgDocBizVol view_entity inner BASIC Business Volume of Billing Documents

Fields (41)

KeyField CDS FieldsUsed in Views
KEY BillingDocument AccountingDocument,BillingDocument,BillingDocumentRequest,PrelimBillingDocument 12
KEY CompanyCode CompanyCode 8
KEY DocumentReferenceID DocumentReferenceID 4
KEY FiscalYear FiscalYear 6
_SoldToParty _SoldToParty 3
_TransactionCurrency _TransactionCurrency 2
AccountingDocument AccountingDocument 2
AccountingExchangeRate AccountingExchangeRate 3
BillgProcDocApprovalReason PrelimBillgDocApprovalReason 1
BillgProcDocApprovalStatus BillgProcDocApprovalStatus 1
BillingDocCombinationCriteria BillingDocCombinationCriteria 1
BillingDocumentCategory BillingDocumentCategory 3
BillingDocumentDate BillingDocumentDate,InvoiceDate,ReportingDate 12
BillingDocumentIsCancelled BillingDocumentIsCancelled 4
BillingDocumentIsTemporary BillingDocumentIsTemporary 2
BillingDocumentType BillingDocumentType 11
CancelledBillingDocument CancelledBillingDocument 2
ContractAccount ContractAccount 1
Country Country 1
CreationDate CreationDate 5
CustomerGroup CustomerGroup 2
DistributionChannel DistributionChannel 4
Division Division 1
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 3
FiscalPeriod FiscalPeriod 2
InvoiceClearingStatus InvoiceClearingStatus 1
LastChangeDate LastChangeDate 3
OverallBillingStatus OverallBillingStatus 6
PayerParty PayerParty 6
PricingDocument PricingDocument 1
Region Region 1
SalesDistrict SalesDistrict 2
SalesOrganization SalesOrganization 9
SDDocumentCategory SDDocumentCategory 4
SoldToParty Customer,SoldToParty 8
StatisticsCurrency StatisticsCurrency 2
TotalNetAmount TotalNetAmount 4
TransactionCurrency CompanyCodeCurrency,TransactionCurrency 6
VATRegistration VATRegistration 1
VATRegistrationCountry VATRegistrationCountry 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Billing Document Basic
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCUMENTBASIC (
    BILLINGDOCUMENT,
    COMPANYCODE,
    DOCUMENTREFERENCEID,
    FISCALYEAR,
    _SOLDTOPARTY,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGEXCHANGERATE,
    BILLGPROCDOCAPPROVALREASON,
    BILLGPROCDOCAPPROVALSTATUS,
    BILLINGDOCCOMBINATIONCRITERIA,
    BILLINGDOCUMENTCATEGORY,
    BILLINGDOCUMENTDATE,
    BILLINGDOCUMENTISCANCELLED,
    BILLINGDOCUMENTISTEMPORARY,
    BILLINGDOCUMENTTYPE,
    CANCELLEDBILLINGDOCUMENT,
    CONTRACTACCOUNT,
    COUNTRY,
    CREATIONDATE,
    CUSTOMERGROUP,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    FISCALPERIOD,
    INVOICECLEARINGSTATUS,
    LASTCHANGEDATE,
    OVERALLBILLINGSTATUS,
    PAYERPARTY,
    PRICINGDOCUMENT,
    REGION,
    SALESDISTRICT,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SOLDTOPARTY,
    STATISTICSCURRENCY,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (BILLINGDOCUMENT, COMPANYCODE, DOCUMENTREFERENCEID, FISCALYEAR)
);

Learn More