I_BILLINGDOCUMENTREQUEST

CDS View

Billing Document Request

I_BILLINGDOCUMENTREQUEST is a CDS View in S/4HANA. Billing Document Request. It contains 47 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
A_BillingDocumentRequest view from COMPOSITE Billing Document Request Header
C_BillgDocReqWorklist view from CONSUMPTION Billing Document Request
C_BillingDocRequestObjPg view from CONSUMPTION
C_BSOrdProcFlwBillgDocReq view from CONSUMPTION BDR Attrib for BSOrd Prgrs
C_BSQPMBillingDocumentRequest view_entity from CONSUMPTION BSQPM Billing Document Request
C_DspDocFlwBillgDocRequest view_entity from CONSUMPTION Billing Document Request Attributes
C_DspDocFlwBillgDocRequestVH view_entity from CONSUMPTION Billing Document Request
ESH_N_BILLINGDOCUMENTREQUEST view from
I_BillingDocumentRequestStdVH view from COMPOSITE Billing Document Request
P_ARProcessFlowBillgDocRequest view_entity from COMPOSITE Billing Document Request Attributes
R_BillgDocRequestItemTextTP view_entity inner TRANSACTIONAL Billing Document Request Item Text - TP
R_BillingDocumentRequestTextTP view_entity inner TRANSACTIONAL Billing Document Request Text - TP
R_BillingDocumentRequestTP view_entity from TRANSACTIONAL Billing Document Request - TP

Fields (47)

KeyField CDS FieldsUsed in Views
KEY BillingDocumentRequest BillingDocumentRequest,ReferenceSDDocument 4
_BillingDocumentRequestType _BillingDocumentRequestType 2
_BillingIssueType _BillingIssueType 2
_CompanyCode _CompanyCode 2
_Country _Country 1
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup 1
_CustomerPaymentTerms _CustomerPaymentTerms 2
_DunningBlockingReason _DunningBlockingReason 1
_DunningKey _DunningKey 1
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 2
_OvrlBillingDocReqStatus _OvrlBillingDocReqStatus 2
_ProposedBillingDocumentType _ProposedBillingDocumentType 2
_ReferenceDocSDDocCategory _ReferenceDocSDDocCategory 2
_SalesOrganization _SalesOrganization 2
_SDDocumentCategory _SDDocumentCategory 2
_SoldToParty _SoldToParty 1
_TransactionCurrency _TransactionCurrency 2
BillingDocumentDate BillingDocumentDate 5
BillingDocumentRequestType BillingDocumentRequestType 1
BillingIssueType BillingIssueType 2
CompanyCode CompanyCode 5
Country Country 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 1
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 1
CustomerPaymentTerms CustomerPaymentTerms 3
CustomerTaxClassification1 CustomerTaxClassification1 1
DistributionChannel DistributionChannel 1
Division Division 1
DocumentReferenceID DocumentReferenceID 1
DunningArea DunningArea 1
DunningBlockingReason DunningBlockingReason 1
DunningKey DunningKey 1
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 1
IncotermsVersion IncotermsVersion 2
OverallBillingDocReqStatus OverallBillingDocReqStatus 3
PayerParty PayerParty 4
PricingDocument SalesDocumentCondition 2
SalesOrganization SalesOrganization 4
SoldToParty SoldToParty 5
TotalNetAmount TotalNetAmount 4
TotalTaxAmount TotalTaxAmount 2
TransactionCurrency TransactionCurrency 4
VATRegistration VATRegistration 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 Request
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCUMENTREQUEST (
    BILLINGDOCUMENTREQUEST,
    _BILLINGDOCUMENTREQUESTTYPE,
    _BILLINGISSUETYPE,
    _COMPANYCODE,
    _COUNTRY,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERPAYMENTTERMS,
    _DUNNINGBLOCKINGREASON,
    _DUNNINGKEY,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _OVRLBILLINGDOCREQSTATUS,
    _PROPOSEDBILLINGDOCUMENTTYPE,
    _REFERENCEDOCSDDOCCATEGORY,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SOLDTOPARTY,
    _TRANSACTIONCURRENCY,
    BILLINGDOCUMENTDATE,
    BILLINGDOCUMENTREQUESTTYPE,
    BILLINGISSUETYPE,
    COMPANYCODE,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERTAXCLASSIFICATION1,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    DUNNINGAREA,
    DUNNINGBLOCKINGREASON,
    DUNNINGKEY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    OVERALLBILLINGDOCREQSTATUS,
    PAYERPARTY,
    PRICINGDOCUMENT,
    SALESORGANIZATION,
    SOLDTOPARTY,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    PRIMARY KEY (BILLINGDOCUMENTREQUEST)
);