P_BSEG_COM

CDS View
65 Fields 4 CDS Views

P_BSEG_COM is a CDS View in S/4HANA. It contains 65 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_OperationalAcctgDocItem view_entity from BASIC Operational Accounting Document Item
I_ReceivablesPayablesItem view from BASIC Receivables Payables Item
I_USFedPrptPaytDocItm view_entity from BASIC US Fed Prompt Payment Opl Acctg Doc Itm
P_USFedOplAcctgDocItem view_entity inner BASIC

Fields (65)

KeyField CDS FieldsUsed in Views
KEY belnr AccountingDocument 1
KEY bukrs CompanyCode 2
KEY buzei AccountingDocumentItem 1
KEY gjahr FiscalYear 1
absbt HedgedAbsoluteAmount 1
augbl ClearingJournalEntry 1
augdt ClearingDate 1
bdif2 ValnDiffAbsltAmtInAddlCrcy1 1
bdif3 ValnDiffAbsltAmtInAddlCrcy2 1
bdiff ValnDiffAbsltAmtInCoCodeCrcy 1
dmbe2 AbsltAmtInAdditionalCurrency1 1
dmbe3 AbsltAmtInAdditionalCurrency2 1
dmbt1 TaxBrkdwnAbsltAmt1InCoCodeCrcy 1
dmbt2 TaxBrkdwnAbsltAmt2InCoCodeCrcy 1
dmbt3 TaxBrkdwnAbsltAmt3InCoCodeCrcy 1
dmbtr AbsoluteAmountInCoCodeCrcy,AmountInLocalCurrency 2
fcsl AbsltAmtInFunctionalCurrency 1
fdwbt PlannedAbsltAmtInTransCrcy 1
fmfgus_key USFedGovernmentUUID 1
fwbas TaxAbsltBaseAmountInTransCrcy 1
h_blart JournalEntryType 1
h_waers CompanyCodeCurrency 1
hwbas TaxAbsltBaseAmountInCoCodeCrcy 1
kkber CreditControlArea 1
koart FinancialAccountType 1
mwst2 TaxAbsltAmtInAddlCurrency1 1
mwst3 TaxAbsltAmtInAddlCurrency2 1
mwsts TaxAbsltAmountInCoCodeCrcy 1
navfw NonDcblTaxAbsltAmtInTransCrcy 1
navhw NonDcblTaxAbsltAmtInCoCodeCrcy 1
nebtr NetPaymentAbsoluteAmount 1
netdt NetDueDate 1
pendays NrOfDaysPnltyChrgCalc 1
penlc1 PnltyChrgAmtIn1stLoclCrcy 1
pswbt AbsltAmtInBalanceTransacCrcy 1
pyamt AbsltAmountInPaymentCurrency 1
qbshb WithholdingTaxAbsoluteAmount 1
qsfbt WhldgTaxExemptionAbsltAmount 1
qsshb WithholdingTaxAbsoluteBaseAmt 1
rewrt InvoiceAbsltAmtInCoCodeCrcy 1
rewwr InvoiceAbsltAmtInFrgnCurrency 1
shkzg_unadjusted UnadjustedDebitCreditCode 1
skfbt CashDiscountAbsoluteBaseAmount 1
sknto CashDiscAbsltAmtInCoCodeCrcy,CashDiscountAmtInCoCodeCrcy 2
stceg VATRegistration 1
txbfw OriginalTaxAbsoluteBaseAmount 1
txbh2 OriglTxAbsltBaseAmtInAddlCrcy1 1
txbh3 OriglTxAbsltBaseAmtInAddlCrcy2 1
txbhw OriglTxAbsltBaseAmountInCCCrcy 1
txjcd TaxJurisdiction 1
wmwst TaxAbsoluteAmount 1
wrbt1 TaxBrkdwnAbsltAmt1InTransCrcy 1
wrbt2 TaxBrkdwnAbsltAmt2InTransCrcy 1
wrbt3 TaxBrkdwnAbsltAmt3InTransCrcy 1
wrbtr AbsoluteAmountInTransacCrcy 1
wskto CashDiscountAbsoluteAmount 1
xnegp IsNegativePosting 1
xopvw IsOpenItemManaged 1
zbd1p CashDiscount1Percent 1
zbd1t CashDiscount1Days 1
zbd2p CashDiscount2Percent 1
zbd2t CashDiscount2Days 1
zbd3t NetPaymentDays 1
zfbdt DueCalculationBaseDate 1
zterm PaymentTerms 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_BSEG_COM (
    BELNR,
    BUKRS,
    BUZEI,
    GJAHR,
    ABSBT,
    AUGBL,
    AUGDT,
    BDIF2,
    BDIF3,
    BDIFF,
    DMBE2,
    DMBE3,
    DMBT1,
    DMBT2,
    DMBT3,
    DMBTR,
    FCSL,
    FDWBT,
    FMFGUS_KEY,
    FWBAS,
    H_BLART,
    H_WAERS,
    HWBAS,
    KKBER,
    KOART,
    MWST2,
    MWST3,
    MWSTS,
    NAVFW,
    NAVHW,
    NEBTR,
    NETDT,
    PENDAYS,
    PENLC1,
    PSWBT,
    PYAMT,
    QBSHB,
    QSFBT,
    QSSHB,
    REWRT,
    REWWR,
    SHKZG_UNADJUSTED,
    SKFBT,
    SKNTO,
    STCEG,
    TXBFW,
    TXBH2,
    TXBH3,
    TXBHW,
    TXJCD,
    WMWST,
    WRBT1,
    WRBT2,
    WRBT3,
    WRBTR,
    WSKTO,
    XNEGP,
    XOPVW,
    ZBD1P,
    ZBD1T,
    ZBD2P,
    ZBD2T,
    ZBD3T,
    ZFBDT,
    ZTERM,
    PRIMARY KEY (BELNR, BUKRS, BUZEI, GJAHR)
);

Learn More