P_RU_BSET

CDS View
16 Fields 11 CDS Views

P_RU_BSET is a CDS View in S/4HANA. It contains 16 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
P_RU_DownPaymentClearing view inner CONSUMPTION
P_RU_ExtInvoiceTotalAmount1 view from CONSUMPTION
P_RU_GTDBase2 view inner COMPOSITE
P_RU_InvoiceTotalAmount1 view from CONSUMPTION
P_RU_TaxItem view from CONSUMPTION
P_RU_TaxItemIsNegativePosting view from CONSUMPTION
P_RU_TaxItemIsNegativePosting view union_all CONSUMPTION
P_RU_VATInvcJrnlLinkIncgInvc view inner CONSUMPTION
P_RU_VATInvoiceClearingChain1 view inner CONSUMPTION
P_RU_VATReporting1 view inner CONSUMPTION
P_RU_VATRetImpEAEU view inner CONSUMPTION Source CDS for Section 1 and 1.1

Fields (16)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 4
KEY FiscalYear FiscalYear 4
KEY TaxItem ClearingTaxItem,TaxItem 3
DebitCreditCode DebitCreditCode 3
GLAccount ClearingTaxGLAccount,GLAccount 2
TaxAmount TaxAmount 4
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 5
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 4
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 4
TaxCode TaxCode 3
TaxCountry TaxCountry 1
TaxItemGroup2 TaxItemGroup,TaxItemGroup2 1
TaxJurisdiction TaxJurisdiction 1
TaxRate TaxRate 3
TransactionTypeDetermination ClearingTaxTransactTypeDeterm,TransactionTypeDetermination 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_RU_BSET (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    TAXITEM,
    DEBITCREDITCODE,
    GLACCOUNT,
    TAXAMOUNT,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXCODE,
    TAXCOUNTRY,
    TAXITEMGROUP2,
    TAXJURISDICTION,
    TAXRATE,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, TAXITEM)
);

Learn More