SNC_PL_BC
SAF-T PL : Business Cases
SNC_PL_BC is an SAP database table in S/4HANA. SAF-T PL : Business Cases. It contains 14 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PL_SAFTGeneralSettings | view | from | BASIC | SAFT PL General Settings |
| I_PL_SAFTGoodsMovement | view | left_outer | BASIC | SAF-T Goods Movement |
| I_PL_SAFTInvoiceHeader | view | left_outer | BASIC | SAF-T Invoice Header |
| I_PL_SAFTJournalHeader | view | left_outer | BASIC | SAF-T Journal Header |
| I_PL_SAFTTaxItem | view | left_outer | BASIC | SAF-T Tax item |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | bukrs | bukrs | Company Code | |||
| KEY | endda | endda | End Date | |||
| begda | begda | Start Date | ||||
| main_alt_acct | saftn_pl_main_alt_acc | Account | ||||
| fi_view | saftn_pl_fi_view | GL View | ||||
| file_email | ad_smtpadr | E-Mail Address | ||||
| regon | fipl_tax_number | REGON | ||||
| district | fipl_district | District | ||||
| sub_district | fipl_sub_district | Sub District | ||||
| tax_office | saftn_pl_tax_office | Tax Office Code | ||||
| business_type | saft_pl_kr_type | |||||
| cit | saft_pl_est_cit | |||||
| ifrs | saft_pl_kr_ifrs |
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.
-- SAF-T PL : Business Cases
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNC_PL_BC (
MANDT, -- Client [mandt]
BUKRS, -- Company Code [bukrs]
ENDDA, -- End Date [endda]
BEGDA, -- Start Date [begda]
MAIN_ALT_ACCT, -- Account [saftn_pl_main_alt_acc]
FI_VIEW, -- GL View [saftn_pl_fi_view]
FILE_EMAIL, -- E-Mail Address [ad_smtpadr]
REGON, -- REGON [fipl_tax_number]
DISTRICT, -- District [fipl_district]
SUB_DISTRICT, -- Sub District [fipl_sub_district]
TAX_OFFICE, -- Tax Office Code [saftn_pl_tax_office]
BUSINESS_TYPE, -- saft_pl_kr_type
CIT, -- saft_pl_est_cit
IFRS, -- saft_pl_kr_ifrs
PRIMARY KEY (MANDT, BUKRS, ENDDA)
);
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