P_BSEG_COM1
P_BSEG_COM1 is a CDS View in S/4HANA. It contains 203 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_InspectOplAcctgDocumentItem | view | from | BASIC | Inspect Operational Accounting Doc. Item |
| P_BSEG_COM | view_entity | from | BASIC | |
| P_PL_SAFTGetBPName | view_entity | from | CONSUMPTION |
Fields (203)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | belnr | documentnumber | 1 |
| KEY | bukrs | companycode | 1 |
| KEY | buzei | lineitem | 1 |
| KEY | gjahr | fiscalyear | 1 |
| abper | abper | 1 | |
| anbwa | anbwa | 1 | |
| anfae | anfae | 1 | |
| anfbj | anfbj | 1 | |
| anfbn | anfbn | 1 | |
| anfbu | anfbu | 1 | |
| bdgt_account | bdgt_account | 1 | |
| bdgt_account_cocode | bdgt_account_cocode | 1 | |
| blnbt | blnbt | 1 | |
| blnbt_shl | blnbt_shl | 1 | |
| blnkz | blnkz | 1 | |
| blnpz | blnpz | 1 | |
| bonfb | bonfb | 1 | |
| bonfb_shl | bonfb_shl | 1 | |
| btype | btype | 1 | |
| bualt_shl | bualt_shl | 1 | |
| budget_pd | budget_pd | 1 | |
| bustw | bustw | 1 | |
| buzid | buzid | 1 | |
| bwkey | bwkey | 1 | |
| bwtar | bwtar | 1 | |
| bzdat | bzdat | 1 | |
| depot | depot | 1 | |
| diekz | diekz | 1 | |
| disbj | disbj | 1 | |
| disbz | disbz | 1 | |
| dmb21 | dmb21 | 1 | |
| dmb21_shl | dmb21_shl | 1 | |
| dmb22 | dmb22 | 1 | |
| dmb22_shl | dmb22_shl | 1 | |
| dmb23 | dmb23 | 1 | |
| dmb23_shl | dmb23_shl | 1 | |
| dmb31 | dmb31 | 1 | |
| dmb31_shl | dmb31_shl | 1 | |
| dmb32 | dmb32 | 1 | |
| dmb32_shl | dmb32_shl | 1 | |
| dmb33 | dmb33 | 1 | |
| dmb33_shl | dmb33_shl | 1 | |
| egbld | egbld | 1 | |
| eglld | eglld | 1 | |
| erfme | erfme | 1 | |
| fastpay | fastpay | 1 | |
| fdgrp | fdgrp | 1 | |
| fdlev | fdlev | 1 | |
| fdtag | fdtag | 1 | |
| fkont | fkont | 1 | |
| fmfgus_key | fmfgus_key | 1 | |
| fmxdocln | fmxdocln | 1 | |
| fmxdocnr | fmxdocnr | 1 | |
| fmxyear | fmxyear | 1 | |
| fmxzekkn | fmxzekkn | 1 | |
| fwzuz | fwzuz | 1 | |
| fwzuz_shl | fwzuz_shl | 1 | |
| gbetr | gbetr | 1 | |
| gbetr_shl | gbetr_shl | 1 | |
| geber | geber | 1 | |
| ghkon | ghkon | 1 | |
| gityp | gityp | 1 | |
| glo_ref1 | glo_ref1 | 1 | |
| glupm | glupm | 1 | |
| grant_nbr | grant_nbr | 1 | |
| gricd | gricd | 1 | |
| grirg | grirg | 1 | |
| gst_part | gst_part | 1 | |
| hrkft | hrkft | 1 | |
| hsn_sac | hsn_sac | 1 | |
| hwzuz | hwzuz | 1 | |
| hwzuz_shl | hwzuz_shl | 1 | |
| idxsp | idxsp | 1 | |
| ignr_ivref | ignr_ivref | 1 | |
| intreno | intreno | 1 | |
| j_1tpbupl | j_1tpbupl | 1 | |
| kblnr | kblnr | 1 | |
| kblpos | kblpos | 1 | |
| kdgrp | kdgrp | 1 | |
| klibt | klibt | 1 | |
| klibt_shl | klibt_shl | 1 | |
| koart | accounttype | 1 | |
| kontl | kontl | 1 | |
| kontt | kontt | 1 | |
| kstar | kstar | 1 | |
| kstrg | kstrg | 1 | |
| kursr | kursr | 1 | |
| kzbtr | kzbtr | 1 | |
| kzbtr_shl | kzbtr_shl | 1 | |
| linfv | linfv | 1 | |
| lnran | lnran | 1 | |
| lqitem | lqitem | 1 | |
| lstar | lstar | 1 | |
| lzbkz | lzbkz | 1 | |
| matnr | matnr | 1 | |
| measure | measure | 1 | |
| meins | meins | 1 | |
| mwart | mwart | 1 | |
| navh2 | navh2 | 1 | |
| navh2_shl | navh2_shl | 1 | |
| navh3 | navh3 | 1 | |
| navh3_shl | navh3_shl | 1 | |
| nbritm | nbritm | 1 | |
| nplnr | nplnr | 1 | |
| nprei_shl | nprei_shl | 1 | |
| obzei | obzei | 1 | |
| paobjnr | paobjnr | 1 | |
| pasubnr | pasubnr | 1 | |
| payt_rsn | payt_rsn | 1 | |
| pbudget_pd | pbudget_pd | 1 | |
| pendays | pendays | 1 | |
| penfc | penfc | 1 | |
| penfc_shl | penfc_shl | 1 | |
| penlc1 | penlc1 | 1 | |
| penlc1_shl | penlc1_shl | 1 | |
| penlc2 | penlc2 | 1 | |
| penlc2_shl | penlc2_shl | 1 | |
| penlc3 | penlc3 | 1 | |
| penlc3_shl | penlc3_shl | 1 | |
| penrc | penrc | 1 | |
| pernr | pernr | 1 | |
| perop_beg | perop_beg | 1 | |
| perop_end | perop_end | 1 | |
| pgrant_nbr | pgrant_nbr | 1 | |
| plc_sup | plc_sup | 1 | |
| popts | popts | 1 | |
| ppa_ex_ind | ppa_ex_ind | 1 | |
| ppdif2 | ppdif2 | 1 | |
| ppdif2_shl | ppdif2_shl | 1 | |
| ppdif3 | ppdif3 | 1 | |
| ppdif3_shl | ppdif3_shl | 1 | |
| ppdiff | ppdiff | 1 | |
| ppdiff_shl | ppdiff_shl | 1 | |
| prodper | prodper | 1 | |
| prznr | prznr | 1 | |
| psalt | psalt | 1 | |
| psegment | psegment | 1 | |
| rdif2 | rdif2 | 1 | |
| rdif2_shl | rdif2_shl | 1 | |
| rdif3 | rdif3 | 1 | |
| rdif3_shl | rdif3_shl | 1 | |
| rdiff | rdiff | 1 | |
| rdiff_shl | rdiff_shl | 1 | |
| recid | recid | 1 | |
| rfccur | rfccur | 1 | |
| rpacq | rpacq | 1 | |
| ryacq | ryacq | 1 | |
| sctax_shl | sctax_shl | 1 | |
| segment | segment | 1 | |
| service_doc_id | service_doc_id | 1 | |
| service_doc_item_id | service_doc_item_id | 1 | |
| service_doc_type | service_doc_type | 1 | |
| shzuz | shzuz | 1 | |
| sknt2 | sknt2 | 1 | |
| sknt2_shl | sknt2_shl | 1 | |
| sknt3 | sknt3 | 1 | |
| sknt3_shl | sknt3_shl | 1 | |
| spgrc | spgrc | 1 | |
| spgrg | spgrg | 1 | |
| spgrm | spgrm | 1 | |
| spgrp | spgrp | 1 | |
| spgrq | spgrq | 1 | |
| spgrs | spgrs | 1 | |
| spgrt | spgrt | 1 | |
| spgrv | spgrv | 1 | |
| srtype | srtype | 1 | |
| stbuk | stbuk | 1 | |
| stekz | stekz | 1 | |
| sttax_shl | sttax_shl | 1 | |
| tax_country | tax_country | 1 | |
| taxps | taxps | 1 | |
| tbtkz | tbtkz | 1 | |
| txdat_from | txdat_from | 1 | |
| txgrp | txgrp | 1 | |
| valut | valut | 1 | |
| vbel2 | vbel2 | 1 | |
| vbeln | vbeln | 1 | |
| vname | vname | 1 | |
| vorgn | vorgn | 1 | |
| vptnr | vptnr | 1 | |
| vrsdt | vrsdt | 1 | |
| vrskz | vrskz | 1 | |
| werks | werks | 1 | |
| xanet | xanet | 1 | |
| xcpdd | xcpdd | 1 | |
| xfakt | xfakt | 1 | |
| xfrge_bseg | xfrge_bseg | 1 | |
| xhkom | xhkom | 1 | |
| xhres | xhres | 1 | |
| xinve | xinve | 1 | |
| xlgclr | xlgclr | 1 | |
| xncop | xncop | 1 | |
| xpanz | xpanz | 1 | |
| xsauf | xsauf | 1 | |
| xserg | xserg | 1 | |
| xskst | xskst | 1 | |
| xspro | xspro | 1 | |
| xuman | xuman | 1 | |
| zekkn | zekkn | 1 | |
| zinkz | zinkz | 1 | |
| zolld | zolld | 1 | |
| zollt | zollt | 1 | |
| zumsk | zumsk | 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_COM1 (
BELNR,
BUKRS,
BUZEI,
GJAHR,
ABPER,
ANBWA,
ANFAE,
ANFBJ,
ANFBN,
ANFBU,
BDGT_ACCOUNT,
BDGT_ACCOUNT_COCODE,
BLNBT,
BLNBT_SHL,
BLNKZ,
BLNPZ,
BONFB,
BONFB_SHL,
BTYPE,
BUALT_SHL,
BUDGET_PD,
BUSTW,
BUZID,
BWKEY,
BWTAR,
BZDAT,
DEPOT,
DIEKZ,
DISBJ,
DISBZ,
DMB21,
DMB21_SHL,
DMB22,
DMB22_SHL,
DMB23,
DMB23_SHL,
DMB31,
DMB31_SHL,
DMB32,
DMB32_SHL,
DMB33,
DMB33_SHL,
EGBLD,
EGLLD,
ERFME,
FASTPAY,
FDGRP,
FDLEV,
FDTAG,
FKONT,
FMFGUS_KEY,
FMXDOCLN,
FMXDOCNR,
FMXYEAR,
FMXZEKKN,
FWZUZ,
FWZUZ_SHL,
GBETR,
GBETR_SHL,
GEBER,
GHKON,
GITYP,
GLO_REF1,
GLUPM,
GRANT_NBR,
GRICD,
GRIRG,
GST_PART,
HRKFT,
HSN_SAC,
HWZUZ,
HWZUZ_SHL,
IDXSP,
IGNR_IVREF,
INTRENO,
J_1TPBUPL,
KBLNR,
KBLPOS,
KDGRP,
KLIBT,
KLIBT_SHL,
KOART,
KONTL,
KONTT,
KSTAR,
KSTRG,
KURSR,
KZBTR,
KZBTR_SHL,
LINFV,
LNRAN,
LQITEM,
LSTAR,
LZBKZ,
MATNR,
MEASURE,
MEINS,
MWART,
NAVH2,
NAVH2_SHL,
NAVH3,
NAVH3_SHL,
NBRITM,
NPLNR,
NPREI_SHL,
OBZEI,
PAOBJNR,
PASUBNR,
PAYT_RSN,
PBUDGET_PD,
PENDAYS,
PENFC,
PENFC_SHL,
PENLC1,
PENLC1_SHL,
PENLC2,
PENLC2_SHL,
PENLC3,
PENLC3_SHL,
PENRC,
PERNR,
PEROP_BEG,
PEROP_END,
PGRANT_NBR,
PLC_SUP,
POPTS,
PPA_EX_IND,
PPDIF2,
PPDIF2_SHL,
PPDIF3,
PPDIF3_SHL,
PPDIFF,
PPDIFF_SHL,
PRODPER,
PRZNR,
PSALT,
PSEGMENT,
RDIF2,
RDIF2_SHL,
RDIF3,
RDIF3_SHL,
RDIFF,
RDIFF_SHL,
RECID,
RFCCUR,
RPACQ,
RYACQ,
SCTAX_SHL,
SEGMENT,
SERVICE_DOC_ID,
SERVICE_DOC_ITEM_ID,
SERVICE_DOC_TYPE,
SHZUZ,
SKNT2,
SKNT2_SHL,
SKNT3,
SKNT3_SHL,
SPGRC,
SPGRG,
SPGRM,
SPGRP,
SPGRQ,
SPGRS,
SPGRT,
SPGRV,
SRTYPE,
STBUK,
STEKZ,
STTAX_SHL,
TAX_COUNTRY,
TAXPS,
TBTKZ,
TXDAT_FROM,
TXGRP,
VALUT,
VBEL2,
VBELN,
VNAME,
VORGN,
VPTNR,
VRSDT,
VRSKZ,
WERKS,
XANET,
XCPDD,
XFAKT,
XFRGE_BSEG,
XHKOM,
XHRES,
XINVE,
XLGCLR,
XNCOP,
XPANZ,
XSAUF,
XSERG,
XSKST,
XSPRO,
XUMAN,
ZEKKN,
ZINKZ,
ZOLLD,
ZOLLT,
ZUMSK,
PRIMARY KEY (BELNR, BUKRS, BUZEI, GJAHR)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA