T161

Transparent Table Customizing (protected)
47 Fields 10 CDS Views

Purchasing Document Types

T161 is an SAP database table in S/4HANA. Purchasing Document Types. It contains 47 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_SrcgProjectItemProcessFlow view_entity inner CONSUMPTION Sourcing Project Item Process Flow
I_CntrlPurContrPartnerFuncVH view from BASIC Central Contract Partner Function details
I_PurchasingDocumentType view from BASIC Purchasing Document Type
I_PurContractClassification view from BASIC Purchase Contract Classification
I_PurContractPartnerFunctionVH view inner COMPOSITE Pur. Contr. Partner Function Value Help
I_SchedgAgrmtPartnerFunctionVH view from BASIC Scheduling Agreement Partner Function VH
Mmim_Purchasing_Document_Types view from Help-View for Purchasing Document Types
P_CRFQCustomizing view from BASIC Customizing view for CRFQ
P_RFQCustomizing view from BASIC RFQ Customizing Data
P_RFQDocumentType view from CONSUMPTION Document type for Request for Quotation

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bstyp bstyp Doc. Category
KEY bsart esart Document Type
bsakz bsakz Control
pincr pincr Item Interval
numki numki NR of Int. Asst
numke numke NR of Ext. Asst
brefn brefn Field Sel. Key
refba rfbsa Ref. doc. type
abvor abvor Rel. Order Qty
stafo stafo Update Group
upinc upinc Subitem Interv.
stako stako Tm.-dep. conds.
pargr pargr PartnDet.Proc.
numka numka No. range ALE
hityp hityp_lh Hierarchy Cat.
lphis lphis Release Docu.
gsfrg gsfrg Overall req. rel.
variante tc_var Layout
shenq shenq Shared lock
kzale kzale ALE-distr. contr.
abgebot abgebot Glob. perc. bid
kornr kornr Corr. misc. pr.
umlif umlif Supplier
koett koett Contract with delivery schedule
ar_object saeobjart Document type
koako koako Contract allowed as release order against contract
oicsegi oia_csegi QS permitted
oirfqreq oih_rfqreq Prec RFQ / req
wvvkz wvvkz FP Summar. Docs
xlokz xlokz CrossSysTransit
cp_aktive cp_active Comm. Plan Act.
cptype cp_type CP Category
fls_rsto fls_rsto Enh. Store Ret.
msr_active msr_active Adv. Returns
rdp_profile logtrm_rdp_profile RDP Profile
numkc numkc SRM Number Range
qtn_fol_doc_draft_autom quote_follow_doc_indicator Ind. for Quote Fol.
qtn_fol_doc_active_autom quote_follow_doc_indicator Ind. for Quote Fol.
qtn_fol_doc_manually quote_follow_doc_indicator Ind. for Quote Fol.
rfq_process_type mm_rfq_process_type External Processing
scnr_based_wfl mmpur_scbsd_wfl Flexible Workflow
rfx_processing_cd rfx_processing_cd RFQ Awarding Type
aic_vcm_type mmpur_aic_vcm_type_sto VCM Type adv. IC-STO
conf_wfl mmpur_conf_wfl Conf Workflow
po_atp_bulk_processing mmpur_po_atp_bulk_processing ATP Bulk Processing
itmac /sapsll/itmac Trade Compliance

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.

-- Purchasing Document Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T161 (
    MANDT,                     -- Client [mandt]
    BSTYP,                     -- Doc. Category [bstyp]
    BSART,                     -- Document Type [esart]
    BSAKZ,                     -- Control [bsakz]
    PINCR,                     -- Item Interval [pincr]
    NUMKI,                     -- NR of Int. Asst [numki]
    NUMKE,                     -- NR of Ext. Asst [numke]
    BREFN,                     -- Field Sel. Key [brefn]
    REFBA,                     -- Ref. doc. type [rfbsa]
    ABVOR,                     -- Rel. Order Qty [abvor]
    STAFO,                     -- Update Group [stafo]
    UPINC,                     -- Subitem Interv. [upinc]
    STAKO,                     -- Tm.-dep. conds. [stako]
    PARGR,                     -- PartnDet.Proc. [pargr]
    NUMKA,                     -- No. range ALE [numka]
    HITYP,                     -- Hierarchy Cat. [hityp_lh]
    LPHIS,                     -- Release Docu. [lphis]
    GSFRG,                     -- Overall req. rel. [gsfrg]
    VARIANTE,                  -- Layout [tc_var]
    SHENQ,                     -- Shared lock [shenq]
    KZALE,                     -- ALE-distr. contr. [kzale]
    ABGEBOT,                   -- Glob. perc. bid [abgebot]
    KORNR,                     -- Corr. misc. pr. [kornr]
    UMLIF,                     -- Supplier [umlif]
    KOETT,                     -- Contract with delivery schedule [koett]
    AR_OBJECT,                 -- Document type [saeobjart]
    KOAKO,                     -- Contract allowed as release order against contract [koako]
    OICSEGI,                   -- QS permitted [oia_csegi]
    OIRFQREQ,                  -- Prec RFQ / req [oih_rfqreq]
    WVVKZ,                     -- FP Summar. Docs [wvvkz]
    XLOKZ,                     -- CrossSysTransit [xlokz]
    CP_AKTIVE,                 -- Comm. Plan Act. [cp_active]
    CPTYPE,                    -- CP Category [cp_type]
    FLS_RSTO,                  -- Enh. Store Ret. [fls_rsto]
    MSR_ACTIVE,                -- Adv. Returns [msr_active]
    RDP_PROFILE,               -- RDP Profile [logtrm_rdp_profile]
    NUMKC,                     -- SRM Number Range [numkc]
    QTN_FOL_DOC_DRAFT_AUTOM,   -- Ind. for Quote Fol. [quote_follow_doc_indicator]
    QTN_FOL_DOC_ACTIVE_AUTOM,  -- Ind. for Quote Fol. [quote_follow_doc_indicator]
    QTN_FOL_DOC_MANUALLY,      -- Ind. for Quote Fol. [quote_follow_doc_indicator]
    RFQ_PROCESS_TYPE,          -- External Processing [mm_rfq_process_type]
    SCNR_BASED_WFL,            -- Flexible Workflow [mmpur_scbsd_wfl]
    RFX_PROCESSING_CD,         -- RFQ Awarding Type [rfx_processing_cd]
    AIC_VCM_TYPE,              -- VCM Type adv. IC-STO [mmpur_aic_vcm_type_sto]
    CONF_WFL,                  -- Conf Workflow [mmpur_conf_wfl]
    PO_ATP_BULK_PROCESSING,    -- ATP Bulk Processing [mmpur_po_atp_bulk_processing]
    ITMAC,                     -- Trade Compliance [/sapsll/itmac]
    PRIMARY KEY (MANDT, BSTYP, BSART)
);

Learn More